OrmLite__数据库框架

本文主要是介绍OrmLite__数据库框架，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

导包

http://ormlite.com/releases/
将core和android的jar各自下载一份并导入

//或者
compile 'com.j256.ormlite:ormlite-android:5.0'

创建实例化bean类

//表名
@DatabaseTable(tableName = "People")
public class People {/** columnName  字段名* dataType 数据类型* defaultValue 字符串默认值* canBeNull 可否为空* id 主键* generatedId 自增主键* foreign 外联* unique 唯一* *///自增主键@DatabaseField(generatedId = true)private int id;//列名@DatabaseField(columnName = "name")private String name;/** 常用类型:* DataType.STRING* DataType.BOOLEAN* DataType.DATE* DataType.DATE_LONG* DataType.CHAR* DataType.BYTE* DataType.SHORT* DataType.INTEGER* DataType.LONG* DataType.FLOAT* DataType.DOUBLE* DataType.SERIALIZABLE* DataType.TIME_STAMP* *///列名和类型@DatabaseField(columnName = "age",dataType = DataType.INTEGER)private int age;//必须存在无参构造器public People() {}@Overridepublic String toString() {return "People{" +"id=" + id +", name='" + name + '\'' +", age=" + age +'}';}public int getId() {return id;}public void setId(int id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public int getAge() {return age;}public void setAge(int age) {this.age = age;}
}

创建helper类,用于获取Dao对象

public class PeopeoDatabaseHelper extends OrmLiteSqliteOpenHelper {public static final String DB_NAME="people.db";public static final int DB_VERSION=1;//出现异常直接抛出RuntimeExceptionDao<People, Integer> mRuntimeExceptionDao;//出现异常进行cacheDao<People, Integer> mDao;public PeopeoDatabaseHelper(Context context) {//在工厂类中传入null即可super(context, DB_NAME, null, DB_VERSION);}@Overridepublic void onCreate(SQLiteDatabase database, ConnectionSource connectionSource) {try {TableUtils.createTable(connectionSource,People.class);} catch (SQLException e) {throw new RuntimeException("建表"+DB_NAME+"失败");}RuntimeExceptionDao<People, Integer> dao = getPeopleRuntimeDao();//在创建数据库时插入一些数据用于测试People people = new People();people.setAge(23);people.setName("小黄");dao.create(people);People people2 = new People();people.setAge(24);people.setName("老江");dao.create(people2);}@Overridepublic void onUpgrade(SQLiteDatabase database, ConnectionSource connectionSource, int oldVersion, int newVersion) {try {TableUtils.dropTable(connectionSource,People.class,true);onCreate(database,connectionSource);} catch (SQLException e) {throw new RuntimeException("升级"+DB_NAME+"失败");}}//获取dao的两个方法public RuntimeExceptionDao<People,Integer> getPeopleRuntimeDao() {if (mRuntimeExceptionDao ==null){mRuntimeExceptionDao =getRuntimeExceptionDao(People.class);}return mRuntimeExceptionDao;}public Dao<People, Integer> getPeopleDao() throws SQLException {if (mDao==null){mDao=getDao(People.class);}return mDao;}//关闭数据库@Overridepublic void close() {super.close();mDao=null;mRuntimeExceptionDao=null;}
}

增删改查

public class MainActivity extends AppCompatActivity {RuntimeExceptionDao<People, Integer> dao;@Overrideprotected void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setContentView(R.layout.activity_main);PeopeoDatabaseHelper peopeoDatabaseHelper = new PeopeoDatabaseHelper(this);peopeoDatabaseHelper = OpenHelperManager.getHelper(this, PeopeoDatabaseHelper.class);dao = peopeoDatabaseHelper.getPeopleRuntimeDao();}int x = 0;public void insert(View view) {People people = new People();people.setName("小黄" + x + "号");people.setAge(x);dao.create(people);x++;}public void delete(View view) {try {int delete = dao.deleteBuilder().delete();Log.d("meee", getClass() + ":\n" + "delete:" + delete);} catch (SQLException e) {e.printStackTrace();}}public void update(View view) {try {List<People> query = dao.queryBuilder().where().eq("name", "小黄1号").and().eq("age", 1).query();for (int i = 0; i < query.size(); i++) {People people = query.get(i);people.setName("巨无霸小黄一号");dao.update(people);}} catch (SQLException e) {e.printStackTrace();}}public void query(View view) {List<People> peoples = dao.queryForAll();for (int i = 0; i < peoples.size(); i++) {People people = peoples.get(i);Log.d("meee", getClass() + ":\n" + "people:" + people);}}
}