(完整word版)Android實(shí)驗(yàn)報(bào)告_基于SQLite的通信錄

1、第一次實(shí)驗(yàn)Android界面設(shè)計(jì).實(shí)驗(yàn)?zāi)康募皩?shí)驗(yàn)環(huán)境1.實(shí)驗(yàn)?zāi)康?）掌握 SQLiteOpenHelper類結(jié)構(gòu)2）掌握基于SQLite數(shù)據(jù)庫(kù)的應(yīng)用開(kāi)發(fā)過(guò)程3）掌握Content Provider發(fā)布數(shù)據(jù)的方法4）掌握Content Resolver獲取數(shù)據(jù)的方法2.實(shí)驗(yàn)環(huán)境系統(tǒng)開(kāi)發(fā)平 Android Studio 3.0系統(tǒng)開(kāi)發(fā)平臺(tái)：Android 7.1運(yùn)行平臺(tái)： Windows10 x64運(yùn)行環(huán)境：Microsoft.NET Framework SDK 2.0二.實(shí)驗(yàn)教材、組織方式、實(shí)驗(yàn)內(nèi)容1 .實(shí)驗(yàn)教材：Andorid開(kāi)發(fā)與應(yīng)用2 .組織方式：個(gè)人獨(dú)立完成3 .實(shí)驗(yàn)內(nèi)容：實(shí)現(xiàn)基于SQL

2、ite數(shù)據(jù)庫(kù)的通信錄應(yīng)用，通過(guò)單擊增加圖標(biāo)打開(kāi)添加通信錄 界面，通過(guò)單擊通信錄中的各條信息可刪除選中項(xiàng)。二.萬(wàn)案設(shè)計(jì)Android系統(tǒng)中集成了 SQLite數(shù)據(jù)庫(kù)，并且為數(shù)據(jù)庫(kù)的操作提供了相關(guān)的類 和方法，便于沒(méi)有數(shù)據(jù)庫(kù)開(kāi)發(fā)經(jīng)驗(yàn)的開(kāi)發(fā)者編寫(xiě)程序。另外，Android平臺(tái)中利用Content Provider機(jī)制來(lái)實(shí)現(xiàn)跨應(yīng)用程序數(shù)據(jù)共享。一個(gè)應(yīng)用程序可以通過(guò) Content Provider來(lái)發(fā)布自己的數(shù)據(jù)，其他的應(yīng)用程序可以通過(guò)Content Resolver來(lái)獲取共享數(shù)據(jù)。姓名陳銳所屬組電.Q 5:45向通信錄：姓名陳說(shuō)電屬拒同事朋友同學(xué)可捷Q 5:47而通信錄：姓

3、名陳銳電話1580912nd 所愿組保存5 .總結(jié)通過(guò)這次實(shí)驗(yàn)掌握了 SQLite OpenHelper類結(jié)構(gòu)，掌握了基于SQLite數(shù)據(jù)庫(kù) 的應(yīng)用開(kāi)發(fā)過(guò)程以及Content Provider發(fā)布數(shù)據(jù)的方法和掌握 Content Resolve戰(zhàn) 取數(shù)據(jù)的方法。6 .附錄：源代碼主布局文件 activity_main.xml :LinearLayoutxmlns:android =ListViewandroid:id =+id/listViewandroid:layout_width android:layout_height=wrap_content=wrap_contentandroid:

4、onClick =add /添加聯(lián)系人布局文件addrelation.xml EditTextandroid:id =+id/addNameandroid:layout_width android:layout_heightTextViewandroid:layout_width android:layout_height android:text = 電話 =wrap_content=wrap_content/android:id =+id/addTelandroid:layout_width android:layout_height=wrap_content=wrap_contentan

5、droid:text = 所屬組 /主 Activity 文件 MainActivity.java :import android.support.v7.app.ActionBarActivity;import android.app.AlertDialog;import android.app.Application;import android.content.DialogInterface;import android.content.Intent;import android.database.Cursor;import android.os.Bundle;import android

