mybatis 返回部分字段,这里介绍两种方式(主推第一种)
一、.xml文件中,resultMap的 type改为 java.util.HashMap 即可,其余代码都不用写, 亲测可用,xml文件中代码如下:
<!-- 返回类型 -->
<resultMap id="testRestMap" type="java.util.HashMap">
<result column="province_name" jdbcType="VARCHAR" property="provinceName" />
<result column="area_name" jdbcType="VARCHAR" property="areaName" />
<result column="lane_num" jdbcType="VARCHAR" property="laneNum" />
<result column="road_name" jdbcType="VARCHAR" property="roadName" />
</resultMap>
<!--sql查询 -->
<select id="selTest" resultMap="testRestMap">
select
province_name,
area_name,lane_num,
road_name
from site_info
where 1=1
and del_flag='0'
</select>
二、第二种很笨的方法。重新新建一个对象实体,该实体文件的字段与要返回的 “部分字段” 一一对应即可,代码如下:
resultMap 的type=com.sinosoft.pojo.DeviceNumber 指向一个文件,该文件为新建实体类,里面是要返回的 “部分字段”
<!-- 全省设备数量统计 数据返回 -->
<resultMap id="DeviceNumber" type="com.sinosoft.pojo.DeviceNumber">
<result column="distCode" jdbcType="VARCHAR" property="distCode" />
<result column="distName" jdbcType="VARCHAR" property="distName" />
<result column="number" jdbcType="VARCHAR" property="number" />
</resultMap>
<!-- 全省设备数量统计 -->
<select id="statisticsDevice" resultMap="DeviceNumber">
SELECT
t1.distCode,
t1.distName,
t2.number
FROM
(
select
fd_objectid distCode,
area_name distName
FROM t_sys_area
WHERE LEVEL='2'
) t1 LEFT JOIN (
SELECT
city_no,
count(*) as number
FROM site_info
WHERE 1=1
and del_flag='0'
and is_bridge!='1'
GROUP BY city_no
)t2 on t2.city_no=t1.distCode
</select>
DeviceNumber 文件内容如下:
package com.sinosoft.pojo;
/**
* 数据返回
* @author zhangyajuan
*
*/
public class DeviceNumber {
private String distCode;//行政区划
private String distName;//行政区划名称
private String number;//设备数量
public String getDistCode() {
return distCode;
}
public void setDistCode(String distCode) {
this.distCode = distCode;
}
public String getDistName() {
return distName;
}
public void setDistName(String distName) {
this.distName = distName;
}
public String getNumber() {
return number;
}
public void setNumber(String number) {
this.number = number;
}
}