(完整word版)Android實驗報告-基于SQLite的通信錄

第一次實驗Android界面設(shè)計一.實驗?zāi)康募皩嶒灜h(huán)境1.實驗?zāi)康?）掌握SQLiteOpenHelper類結(jié)構(gòu)2）掌握基于SQLite數(shù)據(jù)庫的應(yīng)用開發(fā)過程3）掌握ContentProvider發(fā)布數(shù)據(jù)的方法4）掌握ContentResolver獲取數(shù)據(jù)的方法2.實驗環(huán)境系統(tǒng)開發(fā)平AndroidStudio3.0系統(tǒng)開發(fā)平臺：Android7.1運行平臺：Windows10x64運行環(huán)境：Microsoft.NETFrameworkSDK2.0二.實驗教材、組織方式、實驗內(nèi)容實驗教材：Andorid開發(fā)與應(yīng)用組織方式：個人獨立完成2.實驗內(nèi)容：實現(xiàn)基于SQLite數(shù)據(jù)庫的通信錄應(yīng)用，通過單擊增加圖標(biāo)打開添加通信錄界面，通過單擊通信錄中的各條信息可刪除選中項。三．方案設(shè)計Android系統(tǒng)中集成了SQLite數(shù)據(jù)庫，并且為數(shù)據(jù)庫的操作提供了相關(guān)的類和方法，便于沒有數(shù)據(jù)庫開發(fā)經(jīng)驗的開發(fā)者編寫程序。另外，Android平臺中利用ContentProvider機(jī)制來實現(xiàn)跨應(yīng)用程序數(shù)據(jù)共享。一個應(yīng)用程序可以通過ContentProvider來發(fā)布自己的數(shù)據(jù)，其他的應(yīng)用程序可以通過ContentResolver來獲取共享數(shù)據(jù)。

壯世1陳銳電話四?運行結(jié)果附曲裁MlQ曲裁MlQ5:31!@1通信錄:段唐友陳友

