sqllite事务update

最新推荐文章于 2024-05-02 14:49:30 发布

雜貨鋪老闆

最新推荐文章于 2024-05-02 14:49:30 发布

阅读量723

点赞数

分类专栏： Android

Android 专栏收录该内容

136 篇文章 1 订阅

订阅专栏

public boolean updateCartTable(String retailerName, String mCouponId){
        final ContentValues values = new ContentValues();

        values.put(TableConstantName.COUPON_ONLY_STATUS, 1);
        values.put(TableConstantName.COUPON_SRORE_DEALS_STATUS, 1);
        values.put(TableConstantName.COUPON_CATAGORY, "C");
        try {
            sDb.beginTransaction();
            final boolean state = sDb.update(TableConstantName.COUPON_TABLE, values, TableConstantName.CART_COUPON_RETAILER_NAME + "=" + "'"+retailerName+"'"+ " AND "+TableConstantName.CART_COUPON_ID + "=" + "'"+mCouponId+"'", null)>0;
            sDb.setTransactionSuccessful();
            return state;
        } catch (SQLException e) {
            throw e;
        } finally {
            sDb.endTransaction();
        }
    }