文章目录
前言
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.数据库表
/*
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.测试