user_id, password, user_name, sex, user_avatar, user_salt, create_date, last_login_date, login_count,role,isdel select from sys_user where user_id = #{userId,jdbcType=INTEGER} select from sys_user where user_name = #{userName,jdbcType=VARCHAR} SELECT * FROM sys_user WHERE 1=1 and isdel = 0 and user_name like '%${userName}%' limit #{count,jdbcType=BIGINT}, #{limit,jdbcType=BIGINT} SELECT count(*) FROM sys_user WHERE 1=1 and isdel = 0 and user_name like '%${userName}%' delete from sys_user where user_id = #{userId,jdbcType=INTEGER} insert into sys_user (user_id, password, user_name, sex, user_avatar, user_salt, create_date, last_login_date, login_count,isdel ) values (#{userId,jdbcType=INTEGER}, #{password,jdbcType=VARCHAR}, #{userName,jdbcType=VARCHAR}, #{sex,jdbcType=VARCHAR}, #{userAvatar,jdbcType=VARCHAR}, #{userSalt,jdbcType=VARCHAR}, #{createDate,jdbcType=TIMESTAMP}, #{lastLoginDate,jdbcType=TIMESTAMP}, #{loginCount,jdbcType=INTEGER},0 ) insert into sys_user user_id, password, user_name, sex, user_avatar, user_salt, create_date, last_login_date, login_count, isdel, role, #{userId,jdbcType=INTEGER}, #{password,jdbcType=VARCHAR}, #{userName,jdbcType=VARCHAR}, #{sex,jdbcType=VARCHAR}, #{userAvatar,jdbcType=VARCHAR}, #{userSalt,jdbcType=VARCHAR}, #{createDate,jdbcType=TIMESTAMP}, #{lastLoginDate,jdbcType=TIMESTAMP}, #{loginCount,jdbcType=INTEGER}, 0, #{role,jdbcType=VARCHAR}, update sys_user password = #{password,jdbcType=VARCHAR}, user_name = #{userName,jdbcType=VARCHAR}, sex = #{sex,jdbcType=VARCHAR}, user_avatar = #{userAvatar,jdbcType=VARCHAR}, user_salt = #{userSalt,jdbcType=VARCHAR}, create_date = #{createDate,jdbcType=TIMESTAMP}, last_login_date = #{lastLoginDate,jdbcType=TIMESTAMP}, login_count = #{loginCount,jdbcType=INTEGER}, isdel = #{isdel,jdbcType=INTEGER}, where user_id = #{userId,jdbcType=INTEGER} update sys_user set password = #{password,jdbcType=VARCHAR}, user_name = #{userName,jdbcType=VARCHAR}, sex = #{sex,jdbcType=VARCHAR}, user_avatar = #{userAvatar,jdbcType=VARCHAR}, user_salt = #{userSalt,jdbcType=VARCHAR}, create_date = #{createDate,jdbcType=TIMESTAMP}, last_login_date = #{lastLoginDate,jdbcType=TIMESTAMP}, login_count = #{loginCount,jdbcType=INTEGER}, isdel = #{isdel,jdbcType=INTEGER} where user_id = #{userId,jdbcType=INTEGER}