src/conf/dao/DormitoryDao.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="dao.DormitoryDao" >

    <!--分页查询-->
    <select id="getDormitoryList" parameterType="Dormitory" resultType="Dormitory">
        select *from d_dormitoryinfo
        <where>
            <if test="a_name!=null and a_name!=''">
                and  a_name like  '%${a_name}%'
            </if>
            <if test="s_dormitoryid!=null and s_dormitoryid!=0">
                and  s_dormitoryid like  '%${s_dormitoryid}%'
            </if>
            <if test="d_dormbuilding !=null and d_dormbuilding !=''">
                and  d_dormbuilding like  '%${d_dormbuilding}%'
            </if>
        </where>
        ORDER BY  d_id asc
        limit #{currentPage},#{pageSize}
    </select>
    <!--查询数据总数-->
    <select id="totalCount"  resultType="Integer">
        select count(s_dormitoryid) from d_dormitoryinfo
        <where>
            <if test="a_name!=null and a_name!=''">
                and  a_name like  '%${a_name}%'
            </if>
            <if test="s_dormitoryid!=null and s_dormitoryid!=0">
                and  s_dormitoryid like  '%${s_dormitoryid}%'
            </if>
            <if test="d_dormbuilding !=null and d_dormbuilding !=''">
                and  d_dormbuilding like  '%${d_dormbuilding}%'
            </if>
          </where>
    </select>

    <!--添加宿舍信息-->
    <insert id="addDormitory" parameterType="Dormitory" keyProperty="d_id" useGeneratedKeys="true">
        insert into d_dormitoryinfo (s_dormitoryid,d_dormbuilding,d_bedtotal,d_bed,a_name)
        values(#{s_dormitoryid},#{d_dormbuilding},#{d_bedtotal},#{d_bed},#{a_name})
    </insert>

    <!--通过id删除宿舍信息-->
    <delete id="deleteDormitory" parameterType="Integer" >
        delete from d_dormitoryinfo where d_id=#{d_id}
    </delete>

    <select id="findDormitoryById"  parameterType="Integer" resultType="Dormitory" >
        select * from d_dormitoryinfo where d_id=#{d_id}
    </select>

    <!--修改宿舍信息-->
    <update id="updateDormitory" parameterType="Dormitory">
        update d_dormitoryinfo
        <set>
            <if test="s_dormitoryid!=null and s_dormitoryid!=0">
                s_dormitoryid=#{s_dormitoryid},
            </if>