1.当添加大量数据;
insert into tb_name () values (); #添加大量数据时将执行大量sql语句
2.使用批处理,将相关的sql语句分组到批处理中
Statementbatch
step:
1,创建语句
statement=connection.createStatement();
2.添加batch() addbatch()
statement.addBatch("insert into tb_batchtest (username,PASSWORD) values ('张三"+i+"','zhangsan123')");
3.执行batch() executebatch()
int result[]=statement.executeBatch();
4.关闭batch() clearbatch()
statement.clearBatch();
ps:给语句添加batch
PreparedStatement
1,创建语句
preparedstatment=con.prepareStatement(sql);
2.添加batch() addbatch()
preparedstatment.addBatch();//添加
3.执行batch() executebatch()
int result[]=preparedstatment.executeBatch();
4.关闭batch() clearbatch()
preparedstatment.clearBatch();
两者的区别:
在创建语句时,statement不能给里面写sql语句,可以执行多条不同的语句
preparedstatement给里边写sql语句,进行预编译,不能执行多条不同的语句