项目类型:SSM源码
用户类型:3个角色(管理员+普通用户+代取员)
主要技术:SSM+MySQL+Layui
开发工具:Eclipse/Idea均可使用,有两个不同的版本
数据库:MySQL
数据库表:7张
项目介绍:后端采用SSM。前端使用的是Bootstrap的一个网站模板。通过3种角色使用。包括了快递信息管理、代取员管理、快递代取管理等多个不同的模块。
🍅演示视频在底部🍅
🍅文末获取联系🍅
目录
2.4快递签收(需要填写准确的取件码,如果超时则需要支付费用)
【原创】基于ssm快递代取管理系统(毕业设计源代码)
-
-
- SET NAMES utf8mb4;
- SET FOREIGN_KEY_CHECKS = 0;
-
- -- ----------------------------
- -- Table structure for admin
- -- ----------------------------
- DROP TABLE IF EXISTS `admin`;
- CREATE TABLE `admin` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
-
-
- -- ----------------------------
- -- Table structure for agent
- -- ----------------------------
- DROP TABLE IF EXISTS `agent`;
- CREATE TABLE `agent` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `tx` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `tno` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
-
-
- -- ----------------------------
- -- Table structure for board
- -- ----------------------------
- DROP TABLE IF EXISTS `board`;
- CREATE TABLE `board` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `editor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
-
- -- ----------------------------
- -- Table structure for goods
- -- ----------------------------
- DROP TABLE IF EXISTS `goods`;
- CREATE TABLE `goods` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `gno` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '快递单号',
- `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '物品名称',
- `sid` int(11) DEFAULT NULL COMMENT '学生id',
- `weight` double DEFAULT NULL COMMENT '快递重量',
- `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收货地址',
- `createTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建时间',
- `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '1' COMMENT '状态 1已入库 2预定中 3代取中 4已签收',
- `quTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '取件时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
-
- -- ----------------------------
- -- Table structure for record
- -- ----------------------------
- DROP TABLE IF EXISTS `record`;
- CREATE TABLE `record` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `gid` int(11) DEFAULT NULL COMMENT '快递id',
- `rid` int(11) DEFAULT NULL COMMENT '宿舍楼id',
- `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '详细地址',
- `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '1' COMMENT '1预定中 2已接单 3已签收',
- `createtime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '预定时间',
- `money` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '代取费用',
- `rnum` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '代取单号',
- `aid` int(11) DEFAULT NULL COMMENT '代取员id',
- `yy_date` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '预约日期',
- `yy_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '具体时间',
- `sid` int(11) DEFAULT NULL COMMENT '学生id',
- `quNum` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '取件码',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
-
-
- -- ----------------------------
- -- Table structure for room
- -- ----------------------------
- DROP TABLE IF EXISTS `room`;
- CREATE TABLE `room` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `rno` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
-
-
- -- ----------------------------
- -- Table structure for student
- -- ----------------------------
- DROP TABLE IF EXISTS `student`;
- CREATE TABLE `student` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `tx` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `stno` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `school` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- `grade` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
-
- SET FOREIGN_KEY_CHECKS = 1;