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=INTEGER},
name = #{record.n