src/main/resources/mapper/ReservationDao.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="cn.lemon.lib.mapper.ReservationMapper">
  <resultMap id="BaseResultMap" type="cn.lemon.lib.entity.Reservation">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="user_id" jdbcType="INTEGER" property="userId" />
    <result column="type" jdbcType="INTEGER" property="type" />
    <result column="lib_id" jdbcType="INTEGER" property="libId" />
    <result column="grade_id" jdbcType="INTEGER" property="gradeId" />
    <result column="start_week" jdbcType="INTEGER" property="startWeek" />
    <result column="end_week" jdbcType="INTEGER" property="endWeek" />
    <result column="day" jdbcType="INTEGER" property="day" />
    <result column="part" jdbcType="INTEGER" property="part" />
    <result column="remark" jdbcType="VARCHAR" property="remark" />
    <result column="lib_name" jdbcType="VARCHAR" property="libName" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="update_time" jdbcType="TIMESTAMP" property="updateTime" />
  </resultMap>
  <sql id="Base_Column_List">
    id, user_id, `type`, lib_id, grade_id, start_week, end_week, `day`, `part`, remark, 
    create_time, update_time
  </sql>
  <select id="getReservationList" resultMap="BaseResultMap">
    SELECT reservation.id as id,
    user_id,type,lib_id,grade_id,
    start_week,end_week,`day`,part,
    reservation.`status`,
    reservation.type,
    reservation.remark,
    lib.name as lib_name
    FROM reservation,lib
    WHERE reservation.lib_id = lib.id
    GROUP BY reservation.id
    limit #{page},#{limit}
  </select>

  <select id="getTeacherReservationList" resultMap="BaseResultMap">
    SELECT reservation.id as id,
    user_id,type,lib_id,grade_id,
    start_week,end_week,`day`,part,
    reservation.`status`,
    reservation.type,
    reservation.remark,
    lib.name as lib_name
    FROM reservation,lib
    WHERE reservation.lib_id = lib.id
    and user_id = #{userId}
    and type = 1
    GROUP BY reservation.id
    limit #{page},#{limit}
  </select>

  <select id="getStudentReservationList" resultMap="BaseResultMap">
    SELECT reservation.id as id,
    user_id,type,lib_id,grade_id,
    start_week,end_week,`day`,part,
    reservation.`status`,
    reservation.type,
    reservation.remark,
    lib.name as lib_name
后面还有 185 行代码，购买后查看完整代码

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

AI 解读 AI

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

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