<trim prefix="" prefixOverrides="" suffix="" suffixOverrides="">
sql语句
<trim>
属性 | 说明 |
---|
prefix | 给sql语句拼接的前缀 |
prefixOverrides | 给sql语句拼接的后缀 |
suffix | 去除sql语句前面的关键字或者字符,该关键字或者字符由prefixOverrides属性指定,假设该属性指定为"AND",当sql语句的开头为"AND",trim标签将会去除该"AND" |
suffixOverrides | 去除sql语句后面的关键字或者字符,该关键字或者字符由suffixOverrides属性指定 |
标签例子说明:
<insert id="insertSelective" parameterType="com.adrian.po.AdminUser">
insert into tb_admin_user
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="adminUserId != null">
admin_user_id,
</if>
<if test="loginUserName != null">
login_user_name,
</if>
<if test="loginPassword != null">
login_password,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="adminUserId != null">
#{adminUserId,jdbcType=INTEGER},
</if>
<if test="loginUserName != null">
#{loginUserName,jdbcType=VARCHAR},
</if>
<if test="loginPassword != null">
#{loginPassword,jdbcType=VARCHAR},
</if>
</trim>
</insert>
- prefix="(" 在SQL语句的前面加上“(”;
- suffix=")"在SQL语句的后加上“)”;
- suffixOverrides="," 删除SQL语句后面的“,”;
如果三个都不为null;
insert into tb_admin_user (admin_user_id,
admin_user_name,
admin_password)
value (