具体代码如下:(判断deviceinfo表是否存在)
public boolean isTableExists(SQLiteDatabase db) {
String sql = "select count(*) as c from sqlite_master where type ='table' and name ='DeviceInfo';";
cursor = db.rawQuery(sql, null);
if (cursor.moveToNext()) {
int count = cursor.getInt(0);
if (count > 0) {
result = true;
}
}
return result;
}