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;
        }

 

posted on 2014-05-23 20:37  冰幻孤影  阅读(1567)  评论(0编辑  收藏  举报