Android使用Ormlite

一、概述：
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();
        }
    }
}