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, cid, name, sex, mobile, email, qq, wechat, depatrment, customer_position, tel_num,
major, aid
delete from organization_contact_book
where id = #{id,jdbcType=VARCHAR}
delete from organization_contact_book
insert into organization_contact_book (id, cid, name,
sex, mobile, email, qq,
wechat, depatrment, customer_position,
tel_num, major, aid)
values (#{id,jdbcType=VARCHAR}, #{cid,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR},
#{sex,jdbcType=CHAR}, #{mobile,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, #{qq,jdbcType=VARCHAR},
#{wechat,jdbcType=VARCHAR}, #{depatrment,jdbcType=VARCHAR}, #{customerPosition,jdbcType=VARCHAR},
#{telNum,jdbcType=VARCHAR}, #{major,jdbcType=INTEGER}, #{aid,jdbcType=VARCHAR})
insert into organization_contact_book
id,
cid,
name,
sex,
mobile,
email,
qq,
wechat,
depatrment,
customer_position,
tel_num,
major,
aid,
#{id,jdbcType=VARCHAR},
#{cid,jdbcType=VARCHAR},
#{name,jdbcType=VARCHAR},
#{sex,jdbcType=CHAR},
#{mobile,jdbcType=VARCHAR},
#{email,jdbcType=VARCHAR},
#{qq,jdbcType=VARCHAR},
#{wechat,jdbcType=VARCHAR},
#{depatrment,jdbcType=VARCHAR},
#{customerPosition,jdbcType=VARCHAR},
#{telNum,jdbcType=VARCHAR},
#{major,jdbcType=INTEGER},
#{aid,jdbcType=VARCHAR},
update organization_contact_book
id = #{record.id,jdbcType=VARCHAR},
cid = #{record.cid,jdbcType=VARCHAR},
name = #{record.name,jdbcType=VARCHAR},
sex = #{record.sex,jdbcType=CHAR},
mobile = #{record.mobile,jdbcType=VARCHAR},
email = #{record.email,jdbcType=VARCHAR},
qq = #{record.qq,jdbcType=VARCHAR},
wechat = #{record.wechat,jdbcType=VARCHAR},
depatrment = #{record.depatrment,jdbcType=VARCHAR},
customer_position = #{record.customerPosition,jdbcType=VARCHAR},
tel_num = #{record.telNum,jdbcType=VARCHAR},
major = #{record.major,jdbcType=INTEGER},
aid = #{record.aid,jdbcType=VARCHAR},
update organization_contact_book
set id = #{record.id,jdbcType=VARCHAR},
cid = #{record.cid,jdbcType=VARCHAR},
name = #{record.name,jdbcType=VARCHAR},
sex = #{record.sex,jdbcType=CHAR},
mobile = #{record.mobile,jdbcType=VARCHAR},
email = #{record.email,jdbcType=VARCHAR},
qq = #{record.qq,jdbcType=VARCHAR},
wechat = #{record.wechat,jdbcType=VARCHAR},
depatrment = #{record.depatrment,jdbcType=VARCHAR},
customer_position = #{record.customerPosition,jdbcType=VARCHAR},
tel_num = #{record.telNum,jdbcType=VARCHAR},
major = #{record.major,jdbcType=INTEGER},
aid = #{record.aid,jdbcType=VARCHAR}
update organization_contact_book
cid = #{cid,jdbcType=VARCHAR},
name = #{name,jdbcType=VARCHAR},
sex = #{sex,jdbcType=CHAR},
mobile = #{mobile,jdbcType=VARCHAR},
email = #{email,jdbcType=VARCHAR},
qq = #{qq,jdbcType=VARCHAR},
wechat = #{wechat,jdbcType=VARCHAR},
depatrment = #{depatrment,jdbcType=VARCHAR},
customer_position = #{customerPosition,jdbcType=VARCHAR},
tel_num = #{telNum,jdbcType=VARCHAR},
major = #{major,jdbcType=INTEGER},
aid = #{aid,jdbcType=VARCHAR},
where id = #{id,jdbcType=VARCHAR}
update organization_contact_book
set cid = #{cid,jdbcType=VARCHAR},
name = #{name,jdbcType=VARCHAR},
sex = #{sex,jdbcType=CHAR},
mobile = #{mobile,jdbcType=VARCHAR},
email = #{email,jdbcType=VARCHAR},
qq = #{qq,jdbcType=VARCHAR},
wechat = #{wechat,jdbcType=VARCHAR},
depatrment = #{depatrment,jdbcType=VARCHAR},
customer_position = #{customerPosition,jdbcType=VARCHAR},
tel_num = #{telNum,jdbcType=VARCHAR},
major = #{major,jdbcType=INTEGER},
aid = #{aid,jdbcType=VARCHAR}
where id = #{id,jdbcType=VARCHAR}