新人，求大神给看下

最新推荐文章于 2024-09-06 01:19:09 发布

bizhicuan4095

最新推荐文章于 2024-09-06 01:19:09 发布

阅读量77

点赞数

本文链接：https://blog.csdn.net/bizhicuan4095/article/details/53977874

版权

public static void insert(ArrayList<MsgBean> am) throws SQLException
{
Connection conn=null;
try {
conn=DBopertate.connection();
PreparedStatement ppst=conn.prepareStatement("insert into testtable (search_name1,search_name2,search_name3,search_sort,del_flag) values (?,?,?,?,'1')");
for (int i=0;i<am.size();i++) //for循环里面压根不执行
{
MsgBean tmp=new MsgBean();
tmp=am.get(i);
ppst.setString(1, tmp.getSearch_name1());
ppst.setString(2, tmp.getSearch_name2());
ppst.setString(3, tmp.getSearch_name3());
ppst.setInt(4, tmp.getSearch_sort());
ppst.addBatch();
}
ppst.executeBatch();
//System.out.println("hello");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
if (conn!=null)
{
try {
conn.close();
} catch (Exception e2) {
// TODO: handle exception
}
finally
{
conn=null;
}
}
}
}