mybatis当属性为类型时，查询直接带出对象

<?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.modules.dao.mapper.CommandMapper">

	<!-- 表字段 -->
	<sql id="column">
		id,  <!-- id -->
		emergency,  <!-- proType -->
		uploadPersion,  <!-- proName -->
		treatMent,  <!-- cropName -->
		uploadTime,  <!-- Temperature -->
		assign,  <!-- saveMode -->
		enclosurePath
	</sql>
	<sql id="commandColumns">
		a.id AS "id",
		a.emergency AS "emergency.id",
		i.title AS "emergency.title",
		a.uploadPersion AS "uploadPersion.id_",
		j.name_ AS "uploadPersion.name_",
		a.treatMent AS "treatMent",
		a.uploadTime AS "uploadTime",
		a.assign AS "assign.id_",
		l.name_ AS "assign.name_",
		a.enclosurePath AS "enclosurePath",
		a.opinions AS "opinions"
	</sql>
	<sql id="joins">
		LEFT JOIN emergency i ON i.id = a.emergency
		LEFT JOIN Aos_sys_user j ON j.id_ = a.uploadPersion
		LEFT JOIN Aos_sys_user l ON l.id_ = a.assign
	</sql>

	<!-- 根据Dto查询并返回分页数据持久化对象集合 -->
	<select id="findByPage" parameterType="Dto" resultType="CommandPO"
		useCache="false">
		SELECT
		<include refid="commandColumns" />
		FROM command a
		<include refid="joins" />
	</select>

</mapper>