TbBrandMapper

最新推荐文章于 2023-02-20 10:34:42 发布

hmm_45219760

最新推荐文章于 2023-02-20 10:34:42 发布

阅读量209

点赞数

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

mybatis 同时被 2 个专栏收录

3 篇文章 0 订阅

订阅专栏

配置文件

3 篇文章 0 订阅

订阅专栏

                    
                    <?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}