OA协同办公系统-day01

文章目录


前言

1.技术

1.使用技术:
主体架构: Spring+springMVC+Mybatis(处理业务技术)
Redis: 缓存(把我们经常使用的数据放入redis)减轻db压力(商城项目)
Shiro: 权限框架(根据用户登录角色完成菜单导航)处长 主任 科员。
Echars: 图表工具,数据统计.
Ueditor:图文混排 论坛【富文本】
阿里巴巴的druid数据源: 稳定 高效 世界上最好的数据源技术
页面主体:bootstarp.js(vue.js,react.js)

Quartz: 定时任务,消息的定时发送,

JavaMail: 发送邮件

Ztree插件:树插件

git: 版本控制

Maven:完成jar文件的管理

2.表结构分析:
Attachment: 附件表(项目中需要文档类型规范:编码规范 注释规范 命名规范。。)

Project: 项目表(公司经营的主体业务)
Customer: 客户表(统计保存客户信息)

Analysis: 需求表(当前的项目的编写过程中需求分析文档)

Module: 模块(项目中的具体模块:人员管理 业务管理 仓储信息)

Function: 功能表(一个模块下有多个功能)

Task: 任务表 (那些功能分配给了具体人)

Notice: 通知公告(任命,会议通知,考勤情况)

Employee: 员工表(员工的基本信息)

Role: 角色表

Emp_role:员工和角色中间表 

Role_sources: 角色和资源的中间表

Sources: 资源表(能够去点击那些连接,能够去操作那些功能) 
Email: 邮件表(发送邮件 查看发送的邮件)

Comparsion: 对标管理的表(设定明年的目标,对比企业概况)

Dept: 部门表 (it)
Position: 职位表

level 级别表:当前的职位对应的级别

Msg: 消息表(定时发送一些剪短消息)

Baoxiao: 员工报销的表格
Dangan: 员工的档案表

实际开发:
产品部门 --> 用户: 用户开发
设计原型: [静态html,css/img] ------ UI/UE/前端 [css/html] 确定需求文档
开发: 1/4左右的时间
java [后台接口: springmvc --> service --> dao --> 数据库]
java+前端页面 [前端+漂亮 ] [全站工程师]
全栈: 前端—>全栈: html,css,node.js (有些机构,呵呵)
全栈: 后端 --> 全栈 (厉害)
前端 [html/css/js 和 后端人员进行交互]
测试部门
运维部门+网络安全

4.auth
cus
emp
pro
usual

2.数据库表

OA协同办公系统-day01

OA协同办公系统-day01

/*
SQLyog Ultimate v10.00 Beta1
MySQL - 5.1.62-community : Database - crmpro
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`crmpro` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `crmpro`;

/*Table structure for table `analysis` */

DROP TABLE IF EXISTS `analysis`;

