67,513
社区成员
发帖
与我相关
我的任务
分享
public class AssessTeach{
private Long id;
private String staffid;
private String content;
//其他属性以及getter() and setter()方法就不写了
}
public class AssessTeachComp{
private String year = "";
private AssessTeach entity = null;
//其他属性以及getter() and setter()方法就不写了
}
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<!-- 不使用namespace的话sql搜索定位会比较方便 -->
<mapper namespace="AssessTeach">
<resultMap id="RM.AssessTeachComp" type="com.zf.hrm.assess.model.AssessTeachComp">
<result property="year" column="YEAR"/>
<result property="editable" column="EDITABLE" />
<association property="entity" javaType="com.zf.hrm.assess.model.AssessTeach"
resultMap="RM.AssessTeach"></association>
</resultMap>
<resultMap id="RM.AssessTeach" type="com.zf.hrm.assess.model.AssessTeach">
<id property="id" column="ID"/>
<result property="staffid" column="STAFFID"/>
<result property="starttime" column="STARTTIME"/>
<result property="endtime" column="ENDTIME"/>
<result property="curriculum" column="CURRICULUM"/>
<result property="content" column="CONTENT"/>
<result property="kind" column="KIND"/>
<result property="student" column="STUDENT"/>
<result property="studentcount" column="STUDENTCOUNT"/>
<result property="sumhour" column="SUMHOUR"/>
<result property="assess" column="ASSESS"/>
<result property="remark" column="REMARK"/>
</resultMap>
<sql id="AssessTeach.compColumns">
<!-- 此处定义字段时删除 YEAR和EDITABLE就能够查询到多条 -->
<![CDATA[
YEAR, EDITABLE,
B.ID, B.STAFFID, B.STARTTIME, B.ENDTIME, B.CURRICULUM, B.CONTENT,
B.KIND, B.STUDENT, B.STUDENTCOUNT, B.SUMHOUR, B.ASSESS, B.REMARK
]]>
</sql>
<select id="AssessTeach.list" resultMap="RM.AssessTeachComp">
SELECT <include refid="AssessTeach.compColumns" />
<![CDATA[
FROM ASSESS_TEACH_COMP, ASSESS_TEACH B
WHERE TEACH_ID = B.ID
AND YEAR = #{year}
AND B.STAFFID = #{entity.staffid}
]]>
</select>
</mapper>