数据库中部分数据如下:

/*
 Navicat Premium Data Transfer

 Source Server         : yfy的linux
 Source Server Type    : MySQL
 Source Server Version : 50644
 Source Host           : 39.105.67.182
 Source Database       : p19014

 Target Server Type    : MySQL
 Target Server Version : 50644
 File Encoding         : utf-8

 Date: 09/07/2019 15:12:33 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `logistics_company`
-- ----------------------------
DROP TABLE IF EXISTS `logistics_company`;
CREATE TABLE `logistics_company` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(20) DEFAULT NULL COMMENT '快递公司名',
  `type` varchar(20) DEFAULT NULL COMMENT '快递公司编号',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8mb4 COMMENT='快递公司表';

-- ----------------------------
--  Records of `logistics_company`
-- ----------------------------
BEGIN;
INSERT INTO `logistics_company` VALUES ('1', 'AAE', 'AAEWEB', '2019-09-07 12:06:32'), ('2', '安讯物流', 'ANXL', '2019-09-07 12:06:48'), ('3', '安捷物流', 'AJWL', '2019-09-07 12:07:09'), ('4', '安世通快递', 'ASTEXPRESS', '2019-09-07 12:07:40'), ('5', '澳多多国际速递', 'ADODOXOM', '2019-09-07 12:08:13'), ('6', '安达速递', 'ADAPOST', '2019-09-07 12:08:41'), ('7', '澳洲迈速快递', 'MAXEEDEXPRESS', '2019-09-07 12:09:08'), ('8', 'Aramex', 'ARAMEX', '2019-09-07 12:09:21'), ('9', 'DHL国内件', 'DHL', '2019-09-07 12:09:32'), ('10', 'DPEX', 'DPEX', '2019-09-07 12:09:39'), ('11', 'D速', 'DEXP', '2019-09-07 12:09:50'), ('12', 'EMS', 'EMS', '2019-09-07 12:09:57'), ('13', 'EWE', 'EWE', '2019-09-07 12:10:05'), ('14', 'FedEx', 'FEDEX', '2019-09-07 12:10:15'), ('15', 'FedEx国际', 'FEDEXIN', '2019-09-07 12:10:29'), ('16', 'PCA', 'PCA', '2019-09-07 12:10:41'), ('17', 'TNT', 'TNT', '2019-09-07 12:10:48'), ('18', 'UPS', 'UPS', '2019-09-07 12:10:57'), ('19', '安捷快递', 'ANJELEX', '2019-09-07 12:11:17'), ('20', '安能', 'ANE', '2019-09-07 12:11:28'), ('21', '安能快递', 'ANEEX', '2019-09-07 12:11:38'), ('22', '安信达', 'ANXINDA', '2019-09-07 12:11:53'), ('23', '百福东方', 'EES', '2019-09-07 12:12:08'), ('24', '百世快递', 'HTKY', '2019-09-07 12:12:26'), ('25', '百世快运', 'BSKY', '2019-09-07 14:22:18'), ('26', '程光', 'FLYWAYEX', '2019-09-07 14:30:02'), ('27', '大田', 'DTW', '2019-09-07 14:30:56'), ('28', '德邦', 'DEPPON', '2019-09-07 14:31:12'), ('29', '飞洋', 'GCE', '2019-09-07 14:32:35'), ('30', '凤凰', 'PHOENIXEXP', '2019-09-07 14:32:46'), ('31', '富腾达', 'FTD', '2019-09-07 14:33:01'), ('32', '共速达', 'GSD', '2019-09-07 14:33:12'), ('33', '国通', 'GTO', '2019-09-07 14:33:21'), ('34', '黑狗', 'BLACKDOG', '2019-09-07 14:33:30'), ('35', '恒路', 'HENGLU', '2019-09-07 14:33:46'), ('36', '鸿远', 'HYE', '2019-09-07 14:34:14'), ('37', '华企', 'HQKY', '2019-09-07 14:34:32'), ('38', '急先达', 'JOUST', '2019-09-07 14:34:52'), ('39', '加运美', 'TMS', '2019-09-07 14:35:02'), ('40', '佳吉', 'JIAJI', '2019-09-07 14:35:16'), ('41', '佳怡', 'JIAYI', '2019-09-07 14:35:26'), ('42', '嘉里物流', 'KERRY', '2019-09-07 14:35:40'), ('43', '锦程快递', 'HREX', '2019-09-07 14:36:06'), ('44', '晋越', 'PEWKEE', '2019-09-07 14:36:22'), ('45', '京东', 'JD', '2019-09-07 14:36:57'), ('46', '京广', 'KKE', '2019-09-07 14:37:06'), ('47', '九曳', 'JIUYESCM', '2019-09-07 14:37:20'), ('48', '跨越苏运', 'KYEXPRESS', '2019-09-07 14:37:40'), ('49', '快捷', 'FASTEXPRESS', '2019-09-07 14:38:06'), ('50', '蓝天', 'BLUESKY', '2019-09-07 14:38:16'), ('51', '联昊通', 'LTS', '2019-09-07 14:38:32'), ('52', '中通快运', 'ZTO56', '2019-09-07 14:42:08'), ('53', '壹米滴答', 'YIMIDIDA', '2019-09-07 14:42:32'), ('54', '日日顺物流', 'RRS', '2019-09-07 14:42:42'), ('55', '宇鑫物流', 'YXWL', '2019-09-07 14:42:56'), ('56', '东骏快捷', 'DJ56', '2019-09-07 14:43:18'), ('57', '联邦快递国际', 'FEDEX_GJ', '2019-09-07 14:44:18'), ('58', '澳邮专线(澳邮中国快运)', 'AYCA', '2019-09-07 14:45:10'), ('59', '城市100', 'CITY100', '2019-09-07 14:45:22'), ('60', '递四方速递', 'D4PX', '2019-09-07 14:45:42'), ('61', '广通', 'GTSD', '2019-09-07 14:45:49'), ('62', '好来运快递', 'HYLSD', '2019-09-07 14:46:07'), ('63', '捷特快递', 'JTKD', '2019-09-07 14:46:23'), ('64', '民邦快递', 'MB', '2019-09-07 14:46:34'), ('65', '明亮物流', 'MLWL', '2019-09-07 14:46:49'), ('66', '泛捷快递', 'PANEX', '2019-09-07 14:47:13'), ('67', '全信通', 'QXT', '2019-09-07 14:47:24'), ('68', '赛澳递', 'SAD', '2019-09-07 14:47:34'), ('69', '上大物流', 'SDWL', '2019-09-07 14:47:42'), ('70', '速腾快递', 'STWL', '2019-09-07 14:47:53'), ('71', '万家康', 'WJK', '2019-09-07 14:48:00'), ('72', '增益快递', 'ZENY', '2019-09-07 14:48:29'), ('73', '河马动力', 'HEMA', '2019-09-07 14:48:42'), ('74', '民航', 'CAE', '2019-09-07 14:49:22'), ('75', '澳天速运', 'AOTSD', '2019-09-07 14:49:49'), ('76', '安鲜达', 'EXFRESH', '2019-09-07 14:50:05'), ('77', 'ANTS', 'ANTS', '2019-09-07 14:50:17'), ('78', '爱拜物流', 'IBUY8', '2019-09-07 14:50:39'), ('79', 'Aplus物流', 'APLUSEX', '2019-09-07 14:50:51'), ('80', '澳世速递', 'AUSEXPRESS', '2019-09-07 14:51:05'), ('81', '昂威物流', 'ONWAY', '2019-09-07 14:51:25'), ('82', '能达', 'ND56', '2019-09-07 14:51:36'), ('83', 'DHL国际件', 'DHL_EN', '2019-09-07 14:51:50'), ('84', '平安快递', 'EPSPOST', '2019-09-07 14:52:02'), ('85', '秦远物流', 'CHINZ56', '2019-09-07 14:52:22'), ('86', '全晨', 'QCKD', '2019-09-07 14:52:34'), ('87', '全峰', 'QFKD', '2019-09-07 14:52:43'), ('88', '全一', 'APEX', '2019-09-07 14:52:54'), ('89', '如风达', 'RFD', '2019-09-07 14:53:02'), ('90', '三态', 'SFC', '2019-09-07 14:53:18'), ('91', '申通', 'STO', '2019-09-07 14:53:29'), ('92', '盛丰', 'SFWL', '2019-09-07 14:53:52'), ('93', '盛辉', 'SHENGHUI', '2019-09-07 14:54:05'), ('94', '顺达快递', 'SDEX', '2019-09-07 14:54:13'), ('95', '顺丰', 'SFEXPRESS', '2019-09-07 14:54:44'), ('96', '苏宁', 'SUNING', '2019-09-07 14:54:55'), ('97', '速尔', 'SURE', '2019-09-07 14:55:03'), ('98', '天地华宇', 'HOAU', '2019-09-07 14:55:15'), ('99', '天天', 'TIKDEX', '2019-09-07 14:55:24'), ('100', '万庚', 'VANGEN', '2019-09-07 14:55:37'), ('101', '万家物流', 'WANJIA', '2019-09-07 14:55:47'), ('102', '万象', 'EWINSHINE', '2019-09-07 14:56:00'), ('103', '文捷航空', 'GZWENJIE', '2019-09-07 14:56:21'), ('104', '新邦', 'XBWL', '2019-09-07 14:56:49'), ('105', '信丰', 'XFEXPRESS', '2019-09-07 14:56:59'), ('106', '亚风', 'BROADASIA', '2019-09-07 14:57:18'), ('107', '宜送', 'YIEXPRESS', '2019-09-07 14:57:39'), ('108', '易达通', 'QEXPRESS', '2019-09-07 14:57:57'), ('109', '易通达', 'ETD', '2019-09-07 14:58:06'), ('110', '优速', 'UC56', '2019-09-07 14:58:25'), ('111', '邮政包裹', 'CHINAPOST', '2019-09-07 14:58:34'), ('112', '原飞航', 'YEHEX', '2019-09-07 14:58:53'), ('113', '圆通', 'YTO', '2019-09-07 14:59:01'), ('114', '源安达', 'YADEX', '2019-09-07 14:59:16'), ('115', '远成', 'YCGWL', '2019-09-07 14:59:27'), ('116', '越丰', 'YFEXPRESS', '2019-09-07 14:59:40'), ('117', '运通', 'YTEXPRESS', '2019-09-07 14:59:50'), ('118', '韵达', 'YUNDA', '2019-09-07 14:59:58'), ('119', '宅急送', 'ZJS', '2019-09-07 15:00:09'), ('120', '芝麻开门', 'ZMKMEX', '2019-09-07 15:00:21'), ('121', '中国东方', 'COE', '2019-09-07 15:00:32'), ('122', '中铁快运', 'CRE', '2019-09-07 15:00:44'), ('123', '中铁物流', 'ZTKY', '2019-09-07 15:00:53'), ('124', '中通', 'ZTO', '2019-09-07 15:00:59'), ('125', '龙邦', 'LBEX', '2019-09-07 15:01:07'), ('126', '中邮', 'CNPL', '2019-09-07 15:01:15'), ('127', '品骏快递', 'PJKD', '2019-09-07 15:01:27'), ('128', '汇通快递', 'HTKY', '2019-09-07 15:01:41'), ('129', '邮政国际包裹', 'INTMAIL', '2019-09-07 15:01:52'), ('130', '联邦快递', 'FEDEX', '2019-09-07 15:02:02'), ('131', '配思航宇', 'PEISI', '2019-09-07 15:02:16'), ('132', '八达通', 'BDT', '2019-09-07 15:02:27'), ('133', '城际快递', 'CJKD', '2019-09-07 15:03:59'), ('134', '飞康达', 'FKD', '2019-09-07 15:04:12'), ('135', '环球速运', 'HQSY', '2019-09-07 15:04:21'), ('136', '捷安达', 'JAD', '2019-09-07 15:04:32'), ('137', '景光物流', 'JGWL', '2019-09-07 15:04:48'), ('138', '美快', 'MK', '2019-09-07 15:04:59'), ('139', '平安达腾飞快递', 'PADTF', '2019-09-07 15:05:14'), ('140', '全日通快递', 'QRT', '2019-09-07 15:05:23'), ('141', '瑞风速递', 'RFEX', '2019-09-07 15:05:36'), ('142', '圣安物流', 'SAWL', '2019-09-07 15:05:50'), ('143', '速通物流', 'ST', '2019-09-07 15:05:58'), ('144', '速必达物流', 'SUBIDA', '2019-09-07 15:06:11'), ('145', '新杰物流', 'XJ', '2019-09-07 15:06:23'), ('146', '中邮物流', 'ZYWL', '2019-09-07 15:06:33'), ('147', '澳通速递', 'AOL', '2019-09-07 15:06:43'), ('148', '欧亚专线', 'EUASIA', '2019-09-07 15:06:52');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;