Java WhereBuilder类代码示例

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
/**
 * 删除所有 某字段 等于 vlaue 的值
 */
public <T> Observable<Integer> deleteWhere(final Class<T> cls, final String where, final String[] value) {
    return Observable.defer(new Func0<Observable<Integer>>() {
        @Override
        public Observable<Integer> call() {
            return Observable.just(liteOrm.delete(new WhereBuilder(cls).where(where + "=?", value)));
        }
    }).subscribeOn(Schedulers.io());
}
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
private void initView() {
    mWeathers = new ArrayList<>();
    mAdapter = new MultiCityAdapter(mWeathers);
    mRecyclerView.setLayoutManager(new LinearLayoutManager(getActivity()));
    mRecyclerView.setAdapter(mAdapter);
    mAdapter.setMultiCityClick(new MultiCityAdapter.onMultiCityClick() {
        @Override
        public void longClick(String city) {
            new AlertDialog.Builder(getActivity())
                .setMessage("是否删除该城市?")
                .setPositiveButton("删除", (dialog, which) -> {
                    OrmLite.getInstance().delete(new WhereBuilder(CityORM.class).where("name=?", city));
                    multiLoad();
                    Snackbar.make(getView(), String.format(Locale.CHINA, "已经将%s删掉了 Ծ‸ Ծ", city), Snackbar.LENGTH_LONG)
                        .setAction("撤销",
                            v -> {
                                OrmLite.getInstance().save(new CityORM(city));
                                multiLoad();
                            }).show();
                })
                .show();
        }

        @Override
        public void click(Weather weather) {
            DetailCityActivity.launch(getActivity(), weather);
        }
    });

    if (mRefreshLayout != null) {
        mRefreshLayout.setColorSchemeResources(
            android.R.color.holo_orange_light,
            android.R.color.holo_red_light,
            android.R.color.holo_green_light,
            android.R.color.holo_blue_bright
        );
        mRefreshLayout.setOnRefreshListener(() -> mRefreshLayout.postDelayed(this::multiLoad, 1000));
    }
}
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
private static Consumer<Throwable> disposeFailureInfo(Throwable t) {
    return throwable -> {
        if (t.toString().contains("GaiException") || t.toString().contains("SocketTimeoutException") ||
            t.toString().contains("UnknownHostException")) {
            ToastUtil.showShort("网络问题");
        } else if (t.toString().contains("API没有")) {
            OrmLite.getInstance()
                .delete(new WhereBuilder(CityORM.class).where("name=?", Util.replaceInfo(t.getMessage())));
            ToastUtil.showShort("错误: " + t.getMessage());
        }
        PLog.w(t.getMessage());
    };
}
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
public static void disposeFailureInfo(Throwable t) {
    if (t.toString().contains("GaiException") || t.toString().contains("SocketTimeoutException") ||
        t.toString().contains("UnknownHostException")) {
        ToastUtil.showShort("网络问题");
    } else if (t.toString().contains("API没有")) {
        OrmLite.getInstance().delete(new WhereBuilder(CityORM.class).where("name=?", Util.replaceInfo(t.getMessage())));
        PLog.w(Util.replaceInfo(t.getMessage()));
        ToastUtil.showShort(t.getMessage());
    }
    PLog.w(t.getMessage());
}
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
@OnClick(R.id.fav)
public void favoriteGril() {
    if (mIsGirlCollected) {
        MyApp.mLiteOrm.delete(GirlCollect.class,
                WhereBuilder.create(GirlCollect.class).equals("girlUrl", mMeizhiUrl));
        mIsGirlCollected = false;
        mFavFAB.setImageResource(R.mipmap.ab_fav_normal);
        toast("取消收藏妹纸...");
    } else {
        saveMeizhi();
        mFavFAB.setImageResource(R.mipmap.ab_fav_active);
        mIsGirlCollected = true;
        toast("成功收藏妹纸...");
    }   }
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
private void testDeleteByWhereBuilder() {
    // 删除 student-1
    liteOrm.delete(new WhereBuilder(Student.class)
            .where(Person.COL_NAME + " LIKE ?", new String[]{"%1%"})
            .and()
            .greaterThan("id", 0)
            .and()
            .lessThan("id", 10000));
}
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
private void testDeleteByWhereBuilder() {
    //AND关系 删掉 南京 的 香港路 第一种写法
    liteOrm.delete(WhereBuilder
            .create(Address.class)
            .equals(Address.COL_ADDRESS, "香港路")
            .andEquals(Address.COL_CITY, "南京"));

    //AND关系 删掉 南京 的 香港路 第二种写法
    liteOrm.delete(WhereBuilder
            .create(Address.class)
            .where("address=? AND city=?", new String[]{"香港路", "南京"}));

    //AND关系 删掉 南京 的 香港路 第三种写法
    liteOrm.delete(WhereBuilder
            .create(Address.class)
            .where("address=? AND city=?", "香港路", "南京"));

    printAllAddress();

    //OR关系 删掉所有地址为 香港路 ，同时删掉 青岛的所有地址
    liteOrm.delete(WhereBuilder
            .create(Address.class)
            .equals(Address.COL_ADDRESS, "香港路")
            .orEquals(Address.COL_CITY, "青岛"));
    printAllAddress();

    //IN语句 删掉所有城市为 杭州 或 北京的地址
    liteOrm.delete(WhereBuilder
            .create(Address.class)
            .in(Address.COL_CITY, new String[]{"杭州", "北京"}));
    printAllAddress();

    //IN语句 删掉所有 非香港路 并且 ID>10
    liteOrm.delete(WhereBuilder
            .create(Address.class)
            .equals(Address.COL_ADDRESS, "夫子庙")
            .and()
            .greaterThan(Address.COL_ID, 5));
    printAllAddress();
}
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
@Override
public void remove(String key) {

    Arad.db.getLiteOrm().delete(new WhereBuilder(SearchHistoryModel.class, "content=?", new String[]{key}));
}
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
@Override
public final boolean remove(String key) {
    int result = mLiteOrm.delete(new WhereBuilder(CacheEntry.class)
            .where(CacheEntry.COL_KEY + " = ?", "%"+key+"%"));
    return result > 0;
}
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
private void initView() {
    weatherArrayList = new ArrayList<>();
    mAdatper = new MultiCityAdapter(getActivity(), weatherArrayList);
    mRecyclerview.setLayoutManager(new LinearLayoutManager(getActivity()));
    mRecyclerview.setAdapter(mAdatper);
    mAdatper.setOnMultiCityLongClick(new MultiCityAdapter.onMultiCityLongClick() {
        @Override
        public void longClick(String city) {
            new AlertDialog.Builder(getActivity()).setMessage("是否删除该城市?")
                .setPositiveButton("删除", new DialogInterface.OnClickListener() {
                    @Override
                    public void onClick(DialogInterface dialog, int which) {
                        OrmLite.getInstance().delete(new WhereBuilder(CityORM.class).where("name=?", city));
                        OrmLite.OrmTest(CityORM.class);
                        multiLoad();
                        Snackbar.make(getView(), "已经将" + city + "删掉了 Ծ‸ Ծ", Snackbar.LENGTH_LONG).setAction("撤销",
                            new View.OnClickListener() {
                                @Override
                                public void onClick(View v) {
                                    OrmLite.getInstance().save(new CityORM(city));
                                    multiLoad();
                                }
                            }).show();
                    }
                })
                .show();
        }
    });

    if (mSwiprefresh != null) {
        mSwiprefresh.setOnRefreshListener(new SwipeRefreshLayout.OnRefreshListener() {
            @Override
            public void onRefresh() {
                mSwiprefresh.postDelayed(new Runnable() {
                    @Override
                    public void run() {
                        multiLoad();
                    }
                }, 1000);
            }
        });
    }
}
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
public static void deleteApp(AppInfo info) {
    NotificationBoxApp.getLiteOrm().delete(new WhereBuilder(AppInfo.class)
            .where("packageName = ?", info.getPackageName()));
}
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
public <T> int deleteByWhereBuilder(Class<T> clazz, String column, Object value) {
    LiteOrm lOrm = liteOrm.single();
    return lOrm.delete(new WhereBuilder(clazz).equals(column, value));
}
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
/**
 * 删除所有 某字段等于 Vlaue的值
 *
 * @param cla
 * @param field
 * @param value
 */
public static <T> int deleteWhere(Class<T> cla, String field, String[] value) {
    return liteOrm.delete(cla, new WhereBuilder(cla).where(field + "!=?", value));
}
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
/**
 * 删除所有 某字段等于 Vlaue的值
 *
 * @param cla
 * @param field
 * @param value
 */
public static <T> void deleteWhere(Class<T> cla, String field, String[] value) {
    sLiteOrm.delete(cla, WhereBuilder.create(cla).where(field + "=?", value));
}
 

import com.litesuits.orm.db.assit.WhereBuilder; //导入依赖的package包/类
/**
 * update model use custom where clause.
 *
 * @return number of affected rows
 */
int update(WhereBuilder builder, ColumnsValue cvs, ConflictAlgorithm conflictAlgorithm);