mybatis-mapper.xml配置

最新推荐文章于 2024-01-26 09:34:17 发布

菜到不能自已的程序员

最新推荐文章于 2024-01-26 09:34:17 发布

阅读量572

点赞数 1

分类专栏： Java框架文章标签： mybatis 数据库 sql

本文链接：https://blog.csdn.net/HMH_huige/article/details/125446846

版权

Java框架专栏收录该内容

7 篇文章 0 订阅

订阅专栏

<?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="cp.cpgroup.mapper.DeptMapper">
   
    <insert id="insertUser" useGeneratedKeys="true" keyProperty="no">
        insert into dept(name,type_id,note) values(#{name},#{typeId},#{note})
    </insert>
    <delete id="deleteMore" >
        delete from dept where no in (${ids})
    </delete>
    <delete id="deleteMoreByArray">
        delete from dept where no in
        <foreach collection="deptIds" item="id" separator="," open="(" close=")">
            #{id}
        </foreach>

    </delete>
    <select id="list" resultMap="baseResultMap">
        select no,name,type_id,note from dept
    </select>
    <select id="getByName" resultType="cp.cpgroup.Dept">
        select * from dept where name = '${name}'
    </select>
    <select id="getByNameOrTypeId" resultType="cp.cpgroup.Dept">
        select * from dept where name = #{name} or type_id = #{typeId}
    </select>
    <select id="getByLikeName" resultType="cp.cpgroup.Dept">
        select * from dept where name like '%${name}%'
--       select * from dept where name like concat ('%',#{name},'%')
    </select>
    <select id="getUserByTableName" resultType="cp.cpgroup.Dept">
        select * from ${tableName}
    </select>
    <select id="getEmpAndDeptByStepTwo" resultType="cp.cpgroup.Dept">
        select * from dept where no = #{no}
    </select>
    <select id="getDeptAndEmp" resultMap="deptResultMap">
       select * from dept left join emp  on dept.no = emp.dept_no where dept.no = #{id}
    </select>
    <select id="getDeptAndEmpByStepOne" resultMap="deptResultByStep">
        select * from dept where no = #{no}
    </select>
    <select id="getEmpByCondition" resultType="cp.cpgroup.Dept">
        select * from dept
        <!--prefix/suffix将trim标签中前面或者后面添加指定的内容
            suffixOverriders|prefixoverrides将trim标签前面或后面去掉指定内容
        -->
       <trim prefix="where"  suffixOverrides = "and|or" >
           <if test="name!=null and name!=''">
                name = #{name}  and
           </if>
           <if test="note!=null and note!=''">
              note = #{note}  or
           </if>
       </trim>
    </select>
    <resultMap id="baseResultMap" type="Dept">
        <result property="no" column="no"/>
        <result property="typeId" column="type_id"/>
        <result property="note" column="note"/>
        <result property="name" column="name"/>
    </resultMap>
    <resultMap id = "deptResultMap" type="Dept">
        <id  property="no" column="no"/>
        <result property="typeId" column="type_id"/>
        <result property="note" column="note"/>
        <result property="name" column="name"/>
        <collection property="emps" ofType="Emp">
            <id property="id" column="id"></id>
            <result property="name" column="name"></result>
        </collection>
    </resultMap>
    <resultMap id = "deptResultByStep" type="Dept">
        <id  property="no" column="no"/>
        <result property="typeId" column="type_id"/>
        <result property="note" column="note"/>
        <result property="name" column="name"/>
        <collection property="emps" select="cp.cpgroup.mapper.EmpMapper.getDeptAndEmpByStepTwo" column="no">
            <id property="id" column="id"></id>
            <result property="name" column="name"></result>
        </collection>
    </resultMap>
    
</mapper>