JDBC（五）—— 批量插入数据

批量插入数据

@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);
    }
​
}