DbUtils获取不到count(*)的值
sql:
SELECT
r.superm_id,
d.department_name,
COUNT(*) AS count_smsun
FROM rsd r,dpt d
WHERE r.superm_id=d.department_id
AND
rsd_status='已复核'
GROUP BY r.superm_id
ORDER BY r.superm_id DESC ;
java代码:
DbUtils
Report_result_list = runner.query(conn, sb.toString(), new BeanListHandler<Report_result>(Report_result.class), list.toArray());
javaBean:
Report_result类:
//部门id
private int superm_id;
//部门名称
private String department_name;
//合计
private int count;
前面两个都可以获取到值,就是合计count获取不到呀,大神帮帮忙啊,怎么搞才能获取到count(*)的值。DbUtils还能用吗?