Android快速入门-----数据存储（三）Sqlite应用练习：增删查改案例练习，应用的优化（背景显示），Android开发谈

3）测试

（2）DBHelper:数据库–表：定义DAO，

创建DBHelper类

package com.itzheng.app04_sqlite;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import android.util.Log;

/*

• 数据库操作的帮助类

*/

public class DBHelper extends SQLiteOpenHelper {

public DBHelper(Context context ) {

super(context, “itzheng.db”, null, 1);

}

@Override

public void onCreate(SQLiteDatabase db) {

Log.i(“TAG”, “DBHelper onCreate()”);

//创建表

db.execSQL(“create table black_number(_id integer primary key autoincrement,number varchar )”);

}

@Override

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

// TODO Auto-generated method stub

}

}

（3）实体类

创建BlackNumber

package com.itzheng.app04_sqlite;

/*

• 某一个表black_number表对应的实现类

*/

public class BlackNumber {

private int id;

private String number;

public BlackNumber() {

super();

// TODO Auto-generated constructor stub

}

public BlackNumber(int id, String number) {

super();

this.id = id;

this.number = number;

}

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getNumber() {

return number;

}

public void setNumber(String number) {

this.number = number;

}

@Override

public String toString() {

return “BlackNumber [id=” + id + “, number=” + number + “]”;

}

}

（4）DAO

创建BlackNumberDao，实现增删改查

package com.itzheng.app04_sqlite;

import java.util.ArrayList;

import java.util.List;

import android.content.ContentValues;

import android.content.Context;