select * from t_customer where c_name like concat('%', #{name},'%') order by c_ceroNo limit 0,100

update t_customer set

c_name = #{cus.name},

c_age = #{cus.age},

c_sex = #{cus.sex},

c_ceroNo = #{cus.ceroNo},

c_ceroType = #{cus.ceroType}

where id = #{cus.id}

update t_customer

when id=#{cus.id} then #{cus.name}

when id=#{cus.id} then #{cus.age}

when id=#{cus.id} then #{cus.sex}

when id=#{cus.id} then #{cus.ceroNo}

when id=#{cus.id} then #{cus.ceroType}

id = #{cus.id}