src/main/resources/mybatis/mapper/TeacherMapper.xml

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.example.registrationmanagementsystem.mapper.TeacherMapper">
    <insert id="addTeacher">
        insert into teacher (name, password, sex, idCard, phoneNumber, createTime)
        values (#{name},#{password},#{sex},#{idCard},#{phoneNumber},#{createTime});
    </insert>
    <update id="updateTeacher">
        update teacher
        set name = #{name},
            password = #{password},
            sex = #{sex},
            idCard = #{idCard},
            phoneNumber = #{phoneNumber}
        where id = #{id};
    </update>
    <update id="updateTeacherPart">
        update teacher t
        set sex = #{sex},
            phoneNumber = #{phoneNumber},
            idCard = #{idCard}
        where t.name = #{name};
    </update>
    <delete id="deleteTeacher">
        delete
        from teacher
        where id=#{id};
    </delete>

    <select id="queryTeacherList" resultType="com.example.registrationmanagementsystem.entity.Teacher">
        select *
        from teacher;
    </select>
    <select id="queryTeacherById" resultType="com.example.registrationmanagementsystem.entity.Teacher">
        select *
        from teacher t
        where t.id= #{id};
    </select>
    <select id="queryTeacherByName" resultType="com.example.registrationmanagementsystem.entity.Teacher">
        select *
        from teacher t
        where t.name = #{name};
    </select>
</mapper>