src/main/resources/mapper/OperLogMapper.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="com.yj.oa.project.mapper.OperLogMapper">
    <resultMap id="BaseResultMap" type="com.yj.oa.project.po.OperLog">
        <id column="id" property="id" jdbcType="INTEGER"/>
        <result column="operModal" property="operModal" jdbcType="VARCHAR"/>
        <result column="descr" property="descr" jdbcType="VARCHAR"/>
        <result column="host" property="host" jdbcType="VARCHAR"/>
        <result column="ipAddress" property="ipAddress" jdbcType="VARCHAR"/>
        <result column="url" property="url" jdbcType="VARCHAR"/>
        <result column="method" property="method" jdbcType="VARCHAR"/>
        <result column="params" property="params" jdbcType="VARCHAR"/>
        <result column="errorMsg" property="errorMsg" jdbcType="VARCHAR"/>
        <result column="operUser" property="operUser" jdbcType="VARCHAR"/>
        <result column="time" property="time" jdbcType="TIMESTAMP"/>
        <result column="status" property="status" jdbcType="VARCHAR"/>
        <result column="type" property="type" jdbcType="VARCHAR"/>
        <result column="deptId" property="deptId" jdbcType="VARCHAR"/>
        <result column="sys" property="sys" jdbcType="VARCHAR"/>
        <result column="browser" property="browser" jdbcType="VARCHAR"/>
        <association property="user" javaType="User">
            <id column="uid" property="uid"/>
            <result column="name" property="name"/>
            <result column="dept" property="dept"/>
        </association>
        <association property="dept" javaType="Dept">
            <id column="depId" property="depId"/>
            <result column="deptName" property="deptName"/>
        </association>
    </resultMap>
    <sql id="Base_Column_List">
    id, operModal, descr, host, ipAddress, url,type, method, params, errorMsg, operUser, time,deptId,ol.status,browser,sys,type,

  </sql>

    <!--
       主键查询
    -->
    <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer">
        select
        <include refid="Base_Column_List"/>
        u.uid,u.name,d.depId,d.deptName
        from
        t_operlog ol ,t_dept d ,t_user u
        where ol.deptId=d.depId
        and ol.operUser=u.uid
        and id =#{id}
    </select>
    <!--
       批量删除
    -->
    <delete id="deleteByPrimaryKeys" parameterType="java.lang.Integer">
        delete from t_operlog
        where id IN
        <foreach collection="array" item="id" open="(" separator="," close=")">
            #{id,jdbcType=INTEGER}
        </foreach>
    </delete>
后面还有 185 行代码，购买后查看完整代码

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

AI 解读 AI

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

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