target/classes/com/mty/cc/mapper/ScoreMapper.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.mty.cc.mapper.ScoreMapper">
    <resultMap id="BaseResultMap" type="com.mty.cc.po.Score">
        <id column="id" jdbcType="VARCHAR" property="id" />
        <result column="cno" jdbcType="VARCHAR" property="cno" />
        <result column="cname" jdbcType="VARCHAR" property="cname" />
        <result column="no" jdbcType="VARCHAR" property="no" />
        <result column="realname" jdbcType="VARCHAR" property="realname" />
        <result column="score" jdbcType="VARCHAR" property="score" />
    </resultMap>

    <sql id="Base_Column_List">
    id,
    cno,
    cname,
    no,
    realname,
    score
    </sql>

    <select id="queryById" parameterType="java.lang.String" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />
        from score
        where id = #{id,jdbcType=VARCHAR}
    </select>

    <select id="scoreStatic" resultMap="BaseResultMap">
        select cno,cname,avg(score) score from score GROUP BY cno,cname
    </select>

    <select id="queryByAll" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />
        from score
    </select>

    <select id="queryByAll2" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />
        from score
        where score &lt; 60
    </select>

    <select id="queryByAllAndStudent" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />
        from score
        where no = #{username}
    </select>
    
    <select id="queryReply" resultType="com.mty.cc.po.Appeal">
        select * from appeal
        where 1=1
        <if test="username !=null and username !=''">
           and uid=#{username}
        </if>
    </select>