src/main/resources/mybatis/blog/AlbumMapper.xml

这里只显示每个文件的开头 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.angelblog.project.system.blog.mapper.AlbumMapper">
    <resultMap type="Album" id="AlbumResult">
        <result property="albumId"    column="album_id"    />
        <result property="albumName"    column="album_name"    />
        <result property="userId"    column="user_id"    />
        <result property="deptId"    column="dept_id"    />
        <result property="albumType"    column="album_type"    />
        <result property="description"    column="description"    />
        <result property="createBy"    column="create_by"    />
        <result property="createTime"    column="create_time"    />
        <result property="auditState"    column="audit_state"    />
        <result property="code"    column="code"    />
        <result property="width"    column="width"    />
        <result property="height"    column="height"    />
    </resultMap>

    <sql id="selectAlbumVo">
        select a.album_id, a.album_name, a.user_id, a.dept_id, a.album_type, a.description, a.create_by, a.create_time, a.audit_state,a.code,a.width,a.height from cms_album a
    </sql>

    <select id="selectAlbumList" parameterType="Album" resultMap="AlbumResult">
        <include refid="selectAlbumVo"/>
        <where>  
            <if test="albumName != null  and albumName != ''"> and a.album_name like concat('%', #{albumName}, '%')</if>
            <if test="albumType != null  and albumType != ''"> and a.album_type = #{albumType}</if>
            <if test="code != null  and code != ''"> and a.code = #{code}</if>
            <if test="auditState != null "> and a.audit_state = #{auditState}</if>
            ${params.dataScope}
        </where>

    </select>

    <select id="selectAlbumById" parameterType="String" resultMap="AlbumResult">
        <include refid="selectAlbumVo"/>
        where a.album_id = #{albumId}
    </select>

    <select id="selectAlbumByCode" parameterType="String" resultMap="AlbumResult">
        <include refid="selectAlbumVo"/>
        where a.code = #{code}
    </select>

    <insert id="insertAlbum" parameterType="Album">
        insert into cms_album
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="albumId != null  and albumId != ''">album_id,</if>
            <if test="albumName != null  and albumName != ''">album_name,</if>
            <if test="userId != null  and userId != ''">user_id,</if>
            <if test="deptId != null  and deptId != ''">dept_id,</if>
            <if test="albumType != null  and albumType != ''">album_type,</if>

            <if test="description != null  and description != ''">description,</if>
            <if test="createBy != null  and createBy != ''">create_by,</if>
            <if test="createTime != null ">create_time,</if>
            <if test="auditState != null ">audit_state,</if>
            <if test="code != null  and code != ''">code,</if>