一、实体类
@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(?????),有选择的动态的插入数据