最新android实现一个简单的增删改查的数据库操作.doc

《最新android实现一个简单的增删改查的数据库操作.doc》由会员分享，可在线阅读，更多相关《最新android实现一个简单的增删改查的数据库操作.doc（15页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、精品资料android实现一个简单的增删改查的数据库操作.效果图package com.example.empmanager;import android.app.Activity;import android.content.Intent;import android.os.Bundle;import android.view.View;import android.view.View.OnClickListener;import android.widget.Button;import android.widget.EditText;import android.widget.Toast;

2、public class AddEmpActivity extends Activity private EditText empname,empno,empage,empsal;private Button save,clear;DBHelper helper=new DBHelper(this);MainActivity activity=new MainActivity();empInfo emp;protected void onCreate(Bundle savedInstanceState) / TODO Auto-generated method stubsuper.onCrea

3、te(savedInstanceState);setContentView(R.layout.add_emp);/初始化empname=(EditText) findViewById(R.id.empname);empno=(EditText) findViewById(R.id.empno);empage=(EditText) findViewById(R.id.empage);empsal=(EditText) findViewById(R.id.empsal);save=(Button) findViewById(R.id.save);clear=(Button) findViewByI

4、d(R.id.clear);save.setOnClickListener(new OnClickListener() public void onClick(View v) / TODO Auto-generated method stubString name=empname.getText().toString();String no=empno.getText().toString();String age=empage.getText().toString();String sal=empsal.getText().toString();if(name.length()0&no.le

5、ngth()0&age.length()0&sal.length()0)helper.insertEmp(name,no,age,sal);Toast.makeText(AddEmpActivity.this, 增加成功, 1000).show();Intent intent=new Intent(AddEmpActivity.this,MainActivity.class);startActivity(intent);elseToast.makeText(AddEmpActivity.this, 增加失败, 1000).show(););clear.setOnClickListener(ne

6、w OnClickListener() public void onClick(View v) / TODO Auto-generated method stubempname.setText();empno.setText();empage.setText();empsal.setText(););主活动页面package com.example.empmanager;import android.os.Bundle;import android.provider.ContactsContract.Data;import android.provider.ContactsContract.C

7、ommonDataKinds.Phone;import android.app.Activity;import android.app.AlertDialog;import android.app.AlertDialog.Builder;import android.app.ListActivity;import android.content.Context;import android.content.DialogInterface;import android.content.Intent;import android.database.Cursor;import android.vie

8、w.ContextMenu;import android.view.Menu;import android.view.MenuItem;import android.view.View;import android.view.ContextMenu.ContextMenuInfo;import android.view.View.OnClickListener;import android.widget.AdapterView;import android.widget.AdapterView.AdapterContextMenuInfo;import android.widget.Butto

9、n;import android.widget.CheckBox;import android.widget.ListView;import android.widget.RelativeLayout;import android.widget.SimpleAdapter;import android.widget.SimpleCursorAdapter;import android.widget.TextView;import android.widget.Toast;import android.widget.AdapterView.OnItemClickListener;public c

10、lass MainActivity extends Activity private Button insert,delete,update,select;private TextView show_name,show_no,show_age,show_sal;private ListView lv;DBHelper helper=new DBHelper(this);empInfo emp;Cursor cursor;public int _id;/private Boolean bool = false;private Menu myMenu;private Context context

11、;SimpleCursorAdapter adapter;protected void onCreate(Bundle savedInstanceState) super.onCreate(savedInstanceState);setContentView(R.layout.activity_main);/初始化控件insert=(Button) findViewById(R.id.insert);delete=(Button) findViewById(R.id.delete);update=(Button) findViewById(R.id.update);select=(Button

12、) findViewById(R.id.select);show_name=(TextView) findViewById(R.id.show_name);show_no=(TextView) findViewById(R.id.show_no);show_age=(TextView) findViewById(R.id.show_age);show_sal=(TextView) findViewById(R.id.show_sal);lv=(ListView) findViewById(R.id.lv);registerForContextMenu(lv);insert.setOnClick