五．總結(jié)通過這次實驗掌握了SQLiteOpenHelper類結(jié)構(gòu)，掌握了基于SQLite數(shù)據(jù)庫的應(yīng)用開發(fā)過程以及ContentProvider發(fā)布數(shù)據(jù)的方法和掌握ContentResolver獲取數(shù)據(jù)的方法。六．附錄：源代碼主布局文件activity_main.xml：<LinearLayoutxmlns:android="/apk/res/android"<TextViewandroid:id="@+id/title"android:layout_width="wrap_content"android:layout_height="wrap_content"android:text二"通信錄"/><ListViewandroid:id="@+id/listView"android:layout_width="wrap_content"android:layout_height="wrap_content"></ListView><Buttonandroid:layout_width="wrap_content"android:layout_height="wrap_content"android:onClick="add"/></LinearLayout>添加聯(lián)系人布局文件addrelation.xml：<?xmlversion="1.0"encoding="utf-8"?><LinearLayoutxmlns:android="/apk/res/android"android:layout_width="match_parent"android:layout_height="match_parent"android:orientation="vertical"><TextViewandroid:layout_width="wrap_content"android:layout_height="wrap_content"android:text二"姓名"/><EditTextandroid:id="@+id/addName"android:layout_width="wrap_content"android:layout_height="wrap_content"/><TextViewandroid:layout_width="wrap_content"android:layout_height="wrap_content"android:text二"電話"/><EditTextandroid:id="@+id/addTel"android:layout_width="wrap_content"android:layout_height="wrap_content"/><TextViewandroid:layout_width="wrap_content"android:layout_height="wrap_content"android:text二"所屬組"/><Spinnerandroid:id="@+id/addGroup"android:layout_width="wrap_content"android:layout_height="wrap_content"android:entries="@array/test"></Spinner><Buttonandroid:id="@+id/save"android:layout_width="wrap_content"android:layout_height="wrap_content"android:layout_gravity="center"android:text="保存"/></LinearLayout>主Activity文件MainActivity.java：importandroid.support.v7.app.ActionBarActivity;importandroid.app.AlertDialog;importandroid.app.Application;importandroid.content.DialogInterface;importandroid.content.Intent;importandroid.database.Cursor;importandroid.os.Bundle;importandroid.view.Menu;importandroid.view.MenuItem;importandroid.view.View;importandroid.widget.AdapterView;importandroid.widget.ListView;importandroid.widget.SimpleCursorAdapter;publicclassMainActivityextendsActionBarActivity{privateListViewlistView;protectedvoidonCreate(BundlesavedInstanceState){super.onCreate(savedInstanceState);setContentView(R.layout.activity_mai);listView=(ListView)findViewById(R.id.listVie);//getRelationFromDB();}privatevoidgetRelationFromDB(){finalDatabaseHelperdbHelper=newDatabaseHelper(this);Cursorcursor=dbHelper.query();String[]from={"_id","name","tel","groupName"};int[]to={R.id._id,R.,R.id.tel,R.id.group};SimpleCursorAdapterscadapter=newSimpleCursorAdapter(this,;listView.setAdapter(scadapter);listView.setOnItemClickListener(newAdapterView.OnItemClickListener()publicvoidonItemClick(AdapterView<?>adapter,Viewview,intposition,longid){finallongtemp=id;AlertDialog.BuilderadBuilder=newAlertDialog.Builder(MainActivity.this);adBuilder.setMessage("確認(rèn)要刪除記錄嗎？").setPositiveButton("確認(rèn)"，newDialogInterface.OnClickListener(){@OverridepublicvoidonClick(DialogInterfacedialog，intwhich){//TODOAuto-generatedmethodstubdbHelper.del((int)temp);Cursorcursor=dbHelper.query();String[]from={"_id"，"name"，"tel"，"groupName"};int[]to={R.id._id，R.，R.id.tel，R.id.group};SimpleCursorAdapterscadapter=newSimpleCursorAdapter(getApplicationContext(),R.layout.relationlistcursor,;MainActivity.this.listView.setAdapter(scadapter);}}).setNegativeButton("取消"，newDialogInterface.OnClickListener(){@OverridepublicvoidonClick(DialogInterfacedialog,intwhich){

}});AlertDialogaleraDialog=adBuilder.create();aleraDialog.show();}});dbHelper.close();publicvoidadd(Viewview){Intentintent=newIntent(MainActivity.this,AddrelationActivity.class);startActivityForResult(intent,0x111);}protectedvoidonActivityResult(intrequestCode,intresultCode,Intentdata){super.onActivityResult(requestCode,resultCode,data);if(requestCode==0x111&&resultCode==0x111){getRelationFromDB();}}@OverridepublicbooleanonCreateOptionsMenu(Menumenu){//Inflatethemenu;thisaddsitemstotheactionbarifitispresent.getMenuInflater().inflate(R.menu.main,menu);returntrue;}@OverridepublicbooleanonOptionsItemSelected(MenuItemitem){//Handleactionbaritemclickshere.Theactionbarwill//automaticallyhandleclicksontheHome/Upbutton,solong//asyouspecifyaparentactivityinAndroidMid=item.getItemId();if(id==R.id.action_setting){returntrue;}returnsuper.onOptionsItemSelected(item);}}添加聯(lián)系人AddrelationActivity.javaimportandroid.app.Activity;importandroid.app.AlertDialog;importandroid.content.ContentValues;importandroid.content.DialogInterface;importandroid.content.Intent;importandroid.os.Bundle;importandroid.view.View;importandroid.widget.EditText;importandroid.widget.Spinner;publicclassAddrelationActivityextendsActivity{privateEditTextaddName,addTel;privateSpinneraddGroup;protectedvoidonCreate(BundlesavedInstanceState){super.onCreate(savedInstanceState);setContentView(R.layout.addrelation);addName=(EditText)findViewById(R.id.addName);addTel=(EditText)findViewById(R.id.addTel);addGroup=(Spinner)findViewById(R.id.addGroup);}publicvoidsave(Viewview){finalContentValuesvalues=newContentValues();values.put("name",addName.getText().toString());values.put("tel",addTel.getText().toString());values.put("groupName",addG