一,环境搭建
1.导入数据库文件
# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.7.26)
# Database: meeting
# Generation Time: 2020-07-12 01:34:21 +0000
# ************************************************************
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
# Dump of table counter
# ------------------------------------------------------------
DROP TABLE IF EXISTS `counter`;
CREATE TABLE `counter` (
`visitcount` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `counter` WRITE;
/*!40000 ALTER TABLE `counter` DISABLE KEYS */;
INSERT INTO `counter` (`visitcount`)
VALUES
(99);
/*!40000 ALTER TABLE `counter` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table department
# ------------------------------------------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
`departmentid` int(16) NOT NULL AUTO_INCREMENT,
`departmentname` varchar(20) DEFAULT NULL,
PRIMARY KEY (`departmentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `department` WRITE;
/*!40000 ALTER TABLE `department` DISABLE KEYS */;
INSERT INTO `department` (`departmentid`, `departmentname`)
VALUES
(1,'技术部'),
(2,'人事部'),
(3,'财务部'),
(4,'行政部'),
(7,'运维部');
/*!40000 ALTER TABLE `department` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table employee
# ------------------------------------------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
`employeeid` int(16) NOT NULL AUTO_INCREMENT,
`employeename` varchar(14) DEFAULT NULL,
`username` varchar(20) DEFAULT NULL,
`phone` varchar(20) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`status` varchar(20) DEFAULT NULL,
`departmentid` int(16) DEFAULT NULL,
`password` varchar(50) DEFAULT NULL,
`role` varchar(12) DEFAULT NULL,
PRIMARY KEY (`employeeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `employee` WRITE;
/*!40000 ALTER TABLE `employee` DISABLE KEYS */;
INSERT INTO `employee` (`employeeid`, `employeename`, `username`, `phone`, `email`, `status`, `departmentid`, `password`, `role`)
VALUES
(8,'王晓华','wangxh','13671075406','wang@qq.com','1',1,'1','1'),
(9,'林耀坤','linyk','13671075406','yang@qq.com','1',2,'1','2'),
(10,'熊杰文','xiongjw','134555555','xiong@qq.com','1',3,'1','2'),
(11,'王敏','wangmin','1324554321','wangm@qq.com','2',4,'1','2'),
(12,'林耀坤','linyk','1547896765','kun@qq.com','1',7,'1','2'),
(13,'林耀坤','linyk','13897338822','yao@qq.com','1',1,'2','2'),
(14,'林耀坤','linyk','18908789808','yangyk@qq.com','2',2,'2','2'),
(15,'黄美玲','huangml','huangml@qq.com','13567898765','1',3,'1','2'),
(16,'黄美玲','huangml','huangml@qq.com','13567898765','2',4,'1','2'),
(17,'黄美玲','huangml002','huangml@qq.com','13567898765','2',1,'1','2'),
(20,'王敏','wangmin002','13454332334','wang@qq.com','1',4,'1','2'),
(21,'陈敏','chenm','13559994444','www@aa.com','1',2,'1','2'),
(23,'陈晨','wangm','22·2','11','1',1,'1','2'),
(25,'王晓华','wangxh222','111','1','1',4,'1','2'),
(27,'张三','zhangsan','122','22','0',4,'1','2');
/*!40000 ALTER TABLE `employee` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table meeting
# ------------------------------------------------------------
DROP TABLE IF EXISTS `meeting`;
CREATE TABLE `meeting` (
`meetingid` int(16) NOT NULL AUTO_INCREMENT,
`meetingname` varchar(20) DEFAULT NULL,
`roomid` int(16) DEFAULT NULL,
`reservationistid` int(16) DEFAULT NULL,
`numberofparticipants` int(16) DEFAULT NULL,
`starttime` datetime DEFAULT NULL,
`endtime` datetime DEFAULT NULL,
`reservationtime` datetime DEFAULT NULL,
`canceledtime` datetime DEFAULT NULL,
`description` varchar(200) DEFAULT NULL,
`status` varchar(20) DEFAULT NULL,
PRIMARY KEY (`meetingid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `meeting` WRITE;
/*!40000 ALTER TABLE `meeting` DISABLE KEYS */;
INSERT INTO `meeting` (`meetingid`, `meetingname`, `roomid`, `reservationistid`, `numberofparticipants`, `starttime`, `endtime`, `reservationtime`, `canceledtime`, `description`, `status`)
VALUES
(25,'ces',5,8,12,'2015-01-12 10:00:00','2015-01-12 12:00:00','2015-01-10 23:02:39',NULL,NULL,'1'),
(26,'测测',7,8,12,'2015-01-12 13:00:00','2015-01-12 15:00:00','2015-01-17 23:04:18','2015-01-11 01:06:20',NULL,'1'),
(27,'我看看',6,8,12,'2015-01-13 23:06:06','2015-01-14 03:06:08','2015-01-10 23:06:33','2015-01-11 01:01:42','我看看','1'),
(28,'运营会',5,8,12,'2015-01-10 23:26:11','2015-01-11 23:26:13','2015-01-10 23:26:26',NULL,'测试','0'),
(29,'市场部会议',6,8,12,'2015-01-10 23:44:22','2015-01-11 23:44:24','2015-01-10 23:44:41',NULL,'市场部','0'),
(30,'内部会议',10,8,12,'2015-01-10 23:55:59','2015-01-11 23:56:01','2015-01-10 23:56:20',NULL,'内部会议','0'),
(31,'我的会议',9,8,12,'2015-01-12 16:33:16','2015-01-13 16:33:18','2015-01-11 16:35:11',NULL,'测试','0'),
(32,'我的会议哈哈',5,8,10,'2015-01-12 16:40:31','2015-01-13 16:40:35','2015-01-11 16:40:50',NULL,'','0'),
(33,'哈哈',6,8,12,'2015-01-12 16:41:45','2015-01-13 16:41:48','2015-01-11 16:42:09','2015-01-12 11:44:57','你好','1'),
(34,'我的会议3',8,8,12,'2015-01-11 16:42:36','2015-01-13 16:42:38','2015-01-11 16:42:51',NULL,'测试','0'),
(35,'我的会议',7,8,12,'2015-01-11 16:44:03','2015-01-11 16:44:05','2015-01-11 16:44:35',NULL,'','0'),
(36,'我问问',7,8,12,'2015-01-11 16:56:57','2015-01-11 16:56:59','2015-01-11 16:57:56','2015-01-11 16:59:57','地点','1'),
(37,'我的会议4',7,8,12,'2015-01-12 16:59:26','2015-01-12 16:59:31','2015-01-11 16:59:49',NULL,'我的会议','0'),
(38,'班会',9,8,12,'2015-01-15 16:46:25','2015-01-16 18:46:53','2015-01-12 11:49:17','2015-01-12 11:49:37','班会','1'),
(39,'测试会议',5,8,12,'2015-01-14 14:41:11','2015-01-15 14:41:14','2015-01-14 14:44:07',NULL,'ss','0');
/*!40000 ALTER TABLE `meeting` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table meetingparticipants
# ------------------------------------------------------------
DROP TABLE IF EXISTS `meetingparticipants`;
CREATE TABLE `meetingparticipants` (
`meetingid` int(16) NOT NULL,
`employeeid` int(16) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `meetingparticipants` WRITE;
/*!40000 ALTER TABLE `meetingparticipants` DISABLE KEYS */;
INSERT INTO `meetingparticipants` (`meetingid`, `employeeid`)
VALUES
(28,13),
(28,23),
(28,27),
(28,16),
(29,16),
(29,13),
(29,8),
(30,15),
(30,13),
(30,8),
(30,23),
(27,8),
(26,8),
(25,8),
(28,8),
(31,8),
(31,17),
(31,23),
(32,8),
(32,17),
(33,15),
(34,8),
(34,17),
(35,8),
(36,9),
(36,8),
(37,8),
(37,23),
(38,11),
(38,16),
(38,20),
(39,13);
/*!40000 ALTER TABLE `meetingparticipants` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table meetingroom
# ------------------------------------------------------------
DROP TABLE IF EXISTS `meetingroom`;
CREATE TABLE `meetingroom` (
`roomid` int(16) NOT NULL AUTO_INCREMENT,
`roomnum` int(16) NOT NULL,
`roomname` varchar(20) NOT NULL,
`capacity` int(16) DEFAULT NULL,
`status` varchar(20) DEFAULT NULL,
`description` varchar(200) DEFAULT NULL,
PRIMARY KEY (`roomid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `meetingroom` WRITE;
/*!40000 ALTER TABLE `meetingroom` DISABLE KEYS */;
INSERT INTO `meetingroom` (`roomid`, `roomnum`, `roomname`, `capacity`, `status`, `description`)
VALUES
(5,101,'第一会议室',15,'0','公共会议室'),
(6,102,'第二会议室',5,'0','管理部门会议室'),
(7,103,'第三会议室',12,'0','市场部专用会议室'),
(8,401,'第四会议室',15,'0','公共会议室'),
(9,201,'第五会议室',15,'0','最大会议室'),
(10,601,'第六会议室',12,'0','需要提前三天预定');
/*!40000 ALTER TABLE `meetingroom` ENABLE KEYS */;
UNLOCK TABLES;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2.搭建项目环境
2.1创建maven项目 coolmeeting
2.2 在pom文件中进行 打包方式设置
<packaging>war</packaging>
2.3创建 项目环境
创建webapp
点击添加web.xml文件进行环境添加 复制红色框选区
选择正确webapp文件目录位置
并复制 其余文件路径 \WEB-INF\web.xml文件 确定完成
3.创建项目目录文件结构
4.创建spring配置文件 在resources 文件下 创建 applicationContext.xml 进行spring配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
<context:component-scan base-package="com.liuboss.meeting" use-default-filters="true">
<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
</beans>