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;
}