我在mysql中有三个表，即user、restaurants和cartlist。
用户表用于保存用户详细信息。餐厅餐桌是为了节省用餐的细节，价格和数量。cartlist将添加餐厅详细信息。现在当特定用户登录到应用程序时，我希望将特定用户的cartlist项添加到列表中。但我得到的细节，整个用户谁添加项目到购物车。

show.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View view) {

            String selectQuery = "SELECT * FROM restaurants";
            SQLiteDatabase database = DatabaseManager.getInstance().openDatabase();
            Cursor cursor = database.rawQuery(selectQuery, null);

            if (cursor.moveToFirst()) {
                do {
                    ProductModel productModel = new ProductModel();
                    productModel.setID(Integer.parseInt(cursor.getString(0)));

                    productModel.setName(cursor.getString(1));
                    productModel.setMealname(cursor.getString(2));
                    productModel.setMealprice(cursor.getString(3));
                    productModel.setMealqty(cursor.getString(4));

                    products.add(productModel);

                } while (cursor.moveToNext());
            }

            cursor.close();
            DatabaseManager.getInstance().closeDatabase();

            adapter = new ProductAdapter(ProductList.this, R.layout.activity_cartlistview, products);
            listview.setAdapter(adapter);
            adapter.notifyDataSetChanged();
        }
    });

推车：

protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_checkout);

    lv_checkout = findViewById(R.id.lv_checkout);
    tv_totalamount = findViewById(R.id.tv_totalamount);
    btn_checkouttopayment = findViewById(R.id.btn_checkouttopayment);

    String selectQuery = "SELECT * FROM carttable";
    SQLiteDatabase database = DatabaseManager.getInstance().openDatabase();
    Cursor cursor = database.rawQuery(selectQuery, null);

    if (cursor.moveToFirst()) {
        do {
            ProductModel productModel = new ProductModel();
            productModel.setID(Integer.parseInt(cursor.getString(0)));

            productModel.setName(cursor.getString(1));
            productModel.setMealname(cursor.getString(2));
            productModel.setMealprice(cursor.getString(3));
            productModel.setMealqty(cursor.getString(4));
            productModel.setMealtotal((Double.parseDouble(cursor.getString(3)) * Double.parseDouble(cursor.getString(4)) + ""));

            products.add(productModel);

        } while (cursor.moveToNext());
    }

    double totalPrices = 0;

    for (int i = 0; i < products.size(); i++) {

        totalPrices += Double.parseDouble(products.get(i).getMealtotal());
    }

    tv_totalamount.setText("Total Amount to be Paid : " + totalPrices + "");
    cursor.close();
    DatabaseManager.getInstance().closeDatabase();

    adapter = new ProductAdapter(this, R.layout.activity_cartlistview, products);
    lv_checkout.setAdapter(adapter);
    adapter.notifyDataSetChanged();
}

要对查询执行哪些更改？让我知道，伙计们。蒂亚！