校园快递管理系统-JAVA.JSP【数据库设计、论文、源码、开题报告】

主要使用技术

spring+struts+hibernate+jsp+mysql+tomcat

功能介绍

本系统为基于jsp+mysql的校园快递管理系统，包含用户（学生）和管理员权限，功能如下：
学生：可以查看我的好友，可以发送好友邀请给其他用户，删除好友；可以查看好友申请，同意好友申请，加为好友；可以查看其他用户给我发送的私信并回复；可以查看我发送的私信；可以查看我的快递并签收；可以看到好友的快递（必须是好友）并代签。

数据库脚本

DROP TABLE IF EXISTS `apply`;
CREATE TABLE `apply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `addDate` varchar(255) DEFAULT NULL,
  `checked` bit(1) NOT NULL,
  `content` varchar(255) DEFAULT NULL,
  `from_userid` int(11) DEFAULT NULL,
  `to_userid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `FK58B836E97A657C4` (`from_userid`),
  KEY `FK58B836E30EB43D3` (`to_userid`),
  CONSTRAINT `FK58B836E30EB43D3` FOREIGN KEY (`to_userid`) REFERENCES `user` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK58B836E97A657C4` FOREIGN KEY (`from_userid`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

CREATE TABLE `express` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `area` varchar(255) DEFAULT NULL,
  `finDate` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `sid` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `addressee` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `FKB1FA8F70BBCBCEFD` (`addressee`),
  CONSTRAINT `FKB1FA8F70BBCBCEFD` FOREIGN KEY (`addressee`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

CREATE TABLE `friend` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `checked` bit(1) NOT NULL,
  `user1id` int(11) DEFAULT NULL,
  `user2id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `FKB4860A9E7EE594CA` (`user1id`),
  KEY `FKB4860A9E7EE5988B` (`user2id`),
  CONSTRAINT `FKB4860A9E7EE594CA` FOREIGN KEY (`user1id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FKB4860A9E7EE5988B` FOREIGN KEY (`user2id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;



CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `loginId` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `userRole` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `loginId` (`loginId`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

CREATE TABLE `user_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `addDate` varchar(255) DEFAULT NULL,
  `allUser` bit(1) NOT NULL,
  `content` varchar(255) DEFAULT NULL,
  `from_userid` int(11) DEFAULT NULL,
  `to_userid` int(11) DEFAULT NULL,
  `recontent` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `FK93DA979397A657C4` (`from_userid`),
  KEY `FK93DA979330EB43D3` (`to_userid`),
  CONSTRAINT `FK93DA979330EB43D3` FOREIGN KEY (`to_userid`) REFERENCES `user` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK93DA979397A657C4` FOREIGN KEY (`from_userid`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

项目截图