<resultMap id="BaseResultMap" type="a.b.c.d.e">
? ? <id column="id" property="id" />
? ? <result property="workTime" column="work_time" />
? ? <result property="model" column="model" />
? ? <result property="status" column="status" />
? ? <association property="interfaceUpstream" javaType="interfaceUpstream" columnPrefix="ui_">
? ? ? <id column="id" property="id" />
? ? ? <result property="interfaceName" column="interface_name" />
? ? ? <result property="interfaceType" column="interface_type" />
? ? ? <result property="frequency" column="frequency" />
? ? ? <result property="address" column="address" />
? ? ? <result property="templateOrSql" column="template_or_sql" />
? ? ? <result property="status" column="status" />
? ? ? <association property="systemInfo" javaType="SystemInfo" columnPrefix="sys_">
? ? ? ? <id column="id" property="id"/>
? ? ? ? <result property="systemName" column="system_name"/>
? ? ? ? <result property="systemNameEN" column="system_name_en"/>
? ? ? ? <result property="belong" column="belong"/>
? ? ? ? <result property="status" column="status"/>
? ? ? </association>
? ? ? <association property="serverInfo" javaType="ServerInfo" columnPrefix="ser_">
? ? ? ? <id column="id" property="id"/>
? ? ? ? <result property="ftpIp" column="ftp_ip"/>
? ? ? ? <result property="ftpPort" column="ftp_port"/>
? ? ? ? <result property="ftpAccount" column="ftp_account"/>
? ? ? ? <result property="ftpPassword" column="ftp_password"/>
? ? ? </association>
? ? </association>
? </resultMap>

<sql id="base_select">
? ? SELECT
?? ?ii.Id,
?? ?ii.model,
?? ?ii.status,
?? ?ii.work_time,
?? ?ui.id AS ui_id,
?? ?ui.interface_name AS ui_interface_name,
?? ?ui.interface_type AS ui_interface_type,
?? ?ui.frequency AS ui_frequency,
?? ?ui.address AS ui_address,
?? ?ui.template_or_sql AS ui_template_or_sql,
?? ?ui.status AS ui_status,
?? ?sys.id AS sys_id,
?? ?sys.system_name AS sys_system_name,
?? ?sys.system_name_en AS sys_system_name_en,
?? ?sys.belong AS sys_belong,
?? ?sys.status AS sys_status,
?? ?ser.id AS ser_id,
?? ?ser.ftp_ip AS ser_ftp_ip,
?? ?ser.ftp_port AS ser_ftp_port,
?? ?ser.ftp_account AS ser_ftp_account,
?? ?ser.ftp_password AS ser_ftp_password
? </sql>

SELECT
?? ?ii.Id,
?? ?ii.model,
?? ?ii.status,
?? ?ii.work_time,
?? ?ui.id AS ui_id,
?? ?ui.interface_name AS ui_interface_name,
?? ?ui.interface_type AS ui_interface_type,
?? ?ui.frequency AS ui_frequency,
?? ?ui.address AS ui_address,
?? ?ui.template_or_sql AS ui_template_or_sql,
?? ?ui.status AS ui_status,
?? ?sys.id AS ui_sys_id,
?? ?sys.system_name AS ui_sys_system_name,
?? ?sys.system_name_en AS ui_sys_system_name_en,
?? ?sys.belong AS ui_sys_belong,
?? ?sys.status AS ui_sys_status,
?? ?ser.id AS ui_ser_id,
?? ?ser.ftp_ip AS ui_ser_ftp_ip,
?? ?ser.ftp_port AS ui_ser_ftp_port,
?? ?ser.ftp_account AS ui_ser_ftp_account,
?? ?ser.ftp_password AS ui_ser_ftp_password

<resultMap id="userInfoMap" type="com.advancedc.hrsys.entity.UserInfo">
		<id column="id" property="id" />
		<result column="name" property="name" />
		<result column="gender" property="gender" />
		<result column="id_card" property="idCard" />
		<result column="is_married" property="isMarried" />
		<result column="phone" property="phone" />
		<result column="priority" property="priority" />
		<result column="entry_time" property="entryTime" />
		<result column="full_time" property="fullTime" />
		<result column="created_time" property="createdTime" />
		<result column="edited_time" property="editedTime" />
		<association property="jobDepartment" column="id"
			javaType="com.advancedc.hrsys.entity.JobDepartment">
			<id column="jdid" property="id" />
			<result column="jdname" property="name" />
		</association>
		<association property="jobPosition" column="id"
			javaType="com.advancedc.hrsys.entity.JobPosition">
			<id column="jpid" property="id" />
			<result column="jpname" property="name" />
		</association>
	</resultMap>

<select id="queryUserInfoBySomeone" resultMap="userInfoMap" resultType="com.advancedc.hrsys.entity.UserInfo">
		SELECT
		ui.id,
		ui.name,
		ui.gender,
		ui.id_card,
		ui.is_married,
		ui.department_id,
		ui.position_id,
		ui.phone,
		ui.priority,
		ui.entry_time,
		ui.full_time,
		ui.created_time,
		ui.edited_time,
		jd.id jdid,
		jd.name jdname,
		jp.id jpid,
		jp.name jpname
		FROM
		hr_user_info ui
		INNER JOIN
		hr_job_department jd
		ON
		ui.department_id=jd.id
		INNER JOIN
		hr_job_position jp
		ON
		ui.position_id=jp.id
		<where>
			<if test="someone.id>0">
			and ui.id = #{someone.id}
			</if>
			<if test="someone.gender!=null">
			and ui.gender = #{someone.gender}
			</if>
			<if test="someone.name!=null">
			and ui.name = #{someone.name}
			</if>
			<if test="someone.idCard!=null">
			and ui.id_card = #{someone.idCard}
			</if>
			<if test="someone.isMarried!=null">
			and ui.is_married = #{someone.isMarried}
			</if>
			<if test="someone.jobDepartment!=null and someone.jobDepartment.id!=null">
			and ui.department_id = #{someone.jobDepartment.id}
			</if>
			<if test="someone.jobPosition!=null and someone.jobPosition.id!=null">
			and ui.position_id = #{someone.jonPosition.id}
			</if>
			<if test="someone.phone!=null">
			and ui.phone = #{someone.phone}
			</if>
			<if test="someone.entryTime!=null">
			and ui.entry_time = #{someone.entryTime}
			</if>
			<if test="someone.fullTime!=null">
			and ui.full_time = #{someone.fullTime}
			</if>
		</where>
	</select>

SELECT
		ui.id,
		ui.name,
		ui.gender,
		ui.id_card,
		ui.is_married,
		ui.department_id,
		ui.position_id,
		ui.phone,
		ui.priority,
		ui.entry_time,
		ui.full_time,
		ui.created_time,
		ui.edited_time,
		(select id jdid from hr_job_department jd where jd.id=ui.department_id) jdid,
		(select name jdname from hr_job_department jd where jd.id=ui.department_id) jdname,
		(select id jpid from hr_job_position jp where jp.id=ui.position_id) jpid,
		(select name jpname from hr_job_position jp where jp.id=ui.position_id) jpname
		FROM
		hr_user_info ui;