Mybatis返回统计字段

1.Mapper.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bigdata.lewis.mapper.Job51Mapper">
    <resultMap id="addressMap" type="Job51">
        <result property="address" column="address" jdbcType="VARCHAR"/>
        <result property="address_count" column="addressCount" jdbcType="INTEGER"/>
    </resultMap>
    <select id="addressCount" resultMap="addressMap">
        select address,count(address) as address_count from job51 GROUP BY address order by address_count desc
    </select>
</mapper>

2.entity新增addressCount字段

@Data
public class Job51 implements Serializable {

    private static final long serialVersionUID = 1L;
    private String jobName;
    private String companyName;
    private String salary;
    private String avgSalary;
    private String address;
    private String issuedate;
    private String jobwelf;
    private String companysize;
    private String workYear;
    private String education;
    private String jobHref;
    //新增的字段
    private Integer addressCount;
}