<?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="us.transcode.thymeleaf.dao.EmployeeDao"> <!--插入一条记录--> <insert id="insertOne" parameterType="Employee" keyProperty="id" useGeneratedKeys="true"> INSERT INTO thymeleaf.employee <trim prefix="(" suffix=")" suffixOverrides=","> <if test="id!=null"> id, </if> <if test="username!=null and username!=''"> username, </if> <if test="birthday!=null"> birthday, </if> <if test="salary!=null"> salary, </if> <if test="photo!=null and photo!=''"> photo, </if> </trim> VALUES <trim prefix="(" suffix=")" suffixOverrides=","> <if test="id!=null"> "${id}", </if> <if test="username!=null and username!=''"> #{username}, </if> <if test="birthday!=null"> #{birthday}, </if> <if test="salary!=null"> #{salary}, </if> <if test="photo!=null and photo!=''"> #{photo}, </if> </trim> </insert> <!--通过Id查询--> <select id="selectOneById" parameterType="Integer" resultType="Employee"> SELECT id, username, birthday, salary, photo FROM thymeleaf.employee WHERE id = #{id} </select> <!--查询所有--> <select id="selectAll" resultType="Employee"> SELECT id, username, birthday, salary, photo FROM thymeleaf.employee </select> <!--通过set动态更新--> <update id="updateById" parameterType="Employee"> UPDATE thymeleaf.employee <set> <if test="username!=null and username!=''"> username=#{username}, </if> <if test="birthday!=null"> birthday=#{birthday}, </if> <if test="salary!=null"> salary=#{salary}, </if> <if test="photo!=null and photo!=''"> photo=#{photo}, </if> </set> WHERE id=#{id} </update> <!--通过Id删除--> <delete id="deleteOneById" parameterType="Integer"> DELETE FROM thymeleaf.employee WHERE id = #{id} </delete> </mapper>