需要实现两个类
1.自己写一个OpenHelper继承SQLiteOpenHelper实现里面的方法
实现这个类就可以不用管数据库的创建和连接。。等等操作
实现如下:
package com.tu.db;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DatabaseOpenHelper extends SQLiteOpenHelper {
public DatabaseOpenHelper(Context context) {
super(context, "testdatabase", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String sql = "create table person(_id integer primary key,name varchar(20),age integer);";
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
2.写一个DAO类 用来对数据库进行增删改查等操作
实现如下:
package com.tu.dao;
import java.util.LinkedList;
import java.util.List;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import com.tu.bean.Person;
import com.tu.db.DatabaseOpenHelper;
public class PersonDao {
private SQLiteOpenHelper mHelper = null;
public PersonDao(Context context) {
this.mHelper = new DatabaseOpenHelper(context);
}
/**
* 插入一条Person数据
*/
public void insert(String personNmae,int personAge){
SQLiteDatabase db = mHelper.getWritableDatabase();
if(db.isOpen()){
db.execSQL("insert into person(name,age) values(?,?);", new Object[]{personNmae,personAge});
db.close();
}
}
/**
* 根据Person名字删除数据库中的条目
* @param personNmae
*/
public void delete(String personNmae){
SQLiteDatabase db = mHelper.getWritableDatabase();
if(db.isOpen()){
db.execSQL("delete from person where name = ?;", new String[]{personNmae});
db.close();
}
}
public List<Person> queryAll(){
SQLiteDatabase db = mHelper.getReadableDatabase();
if(db.isOpen()){
List<Person> personList = new LinkedList<Person>();
Person person = null;
Cursor cursor = db.rawQuery("select name,age from person;", null);
if(cursor != null && cursor.getCount() > 0){
while(cursor.moveToNext()){
person = new Person(0, cursor.getString(0), cursor.getInt(1));
personList.add(person);
}
cursor.close();
db.close();
return personList;
}
}
db.close();
return null;
}
}