|
楼主 |
发表于 2014-4-23 15:14:37
|
显示全部楼层
jishuang 发表于 2014-4-23 15:10
把java中完整的代码发一下看看
public boolean getExcle() throws FileNotFoundException, IOException, ClassNotFoundException, SQLException {
// TODO Auto-generated method stub
File file = new File("C:\\ZD_CBF.xls");
String[][] result = DBsql.getData(file, 1);
int rowLength = result.length;
CbfModel cm = new CbfModel();
//链接数据库驱动
Connection conn=null;
PreparedStatement ps=null;
conn=DBConnection.getConn();
// ps=conn.prepareStatement("delete from ZD_CBF");
// ps.executeUpdate();
try {
conn.setAutoCommit(false);
for(int i=0;i<rowLength;i++) {
for(int j=0;j<result.length;j++) {
}
UUID uuid = UUID.randomUUID();
String uu =uuid.toString().replace("-", "");
cm.setFid(uu);
cm.setCBFBM(result[1]);
cm.setfYSHTBH(result[2]);
cm.setCBFDBXM(result[3]);
cm.setCBFDBZJLX(result[4]);
cm.setBFDBZJHM(result[5]);
cm.setCBFZZ(result[6]);
cm.setYZBM(result[7]);
cm.setLXDH(result[8]);
cm.setCBJTRKS((null!=result[9]&&!"".equals(result[9]))?Integer.parseInt(result[9]):0);
cm.setfXB(result[10]);
// System.out.println();
ps=conn.prepareStatement("insert into ZD_CBF (fid,version,CBFBM,fYSHTBH,CBFDBXM,CBFDBZJLX,BFDBZJHM,CBFZZ,YZBM,LXDH,CBJTRKS,fXB)values(?,0,?,?,?,?,?,?,?,?,?,?)");
ps.setString(1, cm.getFid());
ps.setString(2, cm.getCBFBM());
ps.setString(3, cm.getfYSHTBH());
ps.setString(4, cm.getCBFDBXM());
ps.setString(5, cm.getCBFDBZJLX());
ps.setString(6, cm.getBFDBZJHM());
ps.setString(7, cm.getCBFZZ());
ps.setString(8, cm.getYZBM());
ps.setString(9, cm.getLXDH());
ps.setInt(10, cm.getCBJTRKS());
ps.setString(11, cm.getfXB());
ps.executeUpdate();
}
conn.commit();//提交JDBC事务,如果没问题,这时才真正的删除了;
conn.setAutoCommit(true);// 恢复JDBC事务的默认提交方式,这是个好习惯;
return true;//删除成功
} catch (Exception exc){
conn.rollback();//回滚JDBC事务,出现异常,为保证数据完整性,此次操作回滚,不删除;
exc.printStackTrace();//输出异常信息;
return false;//删除失败
} finally {
ps.close();
conn.close();
if(file.exists())
file.delete();
}
} |
|