CREATE TABLE `analysis` (
  `id` int(11) NOT NULL,
  `proname` varchar(64) DEFAULT NULL,
  `title` varchar(64) DEFAULT NULL,
  `simpledis` varchar(320) DEFAULT NULL,
  `detaileddis` varchar(320) DEFAULT NULL,
  `addtime` date DEFAULT NULL,
  `updatetime` date DEFAULT NULL,
  `remark` varchar(320) DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `analysis_ibfk_1` FOREIGN KEY (`id`) REFERENCES `project` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `analysis` */

insert  into `analysis`(`id`,`proname`,`title`,`simpledis`,`detaileddis`,`addtime`,`updatetime`,`remark`) values (2,'联通收费系统','联通收费系统需求分析','联通收费系统需求分析简单描述部分','联通收费系统需求分析详细描述部分','2019-04-08','2019-04-08','联通收费系统需求分析备注部分');

/*Table structure for table `archives` */

DROP TABLE IF EXISTS `archives`;

CREATE TABLE `archives` (
  `dnum` varchar(64) NOT NULL,
  `landline` varchar(32) DEFAULT NULL COMMENT '固话',
  `school` varchar(32) DEFAULT NULL COMMENT '毕业院校',
  `zhuanye` varchar(32) DEFAULT NULL COMMENT '专业',
  `sosperson` varchar(32) DEFAULT NULL COMMENT '紧急联系人',
  `biyedate` date DEFAULT NULL COMMENT '毕业时间',
  `zzmm` varchar(32) DEFAULT NULL COMMENT '政治面貌',
  `minzu` varchar(32) DEFAULT NULL COMMENT '民族',
  `xueli` varchar(32) DEFAULT NULL COMMENT '学历',
  `email` varchar(32) DEFAULT NULL COMMENT '邮箱',
  `emp_fk` int(11) DEFAULT NULL,
  PRIMARY KEY (`dnum`),
  KEY `emp_fk` (`emp_fk`),
  CONSTRAINT `archives_ibfk_1` FOREIGN KEY (`emp_fk`) REFERENCES `employee` (`eid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `archives` */

insert  into `archives`(`dnum`,`landline`,`school`,`zhuanye`,`sosperson`,`biyedate`,`zzmm`,`minzu`,`xueli`,`email`,`emp_fk`) values ('1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'731717486@qq.com',1);

/*Table structure for table `attachment` */

DROP TABLE IF EXISTS `attachment`;

CREATE TABLE `attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pro_fk` int(11) DEFAULT NULL,
  `attname` varchar(32) DEFAULT NULL,
  `attdis` varchar(128) DEFAULT NULL,
  `remark` varchar(256) DEFAULT NULL,
  `path` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKhdq50yhhjhdiyfm03xjohqlki` (`pro_fk`),
  CONSTRAINT `attachment_ibfk_1` FOREIGN KEY (`pro_fk`) REFERENCES `project` (`pid`),
  CONSTRAINT `FKhdq50yhhjhdiyfm03xjohqlki` FOREIGN KEY (`pro_fk`) REFERENCES `project` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `attachment` */

insert  into `attachment`(`id`,`pro_fk`,`attname`,`attdis`,`remark`,`path`) values (1,2,'联通收费附件','联通收费附件描述','备注信息','6531e55fe7074dd4aea3ffdcc40f5a06_Redis集群安装.txt'),(2,2,'联通收费附件','联通收费附件描述','备注信息','6dc8db3f80bd49ab8c05a0ae19755c50_Redis集群安装.txt');

/*Table structure for table `baoxiao` */

DROP TABLE IF EXISTS `baoxiao`;

CREATE TABLE `baoxiao` (
  `bxid` varchar(64) NOT NULL,
  `paymode` varchar(32) DEFAULT NULL COMMENT '类型',
  `totalmoney` double DEFAULT NULL COMMENT '总金额',
  `bxtime` date DEFAULT NULL COMMENT '报销时间',
  `bxremark` varchar(100) DEFAULT NULL COMMENT '报销备注',
  `bxstatus` int(11) DEFAULT NULL COMMENT '报销状态:0未审批,1表示驳回,2.已审批 3.已付款',
  `emp_fk` int(11) DEFAULT NULL COMMENT '发起报销人',
  `caiwu_fk` int(11) DEFAULT NULL COMMENT '处理报销人',
  PRIMARY KEY (`bxid`),
  KEY `emp_fk` (`emp_fk`),
  KEY `caiwu_fk` (`caiwu_fk`),
  CONSTRAINT `baoxiao_ibfk_1` FOREIGN KEY (`emp_fk`) REFERENCES `employee` (`eid`),
  CONSTRAINT `baoxiao_ibfk_2` FOREIGN KEY (`caiwu_fk`) REFERENCES `employee` (`eid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `baoxiao` */

insert  into `baoxiao`(`bxid`,`paymode`,`totalmoney`,`bxtime`,`bxremark`,`bxstatus`,`emp_fk`,`caiwu_fk`) values ('0928a865775547529343a402c3bcb171','出差票据',2232,'2019-02-15','大大发',0,2,NULL),('0f2fce34405343c388e71127a7532e3e','办公采购',14000,'2019-02-15','大大',0,2,NULL),('244023a4ba2746c6a2193109ab11d180','办公采购',14000,'2019-02-15','这阿达',0,2,NULL),('5fb82c51bf2e4e5bb89eb2cc1bdade65','出差票据',14000,'2019-02-15','的发生的发生',0,2,NULL),('8e1df58afd4c4797bf8b3ca4e1c526cd','办公采购',14000,'2019-02-15','办公用品报销',1,2,NULL),('d882f16ecd85419aa332af83fa79457d','办公采购',14000,'2019-02-15','da',0,2,NULL),('e1405997a5b6431dac2a7910e0222058','其他',14000,'2019-02-15','大法师的',0,2,NULL);

/*Table structure for table `comparision` */

DROP TABLE IF EXISTS `comparision`;

CREATE TABLE `comparision` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `company` varchar(50) NOT NULL,
  `targetMoney` double DEFAULT NULL,
  `YEAR` varchar(4) DEFAULT NULL,
  `business` varchar(255) DEFAULT NULL,
  `priority` varchar(100) DEFAULT NULL,
  `bad` varchar(100) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `empCount` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `empFk` int(11) DEFAULT NULL,
  PRIMARY KEY (`cid`),
  KEY `empFk` (`empFk`),
  CONSTRAINT `comparision_ibfk_1` FOREIGN KEY (`empFk`) REFERENCES `employee` (`eid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `comparision` */

insert  into `comparision`(`cid`,`company`,`targetMoney`,`YEAR`,`business`,`priority`,`bad`,`status`,`empCount`,`date`,`description`,`empFk`) values (1,'蓝翔',1000,'2018','挖掘机','知名度高','人员较多,难以管理','龙头老大',20000,'2001-12-12','要问哪家技术强,山东济南找蓝翔',2),(2,'百度',800,'2018','人工智能','高科技技术','认可度有待提高','高科技领军企业',15000,'1990-10-10','百度是一家互联网技术公司,主攻人工智能!',2);

/*Table structure for table `customer` */

DROP TABLE IF EXISTS `customer`;

CREATE TABLE `customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comname` varchar(128) DEFAULT NULL,
  `companyperson` varchar(32) DEFAULT NULL,
  `comaddress` varchar(128) DEFAULT NULL,
  `comphone` varchar(32) DEFAULT NULL,
  `camera` varchar(128) DEFAULT NULL,
  `present` varchar(128) DEFAULT NULL,
  `remark` varchar(128) DEFAULT NULL,
  `addtime` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

/*Data for the table `customer` */

insert  into `customer`(`id`,`comname`,`companyperson`,`comaddress`,`comphone`,`camera`,`present`,`remark`,`addtime`) values (7,'百度','李彦宏','北京','19373928391','0527-127129129','百度是国内最大的人工智能公司','百度技术,无人能敌','2019-04-03'),(9,'阿里巴巴','马云','杭州','19373928392','0527-127129129','发发斯蒂芬','范德萨','2019-04-04'),(10,'腾讯','马化腾','深圳','19373928392','0527-127129120','发的发','发','2019-04-04');

/*Table structure for table `dept` */

DROP TABLE IF EXISTS `dept`;

CREATE TABLE `dept` (
  `deptno` int(11) NOT NULL,
  `dname` varchar(32) DEFAULT NULL,
  `dlocation` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`deptno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `dept` */

insert  into `dept`(`deptno`,`dname`,`dlocation`) values (1,'开发部','北京'),(2,'市场部','上海'),(3,'财务部','广州'),(4,'公关部','深圳'),(5,'人事部','杭州');

/*Table structure for table `email` */

DROP TABLE IF EXISTS `email`;

CREATE TABLE `email` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) DEFAULT NULL,
  `ename` varchar(32) DEFAULT NULL,
  `sendtime` date DEFAULT NULL,
  `content` varchar(128) DEFAULT NULL,
  `emp_fk` int(11) DEFAULT NULL,
  `path` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKbwdib3s3ugq70b5h2ocn0rfvb` (`emp_fk`),
  CONSTRAINT `email_ibfk_1` FOREIGN KEY (`emp_fk`) REFERENCES `employee` (`eid`),
  CONSTRAINT `FKbwdib3s3ugq70b5h2ocn0rfvb` FOREIGN KEY (`emp_fk`) REFERENCES `employee` (`eid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `email` */

insert  into `email`(`id`,`title`,`ename`,`sendtime`,`content`,`emp_fk`,`path`) values (1,NULL,NULL,NULL,NULL,NULL,NULL),(2,NULL,NULL,NULL,NULL,NULL,NULL);

/*Table structure for table `emp_role` */

DROP TABLE IF EXISTS `emp_role`;

CREATE TABLE `emp_role` (
  `erid` int(11) NOT NULL AUTO_INCREMENT,
  `role_fk` int(11) DEFAULT NULL,
  `emp_fk` int(11) DEFAULT NULL,
  `erdis` varchar(32) DEFAULT NULL COMMENT '员工和角色的描述',
  PRIMARY KEY (`erid`),
  KEY `emp_fk` (`emp_fk`),
  KEY `role_fk` (`role_fk`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `emp_role` */

insert  into `emp_role`(`erid`,`role_fk`,`emp_fk`,`erdis`) values (4,10,2,NULL),(5,13,1,NULL);

/*Table structure for table `employee` */

DROP TABLE IF EXISTS `employee`;

CREATE TABLE `employee` (
  `eid` int(11) NOT NULL AUTO_INCREMENT,
  `ename` varchar(32) DEFAULT NULL,
  `esex` varchar(32) DEFAULT NULL,
  `eage` int(11) DEFAULT NULL,
  `telephone` varchar(32) DEFAULT NULL,
  `hiredate` date DEFAULT NULL,
  `pnum` varchar(32) DEFAULT NULL,
  `username` varchar(32) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  `remark` varchar(256) DEFAULT NULL,
  `p_fk` int(11) DEFAULT NULL,
  `d_fk` int(11) DEFAULT NULL,
  `l_fk` int(11) DEFAULT NULL,
  PRIMARY KEY (`eid`),
  KEY `FKt4aodqf7acjpmo7iejdmg3k78` (`p_fk`),
  KEY `d_fk` (`d_fk`),
  KEY `l_fk` (`l_fk`),
  CONSTRAINT `employee_ibfk_1` FOREIGN KEY (`p_fk`) REFERENCES `position` (`id`),
  CONSTRAINT `employee_ibfk_2` FOREIGN KEY (`d_fk`) REFERENCES `dept` (`deptno`),
  CONSTRAINT `employee_ibfk_3` FOREIGN KEY (`l_fk`) REFERENCES `level` (`jid`),
  CONSTRAINT `FKt4aodqf7acjpmo7iejdmg3k78` FOREIGN KEY (`p_fk`) REFERENCES `position` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `employee` */

insert  into `employee`(`eid`,`ename`,`esex`,`eage`,`telephone`,`hiredate`,`pnum`,`username`,`password`,`remark`,`p_fk`,`d_fk`,`l_fk`) values (1,'王五','男',39,'18309087765','2019-04-04','10','好人','123456','努力',3,3,1),(2,'张安','女',40,'19302989783','2019-04-04','9','大牛','123','负责',4,2,1);

/*Table structure for table `errorlog` */

DROP TABLE IF EXISTS `errorlog`;

CREATE TABLE `errorlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cause` text,
  `time` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `errorlog` */

/*Table structure for table `function` */

DROP TABLE IF EXISTS `function`;

CREATE TABLE `function` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `proname` varchar(32) DEFAULT NULL,
  `analysisname` varchar(32) DEFAULT NULL,
  `modele_fk` int(11) DEFAULT NULL,
  `functionname` varchar(32) DEFAULT NULL,
  `level` varchar(32) DEFAULT NULL,
  `simpledis` varchar(256) DEFAULT NULL,
  `detaileddis` varchar(256) DEFAULT NULL,
  `remark` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKjonpxsiii6o3xv16nttvg500w` (`modele_fk`),
  CONSTRAINT `FKjonpxsiii6o3xv16nttvg500w` FOREIGN KEY (`modele_fk`) REFERENCES `module` (`id`),
  CONSTRAINT `function_ibfk_1` FOREIGN KEY (`modele_fk`) REFERENCES `module` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `function` */

insert  into `function`(`id`,`proname`,`analysisname`,`modele_fk`,`functionname`,`level`,`simpledis`,`detaileddis`,`remark`) values (1,'',NULL,2,'查询消费列表','中','简述','详细描述','大大');

/*Table structure for table `level` */

DROP TABLE IF EXISTS `level`;

CREATE TABLE `level` (
  `jid` int(11) NOT NULL AUTO_INCREMENT,
  `jname` varchar(32) DEFAULT NULL,
  `jdis` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`jid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `level` */

insert  into `level`(`jid`,`jname`,`jdis`) values (1,'高级前端工程师',NULL),(2,'中级前端开发工程',NULL),(3,'初级前端开发工程',NULL);

/*Table structure for table `module` */

DROP TABLE IF EXISTS `module`;

CREATE TABLE `module` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `proname` varchar(32) DEFAULT NULL,
  `analysis_fk` int(11) DEFAULT NULL,
  `modname` varchar(32) DEFAULT NULL,
  `level` varchar(32) DEFAULT NULL,
  `simpledis` varchar(256) DEFAULT NULL,
  `detaileddis` varchar(256) DEFAULT NULL,
  `remark` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK986a0ufpo55087x7uc0ous7nb` (`analysis_fk`),
  CONSTRAINT `FK986a0ufpo55087x7uc0ous7nb` FOREIGN KEY (`analysis_fk`) REFERENCES `analysis` (`id`),
  CONSTRAINT `module_ibfk_1` FOREIGN KEY (`analysis_fk`) REFERENCES `analysis` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `module` */

insert  into `module`(`id`,`proname`,`analysis_fk`,`modname`,`level`,`simpledis`,`detaileddis`,`remark`) values (0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'联通收费系统',2,'用户模块','高','用户模块简单描述','用户模块详细描述','用户模块备注'),(3,'联通收费系统',2,'支付模块','高','支付模块简单描述','支付模块详细描述','备注信息');

/*Table structure for table `msg` */

DROP TABLE IF EXISTS `msg`;

CREATE TABLE `msg` (
  `msgid` int(11) NOT NULL AUTO_INCREMENT,
  `sendp` int(32) DEFAULT NULL,
  `recvp` int(32) DEFAULT NULL,
  `mark` int(11) DEFAULT NULL,
  `msgcontent` varchar(32) DEFAULT NULL,
  `msgtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`msgid`),
  KEY `sendp` (`sendp`),
  KEY `recvp` (`recvp`),
  CONSTRAINT `msg_ibfk_1` FOREIGN KEY (`sendp`) REFERENCES `employee` (`eid`),
  CONSTRAINT `msg_ibfk_2` FOREIGN KEY (`recvp`) REFERENCES `employee` (`eid`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

/*Data for the table `msg` */

insert  into `msg`(`msgid`,`sendp`,`recvp`,`mark`,`msgcontent`,`msgtime`) values (1,NULL,NULL,NULL,NULL,'2019-04-11 20:08:55'),(2,2,1,0,'大大','2019-04-19 00:00:00'),(3,2,1,0,'ssSD','2019-04-11 00:00:00'),(4,2,1,0,'daada','2019-04-02 00:00:00'),(5,2,1,0,'大','2019-04-16 00:00:00'),(6,2,1,0,'daada','2019-04-10 00:00:00'),(7,2,1,0,'dsada','2019-04-16 00:00:00'),(8,2,1,0,'dadds','2019-04-10 00:00:00'),(9,2,1,0,'daadada','2019-04-10 00:00:00'),(10,2,1,0,'dadasa','2019-04-09 00:00:00'),(11,2,1,0,'dadad','2019-04-16 00:00:00');

/*Table structure for table `notice` */

DROP TABLE IF EXISTS `notice`;

CREATE TABLE `notice` (
  `nid` int(11) NOT NULL AUTO_INCREMENT,
  `ntitle` varchar(32) DEFAULT NULL,
  `remark` varchar(320) DEFAULT NULL,
  `ndate` date DEFAULT NULL,
  PRIMARY KEY (`nid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `notice` */

insert  into `notice`(`nid`,`ntitle`,`remark`,`ndate`) values (1,'各大城市放开户口限制','为了抓住抢夺年轻人才的机会,各大城市纷纷出台吸引人才的落户政策!','2019-04-11'),(2,'泰国榴莲大王招婿','泰国榴莲大王','2019-04-11'),(3,'开会','各个党委这周五9点在...开会','2019-04-11'),(4,'通报','通报批评','2019-04-12');

/*Table structure for table `position` */

DROP TABLE IF EXISTS `position`;

CREATE TABLE `position` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

/*Data for the table `position` */

insert  into `position`(`id`,`name`) values (1,'后端工程师'),(2,'大数据工程师'),(3,'前端工程师'),(4,'项目经理'),(5,'项目总监'),(6,' 其他');

/*Table structure for table `project` */

DROP TABLE IF EXISTS `project`;

CREATE TABLE `project` (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  `pname` varchar(128) DEFAULT NULL,
  `comname` int(11) DEFAULT NULL,
  `comper` varchar(64) DEFAULT NULL,
  `emp_fk1` int(11) DEFAULT NULL,
  `empcount` int(11) DEFAULT NULL,
  `starttime` date DEFAULT NULL,
  `buildtime` date DEFAULT NULL,
  `cost` int(11) DEFAULT NULL,
  `level` varchar(32) DEFAULT NULL,
  `endtime` date DEFAULT NULL,
  `remark` varchar(256) DEFAULT NULL,
  `emp_fk` int(11) DEFAULT NULL,
  PRIMARY KEY (`pid`),
  KEY `emp_fk1` (`emp_fk1`),
  KEY `FKtirudsu3khj865hrqeamn153y` (`comname`),
  KEY `FKj4vtyyp6ew24vggobfcmav1be` (`emp_fk`),
  CONSTRAINT `FKj4vtyyp6ew24vggobfcmav1be` FOREIGN KEY (`emp_fk`) REFERENCES `employee` (`eid`),
  CONSTRAINT `FKtirudsu3khj865hrqeamn153y` FOREIGN KEY (`comname`) REFERENCES `customer` (`id`),
  CONSTRAINT `project_ibfk_2` FOREIGN KEY (`comname`) REFERENCES `customer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `project` */

insert  into `project`(`pid`,`pname`,`comname`,`comper`,`emp_fk1`,`empcount`,`starttime`,`buildtime`,`cost`,`level`,`endtime`,`remark`,`emp_fk`) values (1,'大大发',9,'马云',NULL,30,'2019-03-09','2019-10-01',30,'1','2018-08-03','擦洗参数',2),(2,'联通收费系统',7,'李彦宏',NULL,30,'2019-03-09','2019-10-01',30,'1','2019-09-07','这是给联通提供服务的系统',2);

/*Table structure for table `role` */

DROP TABLE IF EXISTS `role`;

CREATE TABLE `role` (
  `roleid` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `rolename` varchar(32) DEFAULT NULL COMMENT '角色名称',
  `roledis` varchar(32) DEFAULT NULL COMMENT '角色描述',
  `status` int(11) DEFAULT '0' COMMENT '是否启用',
  PRIMARY KEY (`roleid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

/*Data for the table `role` */

insert  into `role`(`roleid`,`rolename`,`roledis`,`status`) values (10,'董事长','董事长拥有最高权限',1),(11,'普通程序员','普通程序员拥有日常办公和项目管理的部分权限',1),(12,'技术总监','技术总监的权限更大一些',1),(13,'技术经理','',1);

/*Table structure for table `role_sources` */

DROP TABLE IF EXISTS `role_sources`;

CREATE TABLE `role_sources` (
  `rsid` int(11) NOT NULL AUTO_INCREMENT,
  `rsdis` varchar(32) DEFAULT NULL COMMENT '角色和资源的描述',
  `sid` int(11) DEFAULT NULL,
  `roleid` int(11) DEFAULT NULL,
  PRIMARY KEY (`rsid`),
  KEY `roleid` (`roleid`),
  KEY `sid` (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8;

/*Data for the table `role_sources` */

insert  into `role_sources`(`rsid`,`rsdis`,`sid`,`roleid`) values (70,NULL,1,10),(71,NULL,2,10),(72,NULL,9,10),(73,NULL,10,10),(74,NULL,11,10),(75,NULL,12,10),(76,NULL,13,10),(77,NULL,3,10),(78,NULL,14,10),(79,NULL,15,10),(80,NULL,16,10),(81,NULL,17,10),(82,NULL,18,10),(83,NULL,19,10),(84,NULL,20,10),(85,NULL,21,10),(86,NULL,4,10),(87,NULL,27,10),(88,NULL,5,10),(89,NULL,6,10),(90,NULL,7,10),(91,NULL,8,10),(92,NULL,1,11),(93,NULL,2,11),(94,NULL,9,11),(95,NULL,10,11),(96,NULL,11,11),(97,NULL,12,11),(98,NULL,13,11),(99,NULL,3,11),(100,NULL,14,11),(101,NULL,15,11),(102,NULL,16,11),(103,NULL,17,11),(104,NULL,18,11),(105,NULL,19,11),(106,NULL,1,12),(107,NULL,2,12),(108,NULL,9,12),(109,NULL,10,12),(110,NULL,11,12),(111,NULL,12,12),(112,NULL,13,12),(113,NULL,3,12),(114,NULL,14,12),(115,NULL,15,12),(116,NULL,16,12),(117,NULL,17,12),(118,NULL,18,12),(119,NULL,19,12),(120,NULL,20,12),(121,NULL,21,12),(122,NULL,4,12),(123,NULL,27,12),(124,NULL,27,10),(125,NULL,28,10),(126,NULL,29,10),(127,NULL,30,10),(128,NULL,31,10),(129,NULL,32,10),(130,NULL,33,10),(131,NULL,34,10),(132,NULL,35,10),(133,NULL,36,10),(134,NULL,37,10),(135,NULL,1,13),(136,NULL,2,13),(137,NULL,9,13),(138,NULL,10,13),(139,NULL,11,13),(140,NULL,13,13),(141,NULL,3,13),(142,NULL,14,13),(143,NULL,15,13);

/*Table structure for table `sources` */

DROP TABLE IF EXISTS `sources`;

CREATE TABLE `sources` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(32) DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(128) DEFAULT NULL COMMENT '资源路径',
  `remark` varchar(32) DEFAULT NULL COMMENT '资源备注',
  `pid` int(11) DEFAULT NULL COMMENT '父菜单id',
  `icon` varchar(32) DEFAULT NULL COMMENT '图标',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

/*Data for the table `sources` */

insert  into `sources`(`id`,`name`,`url`,`remark`,`pid`,`icon`) values (1,'项目平台管理系统',NULL,'系统名称',0,NULL),(2,'项目管理',NULL,'项目管理',1,NULL),(3,'日常办公',NULL,'日常办公',1,NULL),(4,'信息箱',NULL,'信息箱',1,NULL),(5,'客户信息管理',NULL,'客户信息管理',1,NULL),(6,'系统管理',NULL,'系统管理',1,NULL),(7,'对标管理',NULL,'对标管理',1,NULL),(8,'我的信息',NULL,'我的信息',1,NULL),(9,'基本信息管理','/pms/project-base.jsp','项目基本信息',2,NULL),(10,'需求分析管理','/pms/project-need.jsp','项目需求分析',2,NULL),(11,'模块管理','/pms/project-model.jsp','模块管理',2,NULL),(13,'附件管理','/pms/attachment/info','附件管理',2,NULL),(14,'创建任务','/pms/task-add.jsp','创建任务',3,NULL),(15,'任务信息','/pms/task/list','已发布任务',3,NULL),(16,'我的任务','/pms/task-my.jsp','我的任务',3,NULL),(17,'通知公告','/pms/notice/list','通知公告',3,NULL),(18,'档案管理','/pms/archives.jsp','档案管理',3,NULL),(19,'我的档案','/pms/myarchives.jsp','我的档案',3,NULL),(20,'报销审批','/pms/baoxiao-task.jsp','报销审批',3,NULL),(21,'我的报销','/pms/baoxiao/list','我的报销',3,NULL),(27,'发信息','/pms/message-seed.jsp','仅仅使用javamail发送邮件就ok啦',4,NULL),(28,'消息推送','/pms/message-give.jsp',NULL,3,NULL),(29,'论坛发帖','/pms/fatie.jsp',NULL,3,NULL),(30,'发件箱','/pms/message.jsp',NULL,4,NULL),(31,'收件箱','/pms/message-give.jsp',NULL,4,NULL),(32,'客户信息','/pms/customer.jsp',NULL,5,NULL),(33,'人员管理','/pms/user.jsp',NULL,6,NULL),(34,'权限维护','/pms/pm.jsp',NULL,6,NULL),(35,'角色管理','/pms/role.jsp',NULL,6,NULL),(36,'设定指标','/pms/indexvalue-base.jsp',NULL,7,NULL),(37,'目标营业额分析','/pms/duibiao-result.jsp',NULL,7,NULL),(38,'信息查看','/pms/info.jsp',NULL,8,NULL),(39,'修改密码','/pms/modpassword.jsp',NULL,NULL,NULL);

/*Table structure for table `task` */

DROP TABLE IF EXISTS `task`;

CREATE TABLE `task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `starttime` date DEFAULT NULL,
  `endtime` date DEFAULT NULL,
  `level` varchar(32) DEFAULT NULL,
  `define` varchar(256) DEFAULT NULL,
  `fun_fk` int(11) DEFAULT NULL,
  `emp_fk2` int(11) DEFAULT NULL,
  `emp_fk` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `emp_fk2` (`emp_fk2`),
  KEY `FK8pqhf0pdn5r478vp69g6sip3` (`fun_fk`),
  KEY `FKcpxt4jxiaoqj5nwny5ai74drj` (`emp_fk`),
  CONSTRAINT `FK8pqhf0pdn5r478vp69g6sip3` FOREIGN KEY (`fun_fk`) REFERENCES `function` (`id`),
  CONSTRAINT `FKcpxt4jxiaoqj5nwny5ai74drj` FOREIGN KEY (`emp_fk`) REFERENCES `employee` (`eid`),
  CONSTRAINT `task_ibfk_1` FOREIGN KEY (`fun_fk`) REFERENCES `function` (`id`),
  CONSTRAINT `task_ibfk_3` FOREIGN KEY (`emp_fk2`) REFERENCES `employee` (`eid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `task` */

insert  into `task`(`id`,`starttime`,`endtime`,`level`,`define`,`fun_fk`,`emp_fk2`,`emp_fk`) values (3,'2019-03-09','2019-09-15','高','查询列表赶快做',1,2,1);

/*Table structure for table `tiezi` */

DROP TABLE IF EXISTS `tiezi`;

CREATE TABLE `tiezi` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `content` text,
  `add_date` date DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `tiezi` */

insert  into `tiezi`(`tid`,`title`,`content`,`add_date`) values (1,'商城合作','<p>张三和李四在京东商城工<strong>作,共同</strong>开<img src=\"http://img.baidu.com/hi/jx2/j_0038.gif\"/>发商城项目</p>','2019-04-15'),(2,'联通收费系统需求分析','<p>联通收费系统需求收费标准是啥?</p>','2019-04-15');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

3. 搭建ssm环境:

3.1.导入jar包【依赖】ssm、jstl、json、druid、mysql驱动、上传和下载

3.2.配置web.xml
配置spring、springmvc、两个filter

3.3.创建springmvc、spring配置文件并配置他们
springmvc.xml
扫描包 [controller,controllerAdvice]
配置内部资源视图解析器
配置处理静态资源的标签mvc:default-servlet-handler
mvc:annotation-driven标签

 3.4 spring 配置文件 beans.xml
    扫描包 [除了controller, controllerAdvice]
	加载properties配置文件
	配置数据源
	配置数据源事务管理器
	开启基于注解的事务支持
	
	配置SqlSessionFactoryBean
	  配置数据源
	  加载mybatis的全局配置文件
	配置扫描MapperScannerConfigurer
	  basePackage:
	  
4.MyBatis的配置文件
   下划线转驼峰式命名
   
5.测试

OA协同办公系统-day01
OA协同办公系统-day01

总结

上一篇:telnet -测试端口号


下一篇:一起重新开始学大数据-Hbase篇-day 56 Phoenix