sqlite java orm_sqlite ORMLite 框架应用

package com.test.deamo.utils.db;

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.test.deamo.bean.Account;

import java.sql.SQLException;

import java.util.HashMap;

import java.util.Map;/**

* Created by administrator

* Description 数据库操作封装

* 2016/4/27 9:06.*/public class DatabaseHelper extends OrmLiteSqliteOpenHelper {

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

private Map daos = new HashMap();

private DatabaseHelper(Context context)

{

super(context, TABLE_NAME,null, 4);

}

@Override

public void onCreate(SQLiteDatabase database,

ConnectionSource connectionSource)

{

try

{

TableUtils.createTable(connectionSource, Account.class);

} catch (SQLException e)

{

e.printStackTrace();

}

}

@Override

public void onUpgrade(SQLiteDatabase database,

ConnectionSource connectionSource,int oldVersion, intnewVersion)

{

try

{

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

onCreate(database, connectionSource);

} catch (SQLException e)

{

e.printStackTrace();

}

}

private static DatabaseHelper instance;/**

* 单例获取该Helper

*

* @param context

* @return*/public static synchronized DatabaseHelper getHelper(Context context)

{

context=context.getApplicationContext();if (instance == null)

{

synchronized (DatabaseHelper.class)

{if (instance == null)

instance=new DatabaseHelper(context);

}

}

return instance;

}

public synchronized Dao getDao(Class clazz) throws SQLException

{

Dao dao= null;

String className=clazz.getSimpleName();if(daos.containsKey(className))

{

dao=daos.get(className);

}if (dao == null)

{

dao=super.getDao(clazz);

daos.put(className, dao);

}

return dao;

}/**

* 释放资源*/@Override

public void close()

{

super.close();for(String key : daos.keySet())

{

Dao dao=daos.get(key);

dao= null;

}

}

}