src/main/resources/mapper/FilesMapper.xml

（开头部分） 4KB

这里只显示每个文件的开头 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.FilesMapper">
  <resultMap id="BaseResultMap" type="com.yj.oa.project.po.Files">
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="fileId" jdbcType="INTEGER" property="fileId" />
    <result column="fileName" jdbcType="VARCHAR" property="fileName" />
    <result column="descr" jdbcType="VARCHAR" property="descr" />
    <result column="fileType" jdbcType="VARCHAR" property="fileType" />
    <result column="fileSize"  property="fileSize" />
    <result column="uploadUser" jdbcType="VARCHAR" property="uploadUser" />
    <result column="createTime" jdbcType="TIMESTAMP" property="createTime" />
    <result column="downloadCount" jdbcType="INTEGER" property="downloadCount" />
  </resultMap>

  <sql id="Base_Column_List">
    fileId, fileName,descr, fileType,fileSize, uploadUser, createTime,downloadCount
  </sql>


  <!--列表-->
  <select id="selectFileList" resultMap="BaseResultMap" parameterType="Files">
    select
    <include refid="Base_Column_List" />
    from t_file
    <where>
      <if test="fileName != null and fileName!=null">
        and fileName LIKE concat('%',#{fileName},'%')
      </if>
      <if test="uploadUser != null and uploadUser!=''">
        and uploadUser=#{uploadUser}
      </if>
      <if test="beginTime !=null">
        <![CDATA[   and DATE_FORMAT(createTime, '%Y-%m-%d')>=  DATE_FORMAT(#{beginTime}, '%Y-%m-%d')   ]]>
      </if>
      <if test="overTime !=null">
        <![CDATA[  and DATE_FORMAT(createTime, '%Y-%m-%d') <= DATE_FORMAT(#{overTime}, '%Y-%m-%d')    ]]>
      </if>
    </where>
  </select>

  <!--根据id查询-->
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from t_file
    where fileId = #{fileId,jdbcType=INTEGER}
  </select>


  <!--批量删除-->
  <delete id="deleteByPrimaryKeys" parameterType="String">
    delete from t_file
    where fileId in
     <foreach collection="array" item="id" open="(" separator="," close=")">
       #{id}
     </foreach>
后面还有 78 行代码，购买后查看完整代码

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

AI 解读 AI

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

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