<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                # 綜合應用 > 結合之前所學知識,運用 SQL 語言完成一個實例應用的數據操作,重點是了解在應用程序中,如何構建數據查詢語句。 > 任何基于數據庫的應用程序類型,包括 B/S 架構、 C/S 架構、APP 應用,其實歸根結底都是用不同的界面或者形式完成對數據庫中數據的操作,所以,了解數據中應用的處理過程很重要。 一個典型的應用程序,包含的功能有: * 基礎數據維護:一般通過初始化完成部分數據,后續再次維護; * 業務流程處理:一般通過具體的功能模塊完成; * 數據分析和報表:通過相關復雜的查詢完成,使用視圖,或者緩存統計報表。 下面,我們從上一章節中的訂餐系統進行延伸,模擬系統的數據操作過程等。 ## 表結構及數據 ~~~sql /* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 80018 Source Host : localhost:3306 Source Schema : order Target Server Type : MySQL Target Server Version : 80018 File Encoding : 65001 Date: 15/11/2019 20:45:28 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_employee -- ---------------------------- DROP TABLE IF EXISTS `t_employee`; CREATE TABLE `t_employee` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sex` int(1) NULL DEFAULT NULL, `id_card` varchar(23) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `age` int(2) NULL DEFAULT NULL, `come_time` date NULL DEFAULT NULL, `post_id` int(11) NULL DEFAULT NULL, `telephone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `address` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `restaurant_id` int(11) NULL DEFAULT NULL, `work_time` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `education` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `is_marry` int(1) NULL DEFAULT NULL COMMENT '0未婚,1已婚', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_employee -- ---------------------------- INSERT INTO `t_employee` VALUES (1, '趙柳', 1, '3206231991067128212', 30, '2017-01-13', 1, '12345678910', '南通', 1, 'AM9:00-PM10:30', '本科', 1); INSERT INTO `t_employee` VALUES (2, '勘誤', 0, '3206231991067128212', 30, '2017-01-13', 2, '12345678910', '南通', 1, 'AM9:00-PM10:30', '高中', 1); INSERT INTO `t_employee` VALUES (3, '看晚會', 0, '3206231991067128212', 30, '2017-01-13', 2, '12345678910', '南通', 1, 'AM9:00-PM10:30', '高中', 1); INSERT INTO `t_employee` VALUES (4, '吳昕', 1, '3206231991067128212', 30, '2017-01-13', 3, '12345678910', '南通', 1, 'AM9:00-PM9:30', '大專', 1); -- ---------------------------- -- Table structure for t_kitchen -- ---------------------------- DROP TABLE IF EXISTS `t_kitchen`; CREATE TABLE `t_kitchen` ( `id` int(11) NOT NULL AUTO_INCREMENT, `restaurant_id` int(11) NULL DEFAULT NULL, `employee_id` int(11) NULL DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `marchine_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_kitchen -- ---------------------------- INSERT INTO `t_kitchen` VALUES (1, 1, 4, '紅案', 'wuhbd287bnsdh8', '湯菜'); INSERT INTO `t_kitchen` VALUES (2, 1, 4, '白案', 'weub27846bdf7', '中式面點'); INSERT INTO `t_kitchen` VALUES (3, 1, 4, '紅案', 'weub2347884b734b', '炒菜'); -- ---------------------------- -- Table structure for t_member -- ---------------------------- DROP TABLE IF EXISTS `t_member`; CREATE TABLE `t_member` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '會員名稱', `sex` int(11) NULL DEFAULT NULL COMMENT '性別(0為女,1為男)', `birthday` date NULL DEFAULT NULL COMMENT '會員生日', `telephone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手機', `aviod_food` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '忌口', `taste_like` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '口味喜好', `isCar` int(11) NULL DEFAULT NULL COMMENT '是否有車(0為無,1為有)', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_member -- ---------------------------- INSERT INTO `t_member` VALUES (1, '張三', 1, '1993-02-11', '14672398712', '酸', '甜', 1); INSERT INTO `t_member` VALUES (2, '李四', 1, '1993-02-11', '14672392112', '苦', '甜', 1); INSERT INTO `t_member` VALUES (3, '王五', 1, '1993-02-11', '14672392112', '苦', '甜', 1); -- ---------------------------- -- Table structure for t_member_analysis -- ---------------------------- DROP TABLE IF EXISTS `t_member_analysis`; CREATE TABLE `t_member_analysis` ( `id` int(11) NOT NULL AUTO_INCREMENT, `member_id` int(11) NULL DEFAULT NULL COMMENT '會員表主鍵', `count_time` int(11) NULL DEFAULT NULL COMMENT '消費次數', `count_money` decimal(10, 6) NULL DEFAULT NULL COMMENT '消費金額', `wechat_money` decimal(10, 6) NULL DEFAULT NULL, `zfb_money` decimal(10, 6) NULL DEFAULT NULL, `count` decimal(10, 6) NULL DEFAULT NULL, `card_money` decimal(10, 6) NULL DEFAULT NULL, `flag` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_member_analysis -- ---------------------------- INSERT INTO `t_member_analysis` VALUES (1, 1, 3, 500.500000, 200.000000, 300.500000, 0.000000, 0.000000, '中'); INSERT INTO `t_member_analysis` VALUES (2, 2, 1, 200.000000, 0.000000, 200.000000, 0.000000, 0.000000, '低'); INSERT INTO `t_member_analysis` VALUES (3, 3, 3, 1900.000000, 900.000000, 1000.000000, 0.000000, 0.000000, '高'); -- ---------------------------- -- Table structure for t_menu -- ---------------------------- DROP TABLE IF EXISTS `t_menu`; CREATE TABLE `t_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `price` decimal(10, 2) NULL DEFAULT NULL, `restaurant_id` int(11) NULL DEFAULT NULL, `flavor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `picture_url` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `kitchen_id` int(11) NULL DEFAULT NULL, `material` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cook_time` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, ` evaluate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cost_price` decimal(10, 2) NULL DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_menu -- ---------------------------- INSERT INTO `t_menu` VALUES (1, '紅燒肉', '本幫菜', 40.00, 1, '甜', 'https://www.weuih/ujhdn/jhe.jpg', 3, '豬肉', '10分鐘', '優', 20.00, NULL); INSERT INTO `t_menu` VALUES (2, '宮保雞丁', '川菜', 35.00, 1, '甜辣', 'https://www.weuih/ujhdn/jhe.jpg', 3, '雞肉,胡蘿卜,花生', '6分鐘', '優', 13.00, NULL); -- ---------------------------- -- Table structure for t_menu_type -- ---------------------------- DROP TABLE IF EXISTS `t_menu_type`; CREATE TABLE `t_menu_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `menu_id` int(11) NULL DEFAULT NULL, `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `type_price` decimal(10, 2) NULL DEFAULT NULL, `type_cost_price` decimal(10, 2) NULL DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_menu_type -- ---------------------------- INSERT INTO `t_menu_type` VALUES (1, 1, '大份', 65.00, 30.00, NULL); INSERT INTO `t_menu_type` VALUES (2, 1, '中份', 40.00, 20.00, NULL); INSERT INTO `t_menu_type` VALUES (3, 1, '小份', 20.00, 10.00, NULL); INSERT INTO `t_menu_type` VALUES (4, 2, '大份', 45.00, 20.00, NULL); INSERT INTO `t_menu_type` VALUES (5, 2, '中份', 35.00, 13.00, NULL); INSERT INTO `t_menu_type` VALUES (6, 2, '小份', 20.00, 8.00, NULL); -- ---------------------------- -- Table structure for t_order -- ---------------------------- DROP TABLE IF EXISTS `t_order`; CREATE TABLE `t_order` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `table_id` int(11) NULL DEFAULT NULL, `employee_id` int(11) NULL DEFAULT NULL, `restaurant_id` int(11) NULL DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `is_member` int(1) NULL DEFAULT NULL COMMENT '0不是 1是', `member_id` int(11) NULL DEFAULT NULL, `order_money` decimal(10, 2) NULL DEFAULT NULL, `discount_money` decimal(10, 2) NULL DEFAULT NULL, `pay_money` decimal(10, 2) NULL DEFAULT NULL, `pay_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `create_time` datetime(0) NULL DEFAULT NULL, `people_num` int(11) NULL DEFAULT NULL, `wait_time` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `pay_time` datetime(0) NULL DEFAULT NULL, `telephone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_order -- ---------------------------- INSERT INTO `t_order` VALUES (2, 'wund2873n', 1, 2, 1, '堂食', 0, NULL, 325.00, 5.00, 320.00, '支付寶', '2019-11-13 20:47:14', 4, '2019-11-15 20:31:47', '2019-11-15 20:43:36', NULL, NULL, NULL); INSERT INTO `t_order` VALUES (3, 'wund2873k', 2, 2, 1, '堂食', 0, NULL, 325.00, 5.00, 320.00, '支付寶', '2019-11-14 20:37:18', 2, '3', '2019-11-15 20:39:16', NULL, NULL, NULL); -- ---------------------------- -- Table structure for t_order_detail -- ---------------------------- DROP TABLE IF EXISTS `t_order_detail`; CREATE TABLE `t_order_detail` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` int(11) NULL DEFAULT NULL, `menu_id` int(11) NULL DEFAULT NULL, `menu_type_id` int(11) NULL DEFAULT NULL, `count` int(11) NULL DEFAULT 1, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_order_detail -- ---------------------------- INSERT INTO `t_order_detail` VALUES (1, 2, 1, 1, 1, '不要太辣'); INSERT INTO `t_order_detail` VALUES (2, 2, 2, 5, 2, NULL); -- ---------------------------- -- Table structure for t_order_kitchen -- ---------------------------- DROP TABLE IF EXISTS `t_order_kitchen`; CREATE TABLE `t_order_kitchen` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_detail_id` int(11) NULL DEFAULT NULL, `kitchen_id` int(11) NULL DEFAULT NULL, `come_time` datetime(0) NULL DEFAULT NULL, `out_time` datetime(0) NULL DEFAULT NULL, `employee_id` int(11) NULL DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_order_kitchen -- ---------------------------- INSERT INTO `t_order_kitchen` VALUES (1, 1, 3, '2019-11-13 20:58:33', '2019-11-15 20:28:26', 4, '不放蒜'); INSERT INTO `t_order_kitchen` VALUES (2, 2, 3, '2019-11-13 20:59:16', '2019-11-15 20:28:34', 4, NULL); -- ---------------------------- -- Table structure for t_post -- ---------------------------- DROP TABLE IF EXISTS `t_post`; CREATE TABLE `t_post` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `restaurant_id` int(11) NULL DEFAULT NULL, `post_money` decimal(10, 2) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_post -- ---------------------------- INSERT INTO `t_post` VALUES (1, '經理', 1, 10000.00); INSERT INTO `t_post` VALUES (2, '服務員', 1, 4000.00); INSERT INTO `t_post` VALUES (3, '廚師', 1, 8000.00); -- ---------------------------- -- Table structure for t_restaurant -- ---------------------------- DROP TABLE IF EXISTS `t_restaurant`; CREATE TABLE `t_restaurant` ( `id` int(11) NOT NULL AUTO_INCREMENT, `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `phone1` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `phone2` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `employee_id` int(11) NULL DEFAULT NULL, `create_time` date NULL DEFAULT NULL, `work_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `restaurant_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `scale` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集團內部定義規模', `turnover` decimal(65, 30) NULL DEFAULT NULL COMMENT '月平均營業額', `turnover_rate` double(3, 2) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_restaurant -- ---------------------------- INSERT INTO `t_restaurant` VALUES (1, '躍龍南路', '洞子火鍋', '0513-844821223', '0513-66668888', 1, '2011-01-13', 'AM9:00-PM22:30', 'H12389IWY9347NS888', '中型', 300000.000000000000000000000000000000, 2.70); -- ---------------------------- -- Table structure for t_restaurant_table -- ---------------------------- DROP TABLE IF EXISTS `t_restaurant_table`; CREATE TABLE `t_restaurant_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `restaurant_id` int(11) NULL DEFAULT NULL, `table_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `table_size` int(3) NULL DEFAULT NULL, `employee_id` int(11) NULL DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `description` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_restaurant_table -- ---------------------------- INSERT INTO `t_restaurant_table` VALUES (1, 1, '01', 4, 2, '大堂', NULL); INSERT INTO `t_restaurant_table` VALUES (2, 1, '02', 12, 3, '包廂', NULL); SET FOREIGN_KEY_CHECKS = 1; ~~~ ## 業務邏輯 ~~~sql # 未上線之前基礎數據完善 # 業務流程處理 # 第一點 注冊會員 insert into t_member(name,sex,birthday,telephone,aviod_food,taste_like,isCar) value("張三",1,"1993-02-11","14672398712","酸","甜",1) insert into t_member(name,sex,birthday,telephone,aviod_food,taste_like,isCar) value("李四",1,19930211,"14672392112","苦","甜",1) insert into t_member(name,sex,birthday,telephone,aviod_food,taste_like,isCar) value("王五",1,19930211,"14672392112","苦","甜",1) # 第二點 修改會員分析表數據(假如只知道叫王五) update t_member_analysis set count_time=2,count_money=1400,wechat_money=400 where member_id=(select id from t_member where name="王五") -- 使用update 和 連接(內,外) 進行多表的更新操作 update t_member_analysis a left join t_member m on a.member_id=m.id set a.count_time=3,a.count_money=1900,a.wechat_money=900 where m.name="王五" # 第三點 點菜 insert into t_order(order_code,table_id,employee_id,restaurant_id,type,is_member,member_id,order_money,discount_money,pay_money,pay_type,create_time,people_num,wait_time,pay_time,telephone,address,description) value("wund2873n",1,2,1,"堂食",0,null,NULL,NULL,NULL,null,now(),4,null,null,null,null,null) # 第四點 定菜(顧客確定菜品) insert into t_order_detail value(1,2,1,1,1,null) insert into t_order_detail value(null,2,2,5,2,null) # 第五點 檔口分配 insert into t_order_kitchen value(null,1,3,now(),null,4,"不放蒜") insert into t_order_kitchen value(null,2,3,now(),null,4,null) # 第六點 檔口成菜 -- 查看菜品 查看本檔口的要制作的訂單編號,菜品名稱,菜品大小(菜品規格),菜品份數,菜品顧客備注 select o.order_code,m.name,mt.type,od.count,od.description from t_order as o left join t_order_detail as od on o.id=od.order_id left join t_menu as m on od.menu_id=m.id left join t_menu_type as mt on od.menu_type_id=mt.id left join t_kitchen as k on m.kitchen_id=k.id where k.id=3 -- 出菜 update t_order_kitchen set out_time=now() where order_detail_id=2 # 第七點 全菜 update t_order set wait_time=now() where id=2; # 第八點 買單 -- 注意對于null進行判斷不能使用!= = <>(永遠返回false),需要使用 is not null 和 is null update t_order set order_money=325,discount_money=5,pay_money=320,pay_type="支付寶",pay_time=now() where id=2 and wait_time is not null ~~~
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看