target/classes/mapper/SignupMapper.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.demo28.mapper.SignupMapper">
    <select id="querySignupList" resultType="Signup">
        select * from signup
    </select>
    <select id="querySignupListById" parameterType="int" resultType="Signup">
        select * from signup  where id=#{id}
    </select>

    <select id="querySignupBySignupid" parameterType="int" resultType="Signup">
        select * from signup where signup_id=#{signup_id}
    </select>
    <insert id="addSignup" parameterType="Signup" >
        insert into signup(name, idcard, time, subject, desk_id, exam_id, payment, id, date,money) values(#{name},#{idcard},#{time},#{subject},#{desk_id},#{exam_id},#{payment},#{id},#{date},#{money})
    </insert>
    <update id="updateSignup" parameterType="Signup">
        update signup set name=#{name} where signup_id=#{signup_id}
    </update>

    <update id="updateSignupPay" parameterType="Signup">
        update signup set payment=1 where signup_id=#{signup_id}
    </update>
    <update id="updateSignupType" parameterType="Signup">
        update signup set type =1 where signup_id=#{signup_id}
    </update>
    <delete id="deleteSignup" parameterType="int">
        delete from signup where signup_id=#{signup_id}
    </delete>

    <select id="queryStudentByID" parameterType="String" resultType="com.example.demo28.pojo.Signup">
        select * from signup where idcard=#{str}
    </select>

    <select id="queryStudentByName" resultType="com.example.demo28.pojo.Signup">
        select * from signup where name=#{name}
    </select>
    <select id="queryStudentByExam" resultType="com.example.demo28.pojo.Signup">
        select * from signup where exam_id=#{id}
    </select>
</mapper>