这个东西实现很简单 我写一个,你根据实际改//批量执行方法 public void executeBatch(List sqlList)throws SQLException{ for (int i = 0; i < sqlList.size(); i++) { stmt.addBatch((String) sqlList.get(i)); } stmt.executeBatch(); } //调用方法以oracle得dept表为例 DBAccess access = new DBAccess(); List sqlList = new ArrayList(); sqlList.add("insert into dept values(80,'JAVA','北京')"); sqlList.add("insert into dept values(81,'C++','上海')"); sqlList.add("insert into dept values(82,'PHP','广州')"); access.executeBatch(sqlList);这是一种拼sql,你也可以用与编译,传参数的形式
我写一个,你根据实际改//批量执行方法
public void executeBatch(List sqlList)throws SQLException{
for (int i = 0; i < sqlList.size(); i++) {
stmt.addBatch((String) sqlList.get(i));
}
stmt.executeBatch();
}
//调用方法以oracle得dept表为例
DBAccess access = new DBAccess();
List sqlList = new ArrayList();
sqlList.add("insert into dept values(80,'JAVA','北京')");
sqlList.add("insert into dept values(81,'C++','上海')");
sqlList.add("insert into dept values(82,'PHP','广州')");
access.executeBatch(sqlList);这是一种拼sql,你也可以用与编译,传参数的形式
public void executeBatch(String sql,List paramList)throws SQLException{
stmt=conn.prepareStatement(sql);
for(int i = 0 ; i<paramList.size();i++){
List param = (List)paramList.get(i);
stmt.setInt(1,Integer.valueOf((String)param.get(0)));
stmt.setString(2,(String)param.get(1));
stmt.setString(3,(String)param.get(2));
stmt.addBatch();
}
stmt.executeBatch();
}
//调用
DBUtil access = new DBUtil();
String sql="insert into dept values(?,?,?)";
List paramList = new ArrayList();
List param = new ArrayList();
param.add("90");
param.add("C");
param.add("北京");
paramList.add(param);
param = new ArrayList();
param.add("91");
param.add("Perl");
param.add("上海");
paramList.add(param);
param = new ArrayList();
param.add("92");
param.add("C#");
param.add("广州");
paramList.add(param);
access.executeBatch(sql,paramList);
<textarea name='mobiles' >String mobiles=getParameter("mobiles");
String mobilesArray=mobile.splt("\n");
for(String mobile:mobilesArray)
{
insert into table ......
}