id, username, password, token, display_name, display_picture, created_on, ext_open_id, ext_name, ext_type, location, baby_nickname, baby_dob, baby_gender, status_ , user_tel userTel SELECT FROM USER WHERE ID = #{0} SELECT FROM USER WHERE USERNAME = #{0} SELECT FROM USER WHERE EXT_OPEN_ID = #{0} INSERT INTO USER ( USERNAME,PASSWORD,TOKEN,DISPLAY_NAME,DISPLAY_PICTURE, CREATED_ON,EXT_OPEN_ID,EXT_NAME,EXT_TYPE, LOCATION,BABY_NICKNAME,BABY_DOB,BABY_GENDER,STATUS_,USER_TEL) VALUES ( #{username},#{password},#{token},#{display_name},#{display_picture}, NOW(),#{ext_open_id},#{ext_name},#{ext_type}, #{location},#{baby_nickname},#{baby_dob},#{baby_gender},#{status_}, #{userTel} ) UPDATE USER USERNAME = #{username}, PASSWORD = #{password}, TOKEN = #{token}, DISPLAY_NAME = #{display_name}, DISPLAY_PICTURE = #{display_picture}, EXT_OPEN_ID = #{ext_open_id}, EXT_NAME = #{ext_name}, EXT_TYPE = #{ext_type}, LOCATION = #{location}, BABY_NICKNAME = #{baby_nickname}, BABY_DOB = #{baby_dob}, BABY_GENDER = #{baby_gender}, STATUS_ = #{status_}, USER_TEL = #{userTel} WHERE ID = #{id} UPDATE USER SET DISPLAY_PICTURE = #{0} WHERE ID = #{1} SELECT FROM USER WHERE USERNAME=#{0} AND PASSWORD=#{1} UPDATE USER SET PASSWORD=#{1} WHERE ID=#{0} SELECT FROM USER WHERE TOKEN=#{0} UPDATE USER SET TOKEN=#{0} WHERE ID=#{1} UPDATE USER SET USERNAME=#{0} WHERE ID=#{1} SELECT VALUE_ FROM SYS_CONFIG WHERE KEY_ = #{0} INSERT INTO USER_AVATOR (USER_ID, AVATOR) VALUE (#{0}, #{1}) UPDATE USER_AVATOR SET AVATOR = #{1} WHERE USER_ID = #{0} SELECT avator FROM USER_AVATOR WHERE USER_ID = #{id} SELECT FROM USER LIMIT #{start}, #{end}