java 保留小数与四舍五入以及时间日期的转换和excel读入与数据库写入

public class ImportData {
	
	static SimpleDateFormat formater = new SimpleDateFormat("yyyy-MM-dd");
	static DecimalFormat decimalFormatter = new DecimalFormat("###.##");
	
	public static void main(String[] args) {
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		
		try{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String url = "jdbc:oracle:thin:@10.16.67.55:1526:ehrtst2";
			conn = DriverManager.getConnection(url, "hrmidea", "Midea2014");
			stmt = conn.createStatement();

			
			FileInputStream sourceFile = new FileInputStream("C:\\Users\\hp\\Desktop\\total.xls");
			POIFSFileSystem poiFileSystem = new POIFSFileSystem(sourceFile);
			HSSFWorkbook workBook = new HSSFWorkbook(poiFileSystem, true);
			sourceFile.close();
			
			HSSFSheet sheet = workBook.getSheetAt(0);
			System.out.println(sheet.getLastRowNum());
	//		for(int i = 2; i<90; i++){
			for(int i = 2; i<sheet.getLastRowNum(); i++){
				HSSFRow row = sheet.getRow(i);
				String empName = getCellValue(row.getCell((short)0));	//员工姓名
				String empCode = getCellValue(row.getCell((short)1));	//员工工号
				String worktime = getCellValue(row.getCell((short)2));	//科技工时
				String source = getCellValue(row.getCell((short)3));	//来源
				String beginDate = getCellValue(row.getCell((short)4));	//开始时间
				Date enddateTemp = formater.parse("2015-05-31");
				String endDate= formater.format(enddateTemp);		
				String msg = empName+"\t"+empCode+"\t"+worktime+"\t"+source+"\t"+beginDate+"\t";
				//System.out.print(msg);
				String sql1 = "select c_employeeid, c_code, c_name, c_employeestatus, c_unitid, c_unitname, c_jobid, c_jobname, c_joborder from tb_inf_employee_0526 where c_code='"+empCode+"'";
				rs = stmt.executeQuery(sql1);
				if(rs.next()){
					BigDecimal empid = (BigDecimal)rs.getObject("c_employeeid");
					String name = (String)rs.getObject("c_name");
					String employeestatus = (String)rs.getObject("c_employeestatus");
					BigDecimal unitid = (BigDecimal)rs.getObject("c_unitid");
					String unitname = (String)rs.getObject("c_unitname");
					BigDecimal jobid = (BigDecimal)rs.getObject("c_jobid");
					String jobName = (String)rs.getObject("c_jobname");
					String jobOrder = (String)rs.getObject("c_joborder");
					if(beginDate!=null&&beginDate.length()>1){
						//System.out.println("");
						//todo
					}else{
						if(!"0".equals(worktime)){
							Date date = formater.parse("2015-06-01"); 
							Calendar calendar = Calendar.getInstance();   
							calendar.setTime(date); 							
							BigDecimal bigDecimal = new BigDecimal(worktime).setScale(0, BigDecimal.ROUND_HALF_UP); 
							calendar.add(2,-bigDecimal.intValue());
							date = calendar.getTime();
							beginDate = formater.format(date);
							//System.out.println(beginDate);
							//todo
						}
					}
					String sql2 = "insert into TB_INF_TECPERSONINFO_0526 (C_OID,C_EMPOID,C_OPERATETIME,C_OPERATOR,C_BEGINDATE,C_ENDDATE,C_UNITID,C_UNITNAME,C_JOBID,C_JOBNAME,C_JOBORDER,C_JOBSENIORITYACC) VALUES (hibernate_sequence.nextval,"+empid.longValue()+",sysdate,0,to_date('"+beginDate +"','yyyy-mm-dd'),to_date('"+endDate +"','yyyy-mm-dd'),"+unitid.longValue()+",'"+unitname+"',"+jobid.longValue()+",'"+ jobName +"','"+ jobOrder +"',0)";	
					stmt.addBatch(sql2);
					
				}else{
					msg += "根据工号找不到对应员工;";
				}
				
			}
			stmt.executeBatch();
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			try{
				if(stmt!=null){
					stmt.close();
				}
				if(conn!=null){
					conn.close();
				}
			}catch(Exception e2){
				e2.printStackTrace();
			}
		}
	}
	
	public static String getCellValue(HSSFCell hssfCell){
		String cellValue = null;
	      if (hssfCell != null) {
	         switch (hssfCell.getCellType()) {
	            case HSSFCell.CELL_TYPE_NUMERIC :
	               if (HSSFDateUtil.isCellDateFormatted(hssfCell))
	                  cellValue = formater.format(hssfCell.getDateCellValue());
	               else
	                  cellValue = decimalFormatter.format(hssfCell.getNumericCellValue());
	               break;
	            case HSSFCell.CELL_TYPE_STRING :
	               cellValue = hssfCell.getStringCellValue().trim();
	               break;
	            case HSSFCell.CELL_TYPE_FORMULA :
	               if (!Double.isNaN(hssfCell.getNumericCellValue())) {
	                  if (HSSFDateUtil.isCellDateFormatted(hssfCell))
	                     cellValue = formater.format(hssfCell.getDateCellValue());
	                  else
	                     cellValue = decimalFormatter.format(hssfCell.getNumericCellValue());
	               } else if (!hssfCell.getStringCellValue().equals("")) {
	                  cellValue = hssfCell.getStringCellValue().trim();
	               } else {
	                   // 存在不可识别的数据格式
	                   throw new InfoCenterException(InfoCenterExceptionType.UNKNOWNDATATYPEEXCEPTION, 
	                            new Object[]{String.valueOf(hssfCell.getCellNum() + 1)});
	               }
	               break;
	            case HSSFCell.CELL_TYPE_BLANK :
	               cellValue = "";
	               break;
	            case HSSFCell.CELL_TYPE_BOOLEAN :
	               cellValue = String.valueOf(hssfCell.getBooleanCellValue());
	               break;
	            default :
	               //存在不可识别的数据格式
	               throw new InfoCenterException(InfoCenterExceptionType.UNKNOWNDATATYPEEXCEPTION, 
	                        new Object[]{String.valueOf(hssfCell.getCellNum() + 1)});
	         }
	      }else {
	         //单元格为空时，返回空串
	         cellValue = "";
	      }
	      return cellValue;
	}
	
	
}