企业信息文件_企业管理平台管理系统

欢迎Web文档管理系统

• 首先对整体架构进行分析，进而分配组员任务，根据案例解决方案将组员合理划分责任，落实功能实现Deadline。
• 整体系统的前台，也就是普通的用户模式，在用户界面，用户可以通过登陆界面登录，若没有账户，可以选择注册账户，之后选择登录；登陆后可以查找文档并预览所有文件，之后对需要打印的文件选择打印。
• 整体系统的后台，也就是管理员模式，在管理员界面，管理员可以通过登陆界面登录，但是管理员无法在登陆选择注册管理员注册，默认admin(admin123)账号可以对包括管理员和用户的全部账号进行管理，对用户权限进行管理，对文档类别进行管理，对文档信息进行管理，对文档附件进行管理。
• 通过Jsp实现上述功能，并且在浏览器端可以对相应功能进行操作。

1.开发技术

1. JSP原理：

• 客户端通过浏览器向服务器发出请求，在该请求中包含了请求的资源的路径，这样当服务器接收到该请求后就可以知道被请求的内容。
• 服务器根据接收到的客户端的请求来加载相应的JSP文件。
• Web服务器Tomcat9.1.04中的JSP引擎会将被加载的JSP文件转化为Servlet。
• JSP引擎将生成的Servlet代码编译成Class文件。服务器Tomcat9.1.04执行这个Class文件，最后服务器将执行结果发送给浏览器进行显示。

2. 程序开发环境和开发语言

• 开发环境方面

运行VMware 15.5.0 虚拟机，配置内存4GB，单核4线程
Window 10企业版LTSC x64
JDK 11.0.4 windows-x64
IntelliJ IDEA 2020.1 x64
Mysql 5.1.55
Navicat 10.0.11
Tomcat 9.0.41
Firefox 84.0.1 x64
Google Chrome 87.0.4280.88 x64
Enterprise Architect 12.0.1209

• 开发语言方面，

基于IntelliJ IDEA强大功能，进行Java，HTML，CSS等编写和调用。团队合作时。
前端页面编写用到HbuilderX等HTML编写工具进行HTML编写和CSS渲染。

2.系统总体设计

3.数据存储方案

• 数据通过Mysql数据库,引擎采用InnoDB
• 创建“document”库，并建立相对应的表
  

