struts2+spring+hibernate中使用jdbc批量添加

   项目中需要用到批量添加，考虑到新能问题用jdbc实现.
   记录下来,以后会用.

public void createRolePermissionBySql(final String roleId,final String[] permIds){
		
		getHibernateTemplate().execute(new HibernateCallback() {
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				if(permIds==null||permIds.length==0)
					      return null;
				Connection conn=session.connection();
				PreparedStatement ps=null;
				String sql=" insert into base_role_permission (ROLE_PERM_ID,PERM_ID,ROLE_ID,CREATE_DATE)" +
						   " values (?,?,?,?) ";
				ps=conn.prepareStatement(sql);
				if(log.isDebugEnabled())
					   log.debug("batch add base_role_permission:"+sql);
				UUIDHexGenerator uuidGenerator=null;
				for(String permId:permIds){
					uuidGenerator=new UUIDHexGenerator();
					ps.setString(1,uuidGenerator.generate(null, null).toString());
					ps.setString(2,permId);
					ps.setString(3, roleId);
					ps.setDate(4, DateUtils.getJavaSqlDate());
					ps.addBatch();
				}
				int[] counts=ps.executeBatch();
				ps.close();
				session.flush();
				session.close();
				return null;
			}
		});
	}