mapper and mybatis

mapper的xml映射文件格式

<?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="mapper文件的包路径">


</mapper>

select查询标签

<select id="selectCompLabourList" parameterType="CompLabour" resultMap="CompLabourResult">
        <include refid="selectCompLabourVoNew"/>
        <where>
            <if test="deptId != null ">and l.dept_id = #{deptId}</if>
            <if test="minAge != null ">and l.min_age = #{minAge}</if>
            <if test="maxAge != null ">and l.max_age = #{maxAge}</if>
            <if test="labourType != null  and labourType != ''">and l.labour_type = #{labourType}</if>
            <if test="unitHour != null ">and l.unit_hour = #{unitHour}</if>
        </where>
    </select>

mapper接口

    public List<CompLabour> selectCompLabourList(CompLabour compLabour);

parameterType标签

接受mapper接口对应方法传递到xml映射文件的参数

resultMap标签

resultMap的用法以及关联结果集映射
封装xml映射文件方法的结果,传递给mapper.

resultMap定义对象

    <resultMap type="CompLabour" id="CompLabourResult">
        <id property="id" column="id"/>
        <result property="deptId" column="dept_id"/>
        <result property="age" column="age"/>
        <result property="deptName" column="dept_name"/>
        <result property="minAge" column="min_age"/>
        <result property="maxAge" column="max_age"/>
        <result property="labourType" column="labour_type"/>
        <result property="unitHour" column="unit_hour"/>
        <result property="createBy" column="create_by"/>
        <result property="createTime" column="create_time"/>
        <result property="updateBy" column="update_by"/>
        <result property="updateTime" column="update_time"/>
    </resultMap>

type

实体对象