Mybatis处理多个Sum()结果返回null

Mybatis处理多个Sum()结果返回null

如下面代码所示,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 文件

相关文章