import android.util. Log ;
public class DBAdapter
{
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;
}
DATABASE_CREATE 常量包括创建 titles 表的 SQL 语句。
在 DBAdapter 类中,你可以扩展 SQLiteOpenHelper 类,它是一个 Android 辅助类,主
要用于数据库创建和版本管理。 实际上,你可以覆盖 onCreate()和 onUpgrade()方法, 如清单
2 所示。
清单 2 在 DBAdapter 类中,扩展 SQLiteOpenHelper 类覆盖 onCreate() 和 onUpgrade()
方法
package net.learn2develop. Database ;
import android.content.ContentValues;
import android.content.Context;
import android. database . Cursor ;
import android. database .SQLException;
import android. database .sqlite.SQLiteDatabase;
import android. database .sqlite.SQLiteOpenHelper;
import android.util. Log ;
public class DBAdapter
{
public static final String KEY_ROWID = "_id";
评论0
最新资源