target/classes/mapper/staff.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">
<!-- 这里填写对应的Dao文件所在的路径 -->
<mapper namespace="com.staff">
<!-- parameterType就是你接受的参数的类型，  -->

 <!-- 查询员工信息    -->
    <select id="getAll" parameterType="java.util.Map" resultType="java.util.Map">
        SELECT
        *
        FROM
        staff
        where 1=1
        <if test=" null != username and username!=''" >
        and username like concat(concat('%',#{username}),'%')
        </if>
        <if test=" null != passworda and passworda!=''" >
        and passworda like concat(concat('%',#{passworda}),'%')
        </if>
        <if test=" null != fullname and fullname!=''" >
        and fullname like concat(concat('%',#{fullname}),'%')
        </if>
        <if test=" null != power and power!=''" >
        and power like concat(concat('%',#{power}),'%')
        </if>
        <if test=" null != contactn and contactn!=''" >
        and contactn like concat(concat('%',#{contactn}),'%')
        </if>
        <if test=" null != Gender and Gender!=''" >
        and Gender like concat(concat('%',#{Gender}),'%')
        </if>
    </select>


    <!-- 根据id查询员工信息 -->
    <select id="getstaffByID" resultType="com.model.staff">
        SELECT
        *
        FROM
        staff
        WHERE
        sid=#{sid}
    </select>

    <!--添加员工信息 -->
    <insert id="add" parameterType="com.model.staff">
       
      INSERT INTO  staff(username,passworda,fullname,power,contactn,Gender)  values(#{username},#{passworda},#{fullname},#{power},#{contactn},#{Gender})
    </insert>

    <!-- 改员工信息 -->
    <update id="update" parameterType="com.model.staff">
        update staff set username=#{username},passworda=#{passworda},fullname=#{fullname},power=#{power},contactn=#{contactn},Gender=#{Gender} where sid=#{sid} 
         
    </update>

    <!-- 删员工信息 -->
    <delete id="delete" parameterType="int">
        DELETE FROM