select a.login_name UserName,a.email UserEmail,a.password UserPassword,a.id UserID,b.member_code cku_id,b.name memberName from jeesite_sys_user a left join sys_member b on a.id = b.user_id where a.login_name = #{userName} and a.user_type = '2' and a.del_flag = '0' and b.del_flag = '0' select a.login_name UserName,a.email UserEmail,a.password UserPassword,a.id UserID,b.member_code cku_id,b.name memberName from jeesite_sys_user a left join sys_member b on a.id = b.user_id where a.email = #{userName} and a.user_type = '2' and a.del_flag = '0' and b.del_flag = '0' select a.login_name UserName,a.email UserEmail,a.password UserPassword,a.id UserID,b.member_code cku_id,b.name memberName from jeesite_sys_user a left join sys_member b on a.id = b.user_id where a.id = #{userId} AND b.del_flag = '0' update dv_user set oauth_code = #{oauthCode} where UserId = #{userId} update dv_user set access_token = #{accessToken}, access_token_time = #{accessTokenTime} where UserId = #{userId}