private boolean tabbleIsExist(String tableName, SQLiteDatabase db) { LogUtils.d("DatabaseHelper", "checking tabbleIsExist " + tableName); boolean result = false; if (tableName == null) { return false; } Cursor cursor = null; try { String sql = "select count(*) as c from sqlite_master where type =‘table‘ and name =‘" + tableName.trim() + "‘ "; cursor = db.rawQuery(sql, null); if (cursor.moveToNext()) { int count = cursor.getInt(0); if (count > 0) { result = true; } } } catch (Exception e) { LogUtils.e("DatabaseHelper", "error in tabbleIsExist:" + e.toString()); } LogUtils.d("DatabaseHelper", "checking tabbleIsExist " + tableName + " " + result); return result; }
android在sqlite数据库的SQLiteOpenHelper中的onUpgrade里判断表是否存在,布布扣,bubuko.com