|
DBHelper.java
[java]
view plain
copy
- packagecom.example.sqlitedemo.db;
-
- importandroid.content.Context;
- importandroid.database.SQLException;
- importandroid.database.sqlite.SQLiteDatabase;
- importandroid.database.sqlite.SQLiteOpenHelper;
-
- publicclassDBHelperextendsSQLiteOpenHelper{
-
-
- */
- privatestaticfinalStringDATABASE_NAME="test.db";
- /**
- *数据库版本
- */
- finalintDATABASE_VERSION=1;
- *表格名称
- finalStringTABLE_NAME="profile";
- *列表一，_ID，自动增加
- finalStringCOLUMN_ID="_id";
- *列表二，名称
- finalStringCOLUMN_NAME="name";
- publicDBHelper(Contextcontext){
- super(context,DATABASE_NAME,null,DATABASE_VERSION);
- }
- @Override
- voidonCreate(SQLiteDatabasedb)throwsSQLException{
- //创建表格
- db.execSQL("CREATETABLEIFNOTEXISTS"+TABLE_NAME+"("+COLUMN_ID+"INTEGERPRIMARYKEYAUTOINCREMENT,"+COLUMN_NAME+"VARCHARNOTNULL);");
- }
- voidonUpgrade(SQLiteDatabasedb,153); background-color:inherit; font-weight:bold">intoldVersion,153); background-color:inherit; font-weight:bold">intnewVersion)//删除并创建表格
- db.execSQL("DROPTABLEIFEXISTS"+TABLE_NAME+";");
- onCreate(db);
- }
MainActivity.java
copy
packagecom.example.sqlitedemo;
importandroid.app.ListActivity;
importandroid.content.ContentValues;
importandroid.database.Cursor;
importandroid.os.Bundle;
importandroid.view.Menu;
importandroid.widget.SimpleCursorAdapter;
importcom.example.sqlitedemo.db.DBHelper;
classMainActivityextendsListActivity{
privateDBHelperhelper=null;
privateSQLiteDatabasedb=null;
privateSimpleCursorAdapteradapter=privateCursormCursor=voidonCreate(BundlesavedInstanceState){
super.onCreate(savedInstanceState);
initData();
initAdapter();
voidinitData(){
//获取数据库
helper=newDBHelper(this);
db=helper.getReadableDatabase();
//插入数据
try{
insert("zhangsan");
insert("lisi");
insert("wangwu");
insert("chenliu");
}catch(SQLExceptione){
e.printStackTrace();
voidinitAdapter(){
//查询表格，并获得Cursor
mCursor=db.query(DBHelper.TABLE_NAME,newString[]{DBHelper.COLUMN_ID,DBHelper.COLUMN_NAME},153); background-color:inherit; font-weight:bold">null);
//设置adapter
adapter=newSimpleCursorAdapter(this,android.R.layout.simple_list_item_2,mCursor,153); background-color:inherit; font-weight:bold">newint[]{android.R.id.text1,android.R.id.text2});
setListAdapter(adapter);
voidinsert(Stringname) ContentValuesvalues=newContentValues();
values.put(DBHelper.COLUMN_NAME,name);
db.insertOrThrow(DBHelper.TABLE_NAME,values);
@Override
booleanonCreateOptionsMenu(Menumenu){
getMenuInflater().inflate(R.menu.activity_main,menu);
returntrue;
}
预览效果：
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
