Java codepublic void addStudent(List students) {
Connection conn = DB.getConnection();
String sql = "insert into student values(?, ?, ?)";
PreparedStatement pstmt = null;
try {
pstmt = conn.prepareStatement(sql);
conn.setAutoCommit(false);
for(int i=0; i
Student s = students.get(i);
pstmt.setInt(1, s.getId());
pstmt.setString(2, s.getName());
pstmt.setInt(3, s.getAge());
pstmt.addBatch();
}
pstmt.executeBatch();// 在此卡住,没有出现异常,但就是不动
conn.commit();
conn.setAutoCommit(true);
} catch (SQLException e) {
try {
conn.rollback();
conn.setAutoCommit(true);
} catch (SQLException e1) {
e1.printStackTrace();
}
e.printStackTrace();
} finally {
DB.close(pstmt);
DB.close(conn);
}
}
最后
以上就是娇气含羞草最近收集整理的关于java preparedstatement batch,PreparedStatement的executeBatch()步骤为什么执行不过去的全部内容，更多相关java内容请搜索靠谱客的其他文章。
发表评论 取消回复