TbBrandMapper

最新推荐文章于 2022-09-04 12:37:14 发布

hmm_45219760

最新推荐文章于 2022-09-04 12:37:14 发布

阅读量249

点赞数

分类专栏： mybatis 配置文件文章标签： sql 配置文件

mybatis 同时被 2 个专栏收录

3 篇文章

订阅专栏

配置文件

3 篇文章

订阅专栏

本文深入探讨了MyBatis框架中动态SQL的构造与执行原理，解析了各种动态SQL元素如if、choose、when、otherwise、foreach等的使用场景与语法细节。通过具体实例，展示了如何利用这些元素实现复杂的查询条件组合，提高SQL语句的灵活性和复用性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

                    
                    <?xml version="1.0" encoding="UTF-8" ?>

                  and ${criterion.condition}
                
                  and ${criterion.condition} #{criterion.value}
                
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                
                  and ${criterion.condition}
                  
                    #{listItem}
                  
                  and ${criterion.condition}
                
                  and ${criterion.condition} #{criterion.value}
                
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                
                  and ${criterion.condition}
                  
                    #{listItem}
                  
    id, name, first_char
  
    select
    
      distinct
    
    from tb_brand
    
      order by ${orderByClause}
    
    select 
    
    from tb_brand
    where id = #{id,jdbcType=BIGINT}
  
    delete from tb_brand
    where id = #{id,jdbcType=BIGINT}
  
    delete from tb_brand
    
    insert into tb_brand (id, name, first_char
      )
    values (#{id,jdbcType=BIGINT}, #{name,jdbcType=VARCHAR}, #{firstChar,jdbcType=VARCHAR}
      )
  
    insert into tb_brand
    
        id,
      
        name,
      
        first_char,
      
        #{id,jdbcType=BIGINT},
      
        #{name,jdbcType=VARCHAR},
      
        #{firstChar,jdbcType=VARCHAR},
      
    select count(*) from tb_brand
    
    update tb_brand
    
        id = #{record.id,jdbcType=BIGINT},
      
        name = #{record.name,jdbcType=VARCHAR},
      
        first_char = #{record.firstChar,jdbcType=VARCHAR},
      
    update tb_brand
    set id = #{record.id,jdbcType=BIGINT},
      name = #{record.name,jdbcType=VARCHAR},
      first_char = #{record.firstChar,jdbcType=VARCHAR}
    
    update tb_brand
    
        name = #{name,jdbcType=VARCHAR},
      
        first_char = #{firstChar,jdbcType=VARCHAR},
      
    where id = #{id,jdbcType=BIGINT}
  
    update tb_brand
    set name = #{name,jdbcType=VARCHAR},
      first_char = #{firstChar,jdbcType=VARCHAR}
    where id = #{id,jdbcType=BIGINT}