src/main/resources/mapper/act/ApplyRoomFormMapper.xml

（开头部分） 5KB

这里只显示每个文件的开头 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.ApplyRoomFormMapper" >
  <resultMap id="BaseResultMap" type="com.yj.oa.project.po.ApplyRoomForm" >

    <id column="id" property="id" jdbcType="VARCHAR" />
    <result column="procInstanId" property="procInstanId" jdbcType="VARCHAR" />
    <result column="proposer_Id" property="proposer_Id" jdbcType="VARCHAR" />
    <result column="agent_Id" property="agent_Id" jdbcType="VARCHAR" />
    <result column="roomName" property="roomName" jdbcType="VARCHAR" />
    <result column="createTime" property="createTime" jdbcType="TIMESTAMP" />
    <result column="endTime" property="endTime" jdbcType="TIMESTAMP" />
    <result column="reason" property="reason" jdbcType="VARCHAR" />
    <result column="useStartTime" property="useStartTime" jdbcType="TIMESTAMP" />
    <result column="useEndTime" property="useEndTime" jdbcType="TIMESTAMP" />
    <result column="remark" property="remark" jdbcType="VARCHAR" />
    <result column="reply" property="reply" jdbcType="VARCHAR" />
    <result column="status" property="status" jdbcType="INTEGER" />
  </resultMap>


  <sql id="Base_Column_List" >
    id, proposer_Id,procInstanId,agent_Id,roomName, createTime,endTime, reason, useStartTime,useEndTime, remark,reply, status
  </sql>


  <!--查询列表-->
  <select id="selectApplyRoomList" resultMap="BaseResultMap" parameterType="ApplyRoomForm">
     SELECT
    <include refid="Base_Column_List"/>

    FROM t_applyroom t

    <where>
      <if test="proposer_Id !null and proposer_Id != ''">
      and proposer_Id=#{proposer_Id},
    </if>
      <if test="processInstanceId !null and processInstanceId != ''">
      and processInstanceId=#{processInstanceId},
    </if>
      <if test="roomName !=null and roomName != ''">
        and roomName=#{roomName},
      </if>
      <if test="status !=null and status != ''">
        and status=#{status},
      </if>
    </where>
  </select>


  <!--根据主键查询-->
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select
    <include refid="Base_Column_List" />
    from t_applyroom
    where id = #{id,jdbcType=VARCHAR}
  </select>


  <!--批量删除-->
后面还有 115 行代码，购买后查看完整代码

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

AI 解读 AI

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

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