public static void insertDataItem(Connection conn,List<Map<String,String>> data){
PreparedStatement pst=null;
try {
conn.setAutoCommit(false);
String sql="insert into t_res_dataitem(ID,NAME_EN,NAME_CN,DATA_TYPE,LENGTH,DE_IDENTIFIER) values(?,?,?,?,?,?)";
pst=conn.prepareStatement(sql);
for(Map<String,String> row:data){
pst.setString(1,row.get("0"));
pst.setString(2,row.get("1"));
pst.setString(3,row.get("2"));
pst.setString(4,row.get("3"));
pst.setString(5,row.get("4"));
pst.setString(6,row.get("5"));
pst.addBatch();
}
pst.executeBatch();
conn.commit();
} catch (SQLException e) {
e.printStackTrace();
}finally{
close(null, pst, conn);
}
}
java批量插入数据到Oracle
最新推荐文章于 2023-10-26 10:01:24 发布