6、.view.Menu;import android.view.MenuItem;import android.view.View;import android.widget.AdapterView;import android.widget.ListView;import android.widget.SimpleCursorAdapter;public class MainActivity extends ActionBarActivity private ListView listView ;protected void onCreate(Bundle savedInstanceState

7、) super .onCreate(savedInstanceState);setContentView(R.layout. activity_main );listView = (ListView) findViewById(R.id. listView );/ getRelationFromDB();private void getRelationFromDB() final DatabaseHelper dbHelper = new DatabaseHelper( this );Cursor cursor = dbHelper.query();String from = _id , na

8、me, tel , groupName ;int to = R.id. _id , R.id. name R.id. tel , R.id. group ; SimpleCursorAdapter scadapter = new SimpleCursorAdapter( this , R.layout. relationlist , cursor, from, to);listView .setAdapter(scadapter);listView .setOnItemClickListener( new AdapterView.OnItemClickListener()public void

9、 onItemClick(AdapterView adapter, View view, int position, long id) final long temp = id;AlertDialog.Builder adBuilder =new AlertDialog.Builder(MainActivity. this );adBuilder.setMessage(確認(rèn)要?jiǎng)h除記錄嗎？).setPositiveButton(確認(rèn)，newDialogInterface.OnClickListener() Overridepublic void onClick(DialogInterface d

10、ialog,int which) / TODOAuto-generated method stub dbHelper.del( int ) temp);Cursor cursor = dbHelper.query();String口from = _id , name, telgroupName ;int to = R.id. _id , R.id. name R.id. tel , R.id. group ;SimpleCursorAdapter scadapter = new SimpleCursorAdapter ( _getApplicationContext(),R.layout. r

11、elationlist , cursor, from, to);MainActivity. this . listView .setAdapter(scadapter); ) .setNegativeButton(取消， newDialogInterface.OnClickListener() Override public void onClick(DialogInterface dialog,int which) )；AlertDialog aleraDialog = adBuilder.create();aleraDialog.show();)； dbHelper.close();pub

12、lic void add(View view) Intent intent = newIntent(MainActivity. this , AddrelationActivity. class );startActivityForResult(intent, 0x111);protected void onActivityResult( int requestCode, int resultCode, Intent data) super .onActivityResult(requestCode, resultCode, data);if (requestCode = 0x111 & re

13、sultCode = 0x111) getRelationFromDB();Overridepublic boolean onCreateOptionsMenu(Menu menu) / Inflate the menu; this adds items to the action bar if it is present. getMenuInflater().inflate(R.menu.main, menu);return true ;Overridepublic boolean onOptionsItemSelected(MenuItem item) / Handle action ba

14、r item clicks here. The action bar will/ automatically handle clicks on the Home/Up button, so long/ as you specify a parent activity in AndroidM id = item.getItemId();if (id = R.id. action_settings ) return true ;return super .onOptionsItemSelected(item);添加聯(lián)系人AddrelationActivity.java

15、import android.app.Activity;import android.app.AlertDialog;import android.content.ContentValues;import android.content.DialogInterface;import android.content.Intent;import android.os.Bundle;import android.view.View;import android.widget.EditText;import android.widget.Spinner;public class Addrelation

16、Activity extends Activity private EditText addName, addTel;private Spinner addGroup;protected void onCreate(Bundle savedInstanceState) super.onCreate(savedInstanceState);setContentView(R.layout.addrelation);addName = (EditText) findViewById(R.id.addName);addTel = (EditText) findViewById(R.id.addTel)

17、;addGroup = (Spinner) findViewById(R.id.addGroup);public void save(View view) final ContentValues values = new ContentValues();values.put(name, addName.getText().toString();values.put(tel, addTel.getText().toString();values.put(groupName, addGroup.getSelectedItem().toString();final DatabaseHelper db

18、Helper = new DatabaseHelper( getApplicationContext();final AlertDialog.Builder adBuilder = new AlertDialog.Builder(this);adBuilder.setMessage( 確認(rèn)保存記錄嗎?).setPositiveButton( 確認(rèn) , newDialogInterface.OnClickListener() Overridepublic void onClick(DialogInterface dialog, int which) / TODO Auto-generated method stub dbHelper.i