您的SQL语法有错误;检查与MariaDB服务器版本对应的手册，以便在第1行'?'附近使用正确的语法

2 回答

• 0

  ResultSet rsOrders = stmt2.executeQuery(ordersquery);
  

  stmt2是你的SQL查询然后为什么你传递 ordersquery 将你的代码更改为下面的代码

  ResultSet rsOrders = stmt2.executeQuery();
  

  回复于 2024-04-19T15:39:32+08:00
• 0

  看来你使用了错误的sytax来执行executeQuery（） . 它不期望参数 . 试试下面的代码 . 你应该好

  public static void SearchUser() throws SQLException{
  
      String ordersquery = "SELECT * FROM orders WHERE submittedBy = ?";
      User userDetails = UserController.getUserDetails(username);//gets the details from user tables
      if (userDetails != null){
          System.out.println("----Menu----");
          System.out.println();
          System.out.println("1. View Orders Made By This User");
          System.out.println("2. View Most Expensive Parts Currently Taken Out By This User");
          System.out.println();
          System.out.println("9. Go Back To Main Menu");
          choice = input.nextLine();
  
          if (choice.equals("1")){
              try (
                      PreparedStatement stmt2 = conn.prepareStatement(ordersquery);
  
                      ){
  
                  stmt2.setInt(1, userDetails.getUserId());
                  ResultSet rsOrders = stmt2.executeQuery();
                  if (rsOrders != null){
                      while (rsOrders.next()){
                          Order orderDetails = new Order(rsOrders.getInt("orderId"), userDetails.getUserId(), rsOrders.getInt("totalItems"), rsOrders.getInt("totalPrice"));
                          System.out.println("-------------------------------------");
                          Order.print(orderDetails);
                      }
                  }
              }catch (SQLException e){
                  System.err.println(e);
              }
          }else if (choice.equals("2")){
  
          }
      }
  
  }
  

  回复于 2024-04-19T15:39:32+08:00