Question

mysql，批量插入的时候能不能用预编译该如何解决

Answer 1

内容：
Connection conn = ConnectionObject.getConnection();
String insql = "insert into students(sid,sname,sex,age,address,tel) values(?,?,?,?,?,?)";
if(conn != null){
try {
sta = conn.createStatement();
ps = conn.prepareStatement(insql);
ps.setString(1, "tzcs008");
ps.setString(2, "朱玉丽");
ps.setCharacterStream(3, sr,sex.length());
ps.setInt(4, 22);
ps.setString(5, "宁乡");
ps.setString(6,"15985633254");
ps.executeUpdate();
}