基于ormlite创建数据库存储数据案例

一直不知道安卓创建数据库存储数据，以前遇到过，但是没有深入研究，今天仔细的看了一下，学习到了一点知识

直接看代码了

public class DatabaseHelper extends OrmLiteSqliteOpenHelper{

    private static final String TABLE_NAME = "pspsp.db";
    private static final int DB_VERSION = 3;

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

    private DatabaseHelper(Context context)
    {
        super(context, TABLE_NAME, null, DB_VERSION);
    }
    @Override
    public void onCreate(SQLiteDatabase database, ConnectionSource connectionSource) {
        try
        {
            TableUtils.createTable(connectionSource, SearchHistroy.class);
         
        } catch (SQLException e)
        {
            e.printStackTrace();
        }
    }

    @Override
    public void onUpgrade(SQLiteDatabase database, ConnectionSource connectionSource, int oldVersion, int newVersion) {
        try
        {
            TableUtils.dropTable(connectionSource, SearchHistroy.class, true);
           
        } 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;
        }
    }

}

@DatabaseTable(tableName = "search_history")
public class SearchHistroy {

    @DatabaseField(generatedId = true)
    private int id;

    @DatabaseField
    private String name;

    private boolean isDelete=false;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public boolean isDelete() {
        return isDelete;
    }

    public void setIsDelete(boolean isDelete) {
        this.isDelete = isDelete;
    }

    //    @DatabaseField(canBeNull = true, foreign = true, columnName = "user_id")
//    private User user;
}

然后在dao中运用

public class SearchDao {

    private Context context;
    private Dao<SearchHistroy, Integer> userDaoOpe;
    private DatabaseHelper helper;

    public SearchDao(Context context) {
        this.context = context;
        try {
            helper = DatabaseHelper.getHelper(context);
            userDaoOpe = helper.getDao(SearchHistroy.class);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    /**
     * 增加一个用户
     *
     * @param model
     */
    public void add(SearchHistroy model) {
        try {


            SearchHistroy searchHistroy = userDaoOpe.queryBuilder().where().eq("name", model.getName()).queryForFirst();
            if (searchHistroy == null || StringUtils.isEmpty(searchHistroy.getName()) && !StringUtils.isEmpty(model.getName())) {
                userDaoOpe.create(model);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }


    /**
     * 清楚所有
     */
    public void deteAll() {
        try {
            userDaoOpe.deleteBuilder().delete();
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

    /**
     * 获取所有查询记录
     *
     * @return
     */
    public List<SearchHistroy> getAllList() {
        try {
            return userDaoOpe.queryForAll();
        } catch (SQLException e) {
            e.printStackTrace();
            return new ArrayList<SearchHistroy>();
        }
    }
}

具体运用

searchDao = new SearchDao(this);
        list = new ArrayList<SearchHistroy>();
//获取数据
 list = searchDao.getAllList();



//添加数据
 SearchHistroy histroy = new SearchHistroy();
                histroy.setName(strValue);
                searchDao.add(histroy);

//删除数据
searchDao.deteAll();