src/main/resources/mapper/PermissionMapper.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.PermissionMapper">
    <resultMap id="BaseResultMap" type="com.yj.oa.project.po.Permission">
        <id column="permissionId" property="permissionId" jdbcType="INTEGER"/>
        <result column="perName" property="perName" jdbcType="VARCHAR"/>
        <result column="parenId" property="parenId" jdbcType="INTEGER"/>
        <result column="parentName" property="parentName" jdbcType="VARCHAR"/>
        <result column="type" property="type" jdbcType="INTEGER"/>
        <result column="url" property="url" jdbcType="VARCHAR"/>
        <result column="code" property="code" jdbcType="VARCHAR"/>
        <result column="icon" property="icon" jdbcType="VARCHAR"/>
        <result column="createTime" property="createTime" jdbcType="TIMESTAMP"/>
    </resultMap>


    <sql id="Base_Column_List">
    permissionId, perName, parenId, parentName, type, url, code, icon, p.createTime
  </sql>
    <!--主键查询-->
    <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer">
        select
        <include refid="Base_Column_List"/>
        from t_permission p
        where permissionId = #{permissionId,jdbcType=INTEGER}
    </select>

    <!--查询列表-->
    <select id="selectPersissionList" resultMap="BaseResultMap" parameterType="java.lang.Integer">
        select
        <include refid="Base_Column_List"/>
        from t_permission p
        <where>
            <if test="perName != null and perName != ''">
                and perName=#{perName}
            </if>
            <if test="parenId != null and parenId != ''">
                and parenId=#{parenId}
            </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>
            <if test="type !=null and type !=''">
                and type=#{type}
            </if>
        </where>
    </select>


    <!--检验名称唯一性-->
    <select id="checkMenuNameUnique" parameterType="Permission" resultMap="BaseResultMap">
        select *
        from t_permission p
        <where>
            and parenId=#{parenId} and perName=#{perName}
        </where>
    </select>
后面还有 178 行代码，购买后查看完整代码

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

AI 解读 AI

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

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