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;

 }