Greendao的根据某个字段（非主键）插入去重以及根据某个字段删除对应的行条目

最新推荐文章于 2022-11-12 16:12:32 发布

原创

最新推荐文章于 2022-11-12 16:12:32 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Android #greendao

目前资料上greendao的删除基本都是根据主键删除的，如果我想通过里面一个字段比如name进行删除呢？下面是我对于全局搜索apk的一个greendao的小结。
1.删除某个字段的整条数据
简单封装下Greendao:

GreendaoUtil.java

public class GreendaoUtil {

    private volatile static GreendaoUtil ourInstance;

    private static String name = "search_history";

    public static final String SQL_DISTINCT_ENAME = "SELECT DISTINCT " + SearchHistoryDao.Properties.Text.columnName + " FROM " + SearchHistoryDao.TABLENAME;

    public static final String SQL_Delete = "DELETE FROM " + SearchHistoryDao.TABLENAME + " where text = ";

    private Context mContetx;
    private final DaoMaster mDaoMaster;
    private final DaoSession mDaoSession;

    public static GreendaoUtil getInstance() {
        if (null == ourInstance) {
            synchronized (GreendaoUtil.class) {
                if (null == ourInstance) {
                    ourInstance = new GreendaoUtil();
                }
            }
        }
        return ourInstance;
    }

    private Gree