以下是一个读取SQLite数据库的范例代码:
public class MyDatabaseHelper extends SQLiteOpenHelper {
public static final String CREATE_BOOK = "create table Book ("
+ "id integer primary key autoincrement, "
+ "author text, "
+ "price real, "
+ "pages integer, "
+ "name text)";
private Context mContext;
public MyDatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
mContext = context;
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(CREATE_BOOK);
Toast.makeText(mContext, "Create successed", Toast.LENGTH_SHORT).show();
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
读取数据的代码:
public ArrayList getBook() {
ArrayList list = new ArrayList<>();
SQLiteDatabase db = mHelper.getWritableDatabase();
Cursor cursor = db.query("Book", null, null, null, null, null, null);
if (cursor.moveToFirst()) {
do {
Book book = new Book();
book.setId(cursor.getInt(cursor.getColumnIndex("id")));
book.setAuthor(cursor.getString(cursor.getColumnIndex("author")));
book.setName(cursor.getString(cursor.getColumnIndex("name")));
book.setPages(cursor.getInt(cursor.getColumnIndex("pages")));
book.setPrice(cursor.getFloat(cursor.getColumnIndex("price")));
list.add(book);
} while (cursor.moveToNext());
}
cursor.close();
return list;
}