mybatis_01szrz.rar

<?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.zsjt.szrz.dao.TbEmployeeDao"> <resultMap type="com.zsjt.szrz.entity.TbEmployee" id="TbEmployeeMap"> <result property="id" column="id" jdbcType="INTEGER"/> <result property="name" column="name" jdbcType="VARCHAR"/> <result property="age" column="age" jdbcType="INTEGER"/> <result property="gender" column="gender" jdbcType="VARCHAR"/> <result property="birthday" column="birthday" jdbcType="TIMESTAMP"/> <result property="deptid" column="deptId" jdbcType="INTEGER"/> </resultMap> <!--查询所有员工加部门的resultMap--> <resultMap type="com.zsjt.szrz.vo.QueryVo" id="queryMap"> <result property="id" column="id" jdbcType="INTEGER"/> <result property="name" column="name" jdbcType="VARCHAR"/> <result property="age" column="age" jdbcType="INTEGER"/> <result property="gender" column="gender" jdbcType="VARCHAR"/> <result property="birthday" column="birthday" jdbcType="TIMESTAMP"/> <result property="deptid" column="deptId" jdbcType="INTEGER"/> <!--这里是一对一的关联查询--> <association property="tbDept" select="com.zsjt.szrz.dao.TbDeptDao.findById" column="deptid"> </association> </resultMap> <!--新增员工--> <insert id="addEmployee"> insert into tb_employee(name, age, gender, birthday, deptid) values (#{name}, #{age}, #{gender}, #{birthday}, #{deptid}) </insert> <!--根据id修改--> <update id="updateById"> update tb_employee set name=#{name}, age=#{age}, gender=#{gender}, birthday=#{birthday}, deptid=#{deptid} where id = #{id} </update> <!--删除员工--> <delete id="deleteEmployeeById"> delete from tb_employee where id = #{id} </delete> <!--根据deptid查询,查询所有员工加部门--> <select id="findAllQueryVo" resultMap="queryMap"> select * from tb_employee </select> <!--数据回显 根据id查询--> <select id="findById" resultType="com.zsjt.szrz.entity.TbEmployee"> select * from tb_employee where id = #{id} </select> <!--根据条件模糊查询--> <select id="findByConditions" resultMap="queryMap"> select * from tb_employee <where> <if test="name!=null"> and name like concat("%",#{name},"%") </if> <if test="gender!=null"> and gender=#{gender} </if> <if test="age1!=0 and age2==0"> and age=#{age1} </if> <if test="age1==0 and age2!=0"> and age=#{age2} </if> <if test="age1!=0 and age2!=0"> and age between #{age1} and #{age2} </if> <if test="deptid!=0"> and deptid=#{deptid} </if> </where> </select> </mapper>