个人通讯录（一）开发数据库的辅助类

package com.xxg.personal;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteDatabase.CursorFactory;import android.database.sqlite.SQLiteOpenHelper;public class MyOpenHelper extends SQLiteOpenHelper{public static final String DB_NAME="personal_contacts";//数据库名称public static final String ID="_id";public static final String TABLE_NAME="contacts";public static final String NAME="name";public static final String PHONE="phone";public static final String MOBILE="mobile";public static final String EMAIL="email";public static final String POST="post";public static final String ADDR="addr";public static final String COMP="comp";public MyOpenHelper(Context context, String name, CursorFactory factory,int version) {super(context, name, factory, version); //调用父类// TODO Auto-generated constructor stub}@Overridepublic void onCreate(SQLiteDatabase db) {// TODO Auto-generated method stubdb.execSQL("create table if not exists" + TABLE_NAME + "("    + ID + " integer primary key ,"    + NAME + " varchar ,"    + PHONE + " varchar ,"    + MOBILE + " varchar ,"    + EMAIL + " varchar ,"    + POST + " varchar ,"    + ADDR + " varchar ,"    + COMP + " varchar )");}@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersoin) {// TODO Auto-generated method stub}}