resources/com/cms/dao/ScoreDao.xml

（开头部分） 8KB

这里只显示每个文件的开头 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.cms.dao.ScoreDao">
  <resultMap id="BaseResultMapScore" type="com.cms.entity.Score">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="score" jdbcType="INTEGER" property="score" />
    <result column="result" jdbcType="VARCHAR" property="result" />
    <result column="c_id" jdbcType="INTEGER" property="cId" />
    <result column="s_id" jdbcType="VARCHAR" property="sId" />
  </resultMap>
  
  <resultMap id="BaseResultMap" type="com.cms.entity.Course">
    <result column="start_date" jdbcType="DATE" property="startDate" />
    <result column="courseName" jdbcType="VARCHAR" property="courseName" />
    <result column="teacherName" jdbcType="VARCHAR" property="teacherName" />
    <result column="test_mode" jdbcType="VARCHAR" property="testMode" />
    <result column="score" jdbcType="INTEGER" property="score" />
    <result column="result" jdbcType="VARCHAR" property="result" />
  </resultMap>
  
  
  <resultMap id="ResultMap" type="com.cms.dto.ScoreVo">
    <result column="start_date" jdbcType="DATE" property="startDate" />
    <result column="stuId" jdbcType="VARCHAR" property="stuId" />
    <result column="stuName" jdbcType="VARCHAR" property="stuName" />
    <result column="major" jdbcType="VARCHAR" property="major" />
    <result column="grade" jdbcType="VARCHAR" property="grade" />
    <result column="courseName" jdbcType="VARCHAR" property="courseName" />
    <result column="teacherName" jdbcType="VARCHAR" property="teacherName" />
    <result column="test_mode" jdbcType="VARCHAR" property="testMode" />
    <result column="score" jdbcType="INTEGER" property="score" />
    <result column="result" jdbcType="VARCHAR" property="result" />
  </resultMap>
  
  <sql id="Base_Column_List">
    id, score, result, c_id, s_id
  </sql>
  
  
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMapScore">
    select 
    <include refid="Base_Column_List" />
    from t_score
    where id = #{id,jdbcType=INTEGER}
  </select>
  
  <!-- 成绩报表 start-->
  <select id="getTotalItemsCountForExport" parameterType="com.cms.dto.ScoreVo"  resultType="java.lang.Integer">
    select count(*) 
    from t_score as Sc, t_course as C, t_student as Stu, t_base_course as Bc, t_teacher as T
    where Sc.c_id = C.id and Sc.s_id = Stu.id and C.base_course_id = Bc.id and C.t_id = T.id
    	and C.complete = 1
   	<if test="startDate != null and startDate != '' ">
    	and C.start_date >= #{startDate}
    </if>
    <if test="endDate != null and endDate != '' ">
    	and C.start_date &lt;= #{endDate}
    </if>
   	<if test="isPass == 1">
    	and (score >= 60 or result = '通过')
后面还有 182 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。