完整版Android试验报告基于SQLite的通信录

1、第一次实验Android界面设计.实验目的及实验环境1.实验目的1掌握 SQUteOpenHelper类结构2掌握基于SQLite数据库的应用开发过程3掌握Content Provider发布数据的方法4掌握Content Resolver获取数据的方法2.实验环境系统开发平 Android Studio 3.0系统开发平台：Android 7.1运行平台： Windows10 x64运行环境：Microsoft.NET Framework SDK 2.0二.实验教材、组织方式、实验内容1 .实验教材：Andorid开发与应用2 .组织方式：个人独立完成3 .实验内容：实现基于SQLite数据

2、库的通信录应用,通过单击增加图标翻开添加通信录 界面,通过单击通信录中的各条信息可删除选中项.二.万案设计Android系统中集成了 SQLite数据库,并且为数据库的操作提供了相关的类 和方法,便于没有数据库开发经验的开发者编写程序.另外,Android平台中利用Content Provider机制来实现跨应用程序数据共享.一个应用程序可以通过 Content Provider来发布自己的数据,其他的应用程序可以通过Content Resolver来获取共享数据.姓名陈锐所属组电.Q 5:45向通信录：姓名陈述属拒同事朋友同学可捷Q 5:47而通信录：姓名陈锐 15

3、80912nd 所愿组保存5 .总结通过这次实验掌握了 SQLite OpenHelper类结构,掌握了基于SQUte数据库 的应用开发过程以及Content Provider发布数据的方法和掌握 Content Resolve战 取数据的方法.6 .附录：源代码主布局文件 activity_main.xml :LinearLayoutxmlns:android = :schemas.android /apk/res/androidListViewandroid:id =+id/listViewandroid:layout_width android:layout_height=wrap_co

4、ntent=wrap_contentandroid:onClick =add /添加联系人布局文件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

5、_content=wrap_contentandroid: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.

6、Bundle;import android.view.Menu;import android.view.Menultem;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(Bund

7、le savedlnstanceState) super .onCreate(savedlnstanceState);setContentView(R.layout. activity_main );listView = (ListView) findViewById(R.id. listView );/ getRelationFromDB();private void getRelationFromDB() final DatabaseHelper dbHelper = new DatabaseHelper( this );String from = Cursor cursor = dbHe

8、lper.query();_id , name, 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.OnItemClick

9、Listener()public void onItemClick(AdapterView adapter, View view, int position, long id) final long temp = id;AlertDialog.Builder adBuilder = new AlertDialog.Builder( MainActivity. this );adBuilder.setMessage(确认要删除记录吗).setPositiveButton(确认,newDialogInterface.OnClickListener() Overridepublic void onC

10、lick(DialogInterface dialog,int which) / TODOAuto-generated method stub dbHelper.del( int ) temp);Cursor cursor = dbHelper.query();String from = _id , name, tel groupName ;int to = R.id. _id , R.id. name R.id. tel , R.id. group ;SimpleCursorAdapter scadapter = new SimpleCursorAdapter ( _getApplicati

11、onContext(),R.layout. relationlist , 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();)

12、； dbHelper.close();)public 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 (

13、requestCode = 0x111 & resultCode = 0x111) getRelationFromDB();) ) Override public 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(Me

14、nuItem item) / Handle action bar 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(it

15、em); ) )添加联系人 AddrelationActivity.javaimport 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.w

16、idget.Spinner;public class AddrelationActivity 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

17、= (EditText) findViewById(R.id.addTel);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.getSelectedIte

18、m().toString();final DatabaseHelper dbHelper = new DatabaseHelper( getApplicationContext();final AlertDialog.Builder adBuilder = new AlertDialog.Builder(this);adBuilder.setMessage(确认保存记录吗).setPositiveButton( 确认,newDialogInterface.OnClickListener() Overridepublic void onClick(DialogInterface dialog, int which) / TODO Auto-generated method stub dbHelpe