Android 快速开发系列 ORMLite 框架最佳实践

680 查看

上一篇已经对ORMLite框架做了简单的介绍：Android ORMLite 框架的入门用法~~本篇将介绍项目可能会使用到的一些用法，也为我们的使用ORMLite框架总结出一个较合理的用法。

通过上一篇的了解，我们使用ORMLite，需要自己写一个DatabaseHelper去继承OrmLiteSqliteOpenHelper，下面我们首先给出一个我认为比较靠谱的Helper的写法：

1、DatabaseHelper

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

package com.zhy.zhy_ormlite.db;

import java.sql.SQLException;

import java.util.HashMap;

import java.util.Map;

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 com.zhy.zhy_ormlite.bean.Article;

import com.zhy.zhy_ormlite.bean.Student;

import com.zhy.zhy_ormlite.bean.User;

public class DatabaseHelper extends OrmLiteSqliteOpenHelper

{

private static final String TABLE_NAME = "sqlite-test.db";

private Map<String, Dao> daos = new HashMap<String, Dao>();

private DatabaseHelper(Context context)

{

super(context, TABLE_NAME, null, 4);

}

@Override

public void onCreate(SQLiteDatabase database,

ConnectionSource connectionSource)

{

try

{

TableUtils.createTable(connectionSource, User.class);

TableUtils.createTable(connectionSource, Article.class);

TableUtils.createTable(connectionSource, Student.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);

TableUtils.dropTable(connectionSource, Article.class, true);

TableUtils.dropTable(connectionSource, Student.class, true);

onCreate(database, connectionSource);

通过上一篇的了解，我们使用ORMLite，需要自己写一个DatabaseHelper去继承OrmLiteSqliteOpenHelper，下面我们首先给出一个我认为比较靠谱的Helper的写法：

1、DatabaseHelper

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

package com.zhy.zhy_ormlite.db;

import java.sql.SQLException;

import java.util.HashMap;

import java.util.Map;

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 com.zhy.zhy_ormlite.bean.Article;

import com.zhy.zhy_ormlite.bean.Student;

import com.zhy.zhy_ormlite.bean.User;

public class DatabaseHelper extends OrmLiteSqliteOpenHelper

{

private static final String TABLE_NAME = "sqlite-test.db";

private Map<String, Dao> daos = new HashMap<String, Dao>();

private DatabaseHelper(Context context)

{

super(context, TABLE_NAME, null, 4);

}

@Override

public void onCreate(SQLiteDatabase database,

ConnectionSource connectionSource)

{

try

{

TableUtils.createTable(connectionSource, User.class);

TableUtils.createTable(connectionSource, Article.class);

TableUtils.createTable(connectionSource, Student.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);

TableUtils.dropTable(connectionSource, Article.class, true);

TableUtils.dropTable(connectionSource, Student.class, true);

onCreate(database, connectionSource);

ine="crayon-5812c27b027c3170769743-51">51