.class public Lcom/moji/account/data/UserInfoDBHelper; .super Landroid/database/sqlite/SQLiteOpenHelper; .source "UserInfoDBHelper.java" # instance fields .field private a:Landroid/content/Context; .field private b:I # direct methods .method public constructor (Landroid/content/Context;I)V .locals 2 const-string v0, "mojiSnsUser.db" const/4 v1, 0x0 .line 24 invoke-direct {p0, p1, v0, v1, p2}, Landroid/database/sqlite/SQLiteOpenHelper;->(Landroid/content/Context;Ljava/lang/String;Landroid/database/sqlite/SQLiteDatabase$CursorFactory;I)V const/4 p2, 0x3 .line 67 iput p2, p0, Lcom/moji/account/data/UserInfoDBHelper;->b:I .line 25 iput-object p1, p0, Lcom/moji/account/data/UserInfoDBHelper;->a:Landroid/content/Context; return-void .end method .method private a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)Lcom/moji/account/data/UserInfo; .locals 4 const/4 v0, 0x0 .line 187 :try_start_0 new-instance v1, Ljava/lang/StringBuilder; invoke-direct {v1}, Ljava/lang/StringBuilder;->()V const-string v2, "select * from " invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; const-string p3, " where " invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; const-string p3, "SnsId" invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; const-string p3, "=?" invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v1}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String; move-result-object p3 const-string v1, "USER_DB" .line 188 new-instance v2, Ljava/lang/StringBuilder; invoke-direct {v2}, Ljava/lang/StringBuilder;->()V const-string v3, "query string " invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v2, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v2}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String; move-result-object v2 invoke-static {v1, v2}, Landroid/util/Log;->i(Ljava/lang/String;Ljava/lang/String;)I const/4 v1, 0x1 .line 189 new-array v2, v1, [Ljava/lang/String; const/4 v3, 0x0 aput-object p2, v2, v3 invoke-virtual {p1, p3, v2}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor; move-result-object p1 .line 190 :goto_0 invoke-interface {p1}, Landroid/database/Cursor;->moveToNext()Z move-result p2 if-eqz p2, :cond_0 .line 191 new-instance p2, Lcom/moji/account/data/UserInfo; invoke-direct {p2}, Lcom/moji/account/data/UserInfo;->()V :try_end_0 .catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_1 .line 192 :try_start_1 invoke-interface {p1, v3}, Landroid/database/Cursor;->getInt(I)I move-result p3 iput p3, p2, Lcom/moji/account/data/UserInfo;->sqlId:I .line 193 invoke-interface {p1, v1}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->sns_id:Ljava/lang/String; const/4 p3, 0x2 .line 194 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->user_id:Ljava/lang/String; const/4 p3, 0x3 .line 195 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->nick:Ljava/lang/String; const/4 p3, 0x4 .line 196 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->account:Ljava/lang/String; const/4 p3, 0x5 .line 197 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->login_type:Ljava/lang/String; const/4 p3, 0x6 .line 198 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->password:Ljava/lang/String; const/4 p3, 0x7 .line 199 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->face:Ljava/lang/String; const/16 p3, 0x8 .line 200 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->type:Ljava/lang/String; const/16 p3, 0x9 .line 201 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->status:Ljava/lang/String; const/16 p3, 0xa .line 202 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->create_time:Ljava/lang/String; const/16 p3, 0xb .line 203 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->background_url:Ljava/lang/String; const/16 p3, 0xc .line 204 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->email:Ljava/lang/String; const/16 p3, 0xd .line 205 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->mobile:Ljava/lang/String; const/16 p3, 0xe .line 206 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->sex:Ljava/lang/String; const/16 p3, 0xf .line 207 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->birth:Ljava/lang/String; const/16 p3, 0x10 .line 208 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->sign:Ljava/lang/String; const/16 p3, 0x11 .line 209 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->city_id:Ljava/lang/String; const/16 p3, 0x12 .line 210 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->followed_count:Ljava/lang/String; const/16 p3, 0x13 .line 211 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->following_count:Ljava/lang/String; const/16 p3, 0x14 .line 212 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->sns_name:Ljava/lang/String; const/16 p3, 0x15 .line 213 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->city_name:Ljava/lang/String; :try_end_1 .catch Ljava/lang/Exception; {:try_start_1 .. :try_end_1} :catch_0 move-object v0, p2 goto/16 :goto_0 :catch_0 move-exception p1 move-object v0, p2 goto :goto_1 .line 215 :cond_0 :try_start_2 invoke-interface {p1}, Landroid/database/Cursor;->close()V :try_end_2 .catch Ljava/lang/Exception; {:try_start_2 .. :try_end_2} :catch_1 goto :goto_2 :catch_1 move-exception p1 :goto_1 const-string p2, "USER_DB" .line 217 invoke-virtual {p1}, Ljava/lang/Exception;->toString()Ljava/lang/String; move-result-object p1 invoke-static {p2, p1}, Landroid/util/Log;->e(Ljava/lang/String;Ljava/lang/String;)I :goto_2 return-object v0 .end method .method private a(Landroid/database/sqlite/SQLiteDatabase;I)V .locals 3 const-string v0, "USER_DB" const-string v1, "updateTabeV2: -------------------------" .line 152 invoke-static {v0, v1}, Landroid/util/Log;->i(Ljava/lang/String;Ljava/lang/String;)I const/4 v0, 0x4 if-ge p2, v0, :cond_0 .line 157 :try_start_0 new-instance p2, Lcom/moji/preferences/ProcessPrefer; invoke-direct {p2}, Lcom/moji/preferences/ProcessPrefer;->()V invoke-virtual {p2}, Lcom/moji/preferences/ProcessPrefer;->j()Ljava/lang/String; move-result-object p2 const-string v0, "UserInfo" invoke-direct {p0, p1, p2, v0}, Lcom/moji/account/data/UserInfoDBHelper;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)Lcom/moji/account/data/UserInfo; move-result-object p2 goto :goto_0 :catch_0 move-exception p1 goto :goto_1 :cond_0 if-ne p2, v0, :cond_1 .line 159 new-instance p2, Lcom/moji/preferences/ProcessPrefer; invoke-direct {p2}, Lcom/moji/preferences/ProcessPrefer;->()V invoke-virtual {p2}, Lcom/moji/preferences/ProcessPrefer;->j()Ljava/lang/String; move-result-object p2 const-string v0, "UserInfo" invoke-direct {p0, p1, p2, v0}, Lcom/moji/account/data/UserInfoDBHelper;->b(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)Lcom/moji/account/data/UserInfo; move-result-object p2 goto :goto_0 .line 161 :cond_1 new-instance p2, Lcom/moji/preferences/ProcessPrefer; invoke-direct {p2}, Lcom/moji/preferences/ProcessPrefer;->()V invoke-virtual {p2}, Lcom/moji/preferences/ProcessPrefer;->j()Ljava/lang/String; move-result-object p2 const-string v0, "UserInfo" invoke-direct {p0, p1, p2, v0}, Lcom/moji/account/data/UserInfoDBHelper;->c(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)Lcom/moji/account/data/UserInfo; move-result-object p2 :goto_0 const-string v0, "DROP TABLE IF EXISTS UserInfo" .line 164 invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V .line 166 invoke-virtual {p0, p1}, Lcom/moji/account/data/UserInfoDBHelper;->onCreate(Landroid/database/sqlite/SQLiteDatabase;)V if-eqz p2, :cond_2 const-string v0, "USER_DB" .line 169 new-instance v1, Ljava/lang/StringBuilder; invoke-direct {v1}, Ljava/lang/StringBuilder;->()V const-string v2, "updateTabeV2: UserInfo:" invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {p2}, Lcom/moji/account/data/UserInfo;->toString()Ljava/lang/String; move-result-object v2 invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v1}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String; move-result-object v1 invoke-static {v0, v1}, Landroid/util/Log;->i(Ljava/lang/String;Ljava/lang/String;)I .line 170 invoke-virtual {p0, p1, p2}, Lcom/moji/account/data/UserInfoDBHelper;->a(Landroid/database/sqlite/SQLiteDatabase;Lcom/moji/account/data/UserInfo;)V :try_end_0 .catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_0 goto :goto_2 :goto_1 const-string p2, "USER_DB" .line 173 invoke-static {p2, p1}, Lcom/moji/tool/log/MJLogger;->a(Ljava/lang/String;Ljava/lang/Throwable;)V :cond_2 :goto_2 return-void .end method .method private a(Landroid/database/sqlite/SQLiteDatabase;II)V .locals 6 const/4 v0, 0x6 if-ne p3, v0, :cond_2 const-string v0, "USER_DB" const-string v1, "updateTabeV1: -----------------------" .line 108 invoke-static {v0, v1}, Landroid/util/Log;->i(Ljava/lang/String;Ljava/lang/String;)I .line 109 new-instance v0, Lcom/moji/preferences/DefaultPrefer; invoke-direct {v0}, Lcom/moji/preferences/DefaultPrefer;->()V .line 110 new-instance v1, Lcom/moji/preferences/ProcessPrefer; invoke-direct {v1}, Lcom/moji/preferences/ProcessPrefer;->()V const/4 v2, 0x1 .line 111 invoke-virtual {v0, v2}, Lcom/moji/preferences/DefaultPrefer;->e(Z)V .line 113 :try_start_0 iget v0, p0, Lcom/moji/account/data/UserInfoDBHelper;->b:I if-lez v0, :cond_3 .line 115 iget-object v0, p0, Lcom/moji/account/data/UserInfoDBHelper;->a:Landroid/content/Context; invoke-static {v0}, Lcom/moji/account/data/fillpitplan/SnsUserInfoSqliteManager;->a(Landroid/content/Context;)Ljava/lang/String; move-result-object v0 .line 116 invoke-static {v0}, Landroid/text/TextUtils;->isEmpty(Ljava/lang/CharSequence;)Z move-result v3 if-nez v3, :cond_0 .line 117 invoke-virtual {v1, v0}, Lcom/moji/preferences/ProcessPrefer;->b(Ljava/lang/String;)V const-string v0, "USER_DB" const-string v3, "\u517c\u5bb9\u767b\u9646\u72b6\u6001\u6210\u529f" .line 118 invoke-static {v0, v3}, Lcom/moji/tool/log/MJLogger;->c(Ljava/lang/String;Ljava/lang/String;)V goto :goto_0 :cond_0 const-string v0, "USER_DB" const-string v3, "5.0 \u672a \u767b\u9646 " .line 120 invoke-static {v0, v3}, Lcom/moji/tool/log/MJLogger;->c(Ljava/lang/String;Ljava/lang/String;)V .line 123 :goto_0 new-instance v0, Lcom/moji/account/data/fillpitplan/SnsUserInfoSqliteManager; invoke-direct {v0}, Lcom/moji/account/data/fillpitplan/SnsUserInfoSqliteManager;->()V .line 124 invoke-virtual {v0, p1}, Lcom/moji/account/data/fillpitplan/SnsUserInfoSqliteManager;->a(Landroid/database/sqlite/SQLiteDatabase;)Lcom/moji/account/data/fillpitplan/SnsUserInfo; move-result-object v0 if-eqz v0, :cond_1 const-string v3, "USER_DB" .line 126 new-instance v4, Ljava/lang/StringBuilder; invoke-direct {v4}, Ljava/lang/StringBuilder;->()V const-string v5, "\u65e7\u7248\u672c\u7528\u6237\u6570\u636e " invoke-virtual {v4, v5}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v0}, Lcom/moji/account/data/fillpitplan/SnsUserInfo;->toString()Ljava/lang/String; move-result-object v5 invoke-virtual {v4, v5}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v4}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String; move-result-object v4 invoke-static {v3, v4}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V .line 127 iget-object v3, v0, Lcom/moji/account/data/fillpitplan/SnsUserInfo;->b:Ljava/lang/String; invoke-virtual {v1, v3}, Lcom/moji/preferences/ProcessPrefer;->c(Ljava/lang/String;)V const-string v1, "DROP TABLE IF EXISTS UserInfo" .line 128 invoke-virtual {p1, v1}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V .line 129 invoke-virtual {p0, p1}, Lcom/moji/account/data/UserInfoDBHelper;->onCreate(Landroid/database/sqlite/SQLiteDatabase;)V .line 131 invoke-virtual {v0}, Lcom/moji/account/data/fillpitplan/SnsUserInfo;->a()Lcom/moji/account/data/UserInfo; move-result-object v0 invoke-virtual {p0, p1, v0}, Lcom/moji/account/data/UserInfoDBHelper;->a(Landroid/database/sqlite/SQLiteDatabase;Lcom/moji/account/data/UserInfo;)V const-string v0, "USER_DB" const-string v1, "\u79fb\u690d\u6210\u529f " .line 132 invoke-static {v0, v1}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V goto :goto_1 :cond_1 const-string v0, "USER_DB" const-string v1, "getSnsUserInfo fail \u67e5\u8be2\u672c\u5730\u6570\u636e\u5931\u8d25" .line 134 invoke-static {v0, v1}, Lcom/moji/tool/log/MJLogger;->e(Ljava/lang/String;Ljava/lang/String;)V :try_end_0 .catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_0 goto :goto_1 :catch_0 move-exception v0 .line 138 iget v1, p0, Lcom/moji/account/data/UserInfoDBHelper;->b:I sub-int/2addr v1, v2 iput v1, p0, Lcom/moji/account/data/UserInfoDBHelper;->b:I .line 139 invoke-virtual {p0, p1, p2, p3}, Lcom/moji/account/data/UserInfoDBHelper;->onUpgrade(Landroid/database/sqlite/SQLiteDatabase;II)V const-string p1, "USER_DB" .line 140 invoke-static {p1, v0}, Lcom/moji/tool/log/MJLogger;->a(Ljava/lang/String;Ljava/lang/Throwable;)V const-string p1, "USER_DB" const-string p2, "\u5199\u5165\u6570\u636e\u5931\u8d25 \u91cd\u65b0\u64cd\u4f5c" .line 141 invoke-static {p1, p2}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V goto :goto_1 :cond_2 const-string p2, "USER_DB" const-string p3, "\u662f\u5176\u4ed6\u7248\u672c\u53f7 now delete db " .line 144 invoke-static {p2, p3}, Lcom/moji/tool/log/MJLogger;->e(Ljava/lang/String;Ljava/lang/String;)V const-string p2, "DROP TABLE IF EXISTS UserInfo" .line 146 invoke-virtual {p1, p2}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V .line 147 invoke-virtual {p0, p1}, Lcom/moji/account/data/UserInfoDBHelper;->onCreate(Landroid/database/sqlite/SQLiteDatabase;)V :cond_3 :goto_1 return-void .end method .method private b(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)Lcom/moji/account/data/UserInfo; .locals 4 const/4 v0, 0x0 .line 232 :try_start_0 new-instance v1, Ljava/lang/StringBuilder; invoke-direct {v1}, Ljava/lang/StringBuilder;->()V const-string v2, "select * from " invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; const-string p3, " where " invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; const-string p3, "SnsId" invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; const-string p3, "=?" invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v1}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String; move-result-object p3 const-string v1, "USER_DB" .line 233 new-instance v2, Ljava/lang/StringBuilder; invoke-direct {v2}, Ljava/lang/StringBuilder;->()V const-string v3, "query string " invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v2, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v2}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String; move-result-object v2 invoke-static {v1, v2}, Landroid/util/Log;->i(Ljava/lang/String;Ljava/lang/String;)I const/4 v1, 0x1 .line 234 new-array v2, v1, [Ljava/lang/String; const/4 v3, 0x0 aput-object p2, v2, v3 invoke-virtual {p1, p3, v2}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor; move-result-object p1 .line 235 :goto_0 invoke-interface {p1}, Landroid/database/Cursor;->moveToNext()Z move-result p2 if-eqz p2, :cond_0 .line 236 new-instance p2, Lcom/moji/account/data/UserInfo; invoke-direct {p2}, Lcom/moji/account/data/UserInfo;->()V :try_end_0 .catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_1 .line 237 :try_start_1 invoke-interface {p1, v3}, Landroid/database/Cursor;->getInt(I)I move-result p3 iput p3, p2, Lcom/moji/account/data/UserInfo;->sqlId:I .line 238 invoke-interface {p1, v1}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->sns_id:Ljava/lang/String; const/4 p3, 0x2 .line 239 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->user_id:Ljava/lang/String; const/4 p3, 0x3 .line 240 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->nick:Ljava/lang/String; const/4 p3, 0x4 .line 241 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->account:Ljava/lang/String; const/4 p3, 0x5 .line 242 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->login_type:Ljava/lang/String; const/4 p3, 0x6 .line 243 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->password:Ljava/lang/String; const/4 p3, 0x7 .line 244 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->face:Ljava/lang/String; const/16 p3, 0x8 .line 245 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->type:Ljava/lang/String; const/16 p3, 0x9 .line 246 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->status:Ljava/lang/String; const/16 p3, 0xa .line 247 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->create_time:Ljava/lang/String; const/16 p3, 0xb .line 248 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->background_url:Ljava/lang/String; const/16 p3, 0xc .line 249 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->email:Ljava/lang/String; const/16 p3, 0xd .line 250 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->mobile:Ljava/lang/String; const/16 p3, 0xe .line 251 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->sex:Ljava/lang/String; const/16 p3, 0xf .line 252 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->birth:Ljava/lang/String; const/16 p3, 0x10 .line 253 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->sign:Ljava/lang/String; const/16 p3, 0x11 .line 254 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->city_id:Ljava/lang/String; const/16 p3, 0x12 .line 255 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->followed_count:Ljava/lang/String; const/16 p3, 0x13 .line 256 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->following_count:Ljava/lang/String; const/16 p3, 0x14 .line 257 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->sns_name:Ljava/lang/String; const/16 p3, 0x15 .line 258 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->city_name:Ljava/lang/String; const/16 p3, 0x16 .line 259 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->expire_time:Ljava/lang/String; const/16 p3, 0x17 .line 260 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->is_expire:Ljava/lang/String; const/16 p3, 0x18 .line 261 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->is_vip:Ljava/lang/String; const/16 p3, 0x19 .line 262 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->member_level:Ljava/lang/String; const/16 p3, 0x1a .line 263 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->start_time:Ljava/lang/String; const/16 p3, 0x1b .line 264 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->vip_md5:Ljava/lang/String; :try_end_1 .catch Ljava/lang/Exception; {:try_start_1 .. :try_end_1} :catch_0 move-object v0, p2 goto/16 :goto_0 :catch_0 move-exception p1 move-object v0, p2 goto :goto_1 .line 266 :cond_0 :try_start_2 invoke-interface {p1}, Landroid/database/Cursor;->close()V :try_end_2 .catch Ljava/lang/Exception; {:try_start_2 .. :try_end_2} :catch_1 goto :goto_2 :catch_1 move-exception p1 :goto_1 const-string p2, "USER_DB" .line 268 invoke-virtual {p1}, Ljava/lang/Exception;->toString()Ljava/lang/String; move-result-object p1 invoke-static {p2, p1}, Landroid/util/Log;->e(Ljava/lang/String;Ljava/lang/String;)I :goto_2 return-object v0 .end method .method private c(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)Lcom/moji/account/data/UserInfo; .locals 4 const/4 v0, 0x0 .line 283 :try_start_0 new-instance v1, Ljava/lang/StringBuilder; invoke-direct {v1}, Ljava/lang/StringBuilder;->()V const-string v2, "select * from " invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; const-string p3, " where " invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; const-string p3, "SnsId" invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; const-string p3, "=?" invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v1}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String; move-result-object p3 const-string v1, "USER_DB" .line 284 new-instance v2, Ljava/lang/StringBuilder; invoke-direct {v2}, Ljava/lang/StringBuilder;->()V const-string v3, "query string " invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v2, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v2}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String; move-result-object v2 invoke-static {v1, v2}, Landroid/util/Log;->i(Ljava/lang/String;Ljava/lang/String;)I const/4 v1, 0x1 .line 285 new-array v2, v1, [Ljava/lang/String; const/4 v3, 0x0 aput-object p2, v2, v3 invoke-virtual {p1, p3, v2}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor; move-result-object p1 .line 286 :goto_0 invoke-interface {p1}, Landroid/database/Cursor;->moveToNext()Z move-result p2 if-eqz p2, :cond_0 .line 287 new-instance p2, Lcom/moji/account/data/UserInfo; invoke-direct {p2}, Lcom/moji/account/data/UserInfo;->()V :try_end_0 .catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_1 .line 288 :try_start_1 invoke-interface {p1, v3}, Landroid/database/Cursor;->getInt(I)I move-result p3 iput p3, p2, Lcom/moji/account/data/UserInfo;->sqlId:I .line 289 invoke-interface {p1, v1}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->sns_id:Ljava/lang/String; const/4 p3, 0x2 .line 290 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->user_id:Ljava/lang/String; const/4 p3, 0x3 .line 291 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->nick:Ljava/lang/String; const/4 p3, 0x4 .line 292 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->account:Ljava/lang/String; const/4 p3, 0x5 .line 293 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->login_type:Ljava/lang/String; const/4 p3, 0x6 .line 294 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->password:Ljava/lang/String; const/4 p3, 0x7 .line 295 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->face:Ljava/lang/String; const/16 p3, 0x8 .line 296 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->type:Ljava/lang/String; const/16 p3, 0x9 .line 297 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->status:Ljava/lang/String; const/16 p3, 0xa .line 298 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->create_time:Ljava/lang/String; const/16 p3, 0xb .line 299 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->background_url:Ljava/lang/String; const/16 p3, 0xc .line 300 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->email:Ljava/lang/String; const/16 p3, 0xd .line 301 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->mobile:Ljava/lang/String; const/16 p3, 0xe .line 302 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->sex:Ljava/lang/String; const/16 p3, 0xf .line 303 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->birth:Ljava/lang/String; const/16 p3, 0x10 .line 304 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->sign:Ljava/lang/String; const/16 p3, 0x11 .line 305 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->city_id:Ljava/lang/String; const/16 p3, 0x12 .line 306 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->followed_count:Ljava/lang/String; const/16 p3, 0x13 .line 307 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->following_count:Ljava/lang/String; const/16 p3, 0x14 .line 308 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->sns_name:Ljava/lang/String; const/16 p3, 0x15 .line 309 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->city_name:Ljava/lang/String; const/16 p3, 0x16 .line 310 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->expire_time:Ljava/lang/String; const/16 p3, 0x17 .line 311 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->is_expire:Ljava/lang/String; const/16 p3, 0x18 .line 312 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->is_vip:Ljava/lang/String; const/16 p3, 0x19 .line 313 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->member_level:Ljava/lang/String; const/16 p3, 0x1a .line 314 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->start_time:Ljava/lang/String; const/16 p3, 0x1b .line 315 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->vip_md5:Ljava/lang/String; const/16 p3, 0x1c .line 316 invoke-interface {p1, p3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String; move-result-object p3 iput-object p3, p2, Lcom/moji/account/data/UserInfo;->remain_day:Ljava/lang/String; :try_end_1 .catch Ljava/lang/Exception; {:try_start_1 .. :try_end_1} :catch_0 move-object v0, p2 goto/16 :goto_0 :catch_0 move-exception p1 move-object v0, p2 goto :goto_1 .line 318 :cond_0 :try_start_2 invoke-interface {p1}, Landroid/database/Cursor;->close()V :try_end_2 .catch Ljava/lang/Exception; {:try_start_2 .. :try_end_2} :catch_1 goto :goto_2 :catch_1 move-exception p1 :goto_1 const-string p2, "USER_DB" .line 320 invoke-virtual {p1}, Ljava/lang/Exception;->toString()Ljava/lang/String; move-result-object p1 invoke-static {p2, p1}, Landroid/util/Log;->e(Ljava/lang/String;Ljava/lang/String;)I :goto_2 return-object v0 .end method # virtual methods .method public a(Landroid/database/sqlite/SQLiteDatabase;Lcom/moji/account/data/UserInfo;)V .locals 4 .annotation system Ldalvik/annotation/Throws; value = { Ljava/lang/Exception; } .end annotation :try_start_0 const-string v0, "insert into UserInfo (SnsId, UserId, NickName, Account, password, LoginType, FaceImageUrl, Type, Status, CreateTime, BackgroundUrl, Email, Mobile, Sex, Birth, Sign, CityId, FollowedCount, FollowingCount, OfficalType, OfficalTitle, SnsName, ExpireTime, IsExpire, IsVip, MemberLevel, StartTime, VipSign, Remain_Day, CityName ) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" const-string v1, "USER_DB" .line 364 new-instance v2, Ljava/lang/StringBuilder; invoke-direct {v2}, Ljava/lang/StringBuilder;->()V const-string v3, "insert " invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v2, v0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v2}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String; move-result-object v2 invoke-static {v1, v2}, Landroid/util/Log;->i(Ljava/lang/String;Ljava/lang/String;)I const/16 v1, 0x1e .line 365 new-array v1, v1, [Ljava/lang/Object; const/4 v2, 0x0 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->sns_id:Ljava/lang/String; aput-object v3, v1, v2 const/4 v2, 0x1 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->user_id:Ljava/lang/String; aput-object v3, v1, v2 const/4 v2, 0x2 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->nick:Ljava/lang/String; aput-object v3, v1, v2 const/4 v2, 0x3 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->account:Ljava/lang/String; aput-object v3, v1, v2 const/4 v2, 0x4 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->password:Ljava/lang/String; aput-object v3, v1, v2 const/4 v2, 0x5 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->login_type:Ljava/lang/String; aput-object v3, v1, v2 const/4 v2, 0x6 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->face:Ljava/lang/String; aput-object v3, v1, v2 const/4 v2, 0x7 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->type:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x8 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->status:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x9 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->create_time:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0xa iget-object v3, p2, Lcom/moji/account/data/UserInfo;->background_url:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0xb iget-object v3, p2, Lcom/moji/account/data/UserInfo;->email:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0xc iget-object v3, p2, Lcom/moji/account/data/UserInfo;->mobile:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0xd iget-object v3, p2, Lcom/moji/account/data/UserInfo;->sex:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0xe iget-object v3, p2, Lcom/moji/account/data/UserInfo;->birth:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0xf iget-object v3, p2, Lcom/moji/account/data/UserInfo;->sign:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x10 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->city_id:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x11 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->followed_count:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x12 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->following_count:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x13 iget v3, p2, Lcom/moji/account/data/UserInfo;->offical_type:I .line 386 invoke-static {v3}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer; move-result-object v3 aput-object v3, v1, v2 const/16 v2, 0x14 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->offical_title:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x15 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->sns_name:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x16 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->expire_time:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x17 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->is_expire:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x18 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->is_vip:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x19 iget-object v3, p2, Lcom/moji/account/data/UserInfo;->member_level:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x1a iget-object v3, p2, Lcom/moji/account/data/UserInfo;->start_time:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x1b iget-object v3, p2, Lcom/moji/account/data/UserInfo;->vip_md5:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x1c iget-object v3, p2, Lcom/moji/account/data/UserInfo;->remain_day:Ljava/lang/String; aput-object v3, v1, v2 const/16 v2, 0x1d iget-object p2, p2, Lcom/moji/account/data/UserInfo;->city_name:Ljava/lang/String; aput-object p2, v1, v2 .line 365 invoke-virtual {p1, v0, v1}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;[Ljava/lang/Object;)V const-string p1, "USER_DB" const-string p2, "save user info successfully" .line 398 invoke-static {p1, p2}, Landroid/util/Log;->i(Ljava/lang/String;Ljava/lang/String;)I :try_end_0 .catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_0 goto :goto_0 :catch_0 move-exception p1 const-string p2, "USER_DB" .line 400 invoke-static {p2, p1}, Lcom/moji/tool/log/MJLogger;->a(Ljava/lang/String;Ljava/lang/Throwable;)V :goto_0 return-void .end method .method public onCreate(Landroid/database/sqlite/SQLiteDatabase;)V .locals 2 const-string v0, "USER_DB" const-string v1, "\u6570\u636e\u5e93 onCreate " .line 30 invoke-static {v0, v1}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V const-string v0, "CREATE TABLE IF NOT EXISTS UserInfo(id integer PRIMARY KEY AUTOINCREMENT NOT NULL,SnsId varchar(40),UserId varchar(40),NickName varchar(40), Account varchar(40),LoginType varchar(20),password varchar(200), FaceImageUrl varchar(200),Type varchar(20),Status varchar(20),CreateTime varchar(20),BackgroundUrl varchar(200),Email varchar(40),Mobile varchar(40),Sex varchar(10),Birth varchar(40),Sign varchar(40),CityId varchar(40),FollowedCount varchar(40),FollowingCount varchar(40),OfficalType varchar(10),OfficalTitle varchar(40),SnsName varchar(40),CityName varchar(40),ExpireTime varchar(40),IsExpire varchar(40),IsVip varchar(40),MemberLevel varchar(40), StartTime varchar(40), VipSign varchar(40), Remain_Day varchar(40))" .line 32 invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V const-string p1, "USER_DB" const-string v0, "\u6570\u636e\u5e93\u65b0\u5efa\u6210\u529f " .line 64 invoke-static {p1, v0}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V return-void .end method .method public onDowngrade(Landroid/database/sqlite/SQLiteDatabase;II)V .locals 0 if-le p2, p3, :cond_0 const-string p2, "USER_DB" const-string p3, "onDowngrade: -------------------------" .line 91 invoke-static {p2, p3}, Landroid/util/Log;->i(Ljava/lang/String;Ljava/lang/String;)I :try_start_0 const-string p2, "DROP TABLE IF EXISTS UserInfo" .line 95 invoke-virtual {p1, p2}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V .line 97 invoke-virtual {p0, p1}, Lcom/moji/account/data/UserInfoDBHelper;->onCreate(Landroid/database/sqlite/SQLiteDatabase;)V :try_end_0 .catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_0 goto :goto_0 :catch_0 move-exception p1 const-string p2, "USER_DB" .line 100 invoke-static {p2, p1}, Lcom/moji/tool/log/MJLogger;->a(Ljava/lang/String;Ljava/lang/Throwable;)V :cond_0 :goto_0 return-void .end method .method public onUpgrade(Landroid/database/sqlite/SQLiteDatabase;II)V .locals 3 const-string v0, "USER_DB" .line 71 new-instance v1, Ljava/lang/StringBuilder; invoke-direct {v1}, Ljava/lang/StringBuilder;->()V const-string v2, "onUpgrade: " invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v1, p2}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder; const-string v2, ":" invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder; invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder; invoke-virtual {v1}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String; move-result-object v1 invoke-static {v0, v1}, Landroid/util/Log;->i(Ljava/lang/String;Ljava/lang/String;)I move v0, p2 :goto_0 if-gt v0, p3, :cond_0 packed-switch v0, :pswitch_data_0 goto :goto_1 .line 81 :pswitch_0 invoke-direct {p0, p1, v0}, Lcom/moji/account/data/UserInfoDBHelper;->a(Landroid/database/sqlite/SQLiteDatabase;I)V const/4 v0, 0x5 goto :goto_1 .line 75 :pswitch_1 invoke-direct {p0, p1, p2, p3}, Lcom/moji/account/data/UserInfoDBHelper;->a(Landroid/database/sqlite/SQLiteDatabase;II)V :goto_1 add-int/lit8 v0, v0, 0x1 goto :goto_0 :cond_0 return-void nop :pswitch_data_0 .packed-switch 0x1 :pswitch_1 :pswitch_0 :pswitch_0 :pswitch_0 :pswitch_0 .end packed-switch .end method