本文将带你了解Android应用开发之Android开发判断SQLite数据库中某个表是否存在,希望本文对大家学Android有所帮助。
直接上方法:
Java代码 public boolean tabIsExist(SQLiteDatabase db){ boolean result = false; if(yourTableName == null){ return false; } Cursor cursor = null; try { String sql = "select count(*) as c from sqlite_master where type ='table' and name ='"+yourTableName.trim()+"' "; cursor = db.rawQuery(sql, null); if(cursor.moveToNext()){ int count = cursor.getInt(0); if(count>0){ result = true; } } } catch (Exception e) { } return result; } public boolean tabIsExist(SQLiteDatabase db){
boolean result = false;
if(yourTableName == null){
return false;
}
Cursor cursor = null;
try {
String sql = "select count(*) as c from sqlite_master where type ='table' and name ='"+yourTableName.trim()+"' ";
cursor = db.rawQuery(sql, null);
if(cursor.moveToNext()){
int count = cursor.getInt(0);
if(count>0){
result = true;
}
}
} catch (Exception e) {
}
return result;
}
本文由职坐标整理并发布,希望对同学们有所帮助。了解更多详情请关注职坐标移动开发之Android频道!