// 根据当前用户的用户名查订单
public List selectOrder(String name) {
List list = new ArrayList();
Order or = null;
DbUtil dao = new DbUtil();
PreparedStatement pre = null;
ResultSet re = null;
String sql = "select * from tb_order where name=?";
try {
pre = dao.getCon().prepareStatement(sql);
pre.setString(1, name);
re = pre.executeQuery();
while (re.next()) {
or = new Order();
User user = new User();
or.setOrderId(re.getInt("orderId"));
user.setName(re.getString("name"));
or.setRecvName(re.getString("recvName"));
user.setAddress(re.getString("address"));
user.setPostcode(re.getString("postcode"));
user.setEmail(re.getString("email"));
or.setUser(user);
or.setOrderDate(re.getString("orderDate"));
or.setFlag(re.getInt("flag"));
list.add(or);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
