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

1、精选优质文档-倾情为你奉上效果图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;public class Add

2、EmpActivity 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.onCreate(savedInstance

3、State);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) findViewById(R.id.clear);sa

4、ve.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.lengt

5、h()>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, "增加失

6、败", 1000).show(););clear.setOnClickListener(new OnClickListener() public void onClick(View v) / TODO Auto-generated method stubempname.setText("");empno.setText("");empage.setText("");empsal.setText(""););主活动页面package com.example.empmanager;import android

7、.os.Bundle;import vider.ContactsContract.Data;import vider.ContactsContract.CommonDataKinds.Phone;import android.app.Activity;import android.app.AlertDialog;import android.app.AlertDialog.Builder;import android.app.ListActivity;import android.content.Context;import android.cont

8、ent.DialogInterface;import android.content.Intent;import android.database.Cursor;import android.view.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.widg

9、et.AdapterView;import android.widget.AdapterView.AdapterContextMenuInfo;import android.widget.Button;import android.widget.CheckBox;import android.widget.ListView;import android.widget.RelativeLayout;import android.widget.SimpleAdapter;import android.widget.SimpleCursorAdapter;import android.widget.

10、TextView;import android.widget.Toast;import android.widget.AdapterView.OnItemClickListener;public class 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;Cur

11、sor cursor;public int _id;/private Boolean bool = false;private Menu myMenu;private Context context;SimpleCursorAdapter adapter;protected void onCreate(Bundle savedInstanceState) super.onCreate(savedInstanceState);setContentView(R.layout.activity_main);/初始化控件insert=(Button) findViewById(R.id.insert)

12、;delete=(Button) findViewById(R.id.delete);update=(Button) findViewById(R.id.update);select=(Button) 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) findViewB

13、yId(R.id.show_sal);lv=(ListView) findViewById(R.id.lv);registerForContextMenu(lv);insert.setOnClickListener(listener);delete.setOnClickListener(listener);update.setOnClickListener(listener);select.setOnClickListener(listener);OnClickListener listener=new OnClickListener() public void onClick(View v)

14、 switch(v.getId()case R.id.insert:Intent intent=new Intent(MainActivity.this,AddEmpActivity.class);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.se

15、tHeaderTitle("快捷操作");menu.add(Menu.NONE, 1, 1, "删除");menu.add(Menu.NONE, 2, 2, "修改");super.onCreateContextMenu(menu, v, menuInfo);/显示数据在listview上public void select()Cursor cursor=helper.getCursorScrollData();adapter=new SimpleCursorAdapter(MainActivity.this, R.layout.li

16、st_item, cursor, new String"empname","empno","empage","empsal", new int R.id.show_name,R.id.show_no,R.id.show_age,R.id.show_sal);lv.setAdapter(adapter); adapter.notifyDataSetChanged();/响应事件public boolean onContextItemSelected(MenuItem item) / TODO Auto-generat

17、ed method stub/这样可以获取长按着弹出上下文菜单的LIstView点击的ID值AdapterView.AdapterContextMenuInfo menuInfo=(AdapterContextMenuInfo) item.getMenuInfo(); final int id=(int) menuInfo.id; if (-1 = id) super.onContextItemSelected(item); switch(item.getItemId()case 1:Cursor cursor1 = (Cursor) lv.getItemAtPosition(menuInfo

18、.position); cursor1.moveToPosition(menuInfo.position); _id=cursor1.getInt(0);Builder builder=new Builder(MainActivity.this);builder.setMessage("你确定要删除？");AlertDialog d=builder.create();d.setButton("是", new DialogInterface.OnClickListener() public void onClick(DialogInterface dial

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

20、ialog.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); String empname = String.valueOf(cursor.getString(cursor.getColumnIndex(&qu

21、ot;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.getColumnIndex("empsal"); /跳转页面 inte

22、nt.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.examp

23、le.empmanager;import android.app.Activity;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.

24、widget.Toast;public class UpdateEmpActivity 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 savedInstanceSta

25、te) / TODO Auto-generated method stubsuper.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) findViewById(R.id.clear);/获取传来的数据Intent intent=this.getIntent();_id=intent.getIntExtra("_id", 0);String emp_name = intent.getStringExtra("empname&quo