mybatis中的trim用法详解

insert into study
        <trim prefix="(" suffix=")" suffixOverrides="," >
            <if test="id != null" >
                id,
            </if>
            <if test="name != null" >
                name,
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides="," >
            <if test="id != null" >
                #{id},
            </if>
        </trim>

修改数据

  update study
        <trim prefix="set" suffixOverrides=",">
            <if test="name!= null" >
                name= {name},
            </if>
        </trim>
        where id= #{id}

查询数据

select * from study where id=#{id};

trim 标签可以根据需求组织sql，可以代替where标签或者是set标签

prefix:在trim标签内sql语句加上前缀。

suffix:在trim标签内sql语句加上后缀。

prefixOverrides:指定去除多余的前缀内容

suffixOverrides:指定去除多余的后缀内容，

如：suffixOverrides="," 去除trim标签内sql语句多余的后缀","