java - mysql 之间和通过 JDBC preparedstatement 使用 - 获取参数索引超出范围异常

Question

从 select 查询中参数化了值(带有 BETWEEN 和 AND 的日期值)

我的问题

SELECT COUNT(*) AS assignedtotalcount FROM ticket, ticket_data
WHERE ticket.`ticket_id` = ticket_data.`ticket_id`
AND ticket.`created` BETWEEN '?' AND '?'

从上面的查询参数化了 BETWEEN , AND 中的值

Java代码

static String dateFrom = "2018-01-01";
static String dateTo = "2018-01-31";
String query = reportQuery.toString();
statement = connection.createStatement();
preparedStatement = connection.prepareStatement(query);
preparedStatement.setString(1, dateFrom);
preparedStatement.setString(2, dateTo);
resultSet = preparedStatement.executeQuery(query);

执行时出现以下异常

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).

请帮我解决

Answer 1

不要引用占位符。您需要将 '?' 更改为 ?。

所以查询变成这样

SELECT COUNT(*) AS assignedtotalcount FROM ticket, ticket_data
WHERE ticket.`ticket_id` = ticket_data.`ticket_id`
AND ticket.`created` BETWEEN ? AND ?