src/main/resources/mapper/AnswerDao.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="cn.hxh.files.mapper.AnswerDao">

    <resultMap type="cn.hxh.files.pojo.Answer" id="AnswerMap">
        <result property="id" column="id" jdbcType="INTEGER"/>
        <result property="major1" column="major1" jdbcType="VARCHAR"/>
        <result property="major2" column="major2" jdbcType="VARCHAR"/>
        <result property="major3" column="major3" jdbcType="VARCHAR"/>
        <result property="major4" column="major4" jdbcType="VARCHAR"/>
        <result property="major5" column="major5" jdbcType="VARCHAR"/>
        <result property="answer1" column="answer1" jdbcType="VARCHAR"/>
        <result property="answer2" column="answer2" jdbcType="VARCHAR"/>
        <result property="answer3" column="answer3" jdbcType="VARCHAR"/>
        <result property="answer4" column="answer4" jdbcType="VARCHAR"/>
        <result property="answer5" column="answer5" jdbcType="VARCHAR"/>
    </resultMap>




    <!--新增所有列-->
    <select id="queryAllByLimit" resultMap="AnswerMap">
       select
          id, major1, major2, major3,major4,major5, answer1, answer2,answer3,answer4,answer5
        from userfiles.answer
        limit #{startRow, jdbcType=INTEGER}, #{pageSize, jdbcType=INTEGER};
    </select>

    <select id="queryUserCounts" resultType="java.lang.Integer">
        SELECT COUNT(*) FROM userfiles.answer;
    </select>

    <select id="queryAnswer" parameterType="cn.hxh.files.pojo.Answer" resultMap="AnswerMap">
        select
          id, major1, major2, major3,major4,major5, answer1, answer2,answer3,answer4,answer5
        from userfiles.answer
        where id = #{id}
    </select>

    <update id="updateAnswer" parameterType="cn.hxh.files.pojo.Answer">
        update userfiles.answer
        set
        major1 =#{major1},answer1 = #{answer1},major2 = #{major2}, answer2=#{answer2},major3=#{major3},answer3 =#{answer3}
        ,major4=#{major4},answer4 =#{answer4},major5=#{major5},answer5 =#{answer5}
        where id=#{id}
    </update>
    <delete id="delAnswer" parameterType="int">
        delete from userfiles.answer where id =#{id}
    </delete>

    <insert id="addAnswer" parameterType="cn.hxh.files.pojo.Answer">
        insert into userfiles.answer (major1,answer1,major2,answer2,major3,answer3,major4,answer4,major5,answer5)
        values (#{major1}, #{answer1},#{major2},#{answer2},#{major3},#{answer3},#{major4},#{answer4},#{major5},#{answer5})
    </insert>

    <select id="queryAllAnswer" resultMap="AnswerMap">
       select
          id, major1, major2, major3,major4,major5, answer1, answer2,answer3,answer4,answer5
        from userfiles.answer