// 根据订单号查订单项 public List selectOrderItem(int id) { List list = new ArrayList(); OrderItem ordetrItem = null; DbUtil dao = new DbUtil(); PreparedStatement pre = null; ResultSet re = null; String sql = "select * from tb_orderItem where orderId = ? "; try { pre = dao.getCon().prepareStatement(sql); pre.setInt(1, id); re = pre.executeQuery(); while (re.next()) { ordetrItem = new OrderItem(); ordetrItem.setBookId(re.getInt("bookId")); ordetrItem.setBookName(re.getString("bookName")); ordetrItem.setBookNum(re.getInt("bookNum")); ordetrItem.setOrderId(re.getInt("orderId")); ordetrItem.setOrderItemId(re.getInt("orderItemId")); ordetrItem.setPrice(re.getFloat("price")); list.add(ordetrItem); } } catch (Exception e) { } return list; }