登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 1 Fork 3

jylx_spiral / MDVRP

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
madefei.sql 12.66 KB
一键复制 编辑 原始数据 按行查看 历史
jylx_spiral 提交于 2017-11-20 23:15 . 毕业设计前与导师合作的实验性Demo。尝试将多目标多车场车辆路径问题的解决算法应用于WEB。并通过对接百度地图API，将解决方案的现实路径通…
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146
/*

Navicat MySQL Data Transfer



Source Server         : Mysql

Source Server Version : 50528

Source Host           : localhost:3306

Source Database       : madefei



Target Server Type    : MYSQL

Target Server Version : 50528

File Encoding         : 65001



Date: 2017-01-05 13:49:46

*/



SET FOREIGN_KEY_CHECKS=0;



-- ----------------------------

-- Table structure for admin

-- ----------------------------

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (

  `uId` int(5) NOT NULL AUTO_INCREMENT,

  `username` varchar(16) DEFAULT NULL,

  `password` varchar(20) DEFAULT NULL,

  PRIMARY KEY (`uId`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of admin

-- ----------------------------

INSERT INTO `admin` VALUES ('1', 'admin', 'admin');



-- ----------------------------

-- Table structure for express

-- ----------------------------

DROP TABLE IF EXISTS `express`;

CREATE TABLE `express` (

  `expressId` int(10) NOT NULL AUTO_INCREMENT,

  `sender` varchar(8) DEFAULT NULL,

  `senderTel` varchar(11) DEFAULT NULL,

  `fromAddr` varchar(255) DEFAULT NULL,

  `fromLNG` double(10,6) DEFAULT NULL,

  `fromLAT` double(10,6) DEFAULT NULL,

  `reciever` varchar(8) DEFAULT NULL,

  `recieverTel` varchar(11) DEFAULT NULL,

  `toAddr` varchar(255) DEFAULT NULL,

  `toLNG` double(10,6) DEFAULT NULL,

  `toLAT` double(10,6) DEFAULT NULL,

  `volume` double(5,2) DEFAULT NULL,

  `weight` double(5,2) DEFAULT NULL,

  `status` int(1) DEFAULT NULL,

  `rmark` varchar(255) NOT NULL,

  `date` datetime DEFAULT NULL,

  PRIMARY KEY (`expressId`)

) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of express

-- ----------------------------

INSERT INTO `express` VALUES ('8', '林泽宇1', '18814103662', '广东省广州市白云区同沙路', '113.340713', '23.201115', '毕志升1', '13926487223', '广东省广州市番禺区金山大道', '113.502854', '23.039359', '7.00', '7.00', '1', 'aaa', '2016-12-26 15:15:38');

INSERT INTO `express` VALUES ('9', '林泽宇2', '18814103662', '广东省广州市越秀区北京路376号', '113.275149', '23.134561', '毕志升2', '13926487223', '广东省广州市番禺区新化快速路', '113.448965', '23.039691', '30.00', '30.00', '0', '', '2016-12-26 15:16:34');

INSERT INTO `express` VALUES ('10', '林泽宇3', '18814103662', '广东省广州市番禺区福愉东路8号', '113.381433', '22.917109', '毕志升3', '13926487223', '广东省广州市越秀区小北路198号', '113.278634', '23.141882', '16.00', '16.00', '2', '', '2016-12-26 15:17:55');

INSERT INTO `express` VALUES ('11', '林泽宇4', '18814103662', '广东省广州市番禺区迎星中路', '113.372232', '22.969886', '毕志升4', '13926487223', '广东省广州市越秀区东园横路2号', '113.283906', '23.124654', '9.00', '9.00', '2', '', '2016-12-26 15:18:58');

INSERT INTO `express` VALUES ('12', '林泽宇5', '18814103662', '广东省广州市花都区迎宾大道89号', '113.226835', '23.409571', '毕志升5', '13926487223', '广东省广州市海珠区龙三工业区四路', '113.345477', '23.083300', '21.00', '21.00', '1', '', '2016-12-26 15:19:35');

INSERT INTO `express` VALUES ('13', '林泽宇6', '18814103662', '广东省广州市天河区金穗路711号', '113.345025', '23.129528', '毕志升6', '13926487223', '广东省广州市番禺区福愉东路8号', '113.381433', '22.917109', '15.00', '15.00', '2', '', '2016-12-26 15:20:52');

INSERT INTO `express` VALUES ('14', '林泽宇7', '18814103662', '广东省广州市白云区祥元路', '113.264564', '23.159039', '毕志升7', '13926487223', '广东省广州市番禺区大口涌北西街', '113.398961', '22.927991', '19.00', '19.00', '0', '', '2016-12-26 15:21:33');

INSERT INTO `express` VALUES ('15', '林泽宇8', '18814103662', '广东省广州市增城市立新中路16号', '113.799733', '23.177306', '毕志升8', '13926487223', '广东省广州市天河区天河路230号', '113.332502', '23.138314', '23.00', '23.00', '1', '', '2016-12-26 15:22:10');

INSERT INTO `express` VALUES ('16', 'Mike-1', '18888888888', '广东省广州市番禺区曾边大街', '113.422217', '23.034689', 'John-1', '13988888888', '广东省广州市荔湾区金花直街85号', '113.256603', '23.135067', '7.00', '7.00', '0', '', '2017-01-03 09:52:09');

INSERT INTO `express` VALUES ('17', 'Mike-2', '18888888888', '广东省广州市番禺区谷围路', '113.442606', '23.040697', 'John-2', '13988888888', '广东省广州市荔湾区康王中路713号', '113.253313', '23.129600', '30.00', '30.00', '0', '', '2017-01-03 09:54:15');

INSERT INTO `express` VALUES ('18', 'Mike-3', '18888888888', '广东省广州市荔湾区恩宁路41号', '113.243041', '23.121427', 'John-3', '13988888888', '广东省广州市番禺区工业路17号', '113.465719', '23.035528', '16.00', '16.00', '1', '', '2017-01-03 09:55:19');

INSERT INTO `express` VALUES ('19', 'Mike-4', '18888888888', '广东省广州市荔湾区恩洲大巷207', '113.243036', '23.130175', 'John-4', '13988888888', '广东省广州市番禺区大石湖街', '113.462944', '23.046156', '9.00', '9.00', '0', '', '2017-01-03 09:56:20');

INSERT INTO `express` VALUES ('20', 'Mike-5', '18888888888', '广东省广州市番禺区东溪东大街', '113.456874', '23.061856', 'John-5', '13988888888', '广东省广州市荔湾区坦尾路1号', '113.224515', '23.129197', '21.00', '21.00', '0', '', '2017-01-03 09:57:47');

INSERT INTO `express` VALUES ('21', 'Mike-6', '18888888888', '广东省广州市白云区沙凤一路4号', '113.211098', '23.155856', 'John-6', '13988888888', '广东省广州市番禺区新马路', '113.453610', '23.066983', '15.00', '15.00', '0', '', '2017-01-03 09:59:58');

INSERT INTO `express` VALUES ('22', 'Mike-7', '18888888888', '广东省广州市番禺区海运路33号', '113.443166', '23.059928', 'John-7', '13988888888', '广东省广州市荔湾区西湾路59号', '113.247582', '23.157408', '19.00', '19.00', '0', '', '2017-01-03 10:02:16');

INSERT INTO `express` VALUES ('23', 'Mike-8', '18888888888', '广东省广州市越秀区站前路229号017档', '113.259794', '23.151536', 'John-8', '13988888888', '广东省广州市番禺区育新路28号', '113.437383', '23.055967', '23.00', '23.00', '0', '', '2017-01-03 10:03:22');

INSERT INTO `express` VALUES ('24', 'Mike-9', '18888888888', '广东省广州市荔湾区新基路26号', '113.257111', '23.113836', 'John-9', '13988888888', '广东省广州市海珠区新港东路170', '113.350807', '23.104106', '2.12', '5.00', '0', '', '2017-01-03 09:52:03');

INSERT INTO `express` VALUES ('25', 'John-1', '18888888888', '广东省广州市番禺区新广路30', '113.422905', '23.040691', 'Mike-1', '13988888888', '广东省广州市越秀区彭家巷1号', '113.263171', '23.136992', '7.00', '7.00', '0', '', '2017-01-04 10:09:52');

INSERT INTO `express` VALUES ('26', 'John-2', '18888888888', '广东省广州市越秀区人民北路116', '113.260800', '23.141669', 'Mike-2', '13988888888', '广东省广州市番禺区X942(兴业大道)', '113.442937', '23.040342', '30.00', '30.00', '0', '', '2017-01-04 10:11:03');

INSERT INTO `express` VALUES ('27', 'John-3', '18888888888', '广东省广州市越秀区高第街68号', '113.272286', '23.123333', 'Mike-3', '13988888888', '广东省广州市番禺区兴岭路', '113.494645', '22.949329', '16.00', '16.00', '0', '', '2017-01-04 10:13:49');

INSERT INTO `express` VALUES ('28', 'John-4', '18888888888', '广东省广州市海珠区怡乐街32号', '113.303486', '23.072064', 'Mike-4', '13988888888', '广东省广州市番禺区东华路', '113.351286', '23.043525', '9.00', '9.00', '0', '', '2017-01-04 10:15:49');

INSERT INTO `express` VALUES ('29', 'John-5', '18888888888', '广东省广州市天河区S81(广州环城高速)', '113.409379', '23.109971', 'Mike-5', '13988888888', '广东省广州市番禺区南站北路', '113.275872', '22.995057', '21.00', '21.00', '0', '', '2017-01-04 10:17:20');

INSERT INTO `express` VALUES ('30', 'John-6', '18888888888', '广东省广州市番禺区大学城星光下道', '113.386029', '23.043485', 'Mike-6', '13988888888', '广东省广州市越秀区东风西路171号', '113.259542', '23.139143', '15.00', '15.00', '0', '', '2017-01-04 10:18:24');

INSERT INTO `express` VALUES ('31', 'John-7', '18888888888', '广东省广州市番禺区北亭一路', '113.442129', '23.041722', 'Mike-7', '13988888888', '广东省广州市越秀区应元路九龙街2-30号', '113.270753', '23.140340', '19.00', '19.00', '0', '', '2017-01-04 10:19:41');

INSERT INTO `express` VALUES ('32', 'John-8', '18888888888', '广东省广州市越秀区东风中路305号', '113.273313', '23.137714', 'Mike-8', '13988888888', '广东省广州市番禺区景秀路', '113.430451', '23.046220', '23.00', '23.00', '0', '', '2017-01-04 10:20:50');

INSERT INTO `express` VALUES ('33', 'John', '18888888888', '广东省广州市荔湾区西增路63', '113.244334', '23.151181', 'Mike', '13988888888', '广东省广州市荔湾区西增路63号', '113.244398', '23.150931', '27.00', '27.00', '0', '', '2017-01-05 12:46:21');

INSERT INTO `express` VALUES ('34', 'John', '18888888888', '广东省广州市越秀区人民北路辅路', '113.265300', '23.150292', 'Mike', '13988888888', '广东省广州市越秀区流花路127号', '113.263629', '23.146636', '16.00', '16.00', '0', '', '2017-01-05 12:47:11');

INSERT INTO `express` VALUES ('35', 'John', '18888888888', '广东省广州市越秀区解放北路802号', '113.268363', '23.137798', 'Mike', '13988888888', '广东省广州市越秀区解放北路889号', '113.268038', '23.145036', '10.00', '10.00', '0', '', '2017-01-05 12:47:59');

INSERT INTO `express` VALUES ('36', 'John', '18888888888', '广东省广州市越秀区流花路111号', '113.260871', '23.146928', 'Mike', '13988888888', '广东省广州市越秀区流花路111-8', '113.261595', '23.146147', '17.00', '17.00', '0', '', '2017-01-05 12:50:59');

INSERT INTO `express` VALUES ('37', 'John', '18888888888', '广东省广州市越秀区新桥直街45号', '113.256488', '23.138429', 'Mike', '13988888888', '广东省广州市越秀区新桥街10号', '113.257119', '23.137528', '11.00', '11.00', '0', '', '2017-01-05 12:51:40');

INSERT INTO `express` VALUES ('38', 'John', '18888888888', '广东省广州市番禺区筱园东路', '113.396908', '23.071899', 'Mike', '13988888888', '广东省广州市番禺区筱园东路', '113.397987', '23.072270', '33.00', '33.00', '0', '', '2017-01-05 12:52:47');

INSERT INTO `express` VALUES ('39', 'John', '18888888888', '广东省广州市番禺区X297(南村东线路)', '113.406951', '23.015090', 'Mike', '13988888888', '广东省广州市番禺区南站北路', '113.275872', '22.995057', '19.00', '19.00', '0', '', '2017-01-05 12:53:40');

INSERT INTO `express` VALUES ('40', 'John', '18888888888', '广东省广州市番禺区X942(兴业大道)', '113.435786', '23.031446', 'Mike', '13988888888', '广东省广州市番禺区东兴路18号', '113.385716', '22.934570', '18.00', '18.00', '0', '', '2017-01-05 12:54:23');



-- ----------------------------

-- Table structure for fromplans

-- ----------------------------

DROP TABLE IF EXISTS `fromplans`;

CREATE TABLE `fromplans` (

  `fplansId` int(8) NOT NULL,

  `fplans` varchar(1024) DEFAULT NULL,

  `fplanNo` int(3) DEFAULT '0',

  PRIMARY KEY (`fplansId`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of fromplans

-- ----------------------------

INSERT INTO `fromplans` VALUES ('20161226', '20161226.Plans', '0');

INSERT INTO `fromplans` VALUES ('20170103', '20170103.Plans', '0');

INSERT INTO `fromplans` VALUES ('20170104', '20170104.Plans', '0');

INSERT INTO `fromplans` VALUES ('20170105', '20170105.Plans', '0');



-- ----------------------------

-- Table structure for port

-- ----------------------------

DROP TABLE IF EXISTS `port`;

CREATE TABLE `port` (

  `pId` int(11) NOT NULL AUTO_INCREMENT,

  `pLNG` double(10,6) DEFAULT NULL,

  `pLAT` varchar(10) DEFAULT NULL,

  `state` int(1) DEFAULT NULL,

  PRIMARY KEY (`pId`)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of port

-- ----------------------------

INSERT INTO `port` VALUES ('1', '113.432337', '23.048174', '1');

INSERT INTO `port` VALUES ('2', '113.263207', '23.140265', '1');

INSERT INTO `port` VALUES ('3', '113.275995', '23.117055', '0');



-- ----------------------------

-- Table structure for toplans

-- ----------------------------

DROP TABLE IF EXISTS `toplans`;

CREATE TABLE `toplans` (

  `tplansId` int(8) NOT NULL,

  `tplans` varchar(1024) DEFAULT NULL,

  `tplanNo` int(3) DEFAULT '0',

  PRIMARY KEY (`tplansId`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;



-- ----------------------------

-- Records of toplans

-- ----------------------------
Java
1
https://gitee.com/jylx_spiral/MDVRP.git
git@gitee.com:jylx_spiral/MDVRP.git
jylx_spiral
MDVRP
MDVRP
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部