批量插入数据
@Test
public void testInsert() throws Exception {
Connection conn = null;
PreparedStatement ps = null;
try {
conn = JdbcUtils.getConnection();
String sql = "insert into blobtest (username,password,photo) values (?,?,?)";
ps = conn.prepareStatement(sql);
for (int i = 0; i < 200; i++) {
ps.setObject(1,"anglebaby"+i+1);
ps.setObject(2,"123");
int a = (i+13)%12;
FileInputStream is = new FileInputStream(new File("D:photo"+a+".jpg"));
ps.setBlob(3,is);
ps.execute();
}
} catch (Exception e) {
e.printStackTrace();
} finally {
JdbcUtils.closeResource(conn,ps);
}
}