Criteria criteria = session.createCriteria(Manhour.class);
//criteria.setProjection(Projections.groupProperty("this.manhourPk"));
criteria.add(Expression.in("group", gr));
criteria.createAlias("workWeek", "workWeek");
criteria.createAlias("project", "project");
criteria.add(Expression.eq("workWeek.state", "通过"));
criteria.add(Expression.eq("project.code", projectCode));
// criteria.createAlias("workWeek", "workWeek").add(Expression.eq("workWeek.state", "通过"));
// criteria.createAlias("project", "project").add(Expression.eq("project.code", "admmd"));
criteria.setProjection(Projections.groupProperty("group.id"));
criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
//criteria.add(Expression.sql (" and 1=1"));
manlist=criteria.list();我想按照group.id来分组,老是报java.lang.Integer。好像只查一个表,这么分组就能出来,是不是因为多表的关系啊?想在后面加sql语句来group by,怎么写都说语法错误criteria.add(Expression.sql (" and 1=1"));有人知道应该怎么写吗?
//criteria.setProjection(Projections.groupProperty("this.manhourPk"));
criteria.add(Expression.in("group", gr));
criteria.createAlias("workWeek", "workWeek");
criteria.createAlias("project", "project");
criteria.add(Expression.eq("workWeek.state", "通过"));
criteria.add(Expression.eq("project.code", projectCode));
// criteria.createAlias("workWeek", "workWeek").add(Expression.eq("workWeek.state", "通过"));
// criteria.createAlias("project", "project").add(Expression.eq("project.code", "admmd"));
criteria.setProjection(Projections.groupProperty("group.id"));
criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
//criteria.add(Expression.sql (" and 1=1"));
manlist=criteria.list();我想按照group.id来分组,老是报java.lang.Integer。好像只查一个表,这么分组就能出来,是不是因为多表的关系啊?想在后面加sql语句来group by,怎么写都说语法错误criteria.add(Expression.sql (" and 1=1"));有人知道应该怎么写吗?
写了这句之后,查出来就是group.id而不是想要的entity了