jdbc 批处理

[size=large][size=medium]public static void main(String[] args) {
Class.forName("sqldriver");
Connection conn = DriverManager.getConnection(URL,USER,PASS)

//无参，添加案例
Statement stmt = conn.createStatement();
stmt.addBatch("insert into authors(firstName，lastName) values('fegor','hack')");
stmt.addBatch("insert into authors(firstName，lastName) values('fegors','hacks')");
stmt.addBatch("insert into authors(firstName，lastName) values('fegorsr','hacksr')");
stmt.executeBatch();
stmt.close();
conn.close();

//带参,添加案例
PreparedStatement ps=conn.prepareStatement("insert into authors(firstName，lastName) values(?,?)");

ps.setString(1,"nihao1");//设置参数
ps.setString(2,"wohao1");
ps.addBatch(); //把语句加入批处理队列

ps.setString(1,"nihao2");
ps.setString(2,"wohao2");
ps.addBatch();

ps.setString(1,"nihao3");
ps.setString(2,"wohao3");
ps.addBatch();

ps.executeBatch(); //执行批处理

ps.close(); //最后关闭
conn.close();
}[/size][/size]