Android 数据库 SQLiteOpenHelper

2019-11-18 分类：Android开发阅读(3262) 评论(0)

publicclassDbOpenHelperextendsSQLiteOpenHelper{privatestaticStringname=”test.db”;/*数据库名称*/privatestaticintversion=1;/*数据库版本号*/publicDbOpenHelper(Contextcontext){super(context,name,null,version);//TODOAuto-generatedconstructorstub}
@OverridepublicvoidonCreate(SQLiteDatabasedb){//TODOAuto-generatedmethodstubStringsql=”createtableperson(idintegerprimarykeyautoincrement,namevarchar(64))”;
db.execSQL(sql);
}
@OverridepublicvoidonUpgrade(SQLiteDatabasedb,intoldVersion,intnewVersion){//TODOAuto-generatedmethodstub}
}
privateButtonbutton;
@OverrideprotectedvoidonCreate(BundlesavedInstanceState){super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
button=(Button)this.findViewById(R.id.button);
button.setOnClickListener(newView.OnClickListener(){
@OverridepublicvoidonClick(Viewv){//TODOAuto-generatedmethodstubDbOpenHelperdbOpenHelper=newDbOpenHelper(MainActivity.this);
dbOpenHelper.getWritableDatabase();
}
});
}