XuDaojie

    /**
     * 检查表是否已存在
     */
    public static boolean tableExist(SQLiteDatabase db) {
        // 查询表是否存在
        String sql = "select count(*) " +
                "from sqlite_master where type='table' and name = '" + TABLE_NAME +"'";
        Cursor cursor = db.rawQuery(sql, null);

        return cursor.getInt(0) == 0;