sql - Android Sqlite:无法解决查询中的语法错误

Question

我在每个选项卡上更新购物车，在代码中更新购物车项目，但语法错误。

 ContentValues values = new ContentValues();
    DbHelper dbHelper = new DbHelper(context);

    SQLiteDatabase database;
    database=  dbHelper.getWritableDatabase();

    values.put(DbConstants.COLUMN_MEMBER, cartItemBean.getCOLUMN_MEMBER());
    values.put(DbConstants.COLUMN_DATE, cartItemBean.getCOLUMN_DATE());
    values.put(DbConstants.COLUMN_TIME, cartItemBean.getCOLUMN_TIME());

    String sql2 = "UPDATE " + DbConstants.TABLE_CART + " SET " +
            DbConstants.COLUMN_MEMBER + " = '" + cartItemBean.getCOLUMN_MEMBER() + "' AND "
            + DbConstants.COLUMN_DATE + " = '" + cartItemBean.getCOLUMN_DATE() + "' AND "
            + DbConstants.COLUMN_TIME + " = '" + cartItemBean.getCOLUMN_TIME() + "' AND "
            + DbConstants.COLUMN_TOTAL_PRICE + " = '" + cartItemBean.getCOLUMN_TOTAL_PRICE() + "' AND "
            + "' WHERE " +
            DbConstants.COLUMN_PACKID + " = '" + cartItemBean.getCOLUMN_PACKID() + "' AND "
            + DbConstants.COLUMN_USERID + " = '" + cartItemBean.getCOLUMN_USERID() + "'";

     database.execSQL(sql2);

Answer 1

您添加的是AND而不是comma，将其删除将解决问题。

将查询更改为：

String sql2 = "UPDATE " + DbConstants.TABLE_CART + " SET " +
        DbConstants.COLUMN_MEMBER + " = '" + cartItemBean.getCOLUMN_MEMBER() + "', "
        + DbConstants.COLUMN_DATE + " = '" + cartItemBean.getCOLUMN_DATE() + "', "
        + DbConstants.COLUMN_TIME + " = '" + cartItemBean.getCOLUMN_TIME() + "', "
        + DbConstants.COLUMN_TOTAL_PRICE + " = '" + cartItemBean.getCOLUMN_TOTAL_PRICE() + "' "
        + " WHERE " +
        DbConstants.COLUMN_PACKID + " = '" + cartItemBean.getCOLUMN_PACKID() + "' AND "
        + DbConstants.COLUMN_USERID + " = '" + cartItemBean.getCOLUMN_USERID() + "'";

检查此 tutorial中的样本。