@Override
public Order getOrder(int orderid) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
Order order = null;
String sql = "select * from orders where orderid = ?";
try {
conn = JdbcUtil.getConnection();
ps = conn.prepareStatement(sql);
ps.setInt(1, orderid);
rs = ps.executeQuery();
if (rs.next()) {
int orderId = rs.getInt("orderId");
String username = rs.getString("username");
String phone = rs.getString("phone");
Date ordertime = rs.getDate("ordertime");
float totalprices = rs.getFloat("totalprices");
int status = rs.getInt("status");
order = new Order();
order.setOrderId(orderId);
order.setUsername(username);
order.setTelephone(phone);
order.setTime(ordertime);
order.setTotalPrices(totalprices);
order.setStatus(status);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
JdbcUtil.free(rs, ps, conn);