ibatis批量添加数据

最新推荐文章于 2021-12-28 16:39:09 发布

weixin_30872789

最新推荐文章于 2021-12-28 16:39:09 发布

阅读量82

点赞数

原文链接：http://www.cnblogs.com/bingrong/p/3139946.html

版权

public int addUserRole(List<UserRole> userRole) {
  int re = 1;
  SqlMapClient sqlMapClient = null;
  try {
   sqlMapClient = getSqlMapClientTemplate().getSqlMapClient();
   sqlMapClient.getDataSource().getConnection().setAutoCommit(false);
   sqlMapClient.startTransaction();   //开启事务    必须写，否则可能会出现事务没有开启的错误
   sqlMapClient.startBatch();        //开始批处理
   for (UserRole reply : userRole) {
    sqlMapClient.insert("insertUserRole", reply);
   }
   sqlMapClient.executeBatch();
   sqlMapClient.commitTransaction();
  } catch (Exception e) {
   e.printStackTrace();
   re = 0;
  } finally {
   try {
    // 结束事务
    sqlMapClient.endTransaction();
   } catch (SQLException e) {
    e.getMessage();
   }
  }
  // new Util().batchInsert("addWorkTrack", workTrack);
  return re;
}