mysql 插入10万条数据 优化效率
程序员文章站
2022-06-09 19:29:34
...
mysql优化
public int addTypes(List babyList) { String sql = "insert into type (typeid,url) values (?,?) "; Connection conn = dbhelper.getConnection(driver,url,username,upwd); int result = 0; PreparedStatement stmt =null; try { stmt = conn.prepareStatement(sql); for(int i=0;i