id, username, password, salt, access_token, access_token_time, oauth_code, oauth_code_time select from oauth2_user where id = #{id,jdbcType=BIGINT} delete from oauth2_user where id = #{id,jdbcType=BIGINT} insert into oauth2_user (id, username, password, salt, access_token, access_token_time, oauth_code, oauth_code_time) values (#{id,jdbcType=BIGINT}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{salt,jdbcType=VARCHAR}, #{accessToken,jdbcType=VARCHAR}, #{accessTokenTime,jdbcType=TIMESTAMP}, #{oauthCode,jdbcType=VARCHAR}, #{oauthCodeTime,jdbcType=TIMESTAMP}) insert into oauth2_user id, username, password, salt, access_token, access_token_time, oauth_code, oauth_code_time, #{id,jdbcType=BIGINT}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{salt,jdbcType=VARCHAR}, #{accessToken,jdbcType=VARCHAR}, #{accessTokenTime,jdbcType=TIMESTAMP}, #{oauthCode,jdbcType=VARCHAR}, #{oauthCodeTime,jdbcType=TIMESTAMP}, update oauth2_user username = #{username,jdbcType=VARCHAR}, password = #{password,jdbcType=VARCHAR}, salt = #{salt,jdbcType=VARCHAR}, access_token = #{accessToken,jdbcType=VARCHAR}, access_token_time = #{accessTokenTime,jdbcType=TIMESTAMP}, oauth_code = #{oauthCode,jdbcType=VARCHAR}, oauth_code_time = #{oauthCodeTime,jdbcType=TIMESTAMP}, where id = #{id,jdbcType=BIGINT} update oauth2_user set username = #{username,jdbcType=VARCHAR}, password = #{password,jdbcType=VARCHAR}, salt = #{salt,jdbcType=VARCHAR}, access_token = #{accessToken,jdbcType=VARCHAR}, access_token_time = #{accessTokenTime,jdbcType=TIMESTAMP}, oauth_code = #{oauthCode,jdbcType=VARCHAR}, oauth_code_time = #{oauthCodeTime,jdbcType=TIMESTAMP} where id = #{id,jdbcType=BIGINT} select from oauth2_user where username = #{username,jdbcType=VARCHAR} and password = #{password,jdbcType=VARCHAR}