jdbc批量添加:
/**
* 批量save专家意见list
*/
public void saveBatchZjyjList(List<ZxDZjyj> zjyjList) {
Connection conn = null;
PreparedStatement ps = null;
try {
Session session = template.getSessionFactory().getCurrentSession();
conn = session.connection();
String sql = "insert into ZX_D_ZJYJ(uuid,hsbm,zjmc,ssdw,zc,lxfs,zjyj,cjsj) values (?,?,?,?,?,?,?,?)";
ps = conn.prepareStatement(sql);
for (ZxDZjyj zjyj:zjyjList) {
ps.setString(1, generateUuid());
ps.setString(2, zjyj.getHsbm());
ps.setString(3, zjyj.getZjmc());
ps.setString(4, zjyj.getSsdw());
ps.setString(5, zjyj.getZc());
ps.setString(6, zjyj.getLxfs());
ps.setString(7, zjyj.getZjyj());
ps.setTimestamp(8, Timestamp.valueOf(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(zjyj.getCjsj())));
ps.addBatch();
}
ps.executeBatch();
} catch (SQLException ex) {
ex.printStackTrace();
} finally{
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn != null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
jdbc批量删除:
/**
* 批量delete专家意见list
*/
public void delBatchZjyjList(ZxDHsjl hsjl) {
Connection conn = null;
PreparedStatement ps = null;
try {
Session session = template.getSessionFactory().getCurrentSession();
conn = session.connection();
String sql = "delete from ZX_D_ZJYJ where hsbm=?";
ps = conn.prepareStatement(sql);
ps.setString(1, hsjl.getUuid());
ps.addBatch();
ps.executeBatch();
} catch (SQLException ex) {
ex.printStackTrace();
} finally{
if(ps != null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn !=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}