号簿助手 v4.6.31版本的 MD5 值为：9d7ff98a6bb5cc178eac2df4d1b2f0e0
以下内容为反编译后的 k.java 源代码，内容仅作参考
package com.cn21.ued.apm.util;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import com.chinatelecom.pim.core.IConstant;
import com.cn21.ued.apm.constants.UedApplicaionData;
import com.ricky.android.common.download.Constants;
import java.net.URLEncoder;
import net.sourceforge.cardme.util.VCardUtils;
import org.json.JSONObject;
public class k {
private static final String Tag = k.class.getName();
public static void A(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Throwable th;
Cursor cursor2 = null;
s.e(Tag, "发送数据库UE数据。");
try {
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th2) {
cursor = null;
th = th2;
if (cursor == null) {
throw th;
}
if (cursor.isClosed()) {
throw th;
}
cursor.close();
throw th;
}
} catch (Exception e) {
s.e(Tag, "uploadAllUERecord出错");
if (0 == 0 || cursor2.isClosed()) {
return;
}
cursor2.close();
return;
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from ue_cache limit 20", null);
rawQuery.moveToFirst();
s.e(Tag, "UE 数据库共有数据" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
String f = com.cn21.ued.apm.b.a.b.f(com.cn21.ued.apm.b.a.b.d(sb.toString().substring(0, sb.toString().length() - 1), UedApplicaionData.key));
s.e(Tag, "ue db :" + f);
String a = com.cn21.ued.apm.b.a.b.a("http://ux.21cn.com/api/appReportRest/userEvent", System.currentTimeMillis(), f, F(context, sQLiteDatabase), 2, 1, G(context, sQLiteDatabase), UedApplicaionData.UE_VERSION);
s.e(Tag, "ue db rep :" + a);
if (!y.aC(a)) {
JSONObject jSONObject = new JSONObject(a);
int a2 = y.a(String.valueOf(jSONObject.getInt("code")), -1);
if (a2 == -1) {
UedApplicaionData.isStart = true;
UedApplicaionData.sid = "";
if (rawQuery == null || rawQuery.isClosed()) {
return;
}
rawQuery.close();
return;
}
if (a2 == 0) {
UedApplicaionData.key = y.f(jSONObject.getString(IConstant.VoiceRecognition.EXTRA_KEY), "");
}
for (int i = 0; i < rawQuery.getCount(); i++) {
sQLiteDatabase.execSQL("delete from ue_cache where insertTime in (select insertTime from ue_cache limit 1) and insertData in (select insertData from ue_cache limit 1)");
}
}
}
if (rawQuery == null || rawQuery.isClosed()) {
return;
}
rawQuery.close();
} catch (Throwable th3) {
cursor = null;
th = th3;
}
}
public static void B(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Throwable th;
Cursor cursor2 = null;
s.e(Tag, "发送数据库custom数据。");
try {
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th2) {
cursor = null;
th = th2;
if (cursor == null) {
throw th;
}
if (cursor.isClosed()) {
throw th;
}
cursor.close();
throw th;
}
} catch (Exception e) {
s.e(Tag, "uploadAllCustomEventRecord出错");
if (0 == 0 || cursor2.isClosed()) {
return;
}
cursor2.close();
return;
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from customevent_cache limit 20", null);
rawQuery.moveToFirst();
s.e(Tag, "custom 数据库共有数据" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
String f = com.cn21.ued.apm.b.a.b.f(com.cn21.ued.apm.b.a.b.d(sb.toString().substring(0, sb.toString().length() - 1), UedApplicaionData.key));
s.e(Tag, "custom db :" + f);
String a = com.cn21.ued.apm.b.a.b.a("http://ux.21cn.com/api/appReportRest/customEvent", System.currentTimeMillis(), f, F(context, sQLiteDatabase), 2, 1, G(context, sQLiteDatabase), UedApplicaionData.CUSTOMEVENT_VERSION);
s.e(Tag, "custom db rep :" + a);
if (!y.aC(a)) {
JSONObject jSONObject = new JSONObject(a);
int a2 = y.a(String.valueOf(jSONObject.getInt("code")), -1);
if (a2 == -1) {
UedApplicaionData.isStart = true;
UedApplicaionData.sid = "";
if (rawQuery == null || rawQuery.isClosed()) {
return;
}
rawQuery.close();
return;
}
if (a2 == 0) {
UedApplicaionData.key = y.f(jSONObject.getString(IConstant.VoiceRecognition.EXTRA_KEY), "");
}
for (int i = 0; i < rawQuery.getCount(); i++) {
sQLiteDatabase.execSQL("delete from customevent_cache where insertTime in (select insertTime from customevent_cache limit 1) and insertData in (select insertData from customevent_cache limit 1)");
}
}
}
if (rawQuery == null || rawQuery.isClosed()) {
return;
}
rawQuery.close();
} catch (Throwable th3) {
cursor = null;
th = th3;
}
}
public static void C(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Throwable th;
s.e(Tag, "发送数据库package数据。");
Cursor cursor2 = null;
try {
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "uploadAllpackageRecord出错");
if (0 == 0 || cursor2.isClosed()) {
return;
}
cursor2.close();
return;
}
} catch (Throwable th2) {
cursor = null;
th = th2;
if (cursor != null) {
throw th;
}
if (cursor.isClosed()) {
throw th;
}
cursor.close();
throw th;
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from package_cache order by insertTime desc limit 20", null);
rawQuery.moveToFirst();
s.e(Tag, "本次共发送 package 数据条数为：" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
s.e(Tag, "获取到的sid:" + UedApplicaionData.sid);
if (y.aC(UedApplicaionData.sid)) {
if (rawQuery == null || rawQuery.isClosed()) {
return;
}
rawQuery.close();
return;
}
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append(VCardUtils.CR);
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
s.e("发送出去的数据", new StringBuilder(String.valueOf(sb.toString())).toString());
s.a("加密前的长度-String", Integer.valueOf(sb.toString().length()));
s.e("加密前的长度", new StringBuilder(String.valueOf(sb.toString().getBytes("UTF-8").length)).toString());
String d = com.cn21.ued.apm.b.a.b.d(sb.toString().substring(0, sb.toString().length() - 1), UedApplicaionData.key);
s.a("加密后压缩前的长度-String", Integer.valueOf(d.length()));
s.e("加密后压缩前的长度", new StringBuilder(String.valueOf(d.getBytes("UTF-8").length)).toString());
s.a("加密后不压缩URLEncoder的长度-String", Integer.valueOf(URLEncoder.encode(d, "UTF-8").toString().length()));
s.a("加密后不压缩URLEncoder的长度", Integer.valueOf(URLEncoder.encode(d, "UTF-8").toString().getBytes().length));
String f = com.cn21.ued.apm.b.a.b.f(d);
s.e(Tag, "package db :" + f);
s.e("压缩后的长度-String", new StringBuilder(String.valueOf(f.length())).toString());
s.e("压缩后的长度", new StringBuilder(String.valueOf(f.getBytes("UTF-8").length)).toString());
String a = com.cn21.ued.apm.b.a.b.a("http://ux.21cn.com/api/appReportRest/packages", System.currentTimeMillis() + UedApplicaionData.deltaBetweenServerAndClientTime, f, F(context, sQLiteDatabase), 2, 1, G(context, sQLiteDatabase), UedApplicaionData.UB_VERSION, UedApplicaionData.UE_VERSION, UedApplicaionData.CUSTOMEVENT_VERSION, UedApplicaionData.HTTP_VERSION, UedApplicaionData.Block_VERSION);
s.e(Tag, "package db rep :" + a);
if (y.aC(a)) {
s.e(Tag, "没有收到回复");
} else {
JSONObject jSONObject = new JSONObject(a);
int a2 = y.a(String.valueOf(jSONObject.getInt("code")), -1);
s.e("发送是否成功", new StringBuilder(String.valueOf(a2 == 0 ? "是" : "否")).toString());
if (a2 == -1) {
UedApplicaionData.isStart = true;
UedApplicaionData.sid = "";
if (rawQuery == null || rawQuery.isClosed()) {
return;
}
rawQuery.close();
return;
}
if (a2 == 0) {
UedApplicaionData.key = y.f(jSONObject.getString(IConstant.VoiceRecognition.EXTRA_KEY), "");
}
for (int i = 0; i < rawQuery.getCount(); i++) {
sQLiteDatabase.execSQL("delete from package_cache where insertTime in (select insertTime from package_cache limit 1) and insertData in (select insertData from package_cache limit 1)");
}
}
}
if (rawQuery == null || rawQuery.isClosed()) {
return;
}
rawQuery.close();
} catch (Throwable th3) {
cursor = null;
th = th3;
if (cursor != null) {
}
}
}
public static void D(Context context, SQLiteDatabase sQLiteDatabase) {
SQLiteDatabase readableDatabase;
SQLiteDatabase readableDatabase2;
SQLiteDatabase readableDatabase3;
SQLiteDatabase readableDatabase4;
SQLiteDatabase readableDatabase5;
SQLiteDatabase readableDatabase6;
String k = k(context, sQLiteDatabase);
if (y.aC(k)) {
if (sQLiteDatabase == null) {
try {
readableDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "deleteUbueown出错");
}
} else {
readableDatabase = sQLiteDatabase;
}
readableDatabase.execSQL("delete from ubueown_cache");
if (sQLiteDatabase == null) {
try {
readableDatabase2 = j.l(context).getReadableDatabase();
} catch (Exception e2) {
s.e(Tag, "deletetrafficinfoown_cache出错");
}
} else {
readableDatabase2 = sQLiteDatabase;
}
readableDatabase2.execSQL("delete from trafficinfoown_cache");
if (sQLiteDatabase == null) {
try {
readableDatabase3 = j.l(context).getReadableDatabase();
} catch (Exception e3) {
s.e(Tag, "deleteFpswn出错");
}
} else {
readableDatabase3 = sQLiteDatabase;
}
readableDatabase3.execSQL("delete from fpsown_cache");
if (sQLiteDatabase == null) {
try {
readableDatabase4 = j.l(context).getReadableDatabase();
} catch (Exception e4) {
s.e(Tag, "deleteNetwork出错");
}
} else {
readableDatabase4 = sQLiteDatabase;
}
readableDatabase4.execSQL("delete from network_cache");
if (sQLiteDatabase == null) {
try {
readableDatabase5 = j.l(context).getReadableDatabase();
} catch (Exception e5) {
s.e(Tag, "deleteCustomLast出错");
}
} else {
readableDatabase5 = sQLiteDatabase;
}
readableDatabase5.execSQL("delete from customeventown_cache");
if (sQLiteDatabase == null) {
try {
readableDatabase6 = j.l(context).getReadableDatabase();
} catch (Exception e6) {
s.e(Tag, "deleteHttpownLast出错");
}
} else {
readableDatabase6 = sQLiteDatabase;
}
readableDatabase6.execSQL("delete from httpown_cache");
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e7) {
s.e(Tag, "deleteBlockownLast出错");
return;
}
}
sQLiteDatabase.execSQL("delete from blockown_cache");
return;
}
String q = q(context, sQLiteDatabase);
String w = w(context, sQLiteDatabase);
String t = t(context, sQLiteDatabase);
String u = u(context, sQLiteDatabase);
String p = p(context, sQLiteDatabase);
String o = o(context, sQLiteDatabase);
if (y.aC(q) && y.aC(w) && y.aC(t) && y.aC(u) && y.aC(p) && y.aC(o)) {
return;
}
StringBuffer stringBuffer = new StringBuffer();
stringBuffer.append(k);
stringBuffer.append(VCardUtils.HT);
if (y.aC(q)) {
stringBuffer.append(Constants.FILENAME_SEQUENCE_SEPARATOR);
} else {
stringBuffer.append(q);
}
stringBuffer.append(VCardUtils.HT);
if (y.aC(w)) {
stringBuffer.append(Constants.FILENAME_SEQUENCE_SEPARATOR);
} else {
stringBuffer.append(w);
}
stringBuffer.append(VCardUtils.HT);
if (y.aC(t)) {
stringBuffer.append(Constants.FILENAME_SEQUENCE_SEPARATOR);
} else {
stringBuffer.append(t);
}
stringBuffer.append(VCardUtils.HT);
if (y.aC(u)) {
stringBuffer.append(Constants.FILENAME_SEQUENCE_SEPARATOR);
} else {
stringBuffer.append(u);
}
stringBuffer.append(VCardUtils.HT);
if (y.aC(p)) {
stringBuffer.append(Constants.FILENAME_SEQUENCE_SEPARATOR);
} else {
stringBuffer.append(p);
}
stringBuffer.append(VCardUtils.HT);
if (y.aC(o)) {
stringBuffer.append(Constants.FILENAME_SEQUENCE_SEPARATOR);
} else {
stringBuffer.append(o);
}
try {
a(context, stringBuffer.toString(), sQLiteDatabase);
String b = G.b(context, new com.cn21.ued.apm.d.c());
if (y.aC(b) || y.aC(b.replaceAll(VCardUtils.HT, "").trim())) {
return;
}
i(context, b, sQLiteDatabase);
} catch (Exception e8) {
e8.printStackTrace();
}
}
public static com.cn21.ued.apm.b.a.b E(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Throwable th;
Cursor cursor2;
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
cursor2 = null;
try {
s.e(Tag, "getUserApm出错");
return cursor2 == null ? null : null;
} catch (Throwable th2) {
th = th2;
cursor = cursor2;
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
throw th;
}
} catch (Throwable th3) {
cursor = null;
th = th3;
if (cursor != null) {
}
throw th;
}
}
cursor = sQLiteDatabase.rawQuery("select * from user t order by t.createTime desc limit 1", null);
try {
if (cursor.getCount() <= 0) {
if (cursor == null || cursor.isClosed()) {
return null;
}
cursor.close();
return null;
}
cursor.moveToFirst();
String string = cursor.getString(cursor.getColumnIndex("imei"));
String string2 = cursor.getString(cursor.getColumnIndex("mac"));
String string3 = cursor.getString(cursor.getColumnIndex("apmid"));
String string4 = cursor.getString(cursor.getColumnIndex("createTime"));
com.cn21.ued.apm.b.a.b bVar = new com.cn21.ued.apm.b.a.b();
bVar.b(string3);
bVar.c(string4);
bVar.d(string);
bVar.e(string2);
UedApplicaionData.imei = string;
UedApplicaionData.mac = string2;
UedApplicaionData.apmid = string3;
UedApplicaionData.createTime = string4;
if (!cursor.isClosed()) {
cursor.close();
}
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return bVar;
} catch (Exception e2) {
cursor2 = cursor;
s.e(Tag, "getUserApm出错");
if (cursor2 == null && !cursor2.isClosed()) {
cursor2.close();
return null;
}
} catch (Throwable th4) {
th = th4;
if (cursor != null) {
cursor.close();
}
throw th;
}
}
public static String F(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
String str = null;
?? aC = y.aC(UedApplicaionData.ProductId);
if (aC == 0) {
return UedApplicaionData.ProductId;
}
try {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
cursor = null;
s.e(Tag, "getProductId出错");
return cursor == null ? null : null;
} catch (Throwable th) {
aC = 0;
th = th;
if (aC != 0 && !aC.isClosed()) {
aC.close();
}
throw th;
}
}
cursor = sQLiteDatabase.rawQuery("select * from product_info limit 1", null);
if (cursor != null) {
try {
if (cursor.getCount() > 0) {
cursor.moveToFirst();
str = cursor.getString(cursor.getColumnIndex("productId"));
}
} catch (Exception e2) {
s.e(Tag, "getProductId出错");
if (cursor == null && !cursor.isClosed()) {
cursor.close();
return null;
}
}
}
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
UedApplicaionData.ProductId = str;
return str;
} catch (Throwable th2) {
th = th2;
}
}
public static String G(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
String str = null;
?? aC = y.aC(UedApplicaionData.PublicKey);
if (aC == 0) {
return UedApplicaionData.PublicKey;
}
try {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
cursor = null;
s.e(Tag, "getPublicKey出错");
if (cursor != null) {
cursor.close();
}
UedApplicaionData.PublicKey = str;
return str;
} catch (Throwable th) {
aC = 0;
th = th;
if (aC != 0 && !aC.isClosed()) {
aC.close();
}
throw th;
}
}
cursor = sQLiteDatabase.rawQuery("select * from product_info limit 1", null);
if (cursor != null) {
try {
if (cursor.getCount() > 0) {
cursor.moveToFirst();
str = cursor.getString(cursor.getColumnIndex("publicKey"));
}
} catch (Exception e2) {
s.e(Tag, "getPublicKey出错");
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
UedApplicaionData.PublicKey = str;
return str;
}
}
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
UedApplicaionData.PublicKey = str;
return str;
} catch (Throwable th2) {
th = th2;
}
}
public static void a(Context context, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "deleteTrafficinfoown出错");
return;
}
}
s.e(Tag, "删除trafficinfoown老数据");
sQLiteDatabase.execSQL("delete from trafficinfoown_cache where insertTime < datetime('now','-7 day') ");
}
public static void a(Context context, com.cn21.ued.apm.b.a.b bVar, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Throwable th;
Cursor cursor2 = null;
if (bVar == null || y.isEmpty(bVar.y()) || y.isEmpty(bVar.z())) {
return;
}
try {
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getWritableDatabase();
} catch (Throwable th2) {
cursor = null;
th = th2;
if (cursor == null) {
throw th;
}
if (cursor.isClosed()) {
throw th;
}
cursor.close();
throw th;
}
} catch (Exception e) {
s.e(Tag, "saveApmUser出错");
if (0 == 0 || cursor2.isClosed()) {
return;
}
cursor2.close();
return;
}
}
cursor2 = sQLiteDatabase.rawQuery("select * from user", null);
if (cursor2.getCount() == 0 && bVar != null && !y.isEmpty(bVar.y()) && !y.isEmpty(bVar.z())) {
sQLiteDatabase.execSQL("insert into user values(?,?,?,?)", new String[]{bVar.A(), bVar.B(), bVar.y(), bVar.z()});
}
if (cursor2 == null || cursor2.isClosed()) {
return;
}
cursor2.close();
} catch (Throwable th3) {
cursor = cursor2;
th = th3;
}
}
public static void a(Context context, String str, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "insertPackageRecord出错");
return;
}
}
sQLiteDatabase.execSQL("insert into package_cache values(datetime('now','localtime'),?)", new String[]{str});
s.e("数据", new StringBuilder(String.valueOf(str)).toString());
}
public static void a(Context context, String str, String str2, SQLiteDatabase sQLiteDatabase) {
try {
j.l(context).getReadableDatabase().execSQL("insert into page_info(pageMark,status) values(?,?)", new String[]{str, str2});
} catch (Exception e) {
s.e(Tag, "insertSSRecord出错");
}
}
public static void b(Context context, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "deleteFpsown出错");
return;
}
}
s.e(Tag, "删除Fpsown老数据");
sQLiteDatabase.execSQL("delete from fpsown_cache where insertTime < datetime('now','-7 day') ");
}
public static void b(Context context, String str, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "insertUbueownRecord出错");
return;
}
}
sQLiteDatabase.execSQL("insert into ubueown_cache values(datetime('now','localtime'),?)", new String[]{str});
}
public static void b(Context context, String str, String str2, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "insertProductRecord出错");
return;
}
}
sQLiteDatabase.execSQL("insert into product_info(productId,publicKey) values(?,?)", new String[]{str, str2});
}
public static void c(Context context, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "deleteUbueown出错");
return;
}
}
s.e(Tag, "删除Ubueown老数据");
sQLiteDatabase.execSQL("delete from ubueown_cache where insertTime < datetime('now','-7 day') ");
}
public static void c(Context context, String str, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "insertTrafficInfoownRecord出错");
return;
}
}
sQLiteDatabase.execSQL("insert into trafficinfoown_cache values(datetime('now','localtime'),?)", new String[]{str});
}
public static void d(Context context, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "deleteHttpown出错");
return;
}
}
s.e(Tag, "删除http own老数据");
sQLiteDatabase.execSQL("delete from httpown_cache where insertTime < datetime('now','-7 day') ");
}
public static void d(Context context, String str, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "insertFpsownRecord出错");
return;
}
}
sQLiteDatabase.execSQL("insert into fpsown_cache values(datetime('now','localtime'),?)", new String[]{str});
}
public static void e(Context context, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "deleteBlockown出错");
return;
}
}
s.e(Tag, "删除http own老数据");
sQLiteDatabase.execSQL("delete from blockown_cache where insertTime < datetime('now','-7 day') ");
}
public static void e(Context context, String str, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "insertblockownRecord出错");
return;
}
}
sQLiteDatabase.execSQL("insert into blockown_cache values(datetime('now','localtime'),?)", new String[]{str});
}
public static void f(Context context, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "deleteCustomown出错");
return;
}
}
s.e(Tag, "删除Customown老数据");
sQLiteDatabase.execSQL("delete from customeventown_cache where insertTime < datetime('now','-7 day') ");
}
public static void f(Context context, String str, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "insertHttpownRecord出错");
return;
}
}
sQLiteDatabase.execSQL("insert into httpown_cache values(datetime('now','localtime'),?)", new String[]{str});
}
public static void g(Context context, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "deleteUBRecord出错");
return;
}
}
s.e(Tag, "删除UB老数据");
sQLiteDatabase.execSQL("delete from ub_cache where insertTime < datetime('now','-7 day') ");
}
public static void g(Context context, String str, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "insertCustomeventownRecord出错");
return;
}
}
sQLiteDatabase.execSQL("insert into customeventown_cache values(datetime('now','localtime'),?)", new String[]{str});
}
public static void h(Context context, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "deleteUERecord出错");
return;
}
}
s.e(Tag, "删除UE老数据");
sQLiteDatabase.execSQL("delete from ue_cache where insertTime < datetime('now','-7 day') ");
}
public static void h(Context context, String str, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "insertNetworkRecord出错");
return;
}
}
sQLiteDatabase.execSQL("insert into network_cache values(datetime('now','localtime'),?)", new String[]{str});
}
public static void i(Context context, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "deleteHTTPRecord出错");
return;
}
}
s.e(Tag, "删除http老数据");
sQLiteDatabase.execSQL("delete from http_cache where insertTime < datetime('now','-7 day') ");
}
public static void i(Context context, String str, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "updateCommon出错");
return;
}
}
sQLiteDatabase.execSQL("delete from common_cache");
sQLiteDatabase.execSQL("insert into common_cache values(datetime('now','localtime'),?)", new String[]{str});
}
public static void j(Context context, SQLiteDatabase sQLiteDatabase) {
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
s.e(Tag, "deleteCUSTOMRecord出错");
return;
}
}
s.e(Tag, "删除CUSTOM老数据");
sQLiteDatabase.execSQL("delete from customevent_cache where insertTime < datetime('now','-7 day') ");
}
public static boolean j(Context context, String str, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Cursor cursor2 = null;
try {
try {
Cursor rawQuery = j.l(context).getReadableDatabase().rawQuery("select * from page_info where pageMark = ?", new String[]{str});
if (rawQuery != null) {
try {
if (rawQuery.getCount() > 0) {
if (rawQuery == null || rawQuery.isClosed()) {
return true;
}
rawQuery.close();
return true;
}
} catch (Exception e) {
cursor = rawQuery;
try {
s.e(Tag, "IsPMRecord出错");
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return false;
} catch (Throwable th) {
cursor2 = cursor;
th = th;
if (cursor2 != null) {
cursor2.close();
}
throw th;
}
}
}
if (rawQuery != null && !rawQuery.isClosed()) {
rawQuery.close();
}
return false;
} catch (Throwable th2) {
th = th2;
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
throw th;
}
} catch (Exception e2) {
cursor = null;
}
}
private static String k(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Throwable th;
String str;
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
cursor = null;
s.e(Tag, "selectCommonRecord出错");
return cursor == null ? null : null;
} catch (Throwable th2) {
cursor = null;
th = th2;
if (cursor != null) {
cursor.close();
}
throw th;
}
}
cursor = sQLiteDatabase.rawQuery("select * from common_cache", null);
try {
try {
if (cursor.getCount() == 1) {
cursor.moveToFirst();
if (y.aC(UedApplicaionData.sid)) {
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
}
str = cursor.getString(cursor.getColumnIndex("insertData"));
} else {
str = "";
}
if (cursor == null || cursor.isClosed()) {
return str;
}
cursor.close();
return str;
} catch (Exception e2) {
s.e(Tag, "selectCommonRecord出错");
if (cursor == null && !cursor.isClosed()) {
cursor.close();
return null;
}
}
} catch (Throwable th3) {
th = th3;
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
throw th;
}
}
public static String l(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Cursor cursor2 = null;
s.e(Tag, "查询 数据库 trafficinfoown_cache own数据。");
String str = "";
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th) {
th = th;
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
throw th;
}
} catch (Exception e) {
cursor = null;
try {
s.e(Tag, "查询 数据库 trafficinfoown_cache 数据出错");
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
} catch (Throwable th2) {
cursor2 = cursor;
th = th2;
if (cursor2 != null) {
cursor2.close();
}
throw th;
}
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from trafficinfoown_cache limit 20", null);
try {
rawQuery.moveToFirst();
s.e(Tag, "trafficinfoown_cache 数据库共有数据" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
if (y.aC(UedApplicaionData.sid)) {
if (rawQuery != null && !rawQuery.isClosed()) {
rawQuery.close();
}
return "";
}
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
str = sb.toString().substring(0, sb.toString().length() - 2);
}
for (int i = 0; i < rawQuery.getCount(); i++) {
s.e(Tag, "删除 trafficinfoown_cache 数据库数据，共" + rawQuery.getCount() + "条数据，这是第" + i + "条数据；");
sQLiteDatabase.execSQL("delete from trafficinfoown_cache where insertTime in (select insertTime from trafficinfoown_cache limit 1) and insertData in (select insertData from trafficinfoown_cache limit 1)");
}
if (rawQuery == null || rawQuery.isClosed()) {
return str;
}
rawQuery.close();
return str;
} catch (Exception e2) {
cursor = rawQuery;
s.e(Tag, "查询 数据库 trafficinfoown_cache 数据出错");
if (cursor != null) {
cursor.close();
}
return "";
}
}
public static String m(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Cursor cursor2 = null;
s.e(Tag, "查询 数据库 fps own数据。");
String str = "";
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th) {
th = th;
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
throw th;
}
} catch (Exception e) {
cursor = null;
try {
s.e(Tag, "查询 数据库 fps own数据出错");
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
} catch (Throwable th2) {
cursor2 = cursor;
th = th2;
if (cursor2 != null) {
cursor2.close();
}
throw th;
}
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from fpsown_cache limit 20", null);
try {
rawQuery.moveToFirst();
s.e(Tag, "FPS own 数据库共有数据" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
if (y.aC(UedApplicaionData.sid)) {
if (rawQuery != null && !rawQuery.isClosed()) {
rawQuery.close();
}
return "";
}
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
str = sb.toString().substring(0, sb.toString().length() - 2);
}
for (int i = 0; i < rawQuery.getCount(); i++) {
s.e(Tag, "删除 fpsown_cache 数据库数据，共" + rawQuery.getCount() + "条数据，这是第" + i + "条数据；");
sQLiteDatabase.execSQL("delete from fpsown_cache where insertTime in (select insertTime from fpsown_cache limit 1) and insertData in (select insertData from fpsown_cache limit 1)");
}
if (rawQuery == null || rawQuery.isClosed()) {
return str;
}
rawQuery.close();
return str;
} catch (Exception e2) {
cursor = rawQuery;
s.e(Tag, "查询 数据库 fps own数据出错");
if (cursor != null) {
cursor.close();
}
return "";
}
}
public static boolean m(Context context) {
try {
String F = F(context, null);
String G = G(context, null);
if (y.aC(F)) {
return false;
}
return !y.aC(G);
} catch (Exception e) {
return false;
}
}
public static String n(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Cursor cursor2 = null;
s.e(Tag, "查询 数据库 ubue own数据。");
String str = "";
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th) {
th = th;
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
throw th;
}
} catch (Exception e) {
cursor = null;
try {
s.e(Tag, "查询 数据库 ubue own数据出错");
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
} catch (Throwable th2) {
cursor2 = cursor;
th = th2;
if (cursor2 != null) {
cursor2.close();
}
throw th;
}
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from ubueown_cache limit 20", null);
try {
rawQuery.moveToFirst();
s.e(Tag, "UBUE own 数据库共有数据" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
if (y.aC(UedApplicaionData.sid)) {
if (rawQuery != null && !rawQuery.isClosed()) {
rawQuery.close();
}
return "";
}
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
str = sb.toString().substring(0, sb.toString().length() - 2);
}
for (int i = 0; i < rawQuery.getCount(); i++) {
s.e(Tag, "删除 ubueown_cache 数据库数据，共" + rawQuery.getCount() + "条数据，这是第" + i + "条数据；");
sQLiteDatabase.execSQL("delete from ubueown_cache where insertTime in (select insertTime from ubueown_cache limit 1) and insertData in (select insertData from ubueown_cache limit 1)");
}
if (rawQuery == null || rawQuery.isClosed()) {
return str;
}
rawQuery.close();
return str;
} catch (Exception e2) {
cursor = rawQuery;
s.e(Tag, "查询 数据库 ubue own数据出错");
if (cursor != null) {
cursor.close();
}
return "";
}
}
private static String o(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Throwable th;
String str;
Cursor cursor2 = null;
s.e(Tag, "查询 数据库 trafficinfo own数据。");
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
try {
s.e(Tag, "查询 数据库 rafficinfo own数据出错");
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
return "";
} catch (Throwable th2) {
cursor = cursor2;
th = th2;
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
throw th;
}
} catch (Throwable th3) {
cursor = null;
th = th3;
if (cursor != null) {
cursor.close();
}
throw th;
}
}
cursor = sQLiteDatabase.rawQuery("select * from trafficinfoown_cache", null);
try {
cursor.moveToFirst();
s.e(Tag, "trafficinfo own 数据库共有数据" + cursor.getCount() + "条");
if (cursor.isAfterLast()) {
str = "";
} else {
if (y.aC(UedApplicaionData.sid)) {
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
}
StringBuilder sb = new StringBuilder();
do {
sb.append(cursor.getString(1)).append("\n");
cursor.moveToNext();
} while (!cursor.isAfterLast());
str = sb.toString().substring(0, sb.toString().length() - 2);
}
sQLiteDatabase.execSQL("delete from trafficinfoown_cache");
if (cursor == null || cursor.isClosed()) {
return str;
}
cursor.close();
return str;
} catch (Exception e2) {
cursor2 = cursor;
s.e(Tag, "查询 数据库 rafficinfo own数据出错");
if (cursor2 != null) {
cursor2.close();
}
return "";
} catch (Throwable th4) {
th = th4;
if (cursor != null) {
}
throw th;
}
}
private static String p(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Throwable th;
String str;
Cursor cursor2 = null;
s.e(Tag, "查询 数据库 fps own数据。");
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
try {
s.e(Tag, "查询 数据库 fps own数据出错");
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
return "";
} catch (Throwable th2) {
cursor = cursor2;
th = th2;
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
throw th;
}
} catch (Throwable th3) {
cursor = null;
th = th3;
if (cursor != null) {
cursor.close();
}
throw th;
}
}
cursor = sQLiteDatabase.rawQuery("select * from fpsown_cache", null);
try {
cursor.moveToFirst();
s.e(Tag, "fps own 数据库共有数据" + cursor.getCount() + "条");
if (cursor.isAfterLast()) {
str = "";
} else {
if (y.aC(UedApplicaionData.sid)) {
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
}
StringBuilder sb = new StringBuilder();
do {
sb.append(cursor.getString(1)).append("\n\n");
cursor.moveToNext();
} while (!cursor.isAfterLast());
str = sb.toString().substring(0, sb.toString().length() - 2);
}
sQLiteDatabase.execSQL("delete from fpsown_cache");
if (cursor == null || cursor.isClosed()) {
return str;
}
cursor.close();
return str;
} catch (Exception e2) {
cursor2 = cursor;
s.e(Tag, "查询 数据库 fps own数据出错");
if (cursor2 != null) {
cursor2.close();
}
return "";
} catch (Throwable th4) {
th = th4;
if (cursor != null) {
}
throw th;
}
}
private static String q(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Throwable th;
String str;
Cursor cursor2 = null;
s.e(Tag, "查询 数据库 ubue own数据。");
if (sQLiteDatabase == null) {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Exception e) {
try {
s.e(Tag, "查询 数据库 ubue own数据出错");
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
return "";
} catch (Throwable th2) {
cursor = cursor2;
th = th2;
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
throw th;
}
} catch (Throwable th3) {
cursor = null;
th = th3;
if (cursor != null) {
cursor.close();
}
throw th;
}
}
cursor = sQLiteDatabase.rawQuery("select * from ubueown_cache", null);
try {
cursor.moveToFirst();
s.e(Tag, "UBUE own 数据库共有数据" + cursor.getCount() + "条");
if (cursor.isAfterLast()) {
str = "";
} else {
if (y.aC(UedApplicaionData.sid)) {
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
}
StringBuilder sb = new StringBuilder();
do {
sb.append(cursor.getString(1)).append("\n\n");
cursor.moveToNext();
} while (!cursor.isAfterLast());
str = sb.toString().substring(0, sb.toString().length() - 2);
}
sQLiteDatabase.execSQL("delete from ubueown_cache");
if (cursor == null || cursor.isClosed()) {
return str;
}
cursor.close();
return str;
} catch (Exception e2) {
cursor2 = cursor;
s.e(Tag, "查询 数据库 ubue own数据出错");
if (cursor2 != null) {
cursor2.close();
}
return "";
} catch (Throwable th4) {
th = th4;
if (cursor != null) {
}
throw th;
}
}
public static String r(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Cursor cursor2 = null;
s.e(Tag, "查询 数据库 httpown_cache own数据。");
String str = "";
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th) {
th = th;
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
throw th;
}
} catch (Exception e) {
cursor = null;
try {
s.e(Tag, "查询 数据库 httpown own数据出错");
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
} catch (Throwable th2) {
cursor2 = cursor;
th = th2;
if (cursor2 != null) {
cursor2.close();
}
throw th;
}
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from httpown_cache limit 20", null);
try {
rawQuery.moveToFirst();
s.e(Tag, "httpown own 数据库共有数据" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
if (y.aC(UedApplicaionData.sid)) {
if (rawQuery != null && !rawQuery.isClosed()) {
rawQuery.close();
}
return "";
}
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
str = sb.toString().substring(0, sb.toString().length() - 2);
}
for (int i = 0; i < rawQuery.getCount(); i++) {
s.e(Tag, "删除 httpown_cache 数据库数据，共" + rawQuery.getCount() + "条数据，这是第" + i + "条数据；");
sQLiteDatabase.execSQL("delete from httpown_cache where insertTime in (select insertTime from httpown_cache limit 1) and insertData in (select insertData from httpown_cache limit 1)");
}
if (rawQuery == null || rawQuery.isClosed()) {
return str;
}
rawQuery.close();
return str;
} catch (Exception e2) {
cursor = rawQuery;
s.e(Tag, "查询 数据库 httpown own数据出错");
if (cursor != null) {
cursor.close();
}
return "";
}
}
public static String s(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Cursor cursor2 = null;
s.e(Tag, "查询 数据库 blockown_cache own数据。");
String str = "";
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th) {
th = th;
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
throw th;
}
} catch (Exception e) {
cursor = null;
try {
s.e(Tag, "查询 数据库 blockown own数据出错");
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
} catch (Throwable th2) {
cursor2 = cursor;
th = th2;
if (cursor2 != null) {
cursor2.close();
}
throw th;
}
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from blockown_cache limit 20", null);
try {
rawQuery.moveToFirst();
s.e(Tag, "blockown own 数据库共有数据" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
if (y.aC(UedApplicaionData.sid)) {
if (rawQuery != null && !rawQuery.isClosed()) {
rawQuery.close();
}
return "";
}
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
str = sb.toString().substring(0, sb.toString().length() - 2);
}
for (int i = 0; i < rawQuery.getCount(); i++) {
s.e(Tag, "删除 blockown_cache 数据库数据，共" + rawQuery.getCount() + "条数据，这是第" + i + "条数据；");
sQLiteDatabase.execSQL("delete from blockown_cache where insertTime in (select insertTime from blockown_cache limit 1) and insertData in (select insertData from blockown_cache limit 1)");
}
if (rawQuery == null || rawQuery.isClosed()) {
return str;
}
rawQuery.close();
return str;
} catch (Exception e2) {
cursor = rawQuery;
s.e(Tag, "查询 数据库 blockown own数据出错");
if (cursor != null) {
cursor.close();
}
return "";
}
}
private static String t(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Cursor cursor2 = null;
s.e(Tag, "查询 数据库 httpown_cache own数据。");
String str = "";
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th) {
th = th;
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
throw th;
}
} catch (Exception e) {
cursor = null;
try {
s.e(Tag, "查询 数据库 httpown own数据出错");
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
} catch (Throwable th2) {
cursor2 = cursor;
th = th2;
if (cursor2 != null) {
cursor2.close();
}
throw th;
}
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from httpown_cache", null);
try {
rawQuery.moveToFirst();
s.e(Tag, "httpown own 数据库共有数据" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
if (y.aC(UedApplicaionData.sid)) {
if (rawQuery != null && !rawQuery.isClosed()) {
rawQuery.close();
}
return "";
}
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
str = sb.toString().substring(0, sb.toString().length() - 2);
}
for (int i = 0; i < rawQuery.getCount(); i++) {
s.e(Tag, "删除 httpown_cache 数据库数据，共" + rawQuery.getCount() + "条数据，这是第" + i + "条数据；");
sQLiteDatabase.execSQL("delete from httpown_cache where insertTime in (select insertTime from httpown_cache limit 1) and insertData in (select insertData from httpown_cache limit 1)");
}
if (rawQuery == null || rawQuery.isClosed()) {
return str;
}
rawQuery.close();
return str;
} catch (Exception e2) {
cursor = rawQuery;
s.e(Tag, "查询 数据库 httpown own数据出错");
if (cursor != null) {
cursor.close();
}
return "";
}
}
private static String u(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Cursor cursor2 = null;
s.e(Tag, "查询 数据库 blockown_cache own数据。");
String str = "";
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th) {
th = th;
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
throw th;
}
} catch (Exception e) {
cursor = null;
try {
s.e(Tag, "查询 数据库 blockown own数据出错");
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
} catch (Throwable th2) {
cursor2 = cursor;
th = th2;
if (cursor2 != null) {
cursor2.close();
}
throw th;
}
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from blockown_cache", null);
try {
rawQuery.moveToFirst();
s.e(Tag, "blockown own 数据库共有数据" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
if (y.aC(UedApplicaionData.sid)) {
if (rawQuery != null && !rawQuery.isClosed()) {
rawQuery.close();
}
return "";
}
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
str = sb.toString().substring(0, sb.toString().length() - 2);
}
for (int i = 0; i < rawQuery.getCount(); i++) {
s.e(Tag, "删除 blockown_cache 数据库数据，共" + rawQuery.getCount() + "条数据，这是第" + i + "条数据；");
sQLiteDatabase.execSQL("delete from blockown_cache where insertTime in (select insertTime from blockown_cache limit 1) and insertData in (select insertData from blockown_cache limit 1)");
}
if (rawQuery == null || rawQuery.isClosed()) {
return str;
}
rawQuery.close();
return str;
} catch (Exception e2) {
cursor = rawQuery;
s.e(Tag, "查询 数据库 blockown own数据出错");
if (cursor != null) {
cursor.close();
}
return "";
}
}
public static String v(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Cursor cursor2 = null;
s.e(Tag, "查询 数据库 customevent own数据。");
String str = "";
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th) {
th = th;
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
throw th;
}
} catch (Exception e) {
cursor = null;
try {
s.e(Tag, "查询 数据库 customevent own数据出错");
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
} catch (Throwable th2) {
cursor2 = cursor;
th = th2;
if (cursor2 != null) {
cursor2.close();
}
throw th;
}
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from customeventown_cache limit 20", null);
try {
rawQuery.moveToFirst();
s.e(Tag, "customevent own 数据库共有数据" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
if (y.aC(UedApplicaionData.sid)) {
if (rawQuery != null && !rawQuery.isClosed()) {
rawQuery.close();
}
return "";
}
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
str = sb.toString().substring(0, sb.toString().length() - 2);
}
for (int i = 0; i < rawQuery.getCount(); i++) {
s.e(Tag, "删除 customeventown_cache 数据库数据，共" + rawQuery.getCount() + "条数据，这是第" + i + "条数据；");
sQLiteDatabase.execSQL("delete from customeventown_cache where insertTime in (select insertTime from customeventown_cache limit 1) and insertData in (select insertData from customeventown_cache limit 1)");
}
if (rawQuery == null || rawQuery.isClosed()) {
return str;
}
rawQuery.close();
return str;
} catch (Exception e2) {
cursor = rawQuery;
s.e(Tag, "查询 数据库 customevent own数据出错");
if (cursor != null) {
cursor.close();
}
return "";
}
}
private static String w(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Cursor cursor2 = null;
s.e(Tag, "查询 数据库 customevent own数据。");
String str = "";
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th) {
th = th;
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
throw th;
}
} catch (Exception e) {
cursor = null;
try {
s.e(Tag, "查询 数据库 customevent own数据出错");
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
} catch (Throwable th2) {
cursor2 = cursor;
th = th2;
if (cursor2 != null) {
cursor2.close();
}
throw th;
}
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from customeventown_cache", null);
try {
rawQuery.moveToFirst();
s.e(Tag, "customevent own 数据库共有数据" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
if (y.aC(UedApplicaionData.sid)) {
if (rawQuery != null && !rawQuery.isClosed()) {
rawQuery.close();
}
return "";
}
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
str = sb.toString().substring(0, sb.toString().length() - 2);
}
for (int i = 0; i < rawQuery.getCount(); i++) {
s.e(Tag, "删除 customeventown_cache 数据库数据，共" + rawQuery.getCount() + "条数据，这是第" + i + "条数据；");
sQLiteDatabase.execSQL("delete from customeventown_cache where insertTime in (select insertTime from customeventown_cache limit 1) and insertData in (select insertData from customeventown_cache limit 1)");
}
if (rawQuery == null || rawQuery.isClosed()) {
return str;
}
rawQuery.close();
return str;
} catch (Exception e2) {
cursor = rawQuery;
s.e(Tag, "查询 数据库 customevent own数据出错");
if (cursor != null) {
cursor.close();
}
return "";
}
}
public static String x(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Cursor cursor2 = null;
s.e(Tag, "查询 数据库 Network own数据。");
String str = "";
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th) {
th = th;
if (cursor2 != null && !cursor2.isClosed()) {
cursor2.close();
}
throw th;
}
} catch (Exception e) {
cursor = null;
try {
s.e(Tag, "查询 数据库 network own数据出错");
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return "";
} catch (Throwable th2) {
cursor2 = cursor;
th = th2;
if (cursor2 != null) {
cursor2.close();
}
throw th;
}
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from network_cache limit 20", null);
try {
rawQuery.moveToFirst();
s.e(Tag, "network own 数据库共有数据" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
if (y.aC(UedApplicaionData.sid)) {
if (rawQuery != null && !rawQuery.isClosed()) {
rawQuery.close();
}
return "";
}
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
str = sb.toString().substring(0, sb.toString().length() - 2);
}
for (int i = 0; i < rawQuery.getCount(); i++) {
s.e(Tag, "删除 network_cache 数据库数据，共" + rawQuery.getCount() + "条数据，这是第" + i + "条数据；");
sQLiteDatabase.execSQL("delete from network_cache where insertTime in (select insertTime from network_cache limit 1) and insertData in (select insertData from network_cache limit 1)");
}
if (rawQuery == null || rawQuery.isClosed()) {
return str;
}
rawQuery.close();
return str;
} catch (Exception e2) {
cursor = rawQuery;
s.e(Tag, "查询 数据库 network own数据出错");
if (cursor != null) {
cursor.close();
}
return "";
}
}
public static void y(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Throwable th;
Cursor cursor2 = null;
s.e(Tag, "发送 数据库 UB数据。");
try {
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th2) {
cursor = null;
th = th2;
if (cursor == null) {
throw th;
}
if (cursor.isClosed()) {
throw th;
}
cursor.close();
throw th;
}
} catch (Exception e) {
s.e(Tag, "uploadAllUBRecord出错");
if (0 == 0 || cursor2.isClosed()) {
return;
}
cursor2.close();
return;
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from ub_cache limit 20", null);
rawQuery.moveToFirst();
s.e(Tag, "UB 数据库共有数据" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
if (y.aC(UedApplicaionData.sid)) {
if (rawQuery == null || rawQuery.isClosed()) {
return;
}
rawQuery.close();
return;
}
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
String f = com.cn21.ued.apm.b.a.b.f(com.cn21.ued.apm.b.a.b.d(sb.toString().substring(0, sb.toString().length() - 1), UedApplicaionData.key));
s.e(Tag, "ub db :" + f);
String a = com.cn21.ued.apm.b.a.b.a("http://ux.21cn.com/api/appReportRest/userBehavior", System.currentTimeMillis(), f, F(context, sQLiteDatabase), 2, 1, G(context, sQLiteDatabase), UedApplicaionData.UB_VERSION);
s.e(Tag, "ub db rep:" + a);
if (!y.aC(a)) {
JSONObject jSONObject = new JSONObject(a);
int a2 = y.a(String.valueOf(jSONObject.getInt("code")), -5);
if (a2 == -1) {
UedApplicaionData.isStart = true;
UedApplicaionData.sid = "";
if (rawQuery == null || rawQuery.isClosed()) {
return;
}
rawQuery.close();
return;
}
if (a2 == 0) {
UedApplicaionData.key = y.f(jSONObject.getString(IConstant.VoiceRecognition.EXTRA_KEY), "");
}
for (int i = 0; i < rawQuery.getCount(); i++) {
s.e(Tag, "删除 UB数据库数据，共" + rawQuery.getCount() + "条数据，这是第" + i + "条数据；");
sQLiteDatabase.execSQL("delete from ub_cache where insertTime in (select insertTime from ub_cache limit 1) and insertData in (select insertData from ub_cache limit 1)");
}
}
}
if (rawQuery == null || rawQuery.isClosed()) {
return;
}
rawQuery.close();
} catch (Throwable th3) {
cursor = null;
th = th3;
}
}
public static void z(Context context, SQLiteDatabase sQLiteDatabase) {
Cursor cursor;
Throwable th;
Cursor cursor2 = null;
s.e(Tag, "发送数据库Http数据。");
try {
if (sQLiteDatabase == null) {
try {
try {
sQLiteDatabase = j.l(context).getReadableDatabase();
} catch (Throwable th2) {
cursor = null;
th = th2;
if (cursor == null) {
throw th;
}
if (cursor.isClosed()) {
throw th;
}
cursor.close();
throw th;
}
} catch (Exception e) {
s.e(Tag, "uploadAllUHttpReportRecord出错");
if (0 == 0 || cursor2.isClosed()) {
return;
}
cursor2.close();
return;
}
}
Cursor rawQuery = sQLiteDatabase.rawQuery("select * from http_cache limit 20", null);
rawQuery.moveToFirst();
s.e(Tag, "http 数据库共有数据：" + rawQuery.getCount() + "条");
if (!rawQuery.isAfterLast()) {
s.e(Tag, "httpReport 数据库有数据，共" + rawQuery.getCount() + "条");
if (y.aC(UedApplicaionData.sid)) {
if (rawQuery == null || rawQuery.isClosed()) {
return;
}
rawQuery.close();
return;
}
StringBuilder sb = new StringBuilder();
do {
sb.append(rawQuery.getString(1)).append("\n");
rawQuery.moveToNext();
} while (!rawQuery.isAfterLast());
String f = com.cn21.ued.apm.b.a.b.f(com.cn21.ued.apm.b.a.b.d(sb.toString().substring(0, sb.toString().length() - 1), UedApplicaionData.key));
s.e(Tag, "http db :" + f);
String a = com.cn21.ued.apm.b.a.b.a("http://ux.21cn.com/api/appReportRest/httpRecord", System.currentTimeMillis(), f, F(context, sQLiteDatabase), 2, 1, G(context, sQLiteDatabase), UedApplicaionData.HTTP_VERSION);
s.e(Tag, "http db rep :" + a);
s.e(Tag, "httpReport rep :" + a);
if (!y.aC(a)) {
JSONObject jSONObject = new JSONObject(a);
int a2 = y.a(String.valueOf(jSONObject.getInt("code")), -5);
if (a2 == -1) {
UedApplicaionData.isStart = true;
UedApplicaionData.sid = "";
if (rawQuery == null || rawQuery.isClosed()) {
return;
}
rawQuery.close();
return;
}
if (a2 == 0) {
UedApplicaionData.key = y.f(jSONObject.getString(IConstant.VoiceRecognition.EXTRA_KEY), "");
}
for (int i = 0; i < rawQuery.getCount(); i++) {
s.e(Tag, "删除 UHttpReport数据库数据，共" + rawQuery.getCount() + "条数据，这是第" + i + "条数据；");
sQLiteDatabase.execSQL("delete from http_cache where insertTime in (select insertTime from http_cache limit 1) and insertData in (select insertData from http_cache limit 1)");
}
}
}
if (rawQuery == null || rawQuery.isClosed()) {
return;
}
rawQuery.close();
} catch (Throwable th3) {
cursor = null;
th = th3;
}
}
}