/*!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*/`document` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `document`; DROP TABLE IF EXISTS `document_attachment`; CREATE TABLE `document_attachment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `path` varchar(255) DEFAULT NULL, `size` int(11) DEFAULT NULL, `document_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `document_category`; CREATE TABLE `document_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `document_info`; CREATE TABLE `document_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `content` varchar(255) DEFAULT NULL, `document_category` varchar(255)DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `user_info`; CREATE TABLE `user_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `user_permissions` varchar(255)DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `user_permissions`; CREATE TABLE `user_permissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_permissions` varchar(255)DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; /*!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 */; 

4.功能实现

1. 系统注册登录

• 用户注册登录模块实现用户注册登录功能，企业员工用户登录后，能查看相关文档信息和打印文档信息等；管理员用户登录系统后，能通过后台对系统进行维护和管理，主要包括用户角色管理，文档类别管理和文档信息管理等。
• 首先会根据用户输入的账号和密码，在LoginServlet中获取对应参数，并进行查表获取用户信息。如果用户信息错误，则返回“用户名或者密码错误”相应提示。如果用户信息正确，则根据用户类型来判断是管理员还是普通用户，从而跳转到不同首页。管理员则跳转到后台管理首页，非管理员则跳转到前台首页。

2. 文档类别管理

• 文档类别管理模块实现对文档类别的管理，主要包括文档类别的添加，修改和删除。

3. 文档信息管理

• 文档信息管理模块实现对文档信息的管理功能，主要包括对文档进行添加，修改，删除，查看和文档的浏览功能等。

4. 文档信息查询

• 文档信息查询模块实现对文档的综合查询功能，主要包括按文档类别查询，按文档标题查询，模糊匹配查询等。

5. 文档附件管理

• 文档附件管理模块实现对文档附件的管理功能。主要包括对文件的添加，编辑和删除。

5.运行结果

测试结果与分析

• 首先打开IntelliJ IDEA，之后进行Tomcat配置，Jar配置等
• 环境配置成功后开始debug程序，等待Tomcat显示绿色后，Web exploded显示绿色对号后，进行访问地址：http://localhost:8080/Document_Sys_Web_exploded/front/login.jsp，便可以进入文档管理系统的登陆界面，在界面中可以选择已知的用户或者管理员账号和密码进行登录，如果没有账号，点击“点击注册”超链接进入注册界面进行注册，注册成功后自动跳转至登陆界面进行登录。
• 用户界面可以查找文件和浏览打印文件。
• 管理员账号admin(admin123)进行用户信息，用户权限，文档类别，文档信息，文档附件的增删改操作。
• 整套系统反馈延时低于用户最大等待时间，SQL语句简洁干练，尽可能保证在不提高空间复杂度的条件下降低整体系统的时间复杂度。

测试

在测试中，进行路径覆盖测试：

6.核心代码

Jsp

• index

<%@ page import="model.UserInfo" %> <%@ page import="cn.hutool.core.util.StrUtil" %> <%@ page import="mapper.DocumentInfoMapper" %> <%@ page import="model.DocumentInfo" %> <%@ page import="java.util.List" %><%-- Created by IntelliJ IDEA. User: GodOuO Date: 2020/12/27 Time: 20:20 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%@ page isELIgnored="false" %> <html> <head> <title>用户首页</title> <style> body{ 
    background: url("../images/4.jpg"); background-size: 100%; background-size: cover; } </style> </head> <body style="text-align:center;"> <style type="text/css"> h1{ 
    background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family:"微软雅黑", "宋体", "黑体", Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #; } button{ 
    background:-webkit-linear-gradient(top ,rgb(169,169,169),rgb(34,102,149) 50%,rgb(34,102,140) 50%,rgb(128,128,128) 100%); display:inline-block; border:rgb(169,169, 187) solid 1px; box-shadow:inset rgba(255,255,255,1.0) 0px 0px 2px 0px; border-radius:8px; outline:none; width:45px; height:20px; cursor:pointer; color:#ffffff; font-size:10px; } table { 
    width: 90%; background: #ccc; margin: 10px auto; border-collapse: collapse;/*border-collapse:collapse合并内外边距(去除表格单元格默认的2个像素内外边距*/ } th,td { 
    height: 25px; line-height: 25px; text-align: center; border: 1px solid #ccc; } th { 
    background: #eee; font-weight: normal; } tr { 
    background: #fff; } tr:hover { 
    background: #cc0; } td a { 
    color: #06f; text-decoration: none; } td a:hover { 
    color: #06f; text-decoration: underline;} a:visited{ 
    text-decoration:none; //去除下划线 background-color: purple; color:gray; } a:hover{ 
    background-color: orange; } /*鼠标悬停时背景颜色变橙*/ </style> <h1>文档管理系统-User</h1> <div> <form action="<%=request.getContextPath()%>/front/index.jsp"> <% UserInfo user = (UserInfo) session.getAttribute("user"); if (user != null) { 
    out.write("<span>" + user.getUsername() + "</span>\n" + "<span><a href=\"" + request.getContextPath() + "/logout\">退出登录</a></span>"); } else { 
    out.write("<a href=\"" + request.getContextPath() + "/front/login.jsp\">登录</a>\n" + " /\n" + " <a href=\"" + request.getContextPath() + "/front/register.jsp\">注册</a>"); } %> <% String name = request.getParameter("name"); DocumentInfo book = new DocumentInfo(); book.setName(name); List<DocumentInfo> search = DocumentInfoMapper.search(book); %> <span style="padding-right: 50px"></span> <input type="text" placeholder="请输入名称..." value="" name="name"> <button type="submit">搜索</button> </form> </div> <hr> <br> <div style="text-align: center;"> <table border="1" style="margin: auto;"> <tr> <th>ID</th> <th>名称</th> <th>内容</th> <th>文档类别</th> <th>操作</th> </tr> <c:forEach items="<%=search%>" var="b"> <tr> <td>${ 
   b.id}</td> <td>${ 
   b.name}</td> <td>${ 
   b.content}</td> <td>合同</td> <td> <button >打印</button> </td> </tr> </c:forEach> </table> </div> </body> </html> 

• login

<%-- Created by IntelliJ IDEA. User: GodOuO Date: 2020/12/25 Time: 20:38 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ page isELIgnored="false" %> <html> <head> <title>登录</title> <style> body{ 
    background: url("../images/4.jpg"); background-size: 100%; background-size: cover; } </style> </head> <body style="text-align:center;"> <style type="text/css"> h1{ 
    background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family:"微软雅黑", "宋体", "黑体", Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #; } button{ 
    background:-webkit-linear-gradient(top ,rgb(169,169,169),rgb(34,102,149) 50%,rgb(34,102,140) 50%,rgb(128,128,128) 100%); display:inline-block; border:rgb(169,169, 187) solid 1px; box-shadow:inset rgba(255,255,255,1.0) 0px 0px 2px 0px; border-radius:8px; outline:none; width:45px; height:20px; cursor:pointer; color:#ffffff; font-size:10px; } tr.td{ 
    width: 20%; text-align: right; font-family:"微软雅黑", "宋体", "黑体", Arial; padding-right: 10px; margin-top: 10px; color: #888 } a:visited{ 
    text-decoration:none; //去除下划线 background-color: purple; color:gray; } a:hover{ 
    background-color: orange; } /*鼠标悬停时背景颜色变橙*/ .div0{ 
    position:absolute; /*定位方式绝对定位absolute*/ top:50%; left:50%; /*顶和高同时设置50%实现的是同时水平垂直居中效果*/ transform:translate(-50%,-50%); /*实现块元素百分比下居中*/ width:450px; padding:50px; background: rgba(255,255,255,.3); /*背景颜色为白色，透明度为0.8*/ box-sizing:border-box; /*box-sizing设置盒子模型的解析模式为怪异盒模型， 24 将border和padding划归到width范围内*/ box-shadow: 0px 15px 25px rgba(0,0,0,0.5); /*边框阴影 水平阴影0 垂直阴影15px 模糊25px 颜色黑色透明度0.5*/ border-radius:15px; /*边框圆角，四个角均为15px*/ } .div2{ 
    margin-left: 500px; } </style> <h1>文档管理系统登录</h1> <br> <div class="div0"> <form action="<%=request.getContextPath()%>/login" method="post"> <div class="div1"> 用户名： <input type="text" placeholder="用户名" name="username" value=""> </div> <div class="div1"> 密&emsp;码： <input type="password" placeholder="密码" name="password" value=""> </div> <br> <button type="submit">登录</button> <button type="reset">重置</button> <br> 没有账户？<a href="<%=request.getContextPath()%>/front/register.jsp">点击注册</a> <span style="color: red">${ 
   sessionScope.error}</span></td> </form> </div> </body> </html> <% session.removeAttribute("error"); %> 

• register

<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>注册</title> <style> body{ 
    background: url("../images/4.jpg"); background-size: 100%; background-size: cover; } </style> </head> <body style="text-align:center;"> <style type="text/css"> h1{ 
    background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family:"微软雅黑", "宋体", "黑体", Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #; } button{ 
    background:-webkit-linear-gradient(top ,rgb(169,169,169),rgb(34,102,149) 50%,rgb(34,102,140) 50%,rgb(128,128,128) 100%); display:inline-block; border:rgb(169,169, 187) solid 1px; box-shadow:inset rgba(255,255,255,1.0) 0px 0px 2px 0px; border-radius:8px; outline:none; width:45px; height:20px; cursor:pointer; color:#ffffff; font-size:10px; } tr.td{ 
    width: 20%; text-align: right; font-family:"微软雅黑", "宋体", "黑体", Arial; padding-right: 10px; margin-top: 10px; color: #888 } a:visited{ 
    text-decoration:none; //去除下划线 background-color: purple; color:gray; } a:hover{ 
    background-color: orange; } /*鼠标悬停时背景颜色变橙*/ </style> <h1>文档管理系统注册账号</h1> <br> <div> <form action="<%=request.getContextPath()%>/register" method="post"> <table style="margin: auto"> <tr> <td>用户名：</td> <td><input type="text" placeholder="用户名" name="username" value=""></td> </tr> <tr> <td>密码：</td> <td><input type="password" placeholder="密码" name="password" value=""></td> </tr> <tr> <td>确认：</td> <td><input type="password" placeholder="密码" value=""></td> </tr> <tr> <td> <button type="submit">注册</button> </td> <td> <button type="reset">重置</button> </td> </tr> <tr> <td></td> <td>已有账号？<a href="<%=request.getContextPath()%>/front/login.jsp">点击登录</a></td> </tr> <tr> <td><span style="color: red">${ 
   sessionScope.error}</span></td> </tr> </table> </form> </div> </body> </html> <% session.removeAttribute("error"); %> 

• DocumentAttachment

<%@ page import="cn.hutool.core.util.StrUtil" %> <%@ page import="mapper.DocumentAttachmentMapper" %> <%@ page import="model.DocumentAttachment" %> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%@ page isELIgnored="false" %> <html> <head> <title>DocumentAttachment</title> <style> body{ 
    background: url("images/4.jpg"); background-size: 100%; background-size: cover; } </style> </head> <body style="text-align:center;"> <style type="text/css"> h1{ 
    background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family:"微软雅黑", "宋体", "黑体", Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #; } button{ 
    background:-webkit-linear-gradient(top ,rgb(169,169,169),rgb(34,102,149) 50%,rgb(34,102,140) 50%,rgb(128,128,128) 100%); display:inline-block; border:rgb(169,169, 187) solid 1px; box-shadow:inset rgba(255,255,255,1.0) 0px 0px 2px 0px; border-radius:8px; outline:none; width:45px; height:20px; cursor:pointer; color:#ffffff; font-size:10px; } table { 
    width: 90%; background: #ccc; margin: 10px auto; border-collapse: collapse;/*border-collapse:collapse合并内外边距(去除表格单元格默认的2个像素内外边距*/ } th,td { 
    height: 25px; line-height: 25px; text-align: center; border: 1px solid #ccc; } th { 
    background: #eee; font-weight: normal; } tr { 
    background: #fff; } tr:hover { 
    background: cornflowerblue; } td a { 
    color: #06f; text-decoration: none; } td a:hover { 
    color: #06f; text-decoration: underline;} a:visited{ 
    text-decoration:none; //去除下划线 background-color: purple; color:gray; } a:hover{ 
    background-color: orange; } /*标悬停时背景颜色变橙*/ </style> <h1>文档附件管理</h1> <div> <span>${ 
   sessionScope.user.username}</span> <span><a href="<%=request.getContextPath()%>/logout">退出登录</a></span> <span style="padding-right: 50px"></span> <a href="<%=request.getContextPath()%>/DocumentAttachmentAdd.jsp"> <button>添加</button> </a> </div> <hr> <br> <div style="text-align: center;"> <table style="margin: auto;"> <tr> <td> <jsp:include page="spider.jsp"/> </td> <td><span style="padding-right: 30px"></span></td> <td> <table border="1" style="margin: auto;"> <tr> <th>ID</th> <th>名称</th> <th>路径</th> <th>大小</th> <th>文档ID</th> <th>操作</th> </tr> <% for (DocumentAttachment temp : DocumentAttachmentMapper.list()) { 
    out.write("<tr>\n" + " <td>" + temp.getId() + "</td>\n" + " <td>" + temp.getName() + "</td>\n" + " <td>" + temp.getPath() + "</td>\n" + " <td>" + temp.getSize() + "</td>\n" + " <td>" + temp.getDocumentId() + "</td>\n" + " <td>\n" + " <a href=" + request.getContextPath() + "/documentAttachment?method=getById&id=" + temp.getId() + "><button>编辑</button></a>\n" + " <a href=" + request.getContextPath() + "/documentAttachment?method=deleteById&id=" + temp.getId() + "><button>删除</button></a>\n" + " </td>\n" + " </tr>"); } %> </table> </td> </tr> </table> </div> </body> </html> 

• DocumentAttachmentAdd

 <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%@ page isELIgnored="false" %> <html> <head> <title>DocumentAttachmentAdd</title> <style> body{ 
    background: url("images/4.jpg"); background-size: 100%; background-size: cover; } </style> </head> <body style="text-align:center;"> <h1>文档附件添加</h1> <style type="text/css"> h1{ 
    background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family:"微软雅黑", "宋体", "黑体", Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #; } button{ 
    background:-webkit-linear-gradient(top ,rgb(169,169,169),rgb(34,102,149) 50%,rgb(34,102,140) 50%,rgb(128,128,128) 100%); display:inline-block; border:rgb(169,169, 187) solid 1px; box-shadow:inset rgba(255,255,255,1.0) 0px 0px 2px 0px; border-radius:8px; outline:none; width:45px; height:20px; cursor:pointer; color:#ffffff; font-size:10px; } table { 
    width: 90%; background: #ccc; margin: 10px auto; border-collapse: collapse;/*border-collapse:collapse合并内外边距(去除表格单元格默认的2个像素内外边距*/ } th,td { 
    height: 25px; line-height: 25px; text-align: center; border: 1px solid #ccc; } th { 
    background: #eee; font-weight: normal; } tr { 
    background: #fff; } tr:hover { 
    background: cornflowerblue; } td a { 
    color: #06f; text-decoration: none; } td a:hover { 
    color: #06f; text-decoration: underline;} a:visited{ 
    text-decoration:none; //去除下划线 background-color: purple; color:gray; } a:hover{ 
    background-color: orange; } /*鼠标悬停时背景颜色变橙*/ </style> <div> <span>${ 
   sessionScope.user.username}</span> <span><a href="<%=request.getContextPath()%>/logout">退出登录</a></span> <span style="padding-right: 50px"></span> <a href="<%=request.getContextPath()%>/index.jsp"> <button>返回</button> </a> </div> <hr> <br> <c:if test="${sessionScope.documentAttachment==null}"> <form action="<%=request.getContextPath()%>/documentAttachment?method=addBean" method="post"> </c:if> <c:if test="${sessionScope.documentAttachment!=null}"> <form action="<%=request.getContextPath()%>/documentAttachment?method=updateById" method="post"> </c:if> <table style="margin: auto"> <tr> <td>ID：</td> <td><input type="text" prefix="ID" name="id" value="${sessionScope.documentAttachment.id}"></td> </tr> <tr> <td>名称：</td> <td><input type="text" prefix="名称" name="name" value="${sessionScope.documentAttachment.name}"></td> </tr> <tr> <td>路径：</td> <td><input type="text" prefix="路径" name="path" value="${sessionScope.documentAttachment.path}"></td> </tr> <tr> <td>大小：</td> <td><input type="text" prefix="大小" name="size" value="${sessionScope.documentAttachment.size}"></td> </tr> <tr> <td>文档ID：</td> <td><input type="text" prefix="文档ID" name="documentId" value="${sessionScope.documentAttachment.documentId}"></td> </tr> <tr> <td> <button type="submit">添加</button> </td> <td> <button type="reset">重置</button> </td> </tr> </table> </form> </body> </html> <% session.removeAttribute("documentAttachment"); %> 

• DocumentCategory

<%@ page import="cn.hutool.core.util.StrUtil" %> <%@ page import="mapper.DocumentCategoryMapper" %> <%@ page import="model.DocumentCategory" %> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%@ page isELIgnored="false" %> <html> <head> <title>DocumentCategory</title> <style> body{ 
    background: url("images/4.jpg"); background-size: 100%; background-size: cover; } </style> </head> <body style="text-align:center;"> <h1>文档类别管理</h1> <style type="text/css"> h1{ 
    background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family:"微软雅黑", "宋体", "黑体", Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #; } button{ 
    background:-webkit-linear-gradient(top ,rgb(169,169,169),rgb(34,102,149) 50%,rgb(34,102,140) 50%,rgb(128,128,128) 100%); display:inline-block; border:rgb(169,169, 187) solid 1px; box-shadow:inset rgba(255,255,255,1.0) 0px 0px 2px 0px; border-radius:8px; outline:none; width:45px; height:20px; cursor:pointer; color:#ffffff; font-size:10px; } table { 
    width: 90%; background: #ccc; margin: 10px auto; border-collapse: collapse;/*border-collapse:collapse合并内外边距(去除表格单元格默认的2个像素内外边距*/ } th,td { 
    height: 25px; line-height: 25px; text-align: center; border: 1px solid #ccc; } th { 
    background: #eee; font-weight: normal; } tr { 
    background: #fff; } tr:hover { 
    background: cornflowerblue; } td a { 
    color: #06f; text-decoration: none; } td a:hover { 
    color: #06f; text-decoration: underline;} a:visited{ 
    text-decoration:none; //去除下划线 background-color: purple; color:gray; } a:hover{ 
    background-color: orange; } /*鼠标悬停时背景颜色变橙*/ </style> <div> <span>${ 
   sessionScope.user.username}</span> <span><a href="<%=request.getContextPath()%>/logout">退出登录</a></span> <span style="padding-right: 50px"></span> <a href="<%=request.getContextPath()%>/DocumentCategoryAdd.jsp"> <button>添加</button> </a> </div> <hr> <br> <div style="text-align: center;"> <table style="margin: auto;"> <tr> <td> <jsp:include page="spider.jsp"/> </td> <td><span style="padding-right: 30px"></span></td> <td> <table border="1" style="margin: auto;"> <tr> <th>ID</th> <th>类别名称</th> <th>操作</th> </tr> <% for (DocumentCategory temp : DocumentCategoryMapper.list()) { 
    out.write("<tr>\n" + " <td>" + temp.getId() + "</td>\n" + " <td>" + temp.getName() + "</td>\n" + " <td>\n" + " <a href=" + request.getContextPath() + "/documentCategory?method=getById&id=" + temp.getId() + "><button>编辑</button></a>\n" + " <a href=" + request.getContextPath() + "/documentCategory?method=deleteById&id=" + temp.getId() + "><button>删除</button></a>\n" + " </td>\n" + " </tr>"); } %> </table> </td> </tr> </table> </div> </body> </html> 

• DocumentCategoryAdd

 <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%@ page isELIgnored="false" %> <html> <head> <title>DocumentCategoryAdd</title> <style> body{ 
    background: url("images/4.jpg"); background-size: 100%; background-size: cover; } </style> </head> <body style="text-align:center;"> <h1>文档类别添加</h1> <style type="text/css"> h1{ 
    background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family:"微软雅黑", "宋体", "黑体", Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #; } button{ 
    background:-webkit-linear-gradient(top ,rgb(169,169,169),rgb(34,102,149) 50%,rgb(34,102,140) 50%,rgb(128,128,128) 100%); display:inline-block; border:rgb(169,169, 187) solid 1px; box-shadow:inset rgba(255,255,255,1.0) 0px 0px 2px 0px; border-radius:8px; outline:none; width:45px; height:20px; cursor:pointer; color:#ffffff; font-size:10px; } table { 
    width: 90%; background: #ccc; margin: 10px auto; border-collapse: collapse;/*border-collapse:collapse合并内外边距(去除表格单元格默认的2个像素内外边距*/ } th,td { 
    height: 25px; line-height: 25px; text-align: center; border: 1px solid #ccc; } th { 
    background: #eee; font-weight: normal; } tr { 
    background: #fff; } tr:hover { 
    background: cornflowerblue; } td a { 
    color: #06f; text-decoration: none; } td a:hover { 
    color: #06f; text-decoration: underline;} a:visited{ 
    text-decoration:none; //去除下划线 background-color: purple; color:gray; } a:hover{ 
    background-color: orange; } /*鼠标悬停时背景颜色变橙*/ </style> <div> <span>${ 
   sessionScope.user.username}</span> <span><a href="<%=request.getContextPath()%>/logout">退出登录</a></span> <span style="padding-right: 50px"></span> <a href="<%=request.getContextPath()%>/index.jsp"> <button>返回</button> </a> </div> <hr> <br> <c:if test="${sessionScope.documentCategory==null}"> <form action="<%=request.getContextPath()%>/documentCategory?method=addBean" method="post"> </c:if> <c:if test="${sessionScope.documentCategory!=null}"> <form action="<%=request.getContextPath()%>/documentCategory?method=updateById" method="post"> </c:if> <table style="margin: auto"> <tr> <td>ID：</td> <td><input type="text" prefix="ID" name="id" value="${sessionScope.documentCategory.id}"></td> </tr> <tr> <td>类别名称：</td> <td><input type="text" prefix="类别名称" name="name" value="${sessionScope.documentCategory.name}"></td> </tr> <tr> <td> <button type="submit">添加</button> </td> <td> <button type="reset">重置</button> </td> </tr> </table> </form> </body> </html> <% session.removeAttribute("documentCategory"); %> 

• DocumentInfo

<%@ page import="cn.hutool.core.util.StrUtil" %> <%@ page import="mapper.DocumentInfoMapper" %> <%@ page import="model.DocumentInfo" %> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%@ page isELIgnored="false" %> <html> <head> <title>DocumentInfo</title> <style> body{ 
    background: url("images/4.jpg"); background-size: 100%; background-size: cover; } </style> </head> <body style="text-align:center;"> <style type="text/css"> h1{ 
    background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family:"微软雅黑", "宋体", "黑体", Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #; } button{ 
    background:-webkit-linear-gradient(top ,rgb(169,169,169),rgb(34,102,149) 50%,rgb(34,102,140) 50%,rgb(128,128,128) 100%); display:inline-block; border:rgb(169,169, 187) solid 1px; box-shadow:inset rgba(255,255,255,1.0) 0px 0px 2px 0px; border-radius:8px; outline:none; width:45px; height:20px; cursor:pointer; color:#ffffff; font-size:10px; } table { 
    width: 90%; background: #ccc; margin: 10px auto; border-collapse: collapse;/*border-collapse:collapse合并内外边距(去除表格单元格默认的2个像素内外边距*/ } th,td { 
    height: 25px; line-height: 25px; text-align: center; border: 1px solid #ccc; } th { 
    background: lightsteelblue; font-weight: normal; } tr { 
    background: #fff; } tr:hover { 
    background: cornflowerblue; } td a { 
    color: #06f; text-decoration: none; } td a:hover { 
    color: #06f; text-decoration: underline;} a:visited{ 
    text-decoration:none; //去除下划线 background-color: purple; color:gray; } a:hover{ 
    background-color: orange; } /*鼠标悬停时背景颜色变橙*/ </style> <h1>文档信息管理</h1> <div> <span>${ 
   sessionScope.user.username}</span> <span><a href="<%=request.getContextPath()%>/logout">退出登录</a></span> <span style="padding-right: 50px"></span> <a href="<%=request.getContextPath()%>/DocumentInfoAdd.jsp"> <button>添加</button> </a> </div> <hr> <br> <div style="text-align: center;"> <table style="margin: auto;"> <tr> <td> <jsp:include page="spider.jsp"/> </td> <td><span style="padding-right: 30px"></span></td> <td> <table border="1" style="margin: auto;"> <tr> <th>ID</th> <th>名称</th> <th>内容</th> <th>文档类别</th> <th>操作</th> </tr> <% for (DocumentInfo temp : DocumentInfoMapper.list()) { 
    out.write("<tr>\n" + " <td>" + temp.getId() + "</td>\n" + " <td>" + temp.getName() + "</td>\n" + " <td>" + temp.getContent() + "</td>\n" + " <td>" + temp.getDocumentCategory() + "</td>\n" + " <td>\n" + " <a href=" + request.getContextPath() + "/documentInfo?method=getById&id=" + temp.getId() + "><button>编辑</button></a>\n" + " <a href=" + request.getContextPath() + "/documentInfo?method=deleteById&id=" + temp.getId() + "><button>删除</button></a>\n" + " </td>\n" + " </tr>"); } %> </table> </td> </tr> </table> </div> </body> </html> 

• DocumentInfoAdd

 <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%@ page isELIgnored="false" %> <html> <head> <title>DocumentInfoAdd</title> <style> body{ 
    background: url("images/4.jpg"); background-size: 100%; background-size: cover; } </style> </head> <body style="text-align:center;"> <style type="text/css"> h1{ 
    background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family:"微软雅黑", "宋体", "黑体", Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #; } button{ 
    background:-webkit-linear-gradient(top ,rgb(169,169,169),rgb(34,102,149) 50%,rgb(34,102,140) 50%,rgb(128,128,128) 100%); display:inline-block; border:rgb(169,169, 187) solid 1px; box-shadow:inset rgba(255,255,255,1.0) 0px 0px 2px 0px; border-radius:8px; outline:none; width:45px; height:20px; cursor:pointer; color:#ffffff; font-size:10px; } table { 
    width: 90%; background: #ccc; margin: 10px auto; border-collapse: collapse;/*border-collapse:collapse合并内外边距(去除表格单元格默认的2个像素内外边距*/ } th,td { 
    height: 25px; line-height: 25px; text-align: center; border: 1px solid #ccc; } th { 
    background: #eee; font-weight: normal; } tr { 
    background: #fff; } tr:hover { 
    background: #cc0; } td a { 
    color: #06f; text-decoration: none; } td a:hover { 
    color: #06f; text-decoration: underline;} a:visited{ 
    text-decoration:none; //去除下划线 background-color: purple; color:gray; } a:hover{ 
    background: cornflowerblue; } /*鼠标悬停时背景颜色变橙*/ </style> <h1>文档信息添加</h1> <div> <span>${ 
   sessionScope.user.username}</span> <span><a href="<%=request.getContextPath()%>/logout">退出登录</a></span> <span style="padding-right: 50px"></span> <a href="<%=request.getContextPath()%>/index.jsp"> <button>返回</button> </a> </div> <hr> <br> <c:if test="${sessionScope.documentInfo==null}"> <form action="<%=request.getContextPath()%>/documentInfo?method=addBean" method="post"> </c:if> <c:if test="${sessionScope.documentInfo!=null}"> <form action="<%=request.getContextPath()%>/documentInfo?method=updateById" method="post"> </c:if> <table style="margin: auto"> <tr> <td>ID：</td> <td><input type="text" prefix="ID" name="id" value="${sessionScope.documentInfo.id}"></td> </tr> <tr> <td>名称：</td> <td><input type="text" prefix="名称" name="name" value="${sessionScope.documentInfo.name}"></td> </tr> <tr> <td>内容：</td> <td><input type="text" prefix="内容" name="content" value="${sessionScope.documentInfo.content}"></td> </tr> <tr> <td>文档类别：</td> <td><input type="text" prefix="文档类别" name="documentCategory" value="${sessionScope.documentInfo.documentCategory}"></td> </tr> <tr> <td> <button type="submit">添加</button> </td> <td> <button type="reset">重置</button> </td> </tr> </table> </form> </body> </html> <% session.removeAttribute("documentInfo"); %> 

• index

 <%@ page contentType="text/html;charset=UTF-8" language="java" %> <jsp:include page="UserInfo.jsp"/> 

• spider

<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <style> font{ 
    color: black; } </style> </head> <body> <li><a href="<%=request.getContextPath()%>/UserInfo.jsp"><font>用户信息管理</font></a></li> <li><a href="<%=request.getContextPath()%>/UserPermissions.jsp"><font>用户权限管理</font></a></li> <li><a href="<%=request.getContextPath()%>/DocumentCategory.jsp"><font>文档类别管理</font></a></li> <li><a href="<%=request.getContextPath()%>/DocumentInfo.jsp"><font>文档信息管理</font></a></li> <li><a href="<%=request.getContextPath()%>/DocumentAttachment.jsp"><font>文档附件管理</font></a></li> </body> </html> 

• UserInfo

<%@ page import="cn.hutool.core.util.StrUtil" %> <%@ page import="mapper.UserInfoMapper" %> <%@ page import="model.UserInfo" %> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%@ page isELIgnored="false" %> <html> <head> <title>UserInfo</title> <style> body{ 
    background: url("images/4.jpg"); background-size: 100%; background-size: cover; } </style> </head> <body style="text-align:center;"> <style type="text/css"> h1{ 
    background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5f5a4b, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family:"微软雅黑", "宋体", "黑体", Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #; } button{ 
    background:-webkit-linear-gradient(top ,rgb(169,169,169),rgb(34,102,149) 50%,rgb(34,102,140) 50%,rgb(128,128,128) 100%); display:inline-block; border:rgb(169,169, 187) solid 1px; box-shadow:inset rgba(255,255,255,1.0) 0px 0px 2px 0px; border-radius:8px; outline:none; width:45px; height:20px; cursor:pointer; color:#ffffff; font-size:10px; } table { 
    width: 90%; background: #ccc; margin: 10px auto; border-collapse: collapse;/*border-collapse:collapse合并内外边距(去除表格单元格默认的2个像素内外边距*/ } th,td { 
    background-clip: padding-box; /*背景被裁剪到内边距框*/ position:relative; height: 25px; line-height: 25px; text-align: center; } th { 
    background: #eee; font-weight: normal; } tr { 
    background: #fff; } tr:hover { 
    background: cornflowerblue; } td a { 
    color: #06f; text-decoration: none; } td a:hover { 
    color: #06f; text-decoration: underline;} a:visited{ 
    text-decoration:none; //去除下划线 background-color: purple; color:gray; } a:hover{ 
    background-color: orange; } /*鼠标悬停时背景颜色变橙*/ </style> <h1>用户信息管理</h1> <div> <span>${ 
   sessionScope.user.username}</span> <span><a href="<%=request.getContextPath()%>/logout">退出登录</a></span> <span style="padding-right: 50px"></span> <a href="<%=request.getContextPath()%>/UserInfoAdd.jsp"> <button>添加</button> </a> </div> <hr> <br> <div style="text-align: center;"> <table style="margin: auto;"> <tr> <td> <jsp:include page="spider.jsp"/> </td> <td><span style="padding-right: 30px"></span></td> <td> <table border="1" style="margin: auto;"> <tr> <th>ID</th> <th>姓名</th> <th>密码</th> <th>用户权限</th> <th>操作</th> </tr> <% for (UserInfo temp : UserInfoMapper.list()) { 
    out.write("<tr>\n" + " <td>" + temp.getId() + "</td>\n" + " <td>" + temp.getUsername() + "</td>\n" + " <td>" + temp.getPassword() + "</td>\n" + " <td>" + temp.getUserPermissions() + "</td>\n" + " <td>\n" + " <a href=" + request.getContextPath() + "/userInfo?method=getById&id=" + temp.getId() + "><button>编辑</button></a>\n" + " <a href=" + request.getContextPath() + "/userInfo?method=deleteById&id=" + temp.getId() + "><button>删除</button></a>\n" + " </td>\n" + " </tr>"); } %> </table> </td> </tr> </table> </div> </body> </html> 

• UserInfoAdd

 <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%@ page isELIgnored="false" %> <html> <head> <title>UserInfoAdd</title> <style> body{ 
    background: url("images/4.jpg"); background-size: 100%; background-size: cover; } </style> </head> <body style="text-align:center;"> <h1>用户信息添加</h1> <style type="text/css"> h1{ 
    background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family:"微软雅黑", "宋体", "黑体", Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #; } button{ 
    background:-webkit-linear-gradient(top ,rgb(169,169,169),rgb(34,102,149) 50%,rgb(34,102,140) 50%,rgb(128,128,128) 100%); display:inline-block; border:rgb(169,169, 187) solid 1px; box-shadow:inset rgba(255,255,255,1.0) 0px 0px 2px 0px; border-radius:8px; outline:none; width:45px; height:20px; cursor:pointer; color:#ffffff; font-size:10px; } table { 
    width: 90%; background: #ccc; margin: 10px auto; border-collapse: collapse;/*border-collapse:collapse合并内外边距(去除表格单元格默认的2个像素内外边距*/ } th,td { 
    height: 25px; line-height: 25px; text-align: center; border: 1px solid #ccc; } th { 
    background: #eee; font-weight: normal; } tr { 
    background: #fff; } tr:hover { 
    background: cornflowerblue; } td a { 
    color: #06f; text-decoration: none; } td a:hover { 
    color: #06f; text-decoration: underline;} a:visited{ 
    text-decoration:none; //去除下划线 background-color: purple; color:gray; } a:hover{ 
    background-color: orange; } //鼠标悬停时背景颜色变橙 </style> <div> <span>${ 
   sessionScope.user.username}</span> <span><a href="<%=request.getContextPath()%>/logout">退出登录</a></span> <span style="padding-right: 50px"></span> <a href="<%=request.getContextPath()%>/index.jsp"> <button>返回</button> </a> </div> <hr> <br> <c:if test="${sessionScope.userInfo==null}"> <form action="<%=request.getContextPath()%>/userInfo?method=addBean" method="post"> </c:if> <c:if test="${sessionScope.userInfo!=null}"> <form action="<%=request.getContextPath()%>/userInfo?method=updateById" method="post"> </c:if> <table style="margin: auto"> <tr> <td>ID：</td> <td><input type="text" prefix="ID" name="id" value="${sessionScope.userInfo.id}"></td> </tr> <tr> <td>姓名：</td> <td><input type="text" prefix="姓名" name="username" value="${sessionScope.userInfo.username}"></td> </tr> <tr> <td>密码：</td> <td><input type="text" prefix="密码" name="password" value="${sessionScope.userInfo.password}"></td> </tr> <tr> <td>用户权限：</td> <td><input type="text" prefix="用户权限" name="userPermissions" value="${sessionScope.userInfo.userPermissions}"></td> </tr> <tr> <td> <button type="submit">添加</button> </td> <td> <button type="reset">重置</button> </td> </tr> </table> </form> </body> </html> <% session.removeAttribute("userInfo"); %> 

• UserPermissions

<%@ page import="cn.hutool.core.util.StrUtil" %> <%@ page import="mapper.UserPermissionsMapper" %> <%@ page import="model.UserPermissions" %> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%@ page isELIgnored="false" %> <html> <head> <title>UserPermissions</title> <style> body{ 
    background: url("images/4.jpg"); background-size: 100%; background-size: cover; } </style> </head> <body style="text-align:center;"> <h1>用户权限管理</h1> <style type="text/css"> h1{ 
    background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family:"微软雅黑", "宋体", "黑体", Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #; } button{ 
    background:-webkit-linear-gradient(top ,rgb(169,169,169),rgb(34,102,149) 50%,rgb(34,102,140) 50%,rgb(128,128,128) 100%); display:inline-block; border:rgb(169,169, 187) solid 1px; box-shadow:inset rgba(255,255,255,1.0) 0px 0px 2px 0px; border-radius:8px; outline:none; width:45px; height:20px; cursor:pointer; color:#ffffff; font-size:10px; } table { 
    width: 90%; background: #ccc; margin: 10px auto; border-collapse: collapse;/*border-collapse:collapse合并内外边距(去除表格单元格默认的2个像素内外边距*/ } th,td { 
    background-clip: padding-box; /*背景被裁剪到内边距框*/ position:relative; height: 25px; line-height: 25px; text-align: center; } th { 
    background: #eee; font-weight: normal; } tr { 
    background: #fff; } tr:hover { 
    background: cornflowerblue; } td a { 
    color: #06f; text-decoration: none; } td a:hover { 
    color: #06f; text-decoration: underline;} a:visited{ 
    text-decoration:none; //去除下划线 background-color: purple; color:gray; } a:hover{ 
    background-color: orange; } //鼠标悬停时背景颜色变橙 </style> <div> <span>${ 
   sessionScope.user.username}</span> <span><a href="<%=request.getContextPath()%>/logout">退出登录</a></span> <span style="padding-right: 50px"></span> <a href="<%=request.getContextPath()%>/UserPermissionsAdd.jsp"> <button>添加</button> </a> </div> <hr> <br> <div style="text-align: center;"> <table style="margin: auto;"> <tr> <td> <jsp:include page="spider.jsp"/> </td> <td><span style="padding-right: 30px"></span></td> <td> <table border="1" style="margin: auto;"> <tr> <th>ID</th> <th>用户权限</th> <th>操作</th> </tr> <% for (UserPermissions temp : UserPermissionsMapper.list()) { 
    out.write("<tr>\n" + " <td>" + temp.getId() + "</td>\n" + " <td>" + temp.getUserPermissions() + "</td>\n" + " <td>\n" + " <a href=" + request.getContextPath() + "/userPermissions?method=getById&id=" + temp.getId() + "><button>编辑</button></a>\n" + " <a href=" + request.getContextPath() + "/userPermissions?method=deleteById&id=" + temp.getId() + "><button>删除</button></a>\n" + " </td>\n" + " </tr>"); } %> </table> </td> </tr> </table> </div> </body> </html> 

• UserPermissionsAdd

 <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%@ page isELIgnored="false" %> <html> <head> <title>UserPermissionsAdd</title> <style> body{ 
    background: url("images/4.jpg"); background-size: 100%; background-size: cover; } </style> </head> <body style="text-align:center;"> <style type="text/css"> h1{ 
    background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family:"微软雅黑", "宋体", "黑体", Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #; } button{ 
    background:-webkit-linear-gradient(top ,rgb(169,169,169),rgb(34,102,149) 50%,rgb(34,102,140) 50%,rgb(128,128,128) 100%); display:inline-block; border:rgb(169,169, 187) solid 1px; box-shadow:inset rgba(255,255,255,1.0) 0px 0px 2px 0px; border-radius:8px; outline:none; width:45px; height:20px; cursor:pointer; color:#ffffff; font-size:10px; } table { 
    width: 90%; background: #ccc; margin: 10px auto; border-collapse: collapse;/*border-collapse:collapse合并内外边距(去除表格单元格默认的2个像素内外边距*/ } th,td { 
    height: 25px; line-height: 25px; text-align: center; border: 1px solid #ccc; } th { 
    background: #eee; font-weight: normal; } tr { 
    background: #fff; } tr:hover { 
    background: cornflowerblue; } td a { 
    color: #06f; text-decoration: none; } td a:hover { 
    color: #06f; text-decoration: underline;} a:visited{ 
    text-decoration:none; //去除下划线 background-color: purple; color:gray; } a:hover{ 
    background-color: orange; } //鼠标悬停时背景颜色变橙 </style> <h1>用户权限添加</h1> <div> <span>${ 
   sessionScope.user.username}</span> <span><a href="<%=request.getContextPath()%>/logout">退出登录</a></span> <span style="padding-right: 50px"></span> <a href="<%=request.getContextPath()%>/index.jsp"> <button>返回</button> </a> </div> <hr> <br> <c:if test="${sessionScope.userPermissions==null}"> <form action="<%=request.getContextPath()%>/userPermissions?method=addBean" method="post"> </c:if> <c:if test="${sessionScope.userPermissions!=null}"> <form action="<%=request.getContextPath()%>/userPermissions?method=updateById" method="post"> </c:if> <table style="margin: auto"> <tr> <td>ID：</td> <td><input type="text" prefix="ID" name="id" value="${sessionScope.userPermissions.id}"></td> </tr> <tr> <td>用户权限：</td> <td><input type="text" prefix="用户权限" name="userPermissions" value="${sessionScope.userPermissions.userPermissions}"></td> </tr> <tr> <td> <button type="submit">添加</button> </td> <td> <button type="reset">重置</button> </td> </tr> </table> </form> </body> </html> <% session.removeAttribute("userPermissions"); %>