src/main/resources/mapper/MeetMapper.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.yj.oa.project.mapper.MeetMapper">
    <resultMap id="BaseResultMap" type="com.yj.oa.project.po.Meet">
        <id column="id" property="id" jdbcType="INTEGER"/>
        <result column="create_By" property="createBy" jdbcType="VARCHAR"/>
        <result column="start_Time" property="startTime" jdbcType="TIMESTAMP"/>
        <result column="title" property="title" jdbcType="VARCHAR"/>
        <result column="descr" property="descr" jdbcType="VARCHAR"/>
        <result column="meet_RoomId" property="meetRoomId" jdbcType="VARCHAR"/>
        <result column="create_Time" property="createTime" jdbcType="TIMESTAMP"/>
        <result column="status" property="status" jdbcType="VARCHAR"/>
        <association property="meetRoom" javaType="MeetingRoom">
            <result column="meetRoomName" jdbcType="VARCHAR" property="meetRoomName"/>
            <result column="meetRoomPlace" jdbcType="VARCHAR" property="meetRoomPlace"/>
            <result column="capacity" jdbcType="VARCHAR" property="capacity"/>
        </association>
        <collection property="users" ofType="User">
            <id column="uid" property="uid" jdbcType="VARCHAR"/>
            <result column="name" property="name" jdbcType="VARCHAR"/>
            <result column="dept" property="dept" jdbcType="VARCHAR"/>
        </collection>
    </resultMap>

    <sql id="Base_Column_List">
    m.id , create_By,title,descr, start_Time, meet_RoomId, create_Time, m.status
  </sql>

    <!--
       根据主键查询
    -->
    <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer">
        select u.uid,u.name,u.dept,tm.meetRoomName,tm.capacity,
        <include refid="Base_Column_List"/>
        from
        t_meetingroom tm
        INNER JOIN t_meet m
        ON tm.id = m.meet_RoomId
        LEFT JOIN t_user_meet um ON m.id = um.meet_Id
        LEFT JOIN t_user u ON um.user_Id = u.uid
        where m.id = #{id,jdbcType=INTEGER}
    </select>


    <!--
       所有数据，列表
    -->
    <select id="selectMyMeetList" resultMap="BaseResultMap" parameterType="String">
        select us.uid,us.name,us.dept,tm.meetRoomName,tm.capacity,
        <include refid="Base_Column_List"/>
        from
        t_meetingroom tm
        INNER JOIN t_meet m
        ON tm.id = m.meet_RoomId
        LEFT JOIN t_user_meet um ON m.id = um.meet_Id
        LEFT JOIN t_user us ON um.user_Id = us.uid
        WHERE um.user_Id=#{uId}
        ORDER BY start_Time DESC
    </select>