Scribd
Upload
9 views3 pages

Database Adapter for Book Titles

This document defines a class called DBAdapter that provides methods for creating and interacting with a SQLite database of book titles. It defines constants for column names and the database/table names. The DBHelper class handles database creation and upgrades. Methods are provided to open/close the database connection, insert/delete/update/query titles.

Uploaded by

mugavanest
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views3 pages

Database Adapter for Book Titles

This document defines a class called DBAdapter that provides methods for creating and interacting with a SQLite database of book titles. It defines constants for column names and the database/table names. The DBHelper class handles database creation and upgrades. Methods are provided to open/close the database connection, insert/delete/update/query titles.

Uploaded by

mugavanest
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

public static final String KEY_ROWID = "_id"; public static final String KEY_ISBN = "isbn"; public static final

String KEY_TITLE = "title"; public static final String KEY_PUBLISHER = "publisher"; private static final String TAG = "DBAdapter"; private static final String DATABASE_NAME = "books"; private static final String DATABASE_TABLE = "titles"; private static final int DATABASE_VERSION = 1; private static final String DATABASE_CREATE = "create table titles (_id integer primary key autoincrement, " + "isbn text not null, title text not null, " + "publisher text not null);"; private final Context context; private DatabaseHelper DBHelper; private SQLiteDatabase db; public DBAdapter(Context ctx) { [Link] = ctx; DBHelper = new DatabaseHelper(context); } private static class DatabaseHelper extends SQLiteOpenHelper { DatabaseHelper(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); } @Override public void onCreate(SQLiteDatabase db) { [Link](DATABASE_CREATE); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { Log.w(TAG, "Upgrading database from version " + oldVersion + " to " + newVersion + ", which will destroy all old data"); [Link]("DROP TABLE IF EXISTS titles"); onCreate(db); } } //---opens the database--public DBAdapter open() throws SQLException { db = [Link](); return this; }

//---closes the database--public void close() { [Link](); } //---insert a title into the database--public long insertTitle(String isbn, String title, String publisher) { ContentValues initialValues = new ContentValues(); [Link](KEY_ISBN, isbn); [Link](KEY_TITLE, title); [Link](KEY_PUBLISHER, publisher); return [Link](DATABASE_TABLE, null, initialValues); } //---deletes a particular title--public boolean deleteTitle(long rowId) { return [Link](DATABASE_TABLE, KEY_ROWID + "=" + rowId, null) > 0; } //---retrieves all the titles--public Cursor getAllTitles() { return [Link](DATABASE_TABLE, new String[] { KEY_ROWID, KEY_ISBN, KEY_TITLE, KEY_PUBLISHER}, null, null, null, null, null); } //---retrieves a particular title--public Cursor getTitle(long rowId) throws SQLException { Cursor mCursor = [Link](true, DATABASE_TABLE, new String[] { KEY_ROWID, KEY_ISBN, KEY_TITLE, KEY_PUBLISHER }, KEY_ROWID + "=" + rowId, null, null, null, null, null); if (mCursor != null) { [Link]();

} return mCursor; } //---updates a title--public boolean updateTitle(long rowId, String isbn, String title, String publisher) { ContentValues args = new ContentValues(); [Link](KEY_ISBN, isbn); [Link](KEY_TITLE, title); [Link](KEY_PUBLISHER, publisher); return [Link](DATABASE_TABLE, args, KEY_ROWID + "=" + rowId, null) > 0; }

You might also like