MVC-Mapper.xml示例

代码包结构

cn.bitgeek.springboot.jdbc
├── rest      // rest包专门放置Controller接口
├──── ClassController.java
├── service   // service包专门放置Service服务类
├──── ClassService.java
├── dto       // dto包放传输对象
├──── ClassDTO.java
├── entity     // entity包放实体类对象
├──── ClassEntity.java
├── mapper    // mapper包专门放置和数据库交互的接口类
├──── ClassMapper.java
├──── ClassMapper.xml
└── JdbcApplication.java  // 服务启动类入口

---

ClassMapper.xml代码示例

<?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="cn.bitgeek.springboot.jdbc.mapper.ClassMapper">

    <resultMap id="BaseResultMap" type="cn.bitgeek.springboot.jdbc.dto.ClassDTO" >
        <result column="id" property="id" />
        <result column="name" property="name" />
        <result column="status" property="status" />
        <result column="kind" property="kind" />
        <result column="description" property="description" />
        <result column="highlights" property="highlights" />
    </resultMap>

    <sql id="Base_Column_List">
        id,
        name,
        status,
        kind,
        description,
        highlights
    </sql>

    <insert id="insert" useGeneratedKeys="true" keyColumn="id" keyProperty="id" parameterType="cn.bitgeek.springboot.jdbc.entity.Class1">
        INSERT INTO class1
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="null != class.name and '' != class.name">
                name,
            </if>
            <if test="null != class.kind and '' != class.kind">
                kind,
            </if>
            <if test="null != class.description and '' != class.description">
                description,
            </if>
            <if test="null != class.tag and '' != class.tag">
                tag,
            </if>
            <if test="null != class.status and '' != class.status">
                status
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="null != class.name and '' != class.name">
                #{class.name},
            </if>
            <if test="null != class.kind and '' != class.kind">
                #{class.kind},
            </if>
            <if test="null != class.description and '' != class.description">
                #{class.description},
            </if>
            <if test="null != class.highlights and '' != class.highlights">
                #{class.highlights},
            </if>
            <if test="null != class.status and '' != class.status">
                #{class.status}
            </if>
        </trim>
    </insert>

    <delete id="delete" >
        update  news set status = 0 where id =#{id}
    </delete>

    <update id="update" >
        UPDATE class1
        <set>
            <if test="null != class.name and '' != class.name">name = #{class.name},</if>
            <if test="null != class.kind and '' != class.kind">kind = #{class.kind},</if>
            <if test="null != class.description and '' != class.description">description = #{class.description},</if>
            <if test="null != class.highlights and '' != class.highlights">highlights = #{class.highlights},</if>
            <if test="null != class.status and '' != class.status">status = #{class.status}</if>
        </set>
        WHERE id = #{class.id}
    </update>


    <select id="load" resultMap="BaseResultMap">
        SELECT <include refid="Base_Column_List" />
        FROM news
        WHERE id = #{id}
    </select>

    <select id="pageList" resultMap="BaseResultMap">
        SELECT <include refid="Base_Column_List" />
        FROM class1
        <where>
            1=1
            <if test="obj.name!=null &amp;&amp; obj.name!=''">
                and name like concat('%',#{obj.name},'%')
            </if>
            <if test="obj.kind!=null &amp;&amp; obj.kind!=''">
                and kind = #{obj.kind}
            </if>
            <if test="obj.status!=null &amp;&amp; obj.status!=''">
                and status = 1
            </if>
        </where>
    </select>


</mapper>