build/classes/config/mybatis/mapper/EmployeeMapper.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.ischoolbar.programmer.dao.EmployeeDao">
	<!-- 员工插入操作 -->
	<insert id="add" parameterType="com.ischoolbar.programmer.entity.admin.Employee">
		insert into employee(employee_id,name,work_type,sex,salary,employee_phone,age,address,remark) 
		values(null,#{name},#{work_type},#{sex},#{salary},#{employee_phone},#{age},#{address},#{remark})
	</insert>
	<!-- 员工编辑操作 -->
	<update id="edit" parameterType="com.ischoolbar.programmer.entity.admin.Employee">
		update employee set name=#{name},work_type=#{work_type},sex=#{sex},salary=#{salary},employee_phone=#{employee_phone},
		age=#{age},address=#{address},remark=remark where employee_id = #{employee_id}
	</update>
	<!-- 员工信息搜索查询 -->
	<select id="findList" parameterType="Map" resultType="com.ischoolbar.programmer.entity.admin.Employee">
		select * from employee where 1 = 1 
		<if test="name != null">
			and name like '%${name}%' 
		</if>
		<if test="work_type != null">
			and work_type like '%${work_type}%' 
		</if>
		<if test="sex != null">
			and sex = #{sex} 
		</if>
		<if test="offset != null and pageSize != null">
			limit #{offset},#{pageSize}
		</if>
	</select>
	<!-- 根据员工ID获取单个员工信息 -->
	<select id="find" parameterType="Long" resultType="com.ischoolbar.programmer.entity.admin.Employee">
		select * from  employee where employee_id=#{value} 
	</select>
	<!-- 根据用户名获取学生信息 -->
	<select id="findByname" parameterType="String" resultType="com.ischoolbar.programmer.entity.admin.Employee">
		select * from  employee where name=#{value}
	</select>
	<!-- 获取所有员工信息 -->
	<select id="findAll" parameterType="Map" resultType="com.ischoolbar.programmer.entity.admin.Employee">
		select * from  employee 
		<if test="offset != null and pageSize != null">
			limit #{offset},#{pageSize}
		</if>
	</select>
	<!-- 模糊搜索总条数 -->
	<select id="getTotal" parameterType="Map" resultType="Integer">
		select count(*) from employee where 1=1 
		<if test="name != null">
			and name like '%${name}%' 
		</if>
		<if test="work_type != null">
			and work_type like '%${work_type}%' 
		</if>
		<if test="sex != null">
			and sex = #{sex} 
		</if>
	</select>
	<!-- 删除员工信息 -->