public class Dbhelper extends SQLiteOpenHelper {
public static final String name = "myname.db";
public static final int version = 1;
//创建数据库
public Dbhelper(Context context) {
super(context, name, null, version);
}
//创建表
@Override
public void onCreate(SQLiteDatabase arg0) {
// TODO Auto-generated method stub
arg0.execSQL("create table diary"+"("+"_idinteger primary key autoincrement,"+"topic varchar(100),"+"content varchar(1000)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
// 删除表
db.execSQL("drop table if exists diary");
// 创建表
onCreate(db);
}
}
继承SQLiteOpenHelper创建库增加表和删除表
最新推荐文章于 2023-06-27 00:11:19 发布