80,337
社区成员
发帖
与我相关
我的任务
分享
public static SQLiteDatabase dbInstance;
private MyDBHelper myDBHelper;
public void openDatabase()
{
if(dbInstance == null)
{
myDBHelper = new MyDBHelper(context,"contact",4);
dbInstance = myDBHelper.getWritableDatabase();
}
}
//MyDBHelper类定义如下
class MyDBHelper extends SQLiteOpenHelper
{
public MyDBHelper(Context context, String name,int version)
{
super(context, name, null, version);
}
@Override
public void onCreate(SQLiteDatabase db)
{
tableCreate = new StringBuffer();
tableCreate.append("create table ")
.append(DB_TABLENAME)
.append(" (")
.append("_id integer primary key autoincrement,")
.append("name text,")
.append(")");
System.out.println(tableCreate.toString());
db.execSQL(tableCreate.toString());
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, intnewVersion)
{
String sql = "drop table if exists " + DB_TABLENAME;
db.execSQL(sql);
myDBHelper.onCreate(db);
}
}