public void addOrder(Order order) throws Exception {
PreparedStatement pst = DBUtils.getConnection().prepareStatement(add);
pst.setInt(1, order.getAddress().getUser().getId());
pst.setInt(2, order.getStatus());
pst.setLong(3, order.getTime());
pst.setDouble(4, order.getTotal());
pst.setString(5, order.getAddress().getName());
pst.setString(6, order.getAddress().getAddress());
pst.setString(7, order.getAddress().getPostalCode());
pst.setString(8, order.getAddress().getMobile());
pst.setString(9, order.getAddress().getPhone());
pst.executeUpdate();
}
public List<Category> findAll() throws Exception {
PreparedStatement pst = DBUtils.getConnection().prepareStatement(findAll);
ResultSet rs = pst.executeQuery();
List<Category> list = new ArrayList<Category>();
while (rs.next()) {
Category cat = new Category();
cat.setId(rs.getInt("id"));
cat.setEnName(rs.getString("en_name"));
cat.setName(rs.getString("name"));
cat.setTurn(rs.getInt("turn"));
cat.setDescription(rs.getString("description"));
cat.setParentId(rs.getInt("parent_id"));
list.add(cat);
}
// DBUtils.closeConnection();
return list;
}