外卖系统三方用户——————消费者，管理员，餐馆
其中消费者——点餐、支付订单、查看订单、评论、注册、查看个人信息、积分和等级附加特性、查看订餐路线规划、取消订单、按照类别查找菜品等业务
管理员——审批餐馆
餐馆——申请入驻、查看评论、查看和修改菜品信息、上传菜品信息、查看本餐馆数据分析结果等业务
整体架构：Spring+SpringMVC+Mybatis+Maven
前端架构：JQuery+Bootstrap+Ajax+echarts+highcharts+Amap（高德地图API）+font-awesome等
后端架构：Mybatis
本软件由南京理工大学课设团队于九月耗时十几天完成，下面放图，后期会公开github位置，现若有想要源码学习的同学，可以加Q1551904915.
界面可能稍微拙劣，但由于技术集成度较高，总有你希望学到的东西
数据库配置文件：
1 #表1 2 #创建dishType表 3 4 set foreign_key_checks = 0; 5 6 drop table if exists `dishType`; 7 create table `dishType`( 8 `dishTypeID` int(10) AUTO_INCREMENT COLLATE utf8_general_ci NOT NULL,#菜品类型编号 9 `dishTypeName` varchar(30) COLLATE utf8_general_ci NOT NULL,#菜品类型名称 10 primary key(`dishTypeID`) using BTREE 11 )ENGINE=INNODB AUTO_INCREMENT=1 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; 12 13 #表2 14 #创建restaurantType表 15 drop table if exists `resType`; 16 create table `resType`( 17 `resTypeID` int(10) AUTO_INCREMENT COLLATE utf8_general_ci NOT NULL,#餐馆类型标号 18 `resTypeName` varchar(30) COLLATE utf8_general_ci NOT NULL,#餐馆类型名称 19 primary key(`resTypeID`) using BTREE 20 )ENGINE=INNODB AUTO_INCREMENT=1 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; 21 22 23 #表3 24 #创建manager表 25 drop table if exists `manager`; 26 create table `manager`( 27 `managerID` varchar(20) COLLATE utf8_general_ci NOT NULL,#管理员标识 28 `password` varchar(30) COLLATE utf8_general_ci NOT NULL,#管理员密码 29 `accountID` varchar(20) COLLATE utf8_general_ci NOT NULL,#管理员账号 30 `image` varchar(60) COLLATE utf8_general_ci NOT NULL, 31 primary key(`managerID`), 32 FOREIGN KEY(`accountID`) REFERENCES bank(`accountID`) ON DELETE CASCADE ON UPDATE CASCADE 33 )ENGINE=INNODB CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; 34 35 36 #表4 37 #创建restaurant表 38 drop table if exists `restaurant`; 39 create table `restaurant`( 40 `resID` varchar(10) COLLATE utf8_general_ci NOT NULL,#餐馆识别码 41 `locate` varchar(40) COLLATE utf8_general_ci NOT NULL,#餐馆地点 42 `name` varchar(30) COLLATE utf8_general_ci NOT NULL,#餐馆名称 43 `image` varchar(50) COLLATE utf8_general_ci NOT NULL, 44 `password` varchar(30) COLLATE utf8_general_ci NOT NULL,#登录密码 45 `startTime` int(10) COLLATE utf8_general_ci default 9,#开始营业时间 46 `endTime` int(10) COLLATE utf8_general_ci default 21,#结束营业时间 47 `accountID` varchar(20) COLLATE utf8_general_ci NOT NULL,#餐馆账户 48 `resPhone` varchar(20) COLLATE utf8_general_ci NOT NULL,#餐馆电话 49 `resTypeID` int(10) COLLATE utf8_general_ci NOT NULL,#餐馆类型编号 50 `balance` double COLLATE utf8_general_ci default 0,#餐馆收入 51 `accepted` int(1) COLLATE utf8_general_ci default 0,#是否通过申请 52 `score` int(10) COLLATE utf8_general_ci default 0,#餐馆的评分 53 `managerID` varchar(20) COLLATE utf8_general_ci NOT NULL,#上级管理者 54 primary key(`resID`) using BTREE, 55 FOREIGN KEY(`resTypeID`) REFERENCES resType(`resTypeID`) ON DELETE CASCADE ON UPDATE CASCADE , 56 FOREIGN KEY(`managerID`) REFERENCES manager(`managerID`) ON DELETE CASCADE ON UPDATE CASCADE , 57 FOREIGN KEY(`accountID`) REFERENCES bank(`accountID`) ON DELETE CASCADE ON UPDATE CASCADE 58 )ENGINE=INNODB CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; 59 60 61 #表5 62 # 创建dish表 63 drop table if exists `dish`; 64 create table `dish`( 65 `dishID` int(12) AUTO_INCREMENT COLLATE utf8_general_ci NOT NULL,#菜品标识 66 `image` varchar(50) COLLATE utf8_general_ci NOT NULL,#菜品图片 67 `dishTypeID` int(10) COLLATE utf8_general_ci NOT NULL,#菜品类型 68 `remain` int(11) COLLATE utf8_general_ci default 0,#现存余量 69 `description` varchar(300) COLLATE utf8_general_ci default '该菜品没有介绍',#菜品介绍 70 `startTime` datetime COLLATE utf8_general_ci NOT NULL,#菜品上架时间 71 `price` double COLLATE utf8_general_ci NOT NULL, 72 `name` varchar(30) COLLATE utf8_general_ci NOT NULL,#菜品的名称 73 `resID` varchar(10) COLLATE utf8_general_ci NOT NULL,#餐馆的编号 74 `discount` double COLLATE utf8_general_ci default 1.0,#折扣 75 `saleAmount` int(10) COLLATE utf8_general_ci default 0,#销售量 76 `score` int(10) COLLATE utf8_general_ci default 0,#评分 77 primary key (`dishID`) using BTREE, 78 #创建级联删除以及级联更新 79 FOREIGN KEY(`dishTypeID`) REFERENCES dishType(`dishTypeID`) ON DELETE CASCADE ON UPDATE CASCADE , 80 FOREIGN KEY(`resID`) REFERENCES restaurant(`resID`) ON DELETE CASCADE ON UPDATE CASCADE 81 )ENGINE=INNODB AUTO_INCREMENT=1 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; 82 83 84 #表6 85 #创建bank 86 drop table if exists `bank`; 87 create table `bank`( 88 `accountID` varchar(20) COLLATE utf8_general_ci NOT NULL, 89 `password` varchar(20) COLLATE utf8_general_ci NOT NULL, 90 `amount` decimal(32) COLLATE utf8_general_ci NOT NULL, 91 primary key (`accountID`) using BTREE 92 )ENGINE=INNODB CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; 93 94 95 #表7 96 #创建user表 97 drop table if exists `users`; 98 create table `users`( 99 `userID` int(12) AUTO_INCREMENT COLLATE utf8_general_ci NOT NULL, 100 `userName` varchar(30) COLLATE utf8_general_ci NOT NULL, 101 `password` varchar(20) COLLATE utf8_general_ci NOT NULL, 102 `address` varchar(30) COLLATE utf8_general_ci NOT NULL, 103 `email` varchar(20) COLLATE utf8_general_ci NOT NULL, 104 `avatar` varchar(100) COLLATE utf8_general_ci NOT NULL, 105 `userState` varchar(30) COLLATE utf8_general_ci NOT NULL, 106 `phoneNum` varchar(20) COLLATE utf8_general_ci NOT NULL, 107 `accountID` varchar(20) COLLATE utf8_general_ci NOT NULL, 108 `score` int COLLATE utf8_general_ci default 0, 109 primary key(`userID`) using BTREE, 110 FOREIGN KEY(`accountID`) REFERENCES bank(`accountID`) ON DELETE CASCADE ON UPDATE CASCADE 111 )ENGINE=INNODB CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; 112 113 114 #表8 115 #创建order表 116 #order是mysql的关键字 117 drop table if exists `orders`; 118 create table `orders`( 119 `orderID` int(12) AUTO_INCREMENT COLLATE utf8_general_ci NOT NULL, 120 `userID` int(12) COLLATE utf8_general_ci NOT NULL, 121 `resID` varchar(10) COLLATE utf8_general_ci NOT NULL, 122 `orderTime` datetime COLLATE utf8_general_ci NOT NULL, 123 `state` varchar(20) COLLATE utf8_general_ci default 'indelivery', 124 primary key(`orderID`) using BTREE, 125 FOREIGN KEY(`userID`) REFERENCES users(`userID`) ON DELETE CASCADE ON UPDATE CASCADE , 126 FOREIGN KEY(`resID`) REFERENCES restaurant(`resID`) ON DELETE CASCADE ON UPDATE CASCADE 127 )ENGINE=INNODB CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; 128 129 130 131 #表9 132 drop table if exists `orderItem`; 133 create table `orderItem`( 134 `orderItemID` int(11) AUTO_INCREMENT COLLATE utf8_general_ci NOT NULL, 135 `dishID` int(12) COLLATE utf8_general_ci NOT NULL, 136 `orderID` int(12) COLLATE utf8_general_ci NOT NULL, 137 `count` int(10) COLLATE utf8_general_ci NOT NULL, 138 primary key(`orderItemID`) using BTREE, 139 FOREIGN KEY(`orderID`) REFERENCES orders(`orderID`) ON DELETE CASCADE ON UPDATE CASCADE 140 )ENGINE=INNODB CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; 141 142 143 #表10 144 drop table if exists `review`; 145 create table `review`( 146 `reviewID` int(11) AUTO_INCREMENT COLLATE utf8_general_ci NOT NULL, 147 `userID` int(12) COLLATE utf8_general_ci NOT NULL, 148 `content` varchar(300) COLLATE utf8_general_ci default '该用户没有进行评价', 149 `time` datetime COLLATE utf8_general_ci NOT NULL, 150 `resID` varchar(10) COLLATE utf8_general_ci NOT NULL, 151 primary key(`reviewID`) using BTREE, 152 FOREIGN KEY(`resID`) REFERENCES restaurant(`resID`) ON DELETE CASCADE ON UPDATE CASCADE 153 )ENGINE=INNODB CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; 154 155 156 157 158 set foreign_key_checks = 1; 159 160 161 162 #插入bank 163 164 165 INSERT INTO BANK(`ACCOUNTID`,`PASSWORD`,`AMOUNT`) VALUE('17851093886','17851093886','10000'); 166 INSERT INTO BANK(`ACCOUNTID`,`PASSWORD`,`AMOUNT`) VALUE('13218875296','13218875296','10000'); 167 INSERT INTO BANK(`ACCOUNTID`,`PASSWORD`,`AMOUNT`) VALUE('19825000668','19825000668','10000'); 168 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '100000000', '100000000' ,'10000'); 169 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '100000001', '100000001' ,'10000'); 170 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '100000002', '100000002' ,'10000'); 171 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '100000003', '100000003' ,'10000'); 172 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '100000004', '100000004' ,'10000'); 173 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '100000005', '100000005' ,'10000'); 174 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '100000006', '100000006' ,'10000'); 175 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '100000007', '100000007' ,'10000'); 176 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '100000008', '100000008' ,'10000'); 177 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '100000009', '100000009' ,'10000'); 178 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000010', '1000000010' ,'10000'); 179 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000011', '1000000011' ,'10000'); 180 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000012', '1000000012' ,'10000'); 181 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000013', '1000000013' ,'10000'); 182 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000014', '1000000014' ,'10000'); 183 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000015', '1000000015' ,'10000'); 184 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000016', '1000000016' ,'10000'); 185 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000017', '1000000017' ,'10000'); 186 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000018', '1000000018' ,'10000'); 187 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000019', '1000000019' ,'10000'); 188 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000020', '1000000020' ,'10000'); 189 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000021', '1000000021' ,'10000'); 190 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000022', '1000000022' ,'10000'); 191 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000023', '1000000023' ,'10000'); 192 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000024', '1000000024' ,'10000'); 193 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000025', '1000000025' ,'10000'); 194 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000026', '1000000026' ,'10000'); 195 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000027', '1000000027' ,'10000'); 196 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000028', '1000000028' ,'10000'); 197 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000029', '1000000029' ,'10000'); 198 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000030', '1000000030' ,'10000'); 199 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000031', '1000000031' ,'10000'); 200 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000032', '1000000032' ,'10000'); 201 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000033', '1000000033' ,'10000'); 202 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000034', '1000000034' ,'10000'); 203 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000035', '1000000035' ,'10000'); 204 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000036', '1000000036' ,'10000'); 205 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000037', '1000000037' ,'10000'); 206 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000038', '1000000038' ,'10000'); 207 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000039', '1000000039' ,'10000'); 208 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000040', '1000000040' ,'10000'); 209 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000041', '1000000041' ,'10000'); 210 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000042', '1000000042' ,'10000'); 211 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000043', '1000000043' ,'10000'); 212 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000044', '1000000044' ,'10000'); 213 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000045', '1000000045' ,'10000'); 214 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000046', '1000000046' ,'10000'); 215 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000047', '1000000047' ,'10000'); 216 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000048', '1000000048' ,'10000'); 217 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000049', '1000000049' ,'10000'); 218 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000050', '1000000050' ,'10000'); 219 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000051', '1000000051' ,'10000'); 220 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000052', '1000000052' ,'10000'); 221 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000053', '1000000053' ,'10000'); 222 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000054', '1000000054' ,'10000'); 223 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000055', '1000000055' ,'10000'); 224 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000056', '1000000056' ,'10000'); 225 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000057', '1000000057' ,'10000'); 226 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000058', '1000000058' ,'10000'); 227 INSERT INTO bank(`accountID`,`password`,`amount`) VALUE( '1000000059', '1000000059' ,'10000'); 228 229 230 231 232 #插入dishType 233 INSERT INTO dishType(`dishTypeName`) VALUE( '饺子馄饨' ); 234 INSERT INTO dishType(`dishTypeName`) VALUE( '快餐便当' ); 235 INSERT INTO dishType(`dishTypeName`) VALUE( '汉堡薯条' ); 236 INSERT INTO dishType(`dishTypeName`) VALUE( '意面披萨' ); 237 INSERT INTO dishType(`dishTypeName`) VALUE( '包子粥类' ); 238 INSERT INTO dishType(`dishTypeName`) VALUE( '米粉面类' ); 239 INSERT INTO dishType(`dishTypeName`) VALUE( '麻辣烫冒菜' ); 240 INSERT INTO dishType(`dishTypeName`) VALUE( '川湘菜' ); 241 INSERT INTO dishType(`dishTypeName`) VALUE( '江浙菜' ); 242 INSERT INTO dishType(`dishTypeName`) VALUE( '粤菜' ); 243 INSERT INTO dishType(`dishTypeName`) VALUE( '东北菜' ); 244 INSERT INTO dishType(`dishTypeName`) VALUE( '油炸食品' ); 245 INSERT INTO dishType(`dishTypeName`) VALUE( '西餐牛排' ); 246 INSERT INTO dishType(`dishTypeName`) VALUE( '夹馍饼类' ); 247 INSERT INTO dishType(`dishTypeName`) VALUE( '鸭脖卤味' ); 248 INSERT INTO dishType(`dishTypeName`) VALUE( '日料寿司' ); 249 INSERT INTO dishType(`dishTypeName`) VALUE( '韩式料理' ); 250 INSERT INTO dishType(`dishTypeName`) VALUE( '香锅干锅' ); 251 INSERT INTO dishType(`dishTypeName`) VALUE( '火锅' ); 252 INSERT INTO dishType(`dishTypeName`) VALUE( '海鲜烧烤' ); 253 INSERT INTO dishType(`dishTypeName`) VALUE( '轻食沙拉' ); 254 INSERT INTO dishType(`dishTypeName`) VALUE( '粉丝汤' ); 255 INSERT INTO dishType(`dishTypeName`) VALUE( '面包' ); 256 INSERT INTO dishType(`dishTypeName`) VALUE( '奶茶' ); 257 INSERT INTO dishType(`dishTypeName`) VALUE( '果汁' ); 258 INSERT INTO dishType(`dishTypeName`) VALUE( '鲜果' ); 259 INSERT INTO dishType(`dishTypeName`) VALUE( '冰淇淋' ); 260 INSERT INTO dishType(`dishTypeName`) VALUE( '甜品' ); 261 262 263 264 #插入resType 265 INSERT INTO resType(`resTypeName`) VALUE( '快餐便当' ); 266 INSERT INTO resType(`resTypeName`) VALUE( '火锅烤鱼' ); 267 INSERT INTO resType(`resTypeName`) VALUE( '日韩料理' ); 268 INSERT INTO resType(`resTypeName`) VALUE( '甜品饮品' ); 269 INSERT INTO resType(`resTypeName`) VALUE( '水果店铺' ); 270 INSERT INTO resType(`resTypeName`) VALUE( '小吃烧烤' ); 271 INSERT INTO resType(`resTypeName`) VALUE( '米粉面馆' ); 272 INSERT INTO resType(`resTypeName`) VALUE( '地方菜馆' ); 273 274 #插入manager 275 INSERT INTO MANAGER(`managerID`,`PASSWORD`,`accountID`,`image`) VALUES('M-17851093886','17851093886','17851093886','5d235a4b231341d18d27081e2750ded1.jpg'); 276 INSERT INTO MANAGER(`managerID`,`PASSWORD`,`accountID`,`image`) VALUES('M-13218875296','13218875296','13218875296','599963243f05468094fa27d402b2d437.jpg'); 277 INSERT INTO MANAGER(`managerID`,`PASSWORD`,`accountID`,`image`) VALUES('M-19825000668','19825000668','19825000668','67f81b3431074ee4888ad208207d0e5b.jpg'); 278 279 280 #插入restaurant 281 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000000','孝陵卫晏公庙新村2栋', '七家湾牛肉锅贴' ,'100000000' ,'5' ,'21' ,'100000000' ,'13815896762' ,'6' ,'10000' ,'1' ,'96' ,'M-13218875296','e8c54f728e4648cd868ffbf85d8730bb.jpg'); 282 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000032','玄武区童卫路7号', '吉祥馄饨' ,'100000001' ,'7' ,'20' ,'100000001' ,'13811216132' ,'6' ,'10000' ,'1' ,'98' ,'M-19825000668','656576fd248242038cd3d5ba4c86e7e1.jpg'); 283 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000064', '玄武区罗汉巷2栋', '哈尔滨水饺' ,'100000002' ,'0' ,'24' ,'100000002' ,'13814596232' ,'6' ,'10000' ,'0' ,'90' ,'M-13218875296','68fcfc4d4c5f485183be4918859225a5.jpg'); 284 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000096','孝陵卫罗汉巷12栋', '福庆水饺炸酱面' ,'100000003' ,'6' ,'22' ,'100000003' ,'11366896762' ,'6' ,'10000' ,'1' ,'96' ,'M-13218875296','f552dfd3ebb5499291171b28198896ca.jpg'); 285 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000128', '中山门大街297号钟鼎名悦广场114室', '苗小坛酸菜鱼捞饭' ,'100000004' ,'10' ,'21' ,'100000004' ,'13715855378' ,'1' ,'10000' ,'1' ,'91' ,'M-13218875296','7d16d98dd8184ff0a89f4c800f5ed097.jpg'); 286 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000160', '玄武区银城东苑1号103室', '老乡鸡' ,'100000005' ,'6' ,'22' ,'100000005' ,'19825006882' ,'1' ,'10000' ,'1' ,'95' ,'M-13218875296','2430e0a9972547a781ba1b4bf818294f.jpg'); 287 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000192', '玄武区孝陵卫街85号', '孟氏黄焖鸡' ,'100000006' ,'9' ,'23' ,'100000006' ,'13815316432' ,'1' ,'10000' ,'1' ,'98' ,'M-19825000668','758cc0d615f448ecaee0c3a4b35d6239.jpg'); 288 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000224', '孝陵卫罗汉巷7幢110室', '骨头饭' ,'100000007' ,'10' ,'21' ,'100000007' ,'12313443533' ,'1' ,'10000' ,'1' ,'100' ,'M-13218875296','d4a1a6e33e344c2b96cd5c3aa1f61e42.jpg'); 289 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000256', '天坛村16幢12号', '厨子与辣子' ,'100000008' ,'10' ,'21' ,'100000008' ,'13249549901' ,'2' ,'10000' ,'1' ,'97' ,'M-13218875296','4581c44403134c31b1846c94a6b63e87.jpg'); 290 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000288', '玄武区友谊路100号S50号', '鸡来鲜鸡小地锅' ,'100000009' ,'10' ,'21' ,'100000009' ,'13815896762' ,'2' ,'10000' ,'1' ,'96' ,'M-13218875296','57815850adf348619cd4a2381edf25ba.jpg'); 291 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000320', '四方村中队一队1号', '川小妞麻辣香锅' ,'1000000010' ,'9' ,'22' ,'1000000010' ,'14546780862' ,'2' ,'10000' ,'1' ,'96' ,'M-13218875296','9e79de2ad56d4febae14e01a30a3dfeb.jpg'); 292 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000352', '孝陵卫南京理工大学一号路A2-2', '乡村无骨烤鱼饭' ,'1000000011' ,'9' ,'21' ,'1000000011' ,'13256557757' ,'2' ,'10000' ,'1' ,'91' ,'M-13218875296','13dc07dafc2e43179f44e8a23477cd01.jpg'); 293 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000384', '玄武区友谊路100号N06号', '和风便当' ,'1000000012' ,'10' ,'20' ,'1000000012' ,'13446621567' ,'3' ,'10000' ,'1' ,'97' ,'M-17851093886','4f9b843a0df24a3bab9813585dc12f7c.jpg'); 294 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000416', '玄武区中山门大街301号北京华联超市', 'N多寿司' ,'1000000013' ,'8' ,'22' ,'1000000013' ,'13609631342' ,'3' ,'10000' ,'1' ,'96' ,'M-13218875296','083bd9de6e5f4472af961ece2893608b.jpg'); 295 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000448', '玄武区双拜巷151号', '晨曦日式料理' ,'1000000014' ,'9' ,'20' ,'1000000014' ,'17812114641' ,'3' ,'10000' ,'1' ,'91' ,'M-13218875296','9af749dec38547c3ae744ad7b44a99ec.jpg'); 296 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000480', '秦淮区苜蓿园东街2号', '韩式石锅拌饭' ,'1000000015' ,'0' ,'24' ,'1000000015' ,'13815896762' ,'3' ,'10000' ,'1' ,'95' ,'M-13218875296','b2ca052efac240daa7628dd3a1b0a75d.jpg'); 297 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000512', '玄武区中山门大街297号钟鼎名悦广场127室', '喜霖川烤肉拌饭' ,'1000000016' ,'10' ,'21' ,'1000000016' ,'15673262135' ,'3' ,'10000' ,'1' ,'97' ,'M-13218875296','de2ba4fc7d244c6e832023c6e1671307.jpg'); 298 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000544', '玄武区友谊路100号品硕广场', '1点点' ,'1000000017' ,'10' ,'22' ,'1000000017' ,'14314124463' ,'4' ,'10000' ,'1' ,'99' ,'M-17851093886','d12979c978bd492c9ede229467309054.jpg'); 299 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000576', '玄武区银城东苑1号金石楼', '巴黎贝甜' ,'1000000018' ,'7' ,'22' ,'1000000018' ,'19879834585' ,'4' ,'10000' ,'1' ,'99' ,'M-13218875296','42a08490bc034fc0b3870d781952ba56.jpg'); 300 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000608', '玄武区中山门大街297号6栋327号', '贡茶' ,'1000000019' ,'10' ,'24' ,'1000000019' ,'18502210987' ,'4' ,'10000' ,'1' ,'98' ,'M-13218875296','ce2280715a084b199994874333f14ddc.jpg'); 301 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000640', '太平南路168号309室', '卡漫莫尼蛋糕' ,'1000000020' ,'7' ,'20' ,'1000000020' ,'11823425464' ,'4' ,'10000' ,'1' ,'98' ,'M-13218875296','5504af0ac4034b24991a2bfc64605483.jpg'); 302 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000672', '秦淮区星海路8-1号', '百果园' ,'1000000021' ,'8' ,'23' ,'1000000021' ,'17534323452' ,'5' ,'10000' ,'1' ,'96' ,'M-17851093886','6d15996c40194460a92f881365f46c48.jpg'); 303 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000704', '玄武区后宰门街19号东楼101室', '茂盛果园' ,'1000000022' ,'7' ,'23' ,'1000000022' ,'19868907658' ,'5' ,'10000' ,'1' ,'98' ,'M-13218875296','da33c0b1884f41b18b15fec452f02862.jpg'); 304 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000736', '玄武区小卫街228号01幢105室', '鲜丰水果' ,'1000000023' ,'8' ,'23' ,'1000000023' ,'13812127446' ,'5' ,'10000' ,'1' ,'98' ,'M-13218875296','acc2820b5d404481b717f2d0af2f8db5.jpg'); 305 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000768', '玄武区中山门大街99号君临紫金商业街120号', '龙门花甲' ,'1000000024' ,'0' ,'24' ,'1000000024' ,'13522290893' ,'6' ,'10000' ,'1' ,'90' ,'M-13218875296','3354c67655ae4d4da654b5f20561554b.jpg'); 306 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000800', '长白街464号', '喜辣烧烤' ,'1000000025' ,'0' ,'24' ,'1000000025' ,'12220812354' ,'6' ,'10000' ,'1' ,'98' ,'M-13218875296','a03abb3975d3449083eabc3a792a5b7c.jpg'); 307 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000832', '玄武区小卫街16-3号', '刘长兴面馆' ,'1000000026' ,'7' ,'20' ,'1000000026' ,'19824450987' ,'7' ,'10000' ,'1' ,'97' ,'M-13218875296','dc75a143b00a4de5a93e82a41214b652.jpg'); 308 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000864', '罗汉巷1号10幢8号', '寻味螺蛳粉' ,'1000000027' ,'10' ,'23' ,'1000000027' ,'19825320068' ,'7' ,'10000' ,'1' ,'99' ,'M-13218875296','42bf6e6689254d48bd27ac5281c48a29.jpg'); 309 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000896', '秦淮区银龙花园三期35幢104号', '味之美过桥米线' ,'1000000028' ,'0' ,'24' ,'1000000028' ,'14524000062' ,'7' ,'10000' ,'1' ,'98' ,'M-13218875296','57bae00918504dd5a016cf0fc5c14255.jpg'); 310 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000928', '玄武区罗汉巷123号04幢102室', '盛旺缘面馆' ,'1000000029' ,'6' ,'21' ,'1000000029' ,'13218874296' ,'7' ,'10000' ,'1' ,'97' ,'M-13218875296','455590ae03f0478c81717b1bd13d63ee.jpg'); 311 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000960', '玄武区小卫街20号', '褚记北京烤鸭店' ,'1000000030' ,'10' ,'21' ,'1000000030' ,'13234627656' ,'8' ,'10000' ,'1' ,'97' ,'M-13218875296','68f04bd3459e4b8fa76bd7714e73bff2.png'); 312 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000000992', '玄武区罗汉巷123号03幢', '金陵小碗菜' ,'1000000031' ,'10' ,'21' ,'1000000031' ,'19809891020' ,'8' ,'10000' ,'1' ,'97' ,'M-19825000668','e884b7d197364502aed9a75bffcdae4e.jpg'); 313 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000001024', '紫金明珠34幢110号', '外婆记菜饭骨头汤' ,'1000000032' ,'9' ,'21' ,'1000000032' ,'13312176754' ,'8' ,'10000' ,'1' ,'94' ,'M-13218875296','bfd1e63342724221996d1096651a91db.jpg'); 314 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000001056', '玄武区小卫街16号3幢7号', '巴蜀鱼蛙' ,'1000000033' ,'9' ,'21' ,'1000000033' ,'13776873932' ,'8' ,'10000' ,'1' ,'97' ,'M-13218875296','0884f3ea5adf48d49862aaae17056470.jpg'); 315 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000001088', '万达新村57-1号', '兴隆川菜馆' ,'1000000034' ,'10' ,'24' ,'1000000034' ,'18921498945' ,'8' ,'10000' ,'1' ,'94' ,'M-19825000668','509feab5a8ec4904a9456b3d8b3d6d8a.jpg'); 316 INSERT INTO restaurant(`resID`,`locate`,`name`,`password`,`startTime`,`endTime`,`accountID`,`resPhone`,`resTypeID`,`balance`,`accepted`,`score`,`managerID`,`image`) VALUE('1000001120', '玄武区中山门大街9号', '南京大排档' ,'1000000035' ,'10' ,'21' ,'1000000035' ,'13498567840' ,'8' ,'10000' ,'1' ,'97' ,'M-13218875296','4d73b316968f44d8abcf01c4a4f64a62.jpg'); 317 318 319 320 321 #dish 322 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 2, 100 ,'主料鸡肉，菜系为中餐，分量为300g，口味麻辣' ,'2020-07-01 09:55:00' ,'口水鸡' ,'1000000992' ,18 ,5.5 ,2132 ,96 ,'243678f8e7d44255a2e8336487d82449.jpg'); 323 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 8, 200 ,'主料猪排骨，荤菜，分量约200g，口味辣' ,'2020-07-01 09:55:00' ,'红烧排骨' ,'1000000992' ,18 ,7.1 ,270,92,'d867019f5cc8416c845ad9e5a860324f.jpg'); 324 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 8, 300 ,'主料鸡，腌菜，香菇，荤菜，分量约200g，口味微辣' ,'2020-07-01 09:55:00' ,'霸王别鸡' ,'1000000992' ,18 ,6.6 ,750,95,'7e6c991e9f3a40f2ad1818e21730be73.jpg'); 325 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 15, 150 ,'主料鸭肉，莴笋，鸭，菜系苏菜，分量约200g，口味咸' ,'2020-07-01 09:55:00' ,'金陵盐水鸭' ,'1000000992' ,18 ,6.0 ,164,95,'b6f448ade5c7429893c9867c6eda1351.jpg'); 326 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 15, 100 ,'主料蛋黄，葱，鸭，鸭腿，菜系中餐，分量约200g，口味辣' ,'2020-07-01 09:55:00' ,'金陵烤鸭' ,'1000000992' ,18 ,6.0 ,1039,87,'1367efbf420d4bf0a8d9c71afc5c36af.jpg'); 327 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 10, 100 ,'主料有机蔬菜，青椒，面粉，菜系浙菜，分量约200g，口味辣' ,'2020-07-01 09:55:00' ,'土豆烧牛肉' ,'1000000992' ,19 ,5.7 ,1221,91,'d8b22c2d81b24f859f18225a3131478e.jpg'); 328 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 9, 200 ,'主料番茄，白糖，山椒，家常菜，分量约250g，口味原味' ,'2020-07-01 09:55:00' ,'番茄炒蛋' ,'1000000992' ,14 ,4.2 ,1516,91,'693d9c5af8b04554bbe89b3d5c883d04.jpg'); 329 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 21, 200 ,'主料青椒，火腿，鸡蛋，菜系鲁菜，分量约220g，口味香味' ,'2020-07-01 09:55:00' ,'青椒火腿炒鸡蛋' ,'1000000992' ,13 ,3.7 ,1576,93,'5ea1d914cbee46a3ad5821117bf7e685.jpg'); 330 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 9, 200 ,'主料梅干菜，猪肉，荤菜，分量约200g，口味香味' ,'2020-07-01 09:55:00' ,'梅菜扣肉' ,'1000000992' ,20 ,5.9 ,28,92,'7573066e360b4bb8b34908e2ebdbc186.jpg'); 331 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 9, 200 ,'主料鸡肉，荤菜，菜系家常菜分量约200g，口味香味' ,'2020-07-01 09:55:00' ,'鱼香鸡柳' ,'1000000992' ,20 ,5.4 ,113,95,'2d6f013b6281455ebfb201b5fead1669.jpg'); 332 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 9, 200 ,'主料黄瓜，猪头肉，荤菜，菜系中餐，分量约200g' ,'2020-07-01 09:55:00' ,'黄瓜拌猪头肉' ,'1000000992' ,19 ,6.2 ,150,98,'c492d02bc27842308ae2aa8bfb1b8105.jpg'); 333 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 9, 200 ,'主料黄豆，鸡肉，毛豆，菜系川菜，分量约200g，口味辣' ,'2020-07-01 09:55:00' ,'毛豆鸡丁' ,'1000000992' ,18 ,5.5 ,451,97,'e0087b624aa84ca581b68766831b5e0a.jpg'); 334 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 1, 100 ,'主料猪肉，分量约15g，清淡，口味咸味' ,'2020-07-01 09:55:00' ,'招牌小馄饨' ,'1000000032' ,18.8 ,10 ,132,87,'5494beedd6d6434bbab9b72dbd82697b.jpg'); 335 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 1, 200 ,'主料猪肉，蛋黄，分量约270g，清淡，口味原味' ,'2020-07-01 09:55:00' ,'全家福馄饨' ,'1000000032' ,24.8 ,10 ,127,87,'3b6341b155f64184811bb698f63ac1c8.jpg'); 336 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 1, 200 ,'主料虾仁，分量约270g，清淡，口味原味' ,'2020-07-01 09:55:00' ,'哈尔滨水饺' ,'1000000064' ,23 ,10 ,325,66,'6f98946a325d4886841c4aaaac7b3412.jpg'); 337 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 2, 200 ,'主料香肠，毛豆，分量一碗，清淡，口味咸鲜' ,'2020-07-01 09:55:00' ,'香肠蒸豆米' ,'1000000160' ,14 ,10 ,487,87,'80d236e3d7ff47a88cbdf9fa7ace50d5.jpg'); 338 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 2, 100 ,'主料葱油，鸡肉，分量一碗，家常菜，口味葱香' ,'2020-07-01 09:55:00' ,'葱油鸡' ,'1000000160' ,17 ,10,775,94,'95281695c1de451eb3aa758b7e3a10b3.jpg'); 339 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 2, 100 ,'主料草鱼，辣椒，分量一碗，家常菜，鲜，口味香辣' ,'2020-07-01 09:55:00' ,'鸡汁辣鱼' ,'1000000160' ,14 ,10 ,371,94,'843fd169d84f4290b4ba2395373d1729.jpg'); 340 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 6, 150 ,'主料牛肉，面条，口味咸鲜，一人份' ,'2020-07-01 09:55:00' ,'牛肉面' ,'1000000832' ,23 ,10 ,167,90,'0ea0ac51c64d4129854ad8f8122cca61.jpg'); 341 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 6, 100 ,'主料皮肚，香肠，猪肝，肉丝，青菜，西红柿' ,'2020-07-01 09:55:00' ,'六鲜面' ,'1000000928' ,22 ,10 ,96,94,'caa2359049914362b99d8f6e94a76672.jpg'); 342 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 6, 200 ,'主料猪肉，青椒，爽口，口味咸味' ,'2020-07-01 09:55:00' ,'青椒干子肉丝盖浇饭' ,'1000000928' ,15 ,10 ,75,94,'5b9c6268084740eca939a0e2edc748e0.jpg'); 343 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 7, 100 ,'主料四川农家土公鸡，干辣椒，大火热油现炒，口味辣味' ,'2020-07-01 09:55:00' ,'辣子鸡' ,'1000000256' ,15.8 ,10 ,598,92,'d805f3f37cb14f5cbb029c6c52ba4335.jpg'); 344 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 8, 100 ,'主料现杀活鱼，老坛酸菜，鲶鱼，菜系为川菜，口味辣味' ,'2020-07-01 09:55:00' ,'酸菜鱼' ,'1000000256' ,18.8 ,10 ,214,84,'c4e71594f4a34e7b96f6453c45b561c6.jpg'); 345 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 8, 200 ,'主料上等猪肉，青椒，菜系为川菜，分量为300g，口味为辣味' ,'2020-07-01 09:55:00' ,'回锅肉' ,'1000000256' ,16.8 ,10 ,150,86,'ff82c421532948b8a75c7545bee79c6d.jpg'); 346 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 7, 100 ,'正宗陈氏麻婆豆腐工艺，主料为汉源贡椒，豆腐，菜系为川菜' ,'2020-07-01 09:55:00' ,'麻婆豆腐' ,'1000000256' ,13.8 ,10 ,160,96,'90df4091bbcf41738ac890c3fd6c2558.jpg'); 347 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 14, 200 ,'主料黄牛肉，菜系为苏菜，口感香酥，分量一两五只' ,'2020-07-01 09:55:00' ,'牛肉锅贴一两' ,'1000000000' ,9 ,10 ,1414,100,'623a4897cda747ad961ad319e9fc945b.jpg'); 348 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 14, 100 ,'主料牛杂，干丝，豆腐干，分量一碗，口味咸鲜' ,'2020-07-01 09:55:00' ,'牛杂干丝汤' ,'1000000000' ,18 ,10 ,20,90 ,'0434954129e14e62b59ffcb0316419b8.jpg'); 349 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 15, 100 ,'精选新鲜食材，坚持小锅现炒，均衡搭配更营养，口味辣味' ,'2020-07-01 09:55:00' ,'青椒烤鸭丝套餐饭' ,'1000000960' ,50 ,4.6 ,75,94 ,'c6113f97b2744059814a84eaf9bf9299.jpg'); 350 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 15, 100 ,'包含烤鸭约18片，两个褚记馍饼以及一套葱饼酱，口味椒盐' ,'2020-07-01 09:55:00' ,'烤鸭套餐' ,'1000000960' ,28.99 ,10 ,390,100 ,'608083ebdf944e61bbb74cd683919736.jpg'); 351 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 15, 100 ,'主料鸭脖，口味酱香，鸭脖是通过腌制制成' ,'2020-07-01 09:55:00' ,'酱香鸭脖' ,'1000000960' ,10.99 ,10 ,50,94 ,'1dab66cdc8fe4dc3a4268b262eab2171.jpg'); 352 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 16, 100 ,'主食一份，味增汤一份，蔬菜沙拉一份' ,'2020-07-01 09:55:00' ,'照烧鸡排饭套餐' ,'1000000384' ,38.8 ,5.13 ,1275,93 ,'d8705aebcc084397a6928cf9aadc0168.jpg'); 353 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 16, 100 ,'主料章鱼，面粉，分量六个，口味咸鲜' ,'2020-07-01 09:55:00' ,'章鱼小丸子' ,'1000000384' ,20 ,4.4 ,338,85,'783b850787484a87bf9e1b5fb6342864.jpg'); 354 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 16, 100 ,'主食一份，味增汤一份，蔬菜沙拉一份' ,'2020-07-01 09:55:00' ,'咖喱鸡排饭套餐' ,'1000000384' ,37.8 ,5.26 ,264,95 ,'2d5e45d73d06439080df0204ee99da5b.jpg'); 355 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 17, 100 ,'主食五常米饭，鸡蛋，胡萝卜，腊肠，分量一碗，口味甜辣' ,'2020-07-01 09:55:00' ,'香肠石锅拌饭' ,'1000000480' ,16 ,10 ,140,98 ,'985c5309e3fb45d08084f323bbc59e8c.jpg'); 356 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 17, 100 ,'主料肥牛，优质大米，肥牛片，分量一碗，口味香辣' ,'2020-07-01 09:55:00' ,'肥牛石锅拌饭' ,'1000000480' ,21 ,10 ,149,66 ,'c2770a415f7b48c89677fceab7690af4.jpg'); 357 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 18, 100 ,'主料虾饼，大虾，虾丸，开花肠，一份米饭，口味微辣' ,'2020-07-01 09:55:00' ,'麻辣香锅单人' ,'1000000320' ,37.8 ,5.26 ,264,95 ,'ca71c4edfd3d4766a19c71a1d8b93ec7.jpg'); 358 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 18, 100 ,'主料鸡腿，土豆片，青椒，鱼豆腐，腐竹，菜系为苏菜' ,'2020-07-01 09:55:00' ,'地锅鸡腿饭' ,'1000000288' ,20 ,10 ,821,92 ,'8944d230f623430ea3a75bafcaab4cf5.jpg'); 359 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 19, 100 ,'主料排骨，土豆片，腐竹，青椒，鱼豆腐，口味微辣' ,'2020-07-01 09:55:00' ,'地锅排骨饭' ,'1000000288' ,26 ,10 ,50,95 ,'15bf05597c7a4b1b873d7b5df39eed8c.jpg'); 360 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 24, 200 ,'四季春茶搭配特选植脂末，由黄金比例调制而成，份量一杯' ,'2020-07-01 09:55:00' ,'四季奶青' ,'1000000544' ,13 ,10 ,457,92 ,'38637d11b0b84fd5b545f2aecd36c675.jpg'); 361 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 24, 200 ,'奶茶搭配波霸，口感软，红茶，波霸，植脂末，份量一杯' ,'2020-07-01 09:55:00' ,'波霸奶茶' ,'1000000544' ,13 ,10 ,344,90 ,'bedff2f5d66047338473d23930c190d2.jpg'); 362 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 24, 200 ,'精选米酿和奶茶的碰撞，主料红茶，米酒，份量一杯' ,'2020-07-01 09:55:00' ,'桂花米酿奶茶' ,'1000000608' ,16 ,9.38 ,131,100 ,'a34e5a3dd97a44ec906554759af39ae2.jpg'); 363 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 28, 200 ,'红豆包，红豆包中包含了饱满的红豆，味道清甜' ,'2020-07-01 09:55:00' ,'红豆包' ,'1000000576' ,9 ,10 ,88,95 ,'782783e242b34adab17e67c2a467c147.jpg'); 364 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 28, 200 ,'芋泥空气小蛋糕，蛋糕的味道十分美味' ,'2020-07-01 09:55:00' ,'芋泥空气小蛋糕' ,'1000000576' ,6 ,10 ,88,95 ,'134980d855ce4629a295748eb668465e.jpg'); 365 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 28, 200 ,'葡式蛋挞，蛋挞的口感新鲜美味' ,'2020-07-01 09:55:00' ,'葡式蛋挞' ,'1000000576' ,6.5 ,10 ,28,95 ,'94d7a49e058644f9bb4c4c6281188323.jpg'); 366 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 28, 200 ,'新鲜现做，新鲜水果夹心，主料蛋糕胚，芒果，蓝莓' ,'2020-07-01 09:55:00' ,'芒果生日蛋糕' ,'1000000640' ,138 ,2.2 ,380,96 ,'3e1ae48423844268807b858bb453b765.jpg '); 367 INSERT INTO dish(`dishTypeID`,`remain`,`description`,`startTime`,`name`,`resID`,`price`,`discount`,`saleAmount`,`score`,`image`) VALUE( 28, 200 ,'新鲜现做，新鲜水果夹心，主料蛋糕胚，高级奶油' ,'2020-07-01 09:55:00' ,'黑森林蛋糕' ,'1000000640' ,168 ,2.38 ,125,95 ,'5bdeea7ccc70459f85f0bcb2ccac7ed8.jpg'); 368 369 370 #insert users 371 INSERT INTO users(`userName`,`password`,`address`,`email`,`avatar`,`userState`,`phoneNum`,`accountID`,`score`) VALUES( '王安文' , '19825000668' , '南京市南京理工大学（南大门）' , '19825000668@qq.com', '67f81b3431074ee4888ad208207d0e5b.jpg','registered', '19825000668', '19825000668', '2000' ); 372 INSERT INTO users(`userName`,`password`,`address`,`email`,`avatar`,`userState`,`phoneNum`,`accountID`,`score`) VALUES( '宋涛' , '13218875296' , '南京理工大学宁静轩' , '13218875296@qq.com', '599963243f05468094fa27d402b2d437.jpg', 'registered', '13218875296', '13218875296', '1000' ); 373 INSERT INTO users(`userName`,`password`,`address`,`email`,`avatar`,`userState`,`phoneNum`,`accountID`,`score`) VALUES( '罗文水' , '17851093886' , '南京理工大学明理居' , '1551904915@qq.com', '722cb5b88e4544d9ab5bae6d7fa49f9f.jpg', 'registered', '17851093886', '17851093886', '1000' ); 374 375 376 #插入orders 377 INSERT INTO orders(`userID`,`resID`,`orderTime`,`state`) VALUES( 1, '1000000992' ,'2020-01-03 09:55:00' ,'cancel' ); 378 INSERT INTO orders(`userID`,`resID`,`orderTime`,`state`) VALUES( 2, '1000000992' ,'2020-02-03 10:55:00' ,'alreadypay' ); 379 INSERT INTO orders(`userID`,`resID`,`orderTime`,`state`) VALUES( 3, '1000000992' ,'2020-03-03 11:55:00' ,'indelivery' ); 380 INSERT INTO orders(`userID`,`resID`,`orderTime`,`state`) VALUES(3,'1000000992','2020-04-03 13:55:00','noreview'); 381 INSERT INTO orders(`userID`,`resID`,`orderTime`,`state`) VALUES( 2, '1000000992' ,'2020-05-03 13:55:00' ,'alreadyreview' ); 382 INSERT INTO orders(`userID`,`resID`,`orderTime`,`state`) VALUES( 1, '1000000992' ,'2020-06-03 09:55:00' ,'cancel' ); 383 INSERT INTO orders(`userID`,`resID`,`orderTime`,`state`) VALUES( 2, '1000000992' ,'2020-07-03 10:55:00' ,'alreadypay' ); 384 INSERT INTO orders(`userID`,`resID`,`orderTime`,`state`) VALUES( 3, '1000000992' ,'2020-08-03 11:55:00' ,'indelivery' ); 385 INSERT INTO orders(`userID`,`resID`,`orderTime`,`state`) VALUES(3,'1000000992','2020-09-03 13:55:00','noreview'); 386 INSERT INTO orders(`userID`,`resID`,`orderTime`,`state`) VALUES( 2, '1000000992' ,'2020-09-03 13:55:00' ,'alreadyreview' ); 387 388 389 #插入orderitem 390 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 4, 1, 2 ); 391 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 4, 2,1 ); 392 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 4, 3, 1 ); 393 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 2, 12 ,4 ); 394 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 3, 11, 5 ); 395 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 1, 4, 3); 396 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 5, 5, 2); 397 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 6, 1, 2 ); 398 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 6, 2,1 ); 399 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 7, 3, 1 ); 400 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 8, 9 ,4 ); 401 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 9, 7, 5 ); 402 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 10, 4, 3); 403 INSERT INTO orderitem(`orderID`,`dishID`,`count`) VALUES( 10, 5, 2); 404 405 406 407 #插入review 408 INSERT INTO review(`userID`,`content`,`time`,`resID`) values(2,'菜品非常地美味！！','2020-07-01 09:55:00','1000000992');
下面是各个页面：
