id, username, password, phone, login_type, openid, email, last_login, regist_ip, avatar, age, is_female, fully_registered, name ,real_name,city_id,province_id,area_id, cardId,payPassWord,randomCode,code_time cku_info select , from cab_users where id = #{id} select , from cab_users where username = #{username,jdbcType=VARCHAR} select , from cab_users select , from cab_users where phone = #{phone,jdbcType=VARCHAR} delete from cab_users where id = #{id,jdbcType=BIGINT} insert into cab_users (id, username, password, phone, login_type, openid, email, last_login, regist_ip, avatar, age, is_female, fully_registered, name, cku_info ) values (#{id,jdbcType=BIGINT}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{phone,jdbcType=VARCHAR}, #{threeLoginType,jdbcType=VARCHAR}, #{openid,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, #{lastLogin,jdbcType=TIMESTAMP}, #{registIp,jdbcType=VARCHAR}, #{avatar,jdbcType=VARCHAR}, #{age,jdbcType=VARCHAR}, #{isFemale,jdbcType=INTEGER}, #{fullyRegistered,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{ckuInfo,jdbcType=LONGVARCHAR} ) insert into cab_users id, username, password, phone, login_type, openid, email, last_login, regist_ip, avatar, age, is_female, fully_registered, name, cku_info, real_name, #{id,jdbcType=BIGINT}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{phone,jdbcType=VARCHAR}, #{threeLoginType,jdbcType=VARCHAR}, #{openid,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, #{lastLogin,jdbcType=TIMESTAMP}, #{registIp,jdbcType=VARCHAR}, #{avatar,jdbcType=VARCHAR}, #{age,jdbcType=VARCHAR}, #{isFemale,jdbcType=INTEGER}, #{fullyRegistered,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{ckuInfo,jdbcType=LONGVARCHAR}, #{realName,jdbcType=VARCHAR}, update cab_users username = #{username,jdbcType=VARCHAR}, password = #{password,jdbcType=VARCHAR}, phone = #{phone,jdbcType=VARCHAR}, login_type = #{threeLoginType,jdbcType=VARCHAR}, openid = #{openid,jdbcType=VARCHAR}, email = #{email,jdbcType=VARCHAR}, last_login = #{lastLogin,jdbcType=TIMESTAMP}, regist_ip = #{registIp,jdbcType=VARCHAR}, avatar = #{avatar,jdbcType=VARCHAR}, age = #{age,jdbcType=VARCHAR}, is_female = #{isFemale,jdbcType=INTEGER}, fully_registered = #{fullyRegistered,jdbcType=INTEGER}, name = #{name,jdbcType=VARCHAR}, cku_info = #{ckuInfo,jdbcType=LONGVARCHAR}, real_name = #{realName,jdbcType=VARCHAR}, area_id = #{areaId,jdbcType=INTEGER}, province_id = #{provinceId,jdbcType=INTEGER}, city_id = #{cityId,jdbcType=INTEGER}, cardId = #{cardId}, payPassWord = #{payPassWord}, randomCode = #{randomCode}, code_time = #{codeTime}, where id = #{id,jdbcType=BIGINT} update cab_users set username = #{username,jdbcType=VARCHAR}, password = #{password,jdbcType=VARCHAR}, phone = #{phone,jdbcType=VARCHAR}, login_type = #{threeLoginType,jdbcType=VARCHAR}, openid = #{openid,jdbcType=VARCHAR}, email = #{email,jdbcType=VARCHAR}, last_login = #{lastLogin,jdbcType=TIMESTAMP}, regist_ip = #{registIp,jdbcType=VARCHAR}, avatar = #{avatar,jdbcType=VARCHAR}, age = #{age,jdbcType=VARCHAR}, is_female = #{isFemale,jdbcType=INTEGER}, fully_registered = #{fullyRegistered,jdbcType=INTEGER}, name = #{name,jdbcType=VARCHAR}, cku_info = #{ckuInfo,jdbcType=LONGVARCHAR} where id = #{id,jdbcType=BIGINT} update cab_users set username = #{username,jdbcType=VARCHAR}, password = #{password,jdbcType=VARCHAR}, phone = #{phone,jdbcType=VARCHAR}, login_type = #{threeLoginType,jdbcType=VARCHAR}, openid = #{openid,jdbcType=VARCHAR}, email = #{email,jdbcType=VARCHAR}, last_login = #{lastLogin,jdbcType=TIMESTAMP}, regist_ip = #{registIp,jdbcType=VARCHAR}, avatar = #{avatar,jdbcType=VARCHAR}, age = #{age,jdbcType=VARCHAR}, is_female = #{isFemale,jdbcType=INTEGER}, fully_registered = #{fullyRegistered,jdbcType=INTEGER}, name = #{name,jdbcType=VARCHAR} where id = #{id,jdbcType=BIGINT}