Android 判斷資料庫中是否存在某個表

標籤：

public boolean tabIsExist(String tabName){            boolean result = false;            if(tabName == null){                    return false;            }            Cursor cursor = null;            try {                                       String sql = "select count(*) as c from sqlite_master where type =‘table‘ and name =‘"+tabName.trim()+"‘ ";                    cursor = dbInfo.rawQuery(sql, null);                    if(cursor.moveToNext()){                            int count = cursor.getInt(0);                            if(count>0){                                    result = true;                            }                    }                                } catch (Exception e) {                    // TODO: handle exception            }                            return result;    }  對sqlite_master表查詢不但可以得到建表的sql語句，還可以擷取該資料庫內的trigger資訊 而在純Java環境下對SQL資料庫查詢是否目標表格存在的時候可以更簡單： java.sql.Connection con = getYourConnection();    ResultSet rs = con.getMetaData().getTables(null, null, "yourTable", null );if (rs.next()) {//yourTable exist}else {//yourTable not exist}

 

Android 判斷資料庫中是否存在某個表