Android--SQLite（增，删，改，查）操作实例代码

public class Person {

 privatE int _id;
 private String name;

 public int getId() {
  return _id;
 }

 public void setId(int _id) {
  this._id = _id;
 }

 public String getName() {
  return name;
 }

 public void setName(String Name) {
  this.name = name;
 }

 @Override
 public String toString() {
  return "Person [id=" + _id + ",name=" + name + "]";
 }

 public Person() {
  super();
 }

 public Person(int _id,String Name) {
  super();
  this._id = _id;
  this.name = name;
 }
}

import java.util.List;

/**
 * 增删改查
 * @author ZLQ
 *
 */
public interface sqlOperate {
 public void add(Person p);
 public void delete(int id);
 public void updata(Person p);
 public List<Person> find();
 public Person findById(int id);
}

import android.content.Context;
import android.database.sqlite.sqliteDatabase;
import android.database.sqlite.sqliteOpenHelper;

/**
 * 助手类
 * @author ZLQ
 *
 */
public class DBOpneHelper extends sqliteOpenHelper {

 private static final int version = 1;//版本
 private static final String db_name = "people.db";//数据库名
 public static final String stuDENT_TABLE = "student";//表名
 public static final String _ID = "_id";//表中的列名
 public static final String NAME = "name";//表中的列名
 //创建数据库语句，stuDENT_TABLE，_ID ，NAME的前后都要加空格
 private static final String create_tABLE = "create table " + stuDENT_TABLE + " ( " + _ID + " INTEGER PRIMary key autoincrement," + NAME + " text)";

 public DBOpneHelper(Context context) {
  super(context,db_name,null,VERSION);
 }

 //数据库第一次被创建时调用
 @Override
 public void onCreate(sqliteDatabase db) {
  db.execsql(create_tABLE);
 }

 //版本升级时被调用
 @Override
 public void onUpgrade(sqliteDatabase db,int oldVersion,@R_197_6865@wVersion) {

 }

}

import java.util.ArrayList;
import java.util.List;

import android.content.ContentValues;
import android.content.Context;
import android.database.cursor;
import android.database.sqlite.sqliteDatabase;

public class sqlOperateImpl implements sqlOperate{

 private DBOpneHelper dbOpenHelper;

 public sqlOperateImpl(Context context) {
  dbOpenHelper = new DBOpneHelper(context);
 }

 /**
  * 增，用insert向数据库中插入数据
  */
 public void add(Person p) {
  sqliteDatabase db = dbOpenHelper.getWritableDatabase();
  ContentValues values = new ContentValues();
  values.put(DBOpneHelper._ID,p.getId());
  values.put(DBOpneHelper.NAME,p.getName());
  db.insert(DBOpneHelper.stuDENT_TABLE,values);
 }

 /**
  * 删，通过id删除数据
  */
 public void delete(int id) {
  sqliteDatabase db = dbOpenHelper.getWritableDatabase();
  db.delete(DBOpneHelper.stuDENT_TABLE,DBOpneHelper._ID + "=?",new String[]{String.valueOf(id)});
 }

 /**
  * 改，修改指定id的数据
  */
 public void updata(Person p) {
  sqliteDatabase db = dbOpenHelper.getWritableDatabase();
  ContentValues values = new ContentValues();
  values.put(DBOpneHelper._ID,p.getName());
  db.update(DBOpneHelper.stuDENT_TABLE,values,new String[]{String.valueOf(p.getId())});
 }

 /**
  * 查，查询表中所有的数据
  */
 public List<Person> find() {
  List<Person> persons = null;
  sqliteDatabase db = dbOpenHelper.getReadableDatabase();
  cursor cursor = db.query(DBOpneHelper.stuDENT_TABLE,null);
  if(cursor != null){
   persons = new ArrayList<Person>();
   while(cursor.moveToNext()){
    Person person = new Person();
    int _id = cursor.geTint(cursor.getcolumnIndex(DBOpneHelper._ID));
    String name = cursor.getString(cursor.getcolumnIndex(DBOpneHelper.Name));
    person.setId(_id);
    person.setName(Name);
    persons.add(person);
   }
  }
  return persons;
 }

 /**
  * 查询指定id的数据
  */
 public Person findById(int id) {
  sqliteDatabase db = dbOpenHelper.getReadableDatabase();
  cursor cursor = db.query(DBOpneHelper.stuDENT_TABLE,new String[]{String.valueOf(id)},null);
  Person person = null;
  if(cursor != null && cursor.moveToFirst()){
   person = new Person();
   int _id = cursor.geTint(cursor.getcolumnIndex(DBOpneHelper._ID));
   String name = cursor.getString(cursor.getcolumnIndex(DBOpneHelper.Name));
   person.setId(_id);
   person.setName(Name);
  }
  return person;
 }
}

import java.util.List;

import android.test.AndroidTESTCase;
import android.util.Log;

public class Test extends AndroidTESTCase {
 public void testAdd() throws Exception{
  sqlOperateImpl test = new sqlOperateImpl(getContext());
  Person person = new Person(2,"Peter");
  test.add(person);
 }

 public void testdelete() throws Exception{
  sqlOperateImpl test = new sqlOperateImpl(getContext());
  test.delete(1);
 }

 public void testupdata() throws Exception{
  sqlOperateImpl test = new sqlOperateImpl(getContext());
  Person person = new Person(1,"Tom");
  test.updata(person);
 }

 public void testFind() throws Exception{
  sqlOperateImpl test = new sqlOperateImpl(getContext());
  List<Person> persons = test.find();
  for (Person person : persons) {
   Log.i("System.out",person.toString());
  }
 }

 public void testFindById() throws Exception{
  sqlOperateImpl test = new sqlOperateImpl(getContext());
  Person person = test.findById(2);
  Log.i("System.out",person.toString());
 }
}