运行后报SELECT COUNT(*) AS total FROM t_user WHERE (customerCode = ? AND customerFullName = ? AND customer = ?)

根据你提供的报错信息，查询语句中的条件是 `customerCode = ? AND customerFullName = ? AND customer = ?`，其中 `?` 是占位符，需要传入具体的参数值。报错的原因可能是你没有正确设置参数值导致的。

请确保你在调用查询方法之前，通过 `wrapper.eq(fieldName, value)` 方法设置了正确的参数值。例如：

QueryWrapper<User> wrapper = new QueryWrapper<>();
wrapper.eq("customerCode", "ABC123");
wrapper.eq("customerFullName", "John Doe");
wrapper.eq("customer", "ACME Corp");

List<User> userList = userMapper.selectList(wrapper);

请根据你实际的业务需求和数据表结构，将上述示例中的字段名和参数值替换为正确的值。这样就能够进行精确查询了。

相关问题

优化以下这个试图，把2023-06-09作为变量传入，SELECT A.office_id AS distributorId, A.customer_code AS customerCode, A.erp_name AS customerName, A.total_amount AS totalAmount, A.trade_date AS tradeDate, A.customer_type AS customerType, "初次" AS is_first_deal FROM t_first_feedback A WHERE A.`status` = '已成交' AND A.trade_date IS NOT NULL AND A.trade_date >= DATE_FORMAT( DATE_SUB( '2023-06-09', INTERVAL 1 MONTH ), '%Y-%m-01' ) AND A.trade_date <= LAST_DAY( DATE_SUB( '2023-06-09', INTERVAL 1 MONTH )) UNION ALL SELECT B.office_id AS distributorId, B.customer_number AS customerCode, B.customer_name AS customerName, B.total_amount AS totalAmount, B.transaction_date AS tradeDate, "" AS customerType, "重复" AS is_first_deal FROM t_repeat_feedback B WHERE B.transaction_date IS NOT NULL AND B.transaction_date >= DATE_FORMAT( DATE_SUB( '2023-06-09', INTERVAL 1 MONTH ), '%Y-%m-01' ) AND B.transaction_date <= LAST_DAY( DATE_SUB( '2023-06-09', INTERVAL 1 MONTH ))

可以将'2023-06-09'作为参数传入SQL语句，避免硬编码，提高代码的可维护性和复用性。具体实现方式如下：

DECLARE @date DATE = '2023-06-09';

SELECT A.office_id AS distributorId,
       A.customer_code AS customerCode,
       A.erp_name AS customerName,
       A.total_amount AS totalAmount,
       A.trade_date AS tradeDate,
       A.customer_type AS customerType,
       "初次" AS is_first_deal
FROM t_first_feedback A
WHERE A.`status` = '已成交'
  AND A.trade_date IS NOT NULL
  AND A.trade_date >= DATE_FORMAT(DATE_SUB(@date, INTERVAL 1 MONTH), '%Y-%m-01')
  AND A.trade_date <= LAST_DAY(DATE_SUB(@date, INTERVAL 1 MONTH))
UNION ALL
SELECT B.office_id AS distributorId,
       B.customer_number AS customerCode,
       B.customer_name AS customerName,
       B.total_amount AS totalAmount,
       B.transaction_date AS tradeDate,
       "" AS customerType,
       "重复" AS is_first_deal
FROM t_repeat_feedback B
WHERE B.transaction_date IS NOT NULL
  AND B.transaction_date >= DATE_FORMAT(DATE_SUB(@date, INTERVAL 1 MONTH), '%Y-%m-01')
  AND B.transaction_date <= LAST_DAY(DATE_SUB(@date, INTERVAL 1 MONTH));

"/manage/platform/commodity/baseCommodity/purchaseCommodityList.html?&customerCode=customerCode"后端如何获取customerCode

在后端代码中，可以通过获取HTTP请求中的参数来获取customerCode。具体的实现方式可能因使用的编程语言和框架而异，以下是一些常见的实现方式：

- Java Spring框架：在Controller方法中通过@RequestParam注解获取customerCode参数，例如：

@GetMapping("/purchaseCommodityList.html")
public String purchaseCommodityList(@RequestParam("customerCode") String customerCode, Model model) {
    // 处理业务逻辑
    return "purchaseCommodityList";
}

- Python Django框架：在View函数中通过request.GET.get方法获取customerCode参数，例如：

from django.http import HttpResponse

def purchase_commodity_list(request):
    customer_code = request.GET.get('customerCode')
    # 处理业务逻辑
    return HttpResponse('purchaseCommodityList')

- Node.js Express框架：在路由处理函数中通过req.query获取customerCode参数，例如：

app.get('/manage/platform/commodity/baseCommodity/purchaseCommodityList.html', function (req, res) {
    var customerCode = req.query.customerCode;
    // 处理业务逻辑
    res.send('purchaseCommodityList');
});

希望这些示例能帮到你！