八、person.java 实体类 源码：
package com.example.domain;
public class Person {
private Integer id;
private String name;
private String phone;
private Integer amount;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public Person(String name, String phone) {
this.name = name;
this.phone = phone;
}
public Person(Integer id, String name, String phone,Integer amount) {
super();
this.id = id;
this.name = name;
this.phone = phone;
this.amount = amount;
}
public Person() {
super();
}
public Integer getAmount() {
return amount;
}
public void setAmount(Integer amount) {
this.amount = amount;
}
@Override
public String toString() {
return "Person [id=" + id + ", name=" + name + ", phone=" + phone
+ ", amount=" + amount + "]";
}
}
九、DBOperateHelper.java 业务类源码：
package com.example.service;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class DBOperateHelper extends SQLiteOpenHelper {
public DBOperateHelper(Context context) {//默认创建的数据库文件保存在<包名>/database/
//第一个参数是上下文，第二个参数是数据库名称，第三个是游标工厂为null时使用 数据库默认的游标工厂,第四个是数据库版本号但是不能为0，一般大于0
super(context, "smallpig", null, 4);
}
/**
* 数据库每一次被创建时被调用
*/
@Override
public void onCreate(SQLiteDatabase sqldb) {
sqldb.execSQL("create table person(personid integer primary key autoincrement,name varchar(20),phone varchar(12) null)");
}
/**
* 每一次数据库版本号发生变动时触发此方法
* 比如如果想往数据库中再插入一些表、字段或者其他信息时通过修改数据库版本号来触发此方法
*/
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
//db.execSQL("alter table person add phone varchar(12) null");
db.execSQL("alter table person add amount Integer null");
}
}
