private static void fillDetail(DBCon dbCon, Staff staff, WxOrder wxOrder) throws SQLException, BusinessException { String sql; sql = " SELECT * FROM " + Params.dbName + ".weixin_order_food WHERE wx_order_id = " + wxOrder.getId(); dbCon.rs = dbCon.stmt.executeQuery(sql); while (dbCon.rs.next()) { OrderFood of = new OrderFood(); of.asFood().copyFrom(FoodDao.getById(staff, dbCon.rs.getInt("food_id"))); of.setCount(dbCon.rs.getFloat("food_count")); wxOrder.addFood(of); } dbCon.rs.close(); wxOrder.setMember(MemberDao.getByWxSerial(dbCon, staff, wxOrder.getWeixinSerial())); }