一、概述:
1、官方网站:http://ormlite.com/
2、相关API :http://ormlite.com/javadoc/ormlite-core/
———————————————————————
有需求者请加qq:136137465,非诚勿扰
(java 架构师全套教程,共760G, 让你从零到架构师,每月轻松拿3万)
01.高级架构师四十二个阶段高
02.Java高级系统培训架构课程148课时
03.Java高级互联网架构师课程
04.Java互联网架构Netty、Nio、Mina等-视频教程
05.Java高级架构设计2016整理-视频教程
06.架构师基础、高级片
07.Java架构师必修linux运维系列课程
08.Java高级系统培训架构课程116课时
(送:hadoop系列教程,java设计模式与数据结构, Spring Cloud微服务, SpringBoot入门)
——————————————————————–
二、搭建环境
在module gradle里添加
dependencies {
compile fileTree(include: ['*.jar'], dir: 'libs')
testCompile 'junit:junit:4.12'
compile 'com.android.support:appcompat-v7:24.0.0'
compile 'com.android.support:design:24.0.0'
compile 'com.jakewharton:butterknife:5.1.1'
compile 'com.android.support:recyclerview-v7:24.0.0'
compile 'com.nineoldandroids:library:2.4.0'
compile 'com.android.support:support-v4:24.0.0'
compile 'com.google.code.gson:gson:2.7'
compile 'org.greenrobot:greendao:3.1.1'
compile 'org.greenrobot:greendao-generator:3.1.0'
compile 'com.j256.ormlite:ormlite-android:5.0'
compile 'com.j256.ormlite:ormlite-core:5.0'
compile 'org.androidannotations:ormlite:4.1.0'
compile 'com.j256.ormlite:ormlite-jdbc:5.0'
}
三、代码编写:
1、创建实体类User
package com.app.views.orm;
import com.j256.ormlite.field.DatabaseField;
import com.j256.ormlite.table.DatabaseTable;
/**
* 作者:Administrator on 2016/8/27
*/
@DatabaseTable(tableName = "user")
public class User {
@DatabaseField(generatedId = true)
private long id;
@DatabaseField(columnName = "name")
private String name;
@DatabaseField(columnName = "age")
private int age;
@DatabaseField(columnName = "address")
private String address;
@DatabaseField(columnName = "tel")
private String tel;
public long getId() {
return id;
}
public void setId(long 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;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getTel() {
return tel;
}
public void setTel(String tel) {
this.tel = tel;
}
}
2、创建数据库
package com.app.views.orm;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import com.j256.ormlite.android.apptools.OrmLiteSqliteOpenHelper;
import com.j256.ormlite.dao.Dao;
import com.j256.ormlite.support.ConnectionSource;
import com.j256.ormlite.table.TableUtils;
import java.sql.SQLException;
import java.util.HashMap;
/**
* 作者:chen.lin on 2016/8/27
*/
public class DbHelper extends OrmLiteSqliteOpenHelper {
private static final String DATABASENAME = "orm.db";
private static final int DATABASEVERSION = 1;
private static DbHelper instance;
public DbHelper(Context context) {
super(context, DATABASENAME, null, DATABASEVERSION);
}
public static DbHelper getInstance(Context context){
if (instance == null){
synchronized (DbHelper.class){
if (instance == null){
instance = new DbHelper(context);
}
}
}
return instance;
}
private HashMap<String, Dao> map = new HashMap<String, Dao>();
/**
* 获得访问对象
* @param cls
* @return
*/
public synchronized Dao getDao(Class cls) throws SQLException {
Dao dao = null;
String className = cls.getSimpleName();
if (map.containsKey(className)){
dao = map.get(className);
}else{
dao = super.getDao(cls);
map.put(className, dao);
}
return dao;
}
/**
* 关闭
*/
public void close(){
super.close();
for(String key : map.keySet()){
Dao dao = map.get(key);
dao = null;
}
}
@Override
public void onCreate(SQLiteDatabase database, ConnectionSource connectionSource) {
try {
TableUtils.createTable(connectionSource,User.class);
} catch (SQLException e) {
e.printStackTrace();
}
}
@Override
public void onUpgrade(SQLiteDatabase database, ConnectionSource connectionSource, int oldVersion, int newVersion) {
try {
TableUtils.dropTable(connectionSource, User.class, true);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
3、封装工具类
package com.app.views.orm;
import android.content.Context;
import com.app.views.db.*;
import com.j256.ormlite.dao.Dao;
import com.j256.ormlite.stmt.UpdateBuilder;
import java.sql.SQLException;
/**
* 作者:chen.lin on 2016/8/28
*/
public class UserDao {
private Context context;
private Dao<User, Integer> userDao;
private DbHelper mHelper;
public UserDao(Context context){
this.context = context;
mHelper = DbHelper.getInstance(context);
try {
userDao = mHelper.getDao(User.class);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void addUser(User user){
try {
userDao.create(user);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void updateUser(User user){
try {
userDao.update(user);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void delete(User user){
try {
userDao.delete(user);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void deleteList(List<User> users){
try {
userDao.delete(users);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void updateUserByID(User user, Integer id){
try {
userDao.updateId(user, id);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void deleteByIDs(List<Integer> ids){
try {
userDao.deleteIds(ids);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void updateUserByID(User user, Integer id){
try {
userDao.updateId(user, id);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void updateUserByBuilder(User user, Integer id){
try {
UpdateBuilder<User, Integer> builder = userDao.updateBuilder();
builder .updateColumnValue("name",user.getName()).where().eq("id", id);
builder.update();
} catch (SQLException e) {
e.printStackTrace();
}
}
}