dbhelper.java

来自「android项目实战 7个经典的例子」· Java 代码 · 共 37 行

package com.yarin.android.MyContacts;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper extends SQLiteOpenHelper
{
	public static final String DATABASE_NAME = "mycontacts.db";//数据库名
	public static final int DATABASE_VERSION = 2;				 //版本
	public static final String CONTACTS_TABLE = "contacts";	 //表名
	//创建表
	private static final String DATABASE_CREATE = 
		"CREATE TABLE " + CONTACTS_TABLE +" ("					
		+ ContactColumn._ID+" integer primary key autoincrement,"
		+ ContactColumn.NAME+" text,"
		+ ContactColumn.MOBILENUM+" text,"
		+ ContactColumn.HOMENUM+" text,"
		+ ContactColumn.ADDRESS+" text,"
		+ ContactColumn.EMAIL+" text,"
		+ ContactColumn.BLOG+" text);";
	public DBHelper(Context context)
	{
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
	}
	public void onCreate(SQLiteDatabase db)
	{
		db.execSQL(DATABASE_CREATE);
	}
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
	{
		db.execSQL("DROP TABLE IF EXISTS " + CONTACTS_TABLE);
		onCreate(db);
	}
}