13、Listener(listener);delete.setOnClickListener(listener);update.setOnClickListener(listener);select.setOnClickListener(listener);OnClickListener listener=new OnClickListener() public void onClick(View v) switch(v.getId()case R.id.insert:Intent intent=new Intent(MainActivity.this,AddEmpActivity.class);

14、startActivity(intent);break;case R.id.delete:break;case R.id.update:break;case R.id.select:select();break;/长按菜单public void onCreateContextMenu(ContextMenu menu, View v,ContextMenuInfo menuInfo) menu.setHeaderTitle(快捷操作);menu.add(Menu.NONE, 1, 1, 删除);menu.add(Menu.NONE, 2, 2, 修改);super.onCreateContex

15、tMenu(menu, v, menuInfo);/显示数据在listview上public void select()Cursor cursor=helper.getCursorScrollData();adapter=new SimpleCursorAdapter(MainActivity.this, R.layout.list_item, cursor, new Stringempname,empno,empage,empsal, new int R.id.show_name,R.id.show_no,R.id.show_age,R.id.show_sal);lv.setAdapter(

16、adapter); adapter.notifyDataSetChanged();/响应事件public boolean onContextItemSelected(MenuItem item) / TODO Auto-generated method stub/这样可以获取长按着弹出上下文菜单的LIstView点击的ID值AdapterView.AdapterContextMenuInfo menuInfo=(AdapterContextMenuInfo) item.getMenuInfo(); final int id=(int) menuInfo.id; if (-1 = id) sup

17、er.onContextItemSelected(item); switch(item.getItemId()case 1:Cursor cursor1 = (Cursor) lv.getItemAtPosition(menuInfo.position); cursor1.moveToPosition(menuInfo.position); _id=cursor1.getInt(0);Builder builder=new Builder(MainActivity.this);builder.setMessage(你确定要删除？);AlertDialog d=builder.create();

18、d.setButton(是, new DialogInterface.OnClickListener() public void onClick(DialogInterface dialog, int which) / TODO Auto-generated method stubhelper.delete(_id);select();/更新Toast.makeText(MainActivity.this, 删除成功, 1000).show(););d.setButton2(否, new DialogInterface.OnClickListener()public void onClick(

19、DialogInterface dialog, int which) / TODO Auto-generated method stubdialog.cancel(););d.show();break;case 2:Intent intent = new Intent(this,UpdateEmpActivity.class);Cursor cursor = (Cursor) lv.getItemAtPosition(menuInfo.position); cursor.moveToPosition(menuInfo.position); _id=cursor.getInt(0); Strin

20、g empname = String.valueOf(cursor.getString(cursor.getColumnIndex(empname); String empno = String.valueOf(cursor.getString(cursor.getColumnIndex(empno); String empage = String.valueOf(cursor.getString(cursor.getColumnIndex(empage); String empsal = String.valueOf(cursor.getString(cursor.getColumnInde

21、x(empsal); /跳转页面 intent.putExtra(empname, empname); intent.putExtra(empno, empno); intent.putExtra(empage, empage); intent.putExtra(empsal, empsal); intent.putExtra(_id,_id); startActivity(intent);break;return super.onContextItemSelected(item);package com.example.empmanager;import android.app.Activi

22、ty;import android.content.Context;import android.content.Intent;import android.database.Cursor;import android.os.Bundle;import android.view.View;import android.view.View.OnClickListener;import android.widget.Button;import android.widget.EditText;import android.widget.Toast;public class UpdateEmpActi

23、vity extends Activity private EditText empname,empno,empage,empsal;private DBHelper helper=new DBHelper(this);private Cursor cursor;private Button save,clear;public int _id;MainActivity activity=new MainActivity();protected void onCreate(Bundle savedInstanceState) / TODO Auto-generated method stubsu

24、per.onCreate(savedInstanceState);setContentView(R.layout.add_emp);empname=(EditText) findViewById(R.id.empname);empno=(EditText) findViewById(R.id.empno);empage=(EditText) findViewById(R.id.empage);empsal=(EditText) findViewById(R.id.empsal);save=(Button) findViewById(R.id.save);clear=(Button) findV

25、iewById(R.id.clear);/获取传来的数据Intent intent=this.getIntent();_id=intent.getIntExtra(_id, 0);String emp_name = intent.getStringExtra(empname);String emp_no = intent.getStringExtra(empno);String emp_age=intent.getStringExtra(empage);String emp_sal = intent.getStringExtra(empsal);/显示在文本框中empname.setText(

26、emp_name);empno.setText(emp_no);empage.setText(emp_age);empsal.setText(emp_sal);save.setOnClickListener(new OnClickListener() public void onClick(View v) / TODO Auto-generated method stubString a1=empname.getText().toString();String a2=empno.getText().toString();String a3=empage.getText().toString()

27、;String a4=empsal.getText().toString();helper.UpdateEmp(_id, a1, a2, a3, a4);Toast.makeText(UpdateEmpActivity.this, 修改成功, 5).show();Intent intent=new Intent(UpdateEmpActivity.this,MainActivity.class);startActivity(intent););clear.setOnClickListener(new OnClickListener() public void onClick(View v) / TODO Auto-generated method stub);