public ArrayList<ShoppingCate> querryFlavorEat() throws Exception { ArrayList<ShoppingCate> shoppingCates = new ArrayList<ShoppingCate>(); Connection connection = null; ShoppingCate shoppingCate = null; try { connection = WbJdbcUtil.getConnection(); ResultSet resultSet = WbJdbcUtil.querryFlavorEat(connection); if (resultSet != null) { while (resultSet.next()) { int cate_id = resultSet.getInt("cate_id"); String cate_name = resultSet.getString("cate_name"); int cate_inventory = resultSet.getInt("cate_inventory"); int cate_sale_count = resultSet.getInt("cate_sale_count"); String cate_description = resultSet.getString("cate_description"); double cate_oldprice = resultSet.getDouble("cate_oldprice"); double cate_price = resultSet.getDouble("cate_price"); int cate_image_id = resultSet.getInt("cate_image_id"); int category_id = resultSet.getInt("category_id"); int flavor_category_id = resultSet.getInt("flavor_category_id"); String cate_sale_info = resultSet.getString("cate_sale_info"); shoppingCate = new ShoppingCate( cate_id, cate_name, cate_inventory, cate_sale_count, cate_description, cate_oldprice, cate_price, cate_image_id, category_id, flavor_category_id, cate_sale_info); shoppingCates.add(shoppingCate); } } } catch (Exception e) { e.printStackTrace(); } finally { if (connection != null) { WbJdbcUtil.closeConnection(connection); } } return shoppingCates; }