sqlite增删改查实例(android)

【实例截图】

【核心代码】

package com.example.sqlitetest;

import com.example.sqlitetest.R;

import android.os.Bundle;
import android.os.CancellationSignal;
import android.provider.Contacts.Intents.Insert;
import android.provider.ContactsContract.CommonDataKinds.Phone;
import android.R.layout;
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.SQLiteOpenHelper;
import android.view.Menu;
import android.view.View;

public class MainActivity extends Activity {

	private  DBDao dao;

	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		dao = new DBDao(MainActivity.this,"test.db",1);
		// 打开或创建test.db数据库
	//	SQLiteDatabase db = this.openOrCreateDatabase("test.db",		Context.MODE_PRIVATE, null);
	//	 dbHelper = new MyDBHelper(MainActivity.this, "test.db",
	//		null, 1);
	//	SQLiteDatabase db2 = dbHelper.getWritableDatabase();
		// db.insert(table, nullColumnHack, values);
		// db.delete(table, whereClause, whereArgs);
		// db.update(table, values, whereClause, whereArgs);
		// db.query(distinct, table, columns, selection, selectionArgs, groupBy,
		// having, orderBy, limit, cancellationSignal);
	}
	//添加按钮事件
	public void add(View view) {
		Person p = new Person();
		p.setName("小米");
		p.setPhone("15932264578");
		dao.save(p );
	}
	public void query(View view) {
		 String id = "1";
		 Person person = dao.find(id);
		 if(person != null)
		 {
			 System.out.println("查询结果：" person.toString());
		 }else {
			System.out.println("查询无结果");
		}
	}
	public void  update(View view) {
		Person P= new Person();
		P.setName("小明");
		P.setPhone("110");
		P.setId("1");
		dao.update(P);
	}	
	public void delete(View view) {
		String id ="1";
		dao.delete(id);
	}

	@Override
	public boolean onCreateOptionsMenu(Menu menu) {
		// Inflate the menu; this adds items to the action bar if it is present.
		getMenuInflater().inflate(R.menu.main, menu);
		return true;
	}

}