1. 添加依赖
//数据库框架
compile 'com.j256.ormlite:ormlite-android:5.0'
2. 编写OpenHelper
Openhelper的作用是指定数据库名称,版本,与表
public class MyHelper extends OrmLiteSqliteOpenHelper{
private static final String databaseName="xxxxx.db";
private static final SQLiteDatabase.CursorFactory factory=null;
private static final int databaseVersion=1;
public MyHelper(Context context) {
super(context, databaseName, factory, databaseVersion);
}
@Override
public void onCreate(SQLiteDatabase database, ConnectionSource connectionSource) {
//ORM数据框架 依赖 orm 对象关系映射关系
try {
TableUtils.createTable(connectionSource,ReceiptAddredsInfo.class);
TableUtils.createTable(connectionSource,AllUserInfo.class);
} catch (SQLException e) {
e.printStackTrace();
}
}
@Override
public void onUpgrade(SQLiteDatabase database, ConnectionSource connectionSource, int oldVersion, int newVersion) {
}
}
3. 编写带有映射关系的javaBean
//1.无参构造函数
//2.get/set
//3.配置表名
//4.配置表字段
@DatabaseTable(tableName = "t_receipt_address")
public class ReceipAddressInfo implements Serializable{
//主键 id自增长
@DatabaseField(columnName = "_id",generatedId = true)
private int id;
//用户id
@DatabaseField(columnName = "uid")
private String uid;
@DatabaseField(columnName = "name")
private String name;
@DatabaseField(columnName = "sex")
private String sex;
@DatabaseField(columnName = "phone")
private String phone;
@DatabaseField(columnName = "otherPhone")
private String otherPhone;
@DatabaseField(columnName = "receiptAddress")
private String receiptAddress;
@DatabaseField(columnName = "detailAddress")
private String detailAddress;
@DatabaseField(columnName = "lable")
private String lable;
public ReceipAddressInfo() {
}
}
4. 获取dao
// MyHelper myHelper = new MyHelper(context);
// try {
// dao = myHelper.getDao(AllUserInfo.class);
// } catch (SQLException e) {
// e.printStackTrace();
// }
5. 针对数据库的操作 增删改查
dao.create();
dao.delete();
dao.update();
dao.queryForAll();