安卓增删改查总结.doc

Activity: package com.example.bbb; import android.app.Activity; import android.content.ContentValues; import android.database.Cursor; import android.database.sqlite.SQLiteCursor; import android.database.sqlite.SQLiteDatabase; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.AdapterView; import android.widget.Button; import android.widget.EditText; import android.widget.TextView; import android.widget.ListView; import android.widget.SimpleCursorAdapter; import android.widget.Toast; public class MainActivity extends Activity { public static final String TAG = SQLiteDemo; private SQLiteDatabase db; private Button insertButton; private Button queryButton; private Button deleteButton; private Button updateButton; private ListView listView; private EditText nameEditText; private EditText passwordEditText; private TextView tv1; private TextView tv2; private SimpleCursorAdapter adapter; private int currentId; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); DBHelper dbHelper = new DBHelper(this); // 在执行了getWritableDatabase的时候才会创建数据库 db = dbHelper.getWritableDatabase(); insertButton = (Button) findViewById(R.id.insertButton); insertButton.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View arg0) { insertUserInfo(); } }); queryButton = (Button) findViewById(R.id.queryButton); queryButton.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { queryAllUserInfos(); } }); deleteButton = (Button) findViewById(R.id.deleteButton); deleteButton.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { deleteUserInfo(); } }); updateButton = (Button) findViewById(R.id.updateButton)