package dbOpenHelper;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;/** * Created by Administrator on 2014/8/25. */public class DbOpenHelper extends SQLiteOpenHelper {    public DbOpenHelper(Context context)    {        //Context 上下文        //name 数据库名        //CursorFactory 游标工厂模式 当为null时 使用默认值        //version 数据库版本 版本号从1开始        super(context, "person.db", null, 1);    }    @Override    public void onCreate(SQLiteDatabase db) {        //create table person(id integer primary key autoincrement,name varchar(20),age int,phone varchar(11))        String sql = "create table person(id integer primary key autoincrement,name varchar(20),int age,phone varchar(11))";        db.execSQL(sql);    }    @Override    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {    }}

package domain;/** * Created by Administrator on 2014/8/25. */public class Person {    private int id;    private String name;    private int age;    private String phone;    public Person(){}    public Person(int id, String name, int age, String phone) {        this.id = id;        this.name = name;        this.age = age;        this.phone = phone;    }    public Person(int id, String name, String phone) {        this.id = id;        this.name = name;        this.phone = phone;    }    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;    }    public int getAge() {        return age;    }    public void setAge(int age) {        this.age = age;    }    public String getPhone() {        return phone;    }    public void setPhone(String phone) {        this.phone = phone;    }    @Override    public String toString() {        return "个人信息{" +                "id=" + id +                ", name=‘" + name + ‘\‘‘ +                ", age=" + age +                ", phone=‘" + phone + ‘\‘‘ +                ‘}‘;    }}

package dao;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import dbOpenHelper.DbOpenHelper;import domain.Person;import java.util.ArrayList;import java.util.List;/** * Created by Administrator on 2014/8/25. */public class PersonDao {    private DbOpenHelper helper;    public PersonDao(Context context)    {        helper = new DbOpenHelper(context);    }    public void add(Person p)    {        SQLiteDatabase db = helper.getWritableDatabase();        String sql = "insert into person(name,phone) values(?,?)";        db.execSQL(sql,new Object[]{p.getName(),p.getPhone()});        db.close();    }    public void update(Person p)    {        SQLiteDatabase db = helper.getWritableDatabase();        String sql = "update person set phone=? where name=?";        db.execSQL(sql,new Object[]{p.getPhone(),p.getName()});        db.close();    }    public void delete(String name)    {        SQLiteDatabase db = helper.getWritableDatabase();        String sql = "delete from person where name=?";        db.execSQL(sql,new Object[]{name});        db.close();    }    public Person findByName(String name)    {        SQLiteDatabase db = helper.getWritableDatabase();        String sql = "select * from person where name=?";        Cursor cursor = db.rawQuery(sql,new String[]{name});        Person p = null;        while(cursor.moveToFirst())        {            int id = cursor.getInt(cursor.getColumnIndex("id"));            String phone = cursor.getString(cursor.getColumnIndex("phone"));            p = new Person(id,name,phone);        }        db.close();        return p;    }    public List<Person> findAll()    {        SQLiteDatabase db = helper.getWritableDatabase();        String sql = "select * from person";        Cursor cursor = db.rawQuery(sql,null);        List<Person> list = new ArrayList<Person>();        while(cursor.moveToNext())        {            int id = cursor.getInt(cursor.getColumnIndex("id"));            String name = cursor.getString(cursor.getColumnIndex("name"));            String phone = cursor.getString(cursor.getColumnIndex("phone"));            Person p = new Person(id,name,phone);            list.add(p);        }        db.close();        return list;    }}

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"              android:orientation="horizontal"              android:layout_width="fill_parent"              android:layout_height="fill_parent">    <TextView            android:layout_width="120dp"            android:layout_height="wrap_content"            android:text="@string/id"            android:id="@+id/tv_id"            />    <TextView            android:layout_width="120dp"            android:layout_height="wrap_content"            android:text="@string/name"            android:id="@+id/tv_name"            />    <TextView            android:layout_width="fill_parent"            android:layout_height="wrap_content"            android:text="@string/phone"            android:id="@+id/tv_phone"            /></LinearLayout>

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"              android:orientation="vertical"              android:layout_width="fill_parent"              android:layout_height="fill_parent">    <LinearLayout            android:orientation="horizontal"            android:layout_width="fill_parent"            android:layout_height="wrap_content">        <TextView                android:layout_width="120dp"                android:layout_height="wrap_content"                android:text="@string/id"                />        <TextView                android:layout_width="120dp"                android:layout_height="wrap_content"                android:text="@string/name"                />        <TextView                android:layout_width="fill_parent"                android:layout_height="wrap_content"                android:text="@string/phone"                />    </LinearLayout>   <ListView           android:layout_width="fill_parent"           android:layout_height="fill_parent"           android:id="@+id/list"           /></LinearLayout>