读取操作不起作用。 Postgres 数据库和 Java。 （JAX-WS、SOAP）

Question

我的想法是，我需要创建一个 READ 操作，该操作应按订单 ID 从数据库获取订单。

这是我的 OrderDao 类方法：

@Override public Order read(int orderId) throws SQLException {

    Order order = null;

    //declare and initialize variables
    int orderid = 0; String description = "error"; float amount = 0; boolean delivered = false;

    //Create a statement using connection object

    PreparedStatement statement = conn.prepareStatement("SELECT orderid, description, amount, delivered FROM orders WHERE orderid = ");
    // Set orderid in SQL statement to a parameter(orderId) that was passed when calling the READ method.
    statement.setInt(1, orderId);

    //Execute the query above (statement)
    ResultSet resultSet = statement.executeQuery();

    System.out.println("test outside while");

    // Process the ResultSet object.
    if (resultSet.next())
    {
        orderid = resultSet.getInt("orderid");
        description = resultSet.getString("description");
        amount = resultSet.getInt("amount");
        delivered = resultSet.getBoolean("delivered");
        order = new Order(orderId, description, amount, delivered);

        System.out.println("test inside while");
    }
    return order;
    }

这是我尝试从 DBS 访问并获取此信息的客户端：

public class Client {

public static void main(String[] args) throws MalformedURLException, SQLException {
    URL WSDL_URL = new URL("http://localhost:8080/Dao?WSDL");
    QName SERVICE_NAME = new QName("http://service.orderSystem/", " DaoManageOrders ");

    //CREATE THE JAXWS (CXF)supplied service
    Service service = Service.create(WSDL_URL, SERVICE_NAME);
    System.out.println("SOAP Service is now CREATED...");

    Dao os = service.getPort(Dao.class); // GET PORT ALWAYS SPECIFIES INTERFACE, ELSE YOU WILL GET exception
    System.out.println("=========================");

    //WE CREATE ORDERS HERE:
    Order order1 = new Order(1,"Beer", 200, false);
    Order read = new Order();
    read.setDescription(os.read(1).getDescription());
    System.out.println(read.getDescription());

我无法理解为什么会收到这些异常：

Exception in thread "main" javax.xml.ws.soap.SOAPFaultException: Marshalling Error: java.sql.SQLException is not known to this context
at org.apache.cxf.jaxws.JaxWsClientProxy.mapException(JaxWsClientProxy.java:195)
at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:145)
at jdk.proxy2/jdk.proxy2.$Proxy30.read(Unknown Source)
at orderSystem.client.Client.main(Client.java:31)

Answer 1

我修复了它：

SQL 查询缺少“？” OrderDao 类中的运算符。另外，为了数据传输对象类，我将其放入字符串方法 -​​ 更有意义。