持久层标签

<?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="cn.com.demo.demo.mapper.StudentMapper">
    <insert id="insertStudentInfo" >
       INSERT INTO student(name, age, nickname)
       VALUES (#{name},#{age},#{nickname})
    </insert>

    <delete id="deleteStudentInfoById" >
       DELETE FROM student
       WHERE id=#{id};
    </delete>
    <update id="updateStudentInfo" >
       UPDATE student
       <set>
           <if test="name != null">
               name=#{name},
           </if>
           <if test="age != null">
               age=#{age},
           </if>
           <if test="nickname != null">
               nickname=#{nickname}
           </if>
       </set>
       WHERE id = #{id}
    </update>
    <select id="selectStudentInfoById" resultType="cn.com.demo.demo.pojo.vo.StudentVO">
        SELECT id,name,age,nickname
        FROM student
        WHERE id=#{id}
    </select>
    <select id="selectStudentInfoItemList" resultType="cn.com.demo.demo.pojo.vo.StudentVO">
        SELECT id,name,age,nickname
        FROM student
        ORDER BY id ASC
    </select>

</mapper>