如下面代码所示,sql可以正常返回求和信息,mybatis为什么会回null ,是不是我的mapper映射有问题???
dao
public class CaseListInfo {
private Integer id;
private String courtName;
private String departName;
private String judgeName;
private Integer info1;
private Integer info2;
private Integer info3;
private Integer info4;
private Integer info5;
private Integer info6;
private Integer info7;
private Integer info8;
private Integer info9;
private Integer info10;
private Integer info11;
private Integer info12;
private String sMonth;
private String sYear;
......
}
sql语句,正常返回求和
SELECT
court_name,
depart_name,
SUM(info_1),
SUM(info_2)
FROM
caselist_info
WHERE
court_name = '***人民法院'
AND id IS NOT NULL
GROUP BY
court_name,
depart_name
Mappr 文件
SELECT
id, court_name, depart_name,
SUM(info_1) , SUM(info_2),
SUM(info_3), SUM(info_4), SUM(info_5),
SUM(info_6), SUM(info_7), SUM(info_8),
SUM(info_9), SUM(info_10), SUM(info_11),
SUM(info_12), s_month, s_year
FROM caselist_info
and court_name = #{courtName}
GROUP BY
court_name,
depart_name