android 数据库使用之OrmLite

public class DatabaseHelper extends OrmLiteSqliteOpenHelper {

	/** 数据库版本号 */
	private static final int DATABASE_VERSION = 2;
<span style="white-space:pre">	</span>/** 数据库名称 */
<span style="white-space:pre">	</span>public static final String DATABASE_NAME = "fframework.db";
	public DatabaseHelper(Context context) {
		super(context,DATABASE_NAME, null, DATABASE_VERSION);
	}

	private static DatabaseHelper mHelper;

	/**
	 * 三分钟自动释放的 OpenHelper
	 * 
	 * @return
	 */
	public static DatabaseHelper getOpenHelper() {
//		resetTimer();
//		if(Thread.currentThread() == Looper.getMainLooper().getThread()){
//			throw new IllegalArgumentException("主线程不能进行数据库操作！");
//		}
		if (mHelper != null) {
			return mHelper;
		}
		return mHelper = OpenHelperManager.getHelper(FFApplication.app,
				DatabaseHelper.class);
	}

	private static Timer timer;
	private static int freeTime = 0;

<span style="white-space: pre;">	</span>//计时器，计时数据库在改时间内关闭

	private static void resetTimer() {
		if (timer == null) {
			timer = new Timer();
			timer.schedule(new TimerTask() {

				@Override
				public void run() {
					freeTime++;
					if (freeTime > 180) {
						timer.cancel();
						timer = null;
						freeTime = 0;
						mHelper.close();
						mHelper = null;
					}

				}
			}, 1000, 1000);
		} else {
			freeTime = 0;
		}
	}
<span style="white-space:pre">	</span>//创建数据库，这里创建了三个表
	@Override
	public void onCreate(SQLiteDatabase sqliteDatabase,
			ConnectionSource connectionSource) {
		try {
			TableUtils.createTable(connectionSource, Queue.class);
			TableUtils.createTable(connectionSource, Table.class);
			TableUtils.createTable(connectionSource, Sound.class);
			Dao<Queue, Integer> dao = DaoManager.createDao(connectionSource,
					Queue.class);
			Dao<Table, Integer> dao1 = DaoManager.createDao(connectionSource,
					Table.class);
		} catch (SQLException e) {
			Log.e(DatabaseHelper.class.getName(), "Unable to create datbases",
					e);
		}
	}
<span style="white-space:pre">	</span>//更新数据库
	@Override
	public void onUpgrade(SQLiteDatabase db, ConnectionSource connectionSource,
			int oldVer, int newVer) {
	}

}

private static final ExecutorService taskExecutor = Executors
.newSingleThreadExecutor();
 public static interface DbTask {
  void onExecut();
  void onOK();
 }
 private static class Execution implements Runnable {
  private DbTask task;
  public Execution(DbTask task) {
   this.task = task;
  }
  @Override
  public void run() {
   task.onExecut();
   FFApplication.runOnUiThread(new CallBack(task));
  }
 }
 private static class CallBack implements Runnable {
  private DbTask task;
  public CallBack(DbTask task) {
   this.task = task;
  }
  @Override
  public void run() {
   task.onOK();
  }
 }
 public static void executTask(final DbTask task) {
  taskExecutor.execute(new Execution(task));
 }