javaWeb应用 ssm架构三方外卖系统

外卖系统三方用户——————消费者，管理员，餐馆
其中消费者——点餐、支付订单、查看订单、评论、注册、查看个人信息、积分和等级附加特性、查看订餐路线规划、取消订单、按照类别查找菜品等业务
管理员——审批餐馆
餐馆——申请入驻、查看评论、查看和修改菜品信息、上传菜品信息、查看本餐馆数据分析结果等业务
整体架构：Spring+SpringMVC+Mybatis+Maven
前端架构：JQuery+Bootstrap+Ajax+echarts+highcharts+Amap（高德地图API）+font-awesome等
后端架构：Mybatis
本软件由南京理工大学课设团队于九月耗时十几天完成，下面放图，现若有想要源码学习的同学，可以访问https://github.com/randydkx/DeliveryPlatform。
界面可能稍微拙劣，但由于技术集成度较高，总有你希望学到的东西
数据库配置文件：
  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');