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

效果图 ‘ 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 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 stub super.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); save.setOnClickListener(new OnClickListener() { public void onClick(View v) { // TODO Auto-generated method stub String name=empname.getText().toString(); String no=empno.getText().toString(); String age=empage.getText().toString(); String sal=empsal.getText().toString(); if(name.length()0no.length()0age.length()0sal.length()0){ helper.insertEmp(name,no,age,sal); Toast.makeText(AddEmpActivity.this, 增加成功, 1000).show(); Intent intent=new Intent(AddEmpActivity.this,MainActivity.class); startActivity(intent); } else{ Toast.makeText(AddEmpActivity.this, 增加失败, 1000).show(); } } }); clear.setOnClickListener(new OnClickListener() { public void onClick(View v) { // TODO Auto-generated method stub empname.setText(); empno.setText(); empage.setText(); empsal.setText(); } }); } } 主活动页面 package com.example.empmanager; import android.os.Bundle; import vider.Con