结果集要列出 null [duplicate]-解网

问：

去年关闭。

public List<Order> getAllOrdersByCustomerId(int customerId) throws SQLException {
    List<Order> AllOrdersByCustomerId = new ArrayList<>();
    Connection con = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;


    try {
        String sqlQuery = "SELECT * FROM dbo.Orders WHERE customer_id = ?";
        con = JDBCConnection.getConnection();
        pstmt = con.prepareStatement(sqlQuery);
        pstmt.setInt(1, customerId);
        pstmt.executeUpdate();
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        if (con != null) {
            JDBCConnection.closeConnection(con);
        }
        if (rs != null) {
            JDBCConnection.closeResultSet(rs);
        }
    }
    return AllOrdersByCustomerId;
}

线程“main”java.lang.NullPointerException 中的异常：无法调用“java.util.List.iterator（）”，因为“lo”为 null

java 列表 arraylist nullpointerException 结果集

public List<Order> getAllOrdersByCustomerId(int customerId) throws SQLException {
    List<Order> allOrdersByCustomerId = new ArrayList<>();
    String sqlQuery = "SELECT * FROM dbo.Orders WHERE customer_id = ?";
    try (Connection con = JDBCConnection.getConnection();
        PreparedStatement pstmt = con.prepareStatement(sqlQuery)) {
        pstmt.setInt(1, customerId);
        try (ResultSet rs = pstmt.executeQuery()) {
            while (rs.next()) {
                Order order = new Order();
                String id = rs.getString("ORDER_ID");
                order.setId(id);

                // get and set your values ...

                allOrdersByCustomerId.add(order);
            }
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
    return allOrdersByCustomerId;
}

上一个：线程主 java.lang.NullPointerException 在 Runner.takeInput（Runner.java：24）在 Runner.main（Runner.java：55） [重复]

下一个：使用 Intent 的 ArrayList 上的 Android Studio 空指针异常

结果集要列出 null [duplicate]

Resultset To List null [duplicate]

评论