实训:模拟手机通讯录联系人功能
package com.qf.day43_02;
import android.app.Activity;
import android.app.AlertDialog;
import android.content.DialogInterface;
import android.content.DialogInterface.OnClickListener;
import android.content.Intent;
import android.database.Cursor;
import android.net.Uri;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.AdapterView.OnItemLongClickListener;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import com.qf.day43_02.db.DBService;
public class MainActivity extends Activity {
private ListView lv;
private DBService dbService;
private Cursor c;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
lv = (ListView) findViewById(R.id.lv1);
dbService = new DBService(this);
lv.setOnItemClickListener(new OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> parent, View view,
int position, long id) {
long phonenum = 0 ;
Intent intent = new Intent();
intent.setAction(Intent.ACTION_DIAL);
if (c.moveToPosition(position)) {
phonenum = c.getLong(2);
}
intent.setData(Uri.parse("tel:"+phonenum));
startActivity(intent);
}
});
lv.setOnItemLongClickListener(new OnItemLongClickListener() {
@Override
public boolean onItemLongClick(AdapterView<?> parent, View view,
final int position, long id) {
// TODO Auto-generated method stub
AlertDialog.Builder builder = new AlertDialog.Builder(MainActivity.this);
builder.setIcon(R.drawable.ic_launcher);
builder.setTitle("请选择你的操作");
builder.setItems(new String[]{"编辑联系人","删除联系人"}, new OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
// TODO Auto-generated method stub
final Intent intent = new Intent(MainActivity.this,EditActivity.class);
switch (which) {
case 0:
if (c.moveToPosition(position)) {
int id = c.getInt(0);
String name = c.getString(1);
long phonenun = c.getLong(2);
intent.putExtra("id", id);
intent.putExtra("name", name);
intent.putExtra("phonenum", phonenun);
intent.putExtra("isAdd", false);
startActivity(intent);
}
break;
case 1:
AlertDialog.Builder builder2 = new AlertDialog.Builder(MainActivity.this);
builder2.setIcon(R.drawable.ic_launcher);
builder2.setTitle("提示");
builder2.setMessage("您确定要删除此联系人吗?");
builder2.setNegativeButton("取消", null);
builder2.setPositiveButton("确定", new OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
// TODO Auto-generated method stub
if (c.moveToPosition(position)) {
int id = c.getInt(0);
dbService.delete(id);
setListAdapter();
}
}
});
builder2.show();
break;
}
}
});
builder.show();
return false;
}
});
}
@Override
protected void onResume() {
// TODO Auto-generated method stub
super.onResume();
setListAdapter();
}
private void setListAdapter() {
c = dbService.getInfo();
SimpleCursorAdapter adapter = new SimpleCursorAdapter(MainActivity.this, R.layout.lv, c, new String[]{"name","phonenum"}, new int[]{R.id.name,R.id.phonenum}, SimpleCursorAdapter.FLAG_REGISTER_CONTENT_OBSERVER);
lv.setAdapter(adapter);
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// TODO Auto-generated method stub
getMenuInflater().inflate(R.menu.main, menu);
return super.onCreateOptionsMenu(menu);
}
@Override
public boolean onMenuItemSelected(int featureId, MenuItem item) {
// TODO Auto-generated method stub
switch (item.getItemId()) {
case R.id.addUser:
Intent intent = new Intent(MainActivity.this,EditActivity.class);
intent.putExtra("isAdd", true);
startActivity(intent);
break;
}
return super.onMenuItemSelected(featureId, item);
}
}
package com.qf.day43_02;
import com.qf.day43_02.db.DBService;
import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.widget.EditText;
public class EditActivity extends Activity {
private EditText et1,et2;
private boolean isAdd;
private DBService dbService;
private int id;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_edit);
et1 = (EditText) findViewById(R.id.et1);
et2 = (EditText) findViewById(R.id.et2);
dbService = new DBService(this);
Intent intent = getIntent();
isAdd = intent.getBooleanExtra("isAdd", true);
if (isAdd) {
setTitle("添加联系人");
}else {
String name = intent.getStringExtra("name");
long phonenum = intent.getLongExtra("phonenum", 0);
et1.setText(name);
et2.setText(phonenum+"");
id = intent.getIntExtra("id", 0);
setTitle("更改联系人");
}
}
public void submit(View v){
String name = et1.getText().toString().trim();
String phonenum = et2.getText().toString().trim();
if (isAdd) {
dbService.insert(name,phonenum);
}else {
dbService.update(id, name, phonenum);
}
finish();
}
}
package com.qf.day43_02.db;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DBOpenHelper extends SQLiteOpenHelper{
/**
* 初始数据库的必要参数
* @param context 上下文对象
* @param name 数据库名
* @param factory 游标工厂 null
* @param version 版本信息
*/
public DBOpenHelper(Context context) {
super(context, "calllist", null, 1);
// TODO Auto-generated constructor stub
}
/**
* 创建数据库的时候会执行 创建初始的数据表
* 第一次创建数据库的时候会调用
*/
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("create table if not exists numlist(_id integer primary key autoincrement,name text,phonenum long)");
db.execSQL("insert into numlist(name,phonenum) values('张三',153110120)");
db.execSQL("insert into numlist(name,phonenum) values('张三1',153110121)");
db.execSQL("insert into numlist(name,phonenum) values('张三2',153110122)");
}
/**
* 更新数据库
* 如果数据库的版本号发生变化,系统会执行此方法
*
*/
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
package com.qf.day43_02.db;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
public class DBService {
private Context context;
private DBOpenHelper dbOpenHelper;
public DBService(Context context) {
super();
this.context = context;
dbOpenHelper = new DBOpenHelper(context);
}
public Cursor getInfo(){
SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
Cursor cursor = db.rawQuery("select * from numlist",null);
return cursor;
}
public void insert(String name, String phonenum) {
SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("name", name);
values.put("phonenum", Long.valueOf(phonenum));
db.insert("numlist", null, values);
}
public void update(int id,String name, String phonenum) {
SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("name", name);
values.put("phonenum", Long.valueOf(phonenum));
db.update("numlist", values, "_id="+id, null);
}
public void delete(int id) {
// TODO Auto-generated method stub
SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
db.delete("numlist", "_id="+id, null);
}
}