ListActivity+sqlite+SimpleCursorAdapter

DBHelper.java

[java]view plaincopy 
    
 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;
 }


 
 预览效果：
 

ListActivity+sqlite+SimpleCursorAdapter

相关文章