如何在android中使用SQLite？ [英] How do I use SQLite in android?

问题描述

我已经为这个主题找到了一些答案（例如这个 ），但它不起作用。我只收到警告，它无法解析方法'openOrCreateDatabase（java.lang.String，int，null）'。

I've founde already a few answers to this topic (for example this), but it is not working. I only get the warning, that it cannot resolve the method 'openOrCreateDatabase(java.lang.String, int, null)'.

这是我的源代码：

public class DBHandler
{
    SQLiteDatabase database;
    DBHandler()
    {
        database = openOrCreateDatabase("DatabaseName", Context.MODE_PRIVATE, null);
    }
}

推荐答案

< a href =http://developer.android.com/intl/es/reference/android/database/sqlite/package-summary.html\"rel =noreferrer> SQLite 是一个开源SQL数据库，用于存储数据到设备上的文本文件。 Android带有内置的SQLite数据库实现。

SQLite is a opensource SQL database that stores data to a text file on a device. Android comes in with built in SQLite database implementation.

请查看以下链接

1. Android SQLite数据库教程

SQLite数据库教程

SQLite和Android

结构

 public class MySQLiteHelper extends SQLiteOpenHelper {

  public static final String TABLE_COMMENTS = "comments";
  public static final String COLUMN_ID = "_id";
  public static final String COLUMN_COMMENT = "comment";

  private static final String DATABASE_NAME = "commments.db";
  private static final int DATABASE_VERSION = 1;

  // Database creation sql statement
  private static final String DATABASE_CREATE = "create table "
      + TABLE_COMMENTS + "(" + COLUMN_ID
      + " integer primary key autoincrement, " + COLUMN_COMMENT
      + " text not null);";

  public MySQLiteHelper(Context context) {
    super(context, DATABASE_NAME, null, DATABASE_VERSION);
  }

  @Override
  public void onCreate(SQLiteDatabase database) {
    database.execSQL(DATABASE_CREATE);
  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    Log.w(MySQLiteHelper.class.getName(),
        "Upgrading database from version " + oldVersion + " to "
            + newVersion + ", which will destroy all old data");
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_COMMENTS);
    onCreate(db);
  }

} 

这篇关于如何在android中使用SQLite？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！