target/classes/mapper/ScoreDao.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="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="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"/>
        <result property="creatTime" column="creatTime" jdbcType="VARCHAR"/>
    </resultMap>




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

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

</mapper>