第1个回答 推荐于2018-05-11
Connection conn = DBUtil.getConnection();//获取数据库链接
PreparedStatement stat = conn.prepareStatement("insert into T_TE_WWW_MANBA (id,name,age) values(?,?,?)");//定义sql语句。
BasketBollPlayer player = null;
for(int i=1;i<100000;i++)
{
player = new BasketBollPlayer(new Integer(i),"kebi"+i,"age"+1);
stat.setInt(1, player.getId());
stat.setString(2, player.getName());
stat.setString(3, player.getAge());
stat.addBatch();
if(i%500==0)//500提交一次,避免数据量太大内存溢出。
{
int[] flag = stat.executeBatch();/提交
stat.clearBatch();//清除。
System.out.println(flag+"i");
}
}
stat.executeBatch();//提交本回答被网友采纳