出错了！！

[kkk3388191]

this.getHibernateTemplate().execute(new HibernateCallback<Integer>()
		{
			public Integer doInHibernate(Session session) throws HibernateException, SQLException
			{
				Query query = session.createSQLQuery("delete from t_roles_menus where roleId in (?)");
				query.setParameter(0, role.getId());
				Integer returnVal = query.executeUpdate();
				
				query = session.createSQLQuery("insert into t_roles_menus(roleId, menuId) values(?, ?)");
				
				Set<ZTreeNode> treeNodeSet = role.getTreeNodeSet();
				for(ZTreeNode node : treeNodeSet)
				{
					query.setInteger(0, role.getId());
					query.setInteger(0, node.getMenuId());
					returnVal = query.executeUpdate();
				}
				
				return returnVal;
			}
		});

20:50:52.801 [http-8080-3] WARN org.hibernate.util.JDBCExceptionReporter -- SQL Error: 17041, SQLState: null --
20:50:52.801 [http-8080-3] ERROR org.hibernate.util.JDBCExceptionReporter -- 索引中丢失 IN 或 OUT 参数:: 2 --

[kkk3388191]

query.setInteger(0, node.getMenuId()); 这句改为 query.setInteger(1, node.getMenuId());

[tony4geek]

楼上解决了。