src/main/resources/mapper/RoleMapper.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.RoleMapper">
    <resultMap id="BaseResultMap" type="com.yj.oa.project.po.Role">
        <result column="roleId" jdbcType="INTEGER" property="roleId"/>
        <result column="roleName" jdbcType="VARCHAR" property="roleName"/>
        <result column="descr" jdbcType="VARCHAR" property="descr"/>
        <result column="status" jdbcType="INTEGER" property="status"/>
        <result column="createTime" property="createTime"/>
    </resultMap>

    <resultMap id="BaseResultMapRoleAndPer" type="Role">
        <result column="roleId" jdbcType="INTEGER" property="roleId"/>
        <result column="roleName" jdbcType="VARCHAR" property="roleName"/>
        <result column="descr" jdbcType="VARCHAR" property="descr"/>
        <result column="status" jdbcType="INTEGER" property="status"/>
        <result column="createTime" property="createTime"/>
        <collection property="permissionList" ofType="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"/>
        </collection>
    </resultMap>


    <insert id="insert" parameterType="com.yj.oa.project.po.Role" useGeneratedKeys="true" keyProperty="roleId"
            keyColumn="roleId">
    insert into t_role ( roleName, descr,status,createTime
      )
    values (#{roleName,jdbcType=VARCHAR}, #{descr,jdbcType=VARCHAR},
      #{status},#{createTime})
  </insert>


    <select id="selectRoleList" resultMap="BaseResultMap" parameterType="Role">
        SELECT * from t_role
        <where>
            <if test="roleName !=null and roleName!=''">
                and roleName=#{roleName}
            </if>
            <if test="status !=null and status!='' or status==0">
                and status=#{status}
            </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>

    <update id="updateByPrimaryKeySelective" parameterType="Role">
        update t_role
后面还有 43 行代码，购买后查看完整代码

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

AI 解读 AI

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

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