Android中数据库Sqlite

import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;

public class SqliteActivity extends Activity {
	private MySQLiteHelpr mDBHelper=new MySQLiteHelpr(this);
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        Button insert=(Button)findViewById(R.id.insert);
        Button delete=(Button)findViewById(R.id.delete);
        Button modify=(Button)findViewById(R.id.modify);
        Button select=(Button)findViewById(R.id.select);
        
        OnClickListener οnclick=new OnClickListener() {

			public void onClick(View v) {
				switch(v.getId()){
				case R.id.insert:insert();break;
				case R.id.delete:delete();break;
				case R.id.modify:modify();break;
				case R.id.select:select();break;
				}
			}

			private void insert() {
				SQLiteDatabase db=mDBHelper.getWritableDatabase();
//				db.execSQL("insert into person(name,tel) values(?,?)",new String[]{"tom","13856566565"});
				ContentValues values = new ContentValues();
				values.put("name", "hello");
				values.put("tel", "13535535353");
				db.insert("person", null, values);
			}
			private void delete() {
				SQLiteDatabase db=mDBHelper.getWritableDatabase();
				db.delete("person","id=?", new String[]{"9"});
				
				db.execSQL("delete from person where id=?",new Object[]{"1"});
			}
			private void modify() {
				SQLiteDatabase db=mDBHelper.getWritableDatabase();
				ContentValues values = new ContentValues();
				values.put("name", "zhangsan");
				db.update("person", values, "id=?", new String[]{"2"});
				
//				db.execSQL("update person set name='wang' where id=?",new String[]{"1"});
			}
			private void select() {
				SQLiteDatabase db=mDBHelper.getWritableDatabase();
				Cursor cursor=db.query("person", new String[]{"id","name","tel"}, "id=?", new String[]{"4"}, null, null, null);
				
//				Cursor cursor=db.rawQuery("select * from person where id=?",new String[]{"1"});
				if(cursor.moveToFirst()){
					int id0=cursor.getInt(cursor.getColumnIndex("id"));
					String name=cursor.getString(cursor.getColumnIndex("name"));
					String tel=cursor.getString(cursor.getColumnIndex("tel"));
					
				}
			}
		};
		insert.setOnClickListener(onclick);
		delete.setOnClickListener(onclick);
		modify.setOnClickListener(onclick);
		select.setOnClickListener(onclick);
    }
    
    class MySQLiteHelpr extends SQLiteOpenHelper{
    	
    	//升级表
		public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
			db.execSQL("alter table person add salary varchar(12) null");
		}
		public MySQLiteHelpr(Context context) {  
			super(context, "text.db", null, 3);
		}
		
		@Override
		public void onCreate(SQLiteDatabase db) {
			String sql="create table person(id Integer PRIMARY KEY autoincrement,name VARCHAR(32),tel varchar(11))";
			db.execSQL(sql);
		}
		
    }
}