public List<OrderItem> selectByNo(int orderItemNo) throws SQLException {
List<OrderItem> list = new ArrayList<OrderItem>();
String sql = "select *from Orderproducts where Order_no=?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, orderItemNo);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
OrderItem orderitem = new OrderItem();
orderitem.setProductno(rs.getInt("product_no"));
orderitem.setOrderproductamount(rs.getInt("orderproduct_amount"));
list.add(orderitem);
}
rs.close();
pstmt.close();
return list;
}
