java - 准备好的语句错误 : ORA-00936: missing expression

Question

我准备好的声明有点问题。我收到错误 ORA-00936:执行 executeQuery() 时缺少表达式。你能告诉我我错过了什么吗？

在我的类构造函数中。

private PreparedStatement reachOperation;
reachOperation = connection.prepareStatement("SELECT * FROM operations WHERE account_id = ? AND (date BETWEEN ? AND ?)");

我的方法。

  public List<Operation> getOperations(int number, Date from, Date to)
          throws DataStoreException {

            ArrayList <Operation> result = new ArrayList<Operation>();

        try {

            java.sql.Date debut = new java.sql.Date(from.getTime());
            java.sql.Date fin   = new java.sql.Date(to.getTime());


            reachOperation.setInt(1,number);
            reachOperation.setDate(2,debut);
            reachOperation.setDate(3,fin);


            ResultSet rs = reachOperation.executeQuery();
            while(rs.next()){

            result.add(new Operation(rs.getInt(2),rs.getDouble(3),rs.getDate(4))); 

            }
            rs.close();
            return result;

        } catch (SQLException error) {
            error.printStackTrace();
            return result;
      }

  }

方法的调用

    List<Operation>operations = new ArrayList<>();
              operations = manager.getOperations(1, minDate, maxDate);

// check just do prinln depending of the result of the boolean expression
              check("Blahblahblah", operations != null && operations.size() == 1);
              System.out.println("orders = " + operations);

Answer 1

date 是许多 RDBMS(包括 Oracle)中的保留关键字，您应该使用双引号将其转义 "(也应使用 \ 如果字符串是用双引号创建的):

reachOperation = connection.prepareStatement("SELECT * FROM operations WHERE
                      account_id = ? AND (\"date\" BETWEEN ? AND ?)");