<?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.....">
<insert id="insert" parameterType="com..xdo.">
insert into user(
<include refid="sqlKey"/>
) values(
<include refid="sqlValue"/>
)
</insert>
<sql id="sqlKey">
<trim suffixOverrides=",">
<if test="xdo.name!=null and xdo.name !=''">
`name`,
</if>
<if test="xdo.phone!=null">
phone,
</if>
</trim>
</sql>
<sql id="sqlValue">
<
mybatis利用xml编写sql语句
最新推荐文章于 2024-06-30 13:14:04 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)