java 多表查询并显示
1

2

3

SQL：
SELECT businessType ,userName ,count(businessType) as countNum
FROM task ,tasknode where tasknode.taskId = task.id
and tasknode.userId in (select id from HI_User WHERE org = 1)
group by businessType ,username

Action:
private List list;
HiUser user = org.hi.framework.security.context.UserContextHelper.getUser();//获取登录的用户
public String countNum(){
list = JianGuanLvZhiService.countJianGuanLvZhi(user);//获取登录用户的信息
returnPageURL="/taskManagement/jianguanlvzhi/JianGuanLvZhi.jsp";
return "dispatcher";
}

get/set方法

Service:
private static List list;
public static List countJianGuanLvZhi(HiUser user) {
String sql = "SELECT businessType ,userName ,count(businessType) as countNum " +
"FROM task ,tasknode where tasknode.taskId = task.id and tasknode.userId in " +
"(select id from HI_User WHERE org = "+user.getOrg().getId()+") group by businessType ,username";
//根据登录用户信息里的orgid列出部门所有人员名单,
SpringJdbcBase springJdbcBase = (SpringJdbcBase) SpringContextHolder.getBean("springJdbcBase");
list = springJdbcBase.getJdbcTemplate().queryForList(sql);
return list;
}