src/main/resources/mapper/AppraiseMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.xtu.hrms.mapper.AppraiseMapper">
    <resultMap id="MyAppraise" type="com.xtu.hrms.bean.Appraise">
        <id column="id" property="id"/>
        <result column="eid" property="eid"/>
        <result column="appDate" property="appDate"/>
        <result column="appResult" property="appResult"/>
        <result column="appContent" property="appContent"/>
        <result column="remark" property="remark"/>

        <association property="emp" javaType="com.xtu.hrms.bean.Emp">
            <id column="e_id" property="id"/>
            <result column="name" property="name"/>
            <result column="age" property="age"/>
            <result column="gender" property="gender"/>
            <result column="birthday" property="birthday"/>
            <result column="IDCard" property="IDCard"/>
            <result column="wedlock" property="wedlock"/>
            <result column="nationId" property="nationId"/>
            <result column="nativePlace" property="nativePlace"/>
            <result column="email" property="email"/>
            <result column="phone" property="phone"/>
            <result column="address" property="address"/>
            <result column="deptId" property="deptId"/>
            <result column="posId" property="posId"/>
            <result column="degree" property="degree"/>
            <result column="school" property="school"/>
            <result column="edate" property="edate"/>
            <result column="workState" property="workState"/>
            <result column="eworkID" property="workID"/>
            <result column="conversionTime" property="conversionTime"/>
            <result column="workAge" property="workAge"/>
            <result column="notWorkDate" property="notWorkDate"/>
        </association>
    </resultMap>
    <select id="getAppraiseById" resultType="com.xtu.hrms.bean.Appraise">
        select * from appraise where id=#{id}
    </select>

    <select id="getAll" resultMap="MyAppraise">
        select a.id id,a.eid eid,a.appDate appDate,a.appResult appResult,a.appContent appContent, a.remark remark, e.id e_id,e.name name, e.gender gender, e.birthday birthday, e.IDCard IDCard, e.wedlock wedlock,
               e.nationId nationId, e.nativePlace nativePlace, e.email email, e.phone phone, e.address address,
               e.deptId deptId, e.posId posId, e.degree degree,e.school school, e.edate edate,
               e.workState workState, e.workID workID,e.conversionTime conversionTime,e.workAge workAge,e.notWorkDate notWorkDate
        from appraise a,emp e where a.eid=e.id
    </select>

    <select id="getAllAppraises" resultType="com.xtu.hrms.bean.Appraise">
        select * from appraise
    </select>

    <delete id="deleteAppraiseById">
        delete from appraise where id=#{id}
    </delete>

    <insert id="addAppraise" parameterType="com.xtu.hrms.bean.Appraise">
        insert into appraise (id, eid, appDate,