id, user_name, pass_word, sex, regist_ip, age, creat_time, update_time, creat_user, update_user, freeze, del_flag,name,phone,emaile,qq,depart select from zxb_user where id = #{id,jdbcType=INTEGER} select from zxb_user where user_name = #{userName} select from zxb_user where del_flag = 0 and user_name like '%${record.userName}%' and name like '%${record.name}%' and depart = #{record.depart} limit ${pr.staNum},${pr.pageSize} select count(*) from zxb_user where del_flag = 0 and user_name like '%${record.userName}%' and name like '%${record.name}%' and depart = #{record.depart} delete from zxb_user where id = #{id,jdbcType=INTEGER} insert into zxb_user (id, user_name, pass_word, sex, regist_ip, age, creat_time, update_time, creat_user, update_user, freeze, del_flag ) values (#{id,jdbcType=INTEGER}, #{userName,jdbcType=VARCHAR}, #{passWord,jdbcType=VARCHAR}, #{sex,jdbcType=VARCHAR}, #{registIp,jdbcType=VARCHAR}, #{age,jdbcType=VARCHAR}, #{creatTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP}, #{creatUser,jdbcType=VARCHAR}, #{updateUser,jdbcType=VARCHAR}, #{freeze,jdbcType=INTEGER}, #{delFlag,jdbcType=INTEGER} ) insert into zxb_user id, user_name, pass_word, sex, regist_ip, age, creat_time, update_time, creat_user, update_user, freeze, del_flag, name, phone, emaile, qq, depart, #{id,jdbcType=INTEGER}, #{userName,jdbcType=VARCHAR}, #{passWord,jdbcType=VARCHAR}, #{sex,jdbcType=VARCHAR}, #{registIp,jdbcType=VARCHAR}, #{age,jdbcType=VARCHAR}, #{creatTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP}, #{creatUser,jdbcType=VARCHAR}, #{updateUser,jdbcType=VARCHAR}, #{freeze,jdbcType=INTEGER}, #{delFlag,jdbcType=INTEGER}, #{name}, #{phone}, #{emaile}, #{qq}, #{depart}, update zxb_user set del_flag = 1 where id = #{id,jdbcType=INTEGER} update zxb_user set pass_word = #{newPsw} where id = #{id,jdbcType=INTEGER} update zxb_user user_name = #{userName,jdbcType=VARCHAR}, pass_word = #{passWord,jdbcType=VARCHAR}, sex = #{sex,jdbcType=VARCHAR}, regist_ip = #{registIp,jdbcType=VARCHAR}, age = #{age,jdbcType=VARCHAR}, creat_time = #{creatTime,jdbcType=TIMESTAMP}, update_time = #{updateTime,jdbcType=TIMESTAMP}, creat_user = #{creatUser,jdbcType=VARCHAR}, update_user = #{updateUser,jdbcType=VARCHAR}, freeze = #{freeze,jdbcType=INTEGER}, del_flag = #{delFlag,jdbcType=INTEGER}, name = #{name}, phone = #{phone}, emaile = #{emaile}, qq = #{qq}, depart = #{depart}, where id = #{id,jdbcType=INTEGER} update zxb_user set user_name = #{userName,jdbcType=VARCHAR}, pass_word = #{passWord,jdbcType=VARCHAR}, sex = #{sex,jdbcType=VARCHAR}, regist_ip = #{registIp,jdbcType=VARCHAR}, age = #{age,jdbcType=VARCHAR}, creat_time = #{creatTime,jdbcType=TIMESTAMP}, update_time = #{updateTime,jdbcType=TIMESTAMP}, creat_user = #{creatUser,jdbcType=VARCHAR}, update_user = #{updateUser,jdbcType=VARCHAR}, freeze = #{freeze,jdbcType=INTEGER}, del_flag = #{delFlag,jdbcType=INTEGER} where id = #{id,jdbcType=INTEGER}