target/classes/mapper/ScoreDao.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.ScoreDao">

    <resultMap type="cn.hxh.files.pojo.Score" id="ScoreMap">
        <result property="id" column="id" jdbcType="INTEGER"/>
        <result property="name" column="name" jdbcType="VARCHAR"/>
        <result property="major1" column="major1" jdbcType="VARCHAR"/>
        <result property="major2" column="major2" jdbcType="VARCHAR"/>
        <result property="major3" column="major3" 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="creatTime" column="creatTime" jdbcType="VARCHAR"/>
    </resultMap>




    <!--新增所有列-->
    <insert id="insertScore" parameterType="cn.hxh.files.pojo.Score">
        insert into score(name, major1, major2, major3, answer1,answer2,answer3,creatTime)
        values (#{name}, #{major1}, #{major2}, #{major3}, #{answer1},#{answer2},#{answer3}, #{creatTime})
    </insert>

    <select id="queryAllSimilarity" parameterType="cn.hxh.files.pojo.Score" resultMap="ScoreMap">
        select id,name, major1, major2, major3, answer1,answer2,answer3,creatTime
        from score
    </select>

</mapper>