创建PersonDao操作数据库
package com.example.testdb;
import java.util.ArrayList;
import java.util.List;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
public class PersonDao {
PersonSQLOpenHelper helper;
public PersonDao(Context context) {
helper = new PersonSQLOpenHelper(context);
}
/**
* 添加数据
*
* @param name
* 姓名
* @param number
* 电话
*/
public void add(String name, String number) {
SQLiteDatabase db = helper.getWritableDatabase();
db.execSQL("insert into person(name,number) values(?,?)", new Object[] {
name, number });
db.close();
}
/**
* 查询数据
*
* @param name
* 姓名
* @return false:没有,true:有
*/
public boolean find(String name) {
SQLiteDatabase db = helper.getWritableDatabase();
Cursor cursor = db.rawQuery("select * from person where name = ?",
new String[] { name });
boolean result = cursor.moveToNext();
cursor.close();
db.close();
return result;
}
/**
* 修改一条记录
*
* @param name
* 要修改人的姓名
* @param number
* 新的号码
*/
public void update(String name, String number) {
SQLiteDatabase db = helper.getWritableDatabase();
db.execSQL("update person set number = ? where name = ?", new Object[] {
name, number });
db.close();
}
/**
* 删除一条记录
*
* @param name
* 要删除的姓名
*/
public void delete(String name) {
SQLiteDatabase db = helper.getWritableDatabase();
db.execSQL("delete from person where name = ?", new Object[] { name });
db.close();
}
public List<Person> findAll() {
SQLiteDatabase db = helper.getReadableDatabase();
Cursor cursor = db.rawQuery("select * from person", null);
List<Person> persons = new ArrayList<Person>();
while (cursor.moveToNext()) {
int id = cursor.getInt(cursor.getColumnIndex("id"));
String name = cursor.getString(cursor.getColumnIndex("name"));
String number = cursor.getString(cursor.getColumnIndex("number"));
Person p = new Person(id, name, number);
persons.add(p);
}
return persons;
}
}
创建Person实体类
package com.example.testdb;
public class Person {
int id;
String name;
String number;
public Person() {
}
public Person(int id, String name, String number) {
this.id = id;
this.name = name;
this.number = number;
}
@Override
public String toString() {
return "id=" + id + ", name=" + name + ", number=" + number;
}
}
实现
package com.example.testdb;
import java.util.List;
import android.os.Bundle;
import android.app.Activity;
import android.util.Log;
import android.view.Menu;
public class MainActivity extends Activity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
PersonSQLOpenHelper helper = new PersonSQLOpenHelper(this);
helper.getWritableDatabase();// 执行了这一句代码才会被创建
PersonDao p = new PersonDao(this);
p.add("张三", "16434131313");
p.add("李四", "1245637801");
boolean is = p.find("张三");
Log.i("TAG", "" + is);
p.update("张三", "41111111");
p.delete("张三");
is = p.find("张三");
Log.i("TAG", "删除后:" + is);
List<Person> list = p.findAll();
for (Person x : list) {
Log.i("TAG", x.toString());
}
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
getMenuInflater().inflate(R.menu.main, menu);
return true;
}
}