mybatis——mapper文件详解

select

distinct

/引入一个SQL模块/

from customer

order by ${orderByClause}

limit #{startRow} , #{pageSize}

select

id,name,logo,describe,is_enable,phone,admin,password,uuid

from customer

where id = #{id,jdbcType=INTEGER}

delete from customer

where id = #{id,jdbcType=INTEGER}

delete from customer

insert into customer (id, name, logo,

describe, is_enable, phone,

admin, password, uuid

)

values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{logo,jdbcType=VARCHAR},

#{describe,jdbcType=VARCHAR}, #{isEnable,jdbcType=BIT}, #{phone,jdbcType=VARCHAR},

#{admin,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{uuid,jdbcType=VARCHAR}

)

insert into customer

id,

name,

logo,

describe,

is_enable,

phone,

admin,

password,

uuid,

#{id,jdbcType=INTEGER},

#{name,jdbcType=VARCHAR},

#{logo,jdbcType=VARCHAR},

#{describe,jdbcType=VARCHAR},

#{isEnable,jdbcType=BIT},

#{phone,jdbcType=VARCHAR},

#{admin,jdbcType=VARCHAR},

#{password,jdbcType=VARCHAR},

#{uuid,jdbcType=VARCHAR},

select count(*) from customer

update customer

id = #{record.id,jdbcType=INTEGER},

name = #{record.name,jdbcType=VARCHAR},

logo = #{record.logo,jdbcType=VARCHAR},

describe = #{record.describe,jdbcType=VARCHAR},

is_enable = #{record.isEnable,jdbcType=BIT},

phone = #{record.phone,jdbcType=VARCHAR},

admin = #{record.admin,jdbcType=VARCHAR},

password = #{record.password,jdbcType=VARCHAR},

uuid = #{record.uuid,jdbcType=VARCHAR},

update customer

set id = #{record.id,jdbcType=IN