mybatis之<trim prefix="" suffix="" suffixOverrides="" prefixOverrides=""></trim>

allsmallpig

发布于 2021-02-25 11:36:12

7850

发布于 2021-02-25 11:36:12

文章被收录于专栏：allsmallpi博客

转载自 https://blog.csdn.net/qq_33054511/article/details/70490046

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

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

suffixOverrides:指定去除多余的后缀内容，如：suffixOverrides=","，去除trim标签内sql语句多余的后缀","。

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

2.下面是一个往购物车表中插入数据的mybatis语句


   "insert" parameterType=      "com.tortuousroad.groupon.cart.entity.Cart">     
 
  
 
         insert into cart     
 
  
 
   "(" suffix=      ")" suffixOverrides=      ",">     
 
  
 
         <      if test=      "id != null">     
 
  
 
         id,     
 
  
 
   if>     
 
  
 
         <      if test=      "userId != null">     
 
  
 
         user_id,     
 
  
 
   if>     
 
  
 
         <      if test=      "dealId != null">     
 
  
 
         deal_id,     
 
  
 
   if>     
 
  
 
         <      if test=      "dealSkuId != null">     
 
  
 
         deal_sku_id,     
 
  
 
   if>     
 
  
 
         <      if test=      "count != null">     
 
  
 
         count,     
 
  
 
   if>     
 
  
 
         <      if test=      "createTime != null">     
 
  
 
         create_time,     
 
  
 
   if>     
 
  
 
         <      if test=      "updateTime != null">     
 
  
 
         update_time,     
 
  
 
   if>     
 
  
 
   
 
  
 
   "values (" suffix=      ")" suffixOverrides=      ",">     
 
  
 
         <      if test=      "id != null">     
 
  
 
         #{id,jdbcType=BIGINT},     
 
  
 
   if>     
 
  
 
         <      if test=      "userId != null">     
 
  
 
         #{userId,jdbcType=BIGINT},     
 
  
 
   if>     
 
  
 
         <      if test=      "dealId != null">     
 
  
 
         #{dealId,jdbcType=BIGINT},     
 
  
 
   if>     
 
  
 
         <      if test=      "dealSkuId != null">     
 
  
 
         #{dealSkuId,jdbcType=BIGINT},     
 
  
 
   if>     
 
  
 
         <      if test=      "count != null">     
 
  
 
         #{count,jdbcType=INTEGER},     
 
  
 
   if>     
 
  
 
         <      if test=      "createTime != null">     
 
  
 
         #{createTime,jdbcType=TIMESTAMP},     
 
  
 
   if>     
 
  
 
         <      if test=      "updateTime != null">     
 
  
 
         #{updateTime,jdbcType=TIMESTAMP},     
 
  
 
   if>

假设没有指定