512 lines
12 KiB
Smali
512 lines
12 KiB
Smali
.class public Lcom/moji/mjad/splash/db/SplashCityDbHelper;
|
|
.super Ljava/lang/Object;
|
|
.source "SplashCityDbHelper.java"
|
|
|
|
|
|
# instance fields
|
|
.field private a:Landroid/database/sqlite/SQLiteDatabase;
|
|
|
|
|
|
# direct methods
|
|
.method public constructor <init>(Landroid/content/Context;)V
|
|
.locals 5
|
|
|
|
.line 24
|
|
invoke-direct {p0}, Ljava/lang/Object;-><init>()V
|
|
|
|
const/4 v0, 0x0
|
|
|
|
.line 23
|
|
iput-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;
|
|
|
|
if-eqz p1, :cond_3
|
|
|
|
.line 27
|
|
:try_start_0
|
|
sget-object v1, Lcom/moji/dynamic/DynamicLoadType;->CITY_DB:Lcom/moji/dynamic/DynamicLoadType;
|
|
|
|
invoke-static {p1, v1}, Lcom/moji/dynamic/DynamicLoadManager;->a(Landroid/content/Context;Lcom/moji/dynamic/DynamicLoadType;)Ljava/lang/String;
|
|
|
|
move-result-object v1
|
|
|
|
const-string v2, "SplashCityDbHelper"
|
|
|
|
.line 28
|
|
new-instance v3, Ljava/lang/StringBuilder;
|
|
|
|
invoke-direct {v3}, Ljava/lang/StringBuilder;-><init>()V
|
|
|
|
const-string v4, "SplashCityDbHelper localDBPath:"
|
|
|
|
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-virtual {v3, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-virtual {v3}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
|
|
|
|
move-result-object v3
|
|
|
|
invoke-static {v2, v3}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V
|
|
|
|
.line 29
|
|
invoke-static {v1}, Landroid/text/TextUtils;->isEmpty(Ljava/lang/CharSequence;)Z
|
|
|
|
move-result v2
|
|
|
|
if-nez v2, :cond_0
|
|
|
|
const-string v2, "UNKNOWN"
|
|
|
|
invoke-virtual {v2, v1}, Ljava/lang/String;->equalsIgnoreCase(Ljava/lang/String;)Z
|
|
|
|
move-result v2
|
|
|
|
if-eqz v2, :cond_1
|
|
|
|
:cond_0
|
|
const-string v1, "mojicity11.db"
|
|
|
|
.line 30
|
|
invoke-virtual {p1, v1}, Landroid/content/Context;->getDatabasePath(Ljava/lang/String;)Ljava/io/File;
|
|
|
|
move-result-object p1
|
|
|
|
invoke-virtual {p1}, Ljava/io/File;->getAbsolutePath()Ljava/lang/String;
|
|
|
|
move-result-object v1
|
|
|
|
const-string p1, "SplashCityDbHelper"
|
|
|
|
.line 31
|
|
new-instance v2, Ljava/lang/StringBuilder;
|
|
|
|
invoke-direct {v2}, Ljava/lang/StringBuilder;-><init>()V
|
|
|
|
const-string v3, "SplashCityDbHelper localDBPath2:"
|
|
|
|
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-virtual {v2, v1}, 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 {p1, v2}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V
|
|
|
|
.line 33
|
|
:cond_1
|
|
invoke-static {v1}, Landroid/text/TextUtils;->isEmpty(Ljava/lang/CharSequence;)Z
|
|
|
|
move-result p1
|
|
|
|
if-nez p1, :cond_3
|
|
|
|
.line 34
|
|
new-instance p1, Ljava/io/File;
|
|
|
|
invoke-direct {p1, v1}, Ljava/io/File;-><init>(Ljava/lang/String;)V
|
|
|
|
.line 35
|
|
invoke-virtual {p1}, Ljava/io/File;->exists()Z
|
|
|
|
move-result p1
|
|
|
|
if-eqz p1, :cond_2
|
|
|
|
const/4 p1, 0x1
|
|
|
|
.line 36
|
|
invoke-static {v1, v0, p1}, Landroid/database/sqlite/SQLiteDatabase;->openDatabase(Ljava/lang/String;Landroid/database/sqlite/SQLiteDatabase$CursorFactory;I)Landroid/database/sqlite/SQLiteDatabase;
|
|
|
|
move-result-object p1
|
|
|
|
iput-object p1, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;
|
|
|
|
goto :goto_0
|
|
|
|
:cond_2
|
|
const-string p1, "SplashCityDbHelper"
|
|
|
|
const-string v1, "SplashCityDbHelper !file.exists()"
|
|
|
|
.line 38
|
|
invoke-static {p1, v1}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V
|
|
:try_end_0
|
|
.catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_0
|
|
|
|
goto :goto_0
|
|
|
|
:catch_0
|
|
move-exception p1
|
|
|
|
.line 42
|
|
iput-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;
|
|
|
|
const-string v0, "SplashCityDbHelper"
|
|
|
|
.line 43
|
|
invoke-static {v0, p1}, Lcom/moji/tool/log/MJLogger;->a(Ljava/lang/String;Ljava/lang/Throwable;)V
|
|
|
|
:cond_3
|
|
:goto_0
|
|
return-void
|
|
.end method
|
|
|
|
.method private a(Lcom/moji/mjad/splash/data/CityInfo;IZ)V
|
|
.locals 6
|
|
|
|
.line 75
|
|
iget-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;
|
|
|
|
if-eqz v0, :cond_7
|
|
|
|
const/4 v0, 0x0
|
|
|
|
.line 78
|
|
:try_start_0
|
|
iget-object v1, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;
|
|
|
|
new-instance v2, Ljava/lang/StringBuilder;
|
|
|
|
invoke-direct {v2}, Ljava/lang/StringBuilder;-><init>()V
|
|
|
|
const-string v3, "SELECT * FROM city WHERE "
|
|
|
|
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
if-eqz p3, :cond_0
|
|
|
|
const-string v3, "internal_id"
|
|
|
|
goto :goto_0
|
|
|
|
:cond_0
|
|
const-string v3, "city_id"
|
|
|
|
:goto_0
|
|
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
const-string v3, " = "
|
|
|
|
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-virtual {v2, p2}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
|
|
|
|
const-string v3, ";"
|
|
|
|
invoke-virtual {v2, v3}, 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-virtual {v1, v2, v0}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;
|
|
|
|
move-result-object v1
|
|
:try_end_0
|
|
.catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_1
|
|
.catchall {:try_start_0 .. :try_end_0} :catchall_1
|
|
|
|
.line 79
|
|
:cond_1
|
|
:goto_1
|
|
:try_start_1
|
|
invoke-interface {v1}, Landroid/database/Cursor;->moveToNext()Z
|
|
|
|
move-result v0
|
|
|
|
if-eqz v0, :cond_5
|
|
|
|
.line 80
|
|
invoke-interface {v1}, Landroid/database/Cursor;->isClosed()Z
|
|
|
|
move-result v0
|
|
|
|
if-nez v0, :cond_1
|
|
|
|
const-string v0, "LocalCityDBHelper"
|
|
|
|
.line 81
|
|
new-instance v2, Ljava/lang/StringBuilder;
|
|
|
|
invoke-direct {v2}, Ljava/lang/StringBuilder;-><init>()V
|
|
|
|
const-string v3, "sea city names:"
|
|
|
|
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-interface {v1}, Landroid/database/Cursor;->getColumnNames()[Ljava/lang/String;
|
|
|
|
move-result-object v3
|
|
|
|
const/4 v4, 0x0
|
|
|
|
aget-object v3, v3, v4
|
|
|
|
invoke-virtual {v2, v3}, 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 {v0, v2}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V
|
|
|
|
const-string v0, "parent_id"
|
|
|
|
.line 82
|
|
invoke-interface {v1, v0}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I
|
|
|
|
move-result v0
|
|
|
|
invoke-interface {v1, v0}, Landroid/database/Cursor;->getInt(I)I
|
|
|
|
move-result v0
|
|
|
|
if-lez v0, :cond_4
|
|
|
|
if-eqz p3, :cond_2
|
|
|
|
const-string v2, "city_id"
|
|
|
|
.line 84
|
|
invoke-interface {v1, v2}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I
|
|
|
|
move-result v2
|
|
|
|
invoke-interface {v1, v2}, Landroid/database/Cursor;->getInt(I)I
|
|
|
|
move-result v2
|
|
|
|
goto :goto_2
|
|
|
|
:cond_2
|
|
move v2, p2
|
|
|
|
.line 85
|
|
:goto_2
|
|
iget-object v3, p1, Lcom/moji/mjad/splash/data/CityInfo;->a:Ljava/util/List;
|
|
|
|
invoke-static {v2}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;
|
|
|
|
move-result-object v5
|
|
|
|
invoke-interface {v3, v5}, Ljava/util/List;->contains(Ljava/lang/Object;)Z
|
|
|
|
move-result v3
|
|
|
|
if-nez v3, :cond_3
|
|
|
|
.line 86
|
|
iget-object v3, p1, Lcom/moji/mjad/splash/data/CityInfo;->a:Ljava/util/List;
|
|
|
|
invoke-static {v2}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;
|
|
|
|
move-result-object v2
|
|
|
|
invoke-interface {v3, v2}, Ljava/util/List;->add(Ljava/lang/Object;)Z
|
|
|
|
.line 87
|
|
invoke-direct {p0, p1, v0, v4}, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a(Lcom/moji/mjad/splash/data/CityInfo;IZ)V
|
|
|
|
goto :goto_1
|
|
|
|
.line 89
|
|
:cond_3
|
|
iput v0, p1, Lcom/moji/mjad/splash/data/CityInfo;->b:I
|
|
|
|
const-string v0, "country"
|
|
|
|
.line 90
|
|
invoke-interface {v1, v0}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I
|
|
|
|
move-result v0
|
|
|
|
invoke-interface {v1, v0}, Landroid/database/Cursor;->getInt(I)I
|
|
|
|
move-result v0
|
|
|
|
.line 91
|
|
iput v0, p1, Lcom/moji/mjad/splash/data/CityInfo;->c:I
|
|
|
|
goto :goto_1
|
|
|
|
.line 94
|
|
:cond_4
|
|
iput p2, p1, Lcom/moji/mjad/splash/data/CityInfo;->b:I
|
|
|
|
const-string v0, "country"
|
|
|
|
.line 95
|
|
invoke-interface {v1, v0}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I
|
|
|
|
move-result v0
|
|
|
|
invoke-interface {v1, v0}, Landroid/database/Cursor;->getInt(I)I
|
|
|
|
move-result v0
|
|
|
|
.line 96
|
|
iput v0, p1, Lcom/moji/mjad/splash/data/CityInfo;->c:I
|
|
:try_end_1
|
|
.catch Ljava/lang/Exception; {:try_start_1 .. :try_end_1} :catch_0
|
|
.catchall {:try_start_1 .. :try_end_1} :catchall_0
|
|
|
|
goto :goto_1
|
|
|
|
:cond_5
|
|
if-eqz v1, :cond_7
|
|
|
|
.line 104
|
|
invoke-interface {v1}, Landroid/database/Cursor;->close()V
|
|
|
|
goto :goto_5
|
|
|
|
:catchall_0
|
|
move-exception p1
|
|
|
|
goto :goto_4
|
|
|
|
:catch_0
|
|
move-exception p1
|
|
|
|
move-object v0, v1
|
|
|
|
goto :goto_3
|
|
|
|
:catchall_1
|
|
move-exception p1
|
|
|
|
move-object v1, v0
|
|
|
|
goto :goto_4
|
|
|
|
:catch_1
|
|
move-exception p1
|
|
|
|
:goto_3
|
|
:try_start_2
|
|
const-string p2, "LocalCityDBHelper"
|
|
|
|
.line 101
|
|
invoke-static {p2, p1}, Lcom/moji/tool/log/MJLogger;->a(Ljava/lang/String;Ljava/lang/Throwable;)V
|
|
:try_end_2
|
|
.catchall {:try_start_2 .. :try_end_2} :catchall_1
|
|
|
|
if-eqz v0, :cond_7
|
|
|
|
.line 104
|
|
invoke-interface {v0}, Landroid/database/Cursor;->close()V
|
|
|
|
goto :goto_5
|
|
|
|
:goto_4
|
|
if-eqz v1, :cond_6
|
|
|
|
invoke-interface {v1}, Landroid/database/Cursor;->close()V
|
|
|
|
.line 106
|
|
:cond_6
|
|
throw p1
|
|
|
|
:cond_7
|
|
:goto_5
|
|
return-void
|
|
.end method
|
|
|
|
|
|
# virtual methods
|
|
.method public a()Lcom/moji/mjad/splash/data/CityInfo;
|
|
.locals 3
|
|
|
|
.line 53
|
|
iget-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;
|
|
|
|
const/4 v1, 0x0
|
|
|
|
if-nez v0, :cond_0
|
|
|
|
return-object v1
|
|
|
|
.line 56
|
|
:cond_0
|
|
invoke-static {}, Lcom/moji/areamanagement/MJAreaManager;->a()Lcom/moji/common/area/AreaInfo;
|
|
|
|
move-result-object v0
|
|
|
|
if-eqz v0, :cond_3
|
|
|
|
.line 58
|
|
new-instance v1, Lcom/moji/mjad/splash/data/CityInfo;
|
|
|
|
invoke-direct {v1}, Lcom/moji/mjad/splash/data/CityInfo;-><init>()V
|
|
|
|
.line 60
|
|
:try_start_0
|
|
iget v0, v0, Lcom/moji/common/area/AreaInfo;->cityId:I
|
|
|
|
const/4 v2, 0x1
|
|
|
|
invoke-direct {p0, v1, v0, v2}, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a(Lcom/moji/mjad/splash/data/CityInfo;IZ)V
|
|
:try_end_0
|
|
.catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_0
|
|
.catchall {:try_start_0 .. :try_end_0} :catchall_0
|
|
|
|
.line 64
|
|
iget-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;
|
|
|
|
if-eqz v0, :cond_1
|
|
|
|
.line 65
|
|
:goto_0
|
|
iget-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;
|
|
|
|
invoke-virtual {v0}, Landroid/database/sqlite/SQLiteDatabase;->close()V
|
|
|
|
goto :goto_1
|
|
|
|
:catchall_0
|
|
move-exception v0
|
|
|
|
goto :goto_2
|
|
|
|
:catch_0
|
|
move-exception v0
|
|
|
|
:try_start_1
|
|
const-string v2, "LocalCityDBHelper"
|
|
|
|
.line 62
|
|
invoke-static {v2, v0}, Lcom/moji/tool/log/MJLogger;->a(Ljava/lang/String;Ljava/lang/Throwable;)V
|
|
:try_end_1
|
|
.catchall {:try_start_1 .. :try_end_1} :catchall_0
|
|
|
|
.line 64
|
|
iget-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;
|
|
|
|
if-eqz v0, :cond_1
|
|
|
|
goto :goto_0
|
|
|
|
:cond_1
|
|
:goto_1
|
|
return-object v1
|
|
|
|
:goto_2
|
|
iget-object v1, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;
|
|
|
|
if-eqz v1, :cond_2
|
|
|
|
.line 65
|
|
iget-object v1, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;
|
|
|
|
invoke-virtual {v1}, Landroid/database/sqlite/SQLiteDatabase;->close()V
|
|
|
|
.line 67
|
|
:cond_2
|
|
throw v0
|
|
|
|
:cond_3
|
|
return-object v1
|
|
.end method
|