ORMLite系列---第一篇

1 下载Jar包，添加依赖：

    ormlite-android-4.48.jar
    ormlite-core-4.48.jar

2 关键代码如下：

DataBaseHelper
public class DataBaseHelper extends OrmLiteSqliteOpenHelper {
    private static final String DB_NAME = "aaaaa.db";
    private static final int DATABASE_VERSION = 1;


    public DataBaseHelper(Context context) {
        super(context, DB_NAME, null, DATABASE_VERSION);
    }

    public DataBaseHelper(Context context, String databaseName, SQLiteDatabase.CursorFactory factory, int databaseVersion) {
        super(context, DB_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase, ConnectionSource connectionSource) {
        try {
            TableUtils.createTable(connectionSource, WebInfoBean.class);
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, ConnectionSource connectionSource, int i, int i1) {
        try {
            TableUtils.dropTable(connectionSource, WebInfoBean.class, true);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
//        }
        }
    }

    private static DataBaseHelper helper;

    public static DataBaseHelper getHelper(final Context context) {
        if (helper == null) {
            synchronized (DataBaseHelper.class) {
                if (helper == null) {
                    helper = new DataBaseHelper(context);
                }
            }
        }
        return helper;
    }
}

 实体类：
@DatabaseTable(tableName = "webinfo")
public class WebInfoBean implements Serializable {
    @DatabaseField(id = true)
    public long id;
    @DatabaseField
    public String user_id;
    @DatabaseField
    public String name;
}

Dao方法：
public class WebInfoDao {
    private static Dao<WebInfoBean, Integer> webInfoDao;


    public static Dao<WebInfoBean, Integer> getWebInfoDao(Context context) {
        if (webInfoDao == null) {
            try {
                webInfoDao = DataBaseHelper.getHelper(context).getDao(WebInfoBean.class);
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
            }
        }
        return webInfoDao;
    }

    public static int webInfoInsert(Context context, WebInfoBean authLoginBean) {
        int result = 0;
        try {
            result = getWebInfoDao(context).create(authLoginBean);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return result;
    }

    public static WebInfoBean webInfoQuery(Context context) {
        WebInfoBean bean = new WebInfoBean();
        try {
            List<WebInfoBean> list = getWebInfoDao(context).queryForAll();
            if (list.size() > 0) {
                bean = list.get(0);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return bean;
    }

    public static List<WebInfoBean> webInfoQueryList(Context context) {
        List<WebInfoBean> listResult = new ArrayList<>();
        try {
            List<WebInfoBean> list = getWebInfoDao(context).queryForAll();
            listResult.addAll(list);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return listResult;
    }


    public static void exit(Context context) {
        try {
            List<WebInfoBean> list = getWebInfoDao(context).queryForAll();
            getWebInfoDao(context).delete(list);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

---

补充：Dao方法还可抽象下，写的更通用些。

---