target/classes/mybatis/mapper/SignupMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

<?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.SignupMapper">
    <insert id="addSignup">
        insert into signup (studentName, studentPhoneNumber, picture, sex, address, year, province, schooling,
                            professionName, department, number,aid,createTime)
        values (#{studentName},#{studentPhoneNumber},#{picture},#{sex},#{address},#{year},
                #{province},#{schooling},#{professionName},#{department},#{number},#{aid},#{createTime});
    </insert>
    <update id="updateSignupAdmission">
        update signup
        set aid = #{aid},
            year = #{year},
            province = #{province},
            schooling = #{schooling},
            department = #{department},
            number = #{number}
        where id = #{id};
    </update>
    <update id="passSignup">
        update signup
        set state = '通过'
        where id = #{id};
    </update>
    <update id="refuseSignup">
        update signup
        set state = '拒绝'
        where id = #{id};
    </update>
    <delete id="deleteSignup">
        delete
        from signup
        where id = #{id};
    </delete>

    <select id="querySignupList" resultType="com.example.registrationmanagementsystem.entity.Signup">
        select *
        from signup;
    </select>
    <select id="querySignupById" resultType="com.example.registrationmanagementsystem.entity.Signup">
        select *
        from admissioninfo a
        where a.id = #{id};
    </select>
    <select id="querySignupListByName" resultType="com.example.registrationmanagementsystem.entity.Signup">
        select *
        from signup s
        where s.studentName = #{studentName};
    </select>
    <select id="queryAdmissionListByName"
            resultType="com.example.registrationmanagementsystem.entity.AdmissionInfo">
        select province,schooling,professionName,department,number
        from signup s
        where s.studentName = #{studentName};
    </select>
    <select id="queryAdmissionByAid" resultType="com.example.registrationmanagementsystem.entity.AdmissionInfo">
        select aid,year,province,schooling,professionName,department,number
        from signup s