// 根据订单号查订单项
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;
}
