AndroidSQLite数据库创建和使用实战（一） - 数据库编程

t context, String name, CursorFactory factory, int version) { super(context, name, factory, version); // TODO Auto-generated constructor stub } @Override public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub db.execSQL(DBASE_CREATE); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // TODO Auto-generated method stub Log.w(TAG, "Upgrading database from version " + oldVersion + " to " + newVersion + ", which will destroy all old data"); db.execSQL("DROP TABLE IF EXISTS titles"); onCreate(db); } } } com/jesse/dbasetest1/MainActivity.java（不解释，看不懂说明 Android比我还次，哈哈）。

package com.jesse.dbasetest1;

import android.os.Bundle;
import android.app.Activity;
import android.content.Context;
import android.database.Cursor;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;

public class MainActivity extends Activity {
	private Context mContext;
	private EditText mNameEdTxt;
	private EditText mAgeEdTxt;
	private EditText mSexEdTxt;
	private Button mAddBtn;
	
	private EditText mRmIdEdTxt;
	private Button mRemoveBtn;
	
	private EditText mPersonIdEdTxt;
	private TextView mOneText;
	private Button mGetOneBtn;

	private EditText mIdUpEdTxt;
	private EditText mNameUpEdTxt;
	private EditText 




mAgeUpEdTxt;
	private EditText mSexUpEdTxt;
	private Button mUpBtn;
	
	private TextView mAllText;
	private Button mGetAllBtn;
	
	private DbAdapter mDbAdapter;
	
	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		
		initData();
	}
	
	private void initData()
	{
		mContext = MainActivity.this;
		
		mNameEdTxt = (EditText) this.findViewById(R.id.person_name);
		mAgeEdTxt = (EditText) this.findViewById(R.id.person_age);
		mSexEdTxt = (EditText) this.findViewById(R.id.person_sex);
		mAddBtn = (Button) this.findViewById(R.id.add_btn);
		
		mRmIdEdTxt = (EditText) this.findViewById(R.id.person_id);
		mRemoveBtn = (Button) this.findViewById(R.id.remove_btn);
		
		mPersonIdEdTxt = (EditText) this.findViewById(R.id.get_person_id);
		mOneText = (TextView) this.findViewById(R.id.one_person_info);
		mGetOneBtn = (Button) this.findViewById(R.id.get_one_btn);
		
		mIdUpEdTxt = (EditText) this.findViewById(R.id.id_up); 
		mNameUpEdTxt = (EditText) this.findViewById(R.id.person_name_up);
		mAgeUpEdTxt = (EditText) this.findViewById(R.id.person_age_up);
		mSexUpEdTxt = (EditText) this.findViewById(R.id.person_sex_up);
		mUpBtn = (Button) this.findViewById(R.id.update_btn);
		
		mAllText = (TextView) this.findViewById(R.id.all_person_info);
		mGetAllBtn = (Button) this.findViewById(R.id.get_all_btn);
		
		mAddBtn.setOnClickListener(addBtnClickListener);
		mRemoveBtn.setOnClickListener(removeBtnClickListener);
		mGetOneBtn.setOnClickListener(getOneBtnClickListener);
		mUpBtn.setOnClickListener(upBtnClickListener);

AndroidSQLite数据库创建和使用实战（一）(二)