LiuShuaiDong：Mybaits之insert的动态sql语句

一、实体类

@Data
public class User implements Serializable {

    private Integer id;
    private String loginName;
    private String userPassword;
    private String phone;
    private Integer idDeleted;
    private Integer role;
    private String picPath;
    private Date createtime;
}

二、表结构

三、sqlmapper.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="com.lld.crowdfunding.mapper.UserMapper">

    <!--insert的动态sql 需要插入的字段-->
    <sql id="insert_column">
        <trim suffixOverrides=",">
            <if test="id !=null and id != ''">
                id,
            </if>
            <if test="loginName !=null and loginName != ''">
                loginName,
            </if>
            <if test="userPassword !=null and userPassword != ''">
                userPassword,
            </if>
            <if test="phone !=null and phone != ''">
                phone,
            </if>
            <if test="idDeleted !=null and idDeleted != ''">
                idDeleted,
            </if>
            <if test="role !=null and role != ''">
                role,
            </if>
            <if test="picPath !=null and picPath != ''">
                picPath,
            </if>
            <if test="createtime !=null and createtime != ''">
                createtime,
            </if>
        </trim>
    </sql>
    
    <!--insert的动态sql 插入的数据-->
    <sql id="insert_value">
        <trim suffixOverrides=",">
            <if test="id !=null and id != ''">
                #{id},
            </if>
            <if test="loginName !=null and loginName != ''">
                #{loginName},
            </if>
            <if test="userPassword !=null and userPassword != ''">
                #{userPassword},
            </if>
            <if test="phone !=null and phone != ''">
                #{phone},
            </if>
            <if test="idDeleted !=null and idDeleted != ''">
                #{idDeleted},
            </if>
            <if test="role !=null and role != ''">
                #{role},
            </if>
            <if test="picPath !=null and picPath != ''">
                #{picPath},
            </if>
            <if test="createtime !=null and createtime != ''">
                #{createtime},
            </if>
        </trim>
    </sql>

    <!--向数据库中动态的插入数据-->
    <insert id="saveUser" parameterType="User">
        insert into user(<include refid="insert_column"></include>)
        values(<include refid="insert_value"></include>)
    </insert>
</mapper>

四、最终实现

insert into user(????) values(?????)，有选择的动态的插入数据