src/com/cms/dao/StudentDao.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.cms.dao.StudentDao">
  <resultMap id="BaseResultMapStudent" type="com.cms.entity.Student">
    <id column="id" jdbcType="VARCHAR" property="id" />
    <result column="password" jdbcType="VARCHAR" property="password" />
    <result column="name" jdbcType="VARCHAR" property="name" />
    <result column="sex" jdbcType="VARCHAR" property="sex" />
    <result column="admission_date" jdbcType="DATE" property="admissionDate" />
    <result column="major" jdbcType="VARCHAR" property="major" />
    <result column="grade" jdbcType="VARCHAR" property="grade" />
    <result column="education" jdbcType="VARCHAR" property="education" />
  </resultMap>
  
  <resultMap id="BaseResultMap" type="com.cms.entity.Student">
    <id column="sId" jdbcType="VARCHAR" property="id" />
    <result column="sName" jdbcType="VARCHAR" property="name" />
    <result column="sex" jdbcType="VARCHAR" property="sex" />
    <result column="grade" jdbcType="VARCHAR" property="grade" />
    	<result column="id" property="id" />
    	<result column="score" property="score" />
    	<result column="result" property="result" />
  		<result column="cName" property="courseName" />
  </resultMap>
  
  <sql id="Base_Column_List">
    id, password, name, sex, admission_date, major, grade, education
  </sql>
  
  <select id="select" resultType="Student">
  	select <include refid="Base_Column_List" />
  	from t_student where  id = #{id,jdbcType=VARCHAR}
  	and password = #{password,jdbcType=VARCHAR}
  </select>
  
  <select id="getTotalItemsCountByTid" resultType="Integer">
  	select count(*)
    from t_student as A, t_score as B, t_course as C, t_base_course as BC
    <where>
    	A.id = B.s_id and C.id = B.c_id and C.base_course_id = BC.id
    	and C.complete = 0 
    	and C.t_id = #{param1}
    	<if test="param2 != null and param2 != ''">
  			and C.id = #{param2}
    	</if>
    </where>
  </select>
  
  <select id="getStudentListByTid" resultMap="BaseResultMap">
  	select B.id as id, A.id as sId, A.name as sName, sex, grade, 
  	score, result, C.id as cId, BC.name as cName
    from t_student as A , t_score as B , t_course as C , t_base_course as BC
    <where>
    	A.id = B.s_id and C.id = B.c_id and C.base_course_id = BC.id
    	and C.complete = 0 
    	and C.t_id = #{param2}
    	<if test="param3 != null and param3 != '' ">
  			and C.id = #{param3}
    	</if>
    </where>