android平臺移動云計算開發(fā)所有課件璇10.sqlite

創(chuàng)建數(shù)據(jù)庫.importandroid.databaseimportandroid.database.import..

publicclassDBDaoextendsOpenHelper4個參數(shù):content表示上下文,那個activityactivity面factoryCorsor對象,也就是一個結果集,nullandroidpublicDBDao(Contextcontext,Stringname,CursorFactoryfactory,intversion){}publicvoidonCreate(Databasearg0)TODOAuto-generatedmethodstubStringsql="createtabledbTest(idint,namevarchar(20))";}publicvoidonUpgrade(Databasedb,intoldVersion,intnewVersion)//TODOAuto-generatedmethod}} 數(shù)據(jù)庫文件所在路徑為:data->data->com.example.->databases在這個文件夾下選擇數(shù)據(jù)庫文件,然后選擇從設備導出數(shù)據(jù),也就是那個磁盤圖標,保存到桌使用一款叫的軟件可以對數(shù)據(jù)庫進行操作importimportandroid.database.Cursor;.importandroid.database.importandroid.os.Bundle;import.

importandroid.widget.Button;publicclassMainActivityextendsActivity{privateButtonbutton01;privateButtonbutton02;privateButtonbutton03;privateButtonbutton04;privateButtonprotectedvoidonCreate(BundlesavedInstanceState){button01=(Button)findViewById(R.id.button01);button02=(Button)button03=(Button)findViewById(R.id.button03);button04=(Button)findViewById(R.id.button04);button05=(Button)}@authorclassButton01implementsOnClickListenerpublicvoidonClick(Viewarg0)//TODOAuto-generatedmethodDBDaodh=newDBDao(MainActivity.this,"test1",null,1);Databasedb=dh.getReadableDatabase();}}@authorclassButton02implementspublicvoidonClick(Viewv)//TODOAuto-generatedmethodDBDaodao=newDBDao(MainActivity.this,"test1",null,1);Databasedb=dao.getReadableDatabase();ContentValuesvalues=newContentValues();values.put("id",1);values.put("name","kitty");db.insert("dbTest",null,values);}}@authorclassButton03implementspublicvoidonClick(Viewv)//TODOAuto-generatedmethodDBDaodao=newDBDao(MainActivity.this,"test1",null,1);Databasedb=dao.getReadableDatabase();ContentValuesvalues=newContentValues();values.put("name","kaka");db.update("dbTest",values,"id=?",new}}@authorclassButton04implementspublicvoidonClick(Viewv)//TODOAuto-generatedmethodDBDaodao=newDBDao(MainActivity.this,"test1",null,1);Databasedb=dao.getReadableDatabase();db.delete("dbTest","name=?",new}}@authorclassButton05implementspublicvoidonClick(Viewv)//TODOAuto-generatedmethodDBDaodao=newDBDao(MainActivity.this,"test1",null,1);Databasedb=dao.getReadableDatabase();Cursorcursor=db.query("dbTest",newString[]{"id","name"},"id=?",newString[]{"1"},null,null,null);//注意:cursorResultSet,cursor.getColumnName表示//cursor.getColumnIndex("name")列}}}}ListView是負責顯示數(shù)據(jù)用的,一共顯示都少條是可控的,還有兩個是上一頁和下一頁按鈕,剩下的TextView當做隱藏域來使用,用來存放當前<LinearLayoutxmlns:android="http://s tools:context=".MainActivity">importandroid.content.Context;importandroid.database.importandroid.database.import

publicclassDBDaoextendsOpenHelperpublicDBDao(Contextcontext,Stringname,CursorFactoryfactory,intversion){}publicvoidonCreate(Databasedb)//TODOAuto-generatedmethodStringsql="createtabledatabase(idIntegerprimarykeyautoincrement,name}publicvoidonUpgrade(Databasedb,intoldVersion,intnewVersion)//TODOAuto-generatedmethod}publicvoidinitDatabase(Databasedb){ContentValuesvalues=newContentValues();for(inti=0;i<100;i++){values.put("name","kitty"+i);db.insert("database",null,values);}}}importjava.util.List;import.importandroid.database..importandroid.os.Bundle;import

importandroid.widget.ArrayAdapter;importimportandroid.widget.ListView;publicclassMainActivityextendsActivity{privateButtonincrementButton;privateButtonupButton;privateButtondownButton;privateListViewlistView;privateTextViewtext;privateintprotectedvoidonCreate(BundlesavedInstanceState){incrementButton=(Button)findViewById(R.id.incrementButton);upButton=(Button)findViewById(R.id.upPage);downButton=(Button)findViewById(R.id.downPage);listView=(ListView)findViewById(R.id.listView01);text=(TextView)findViewById(R.id.text);page=Integer.parseInt(text.getText().toString());if(page==}upButton.setOnClickListener(newClickButton());}*publicListgetListView(intindex,intend)DBDaodao=newDBDao(MainActivity.this,"database",null,1);Databasesd=dao.getWritableDatabase();Stringsql="select*fromdatabaselimit"+index+","+end+"";Cursorcursor=sd.rawQuery(sql,null);ListarrayList=newArrayList();while(cursor.moveToNext()){}return}publicvoidonClick(Viewarg0)//TODOAuto-generatedmethodDBDaodao=newDBDao(M