java 多表查询并显示

1[img]http://dl.iteye.com/upload/attachment/609918/8708d464-bb6d-32d7-8f85-87a0aa78e55a.jpg[/img]

2[img]http://dl.iteye.com/upload/attachment/609923/7e272522-780f-3623-adf3-67935e1166ec.jpg[/img]

3[img]http://dl.iteye.com/upload/attachment/609920/e3655886-8c64-3322-81a1-a825f054b573.jpg[/img]

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