公文流转系统②|管理员功能页
一、效果如下：
二、代码如下：
（1）Admin.jsp
1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 3 <!DOCTYPE html> 4 <html> 5 <head> 6 <meta charset="UTF-8"> 7 <title>管理员功能页</title> 8 <link rel="stylesheet" href=".//layui/css/layui.css" media="all"> 9 <script src=".//layui/layui.all.js"></script> 10 <script src=".//layui/layui.js"></script> 11 <script type="text/javascript"> 12 //JavaScript代码区域 13 layui.use('element', function() { 14 var element = layui.element; 15 }); 16 </script> 17 </head> 18 <body class="layui-layout-body"> 19 20 <div class="layui-layout layui-layout-admin"> 21 <div class="layui-header"> 22 <div class="layui-logo"> 23 <% 24 String department = (String) session.getAttribute("department"); 25 out.print(department); 26 %> 27 功能页欢迎 28 <% 29 String username = (String) session.getAttribute("username"); 30 out.print(username); 31 %> 32 </div> 33 <!-- 水平导航 --> 34 <ul class="layui-nav layui-layout-right"> 35 <li class="layui-nav-item "><a href="index.jsp">退出</a></li> 36 </ul> 37 </div> 38 39 <div class="layui-side layui-bg-black"> 40 <div class="layui-side-scroll"> 41 <!-- 左侧导航 --> 42 <ul class="layui-nav layui-nav-tree"> 43 <li class="layui-nav-item"><a href="AdminServlet?method=Look" target="frame">用户管理</a></li> 44 </ul> 45 </div> 46 </div> 47 <div class="layui-body"> 48 <!-- 内容主体区域 --> 49 <iframe name="frame" width="100%" height="100%" 50 style="border: 1px solid #CCC;"></iframe> 51 </div> 52 <div> 53 <div> 54 <input type="text" id="date" /> 55 </div> 56 </div> 57 </div> 58 59 </body> 60 </html>
（2）Admin_User.jsp
1 <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> 2 <%@ page language="java" contentType="text/html; charset=UTF-8" 3 pageEncoding="UTF-8"%> 4 <!DOCTYPE html> 5 <html> 6 <head> 7 <meta charset="UTF-8"> 8 <title>用户管理</title> 9 <link rel="stylesheet" href=".//layui/css/layui.css" media="all"> 10 <script src=".//layui/layui.all.js"></script> 11 <script src=".//layui/layui.js"></script> 12 </head> 13 <body> 14 <table class="layui-table"> 15 <thead> 16 <tr> 17 <th>id</th> 18 <th>姓名</th> 19 <th>密码</th> 20 <th>部门</th> 21 <th>性别</th> 22 <th>电话</th> 23 <th>邮箱</th> 24 <th>地址</th> 25 <th>状态</th> 26 </tr> 27 </thead> 28 <tbody> 29 <c:forEach items="${list}" var="user" varStatus="status"> 30 <tr> 31 <td>${ status.index + 1}</td> 32 <td>${user.name}</td> 33 <td>${user.password}</td> 34 <td>${user.department}</td> 35 <td>${user.sex}</td> 36 <td>${user.phone}</td> 37 <td>${user.email}</td> 38 <td>${user.address}</td> 39 <td>${user.status}</td> 40 </tr> 41 </c:forEach> 42 </tbody> 43 </table> 44 </body> 45 </html>
（3）AdminServlet.java
1 package servlet; 2 3 import java.io.IOException; 4 import java.util.List; 5 6 import javax.servlet.ServletException; 7 import javax.servlet.annotation.WebServlet; 8 import javax.servlet.http.HttpServlet; 9 import javax.servlet.http.HttpServletRequest; 10 import javax.servlet.http.HttpServletResponse; 11 12 import dao.AdminDao; 13 import util.User; 14 15 /** 16 * Servlet implementation class AdminServlet 17 */ 18 @WebServlet("/AdminServlet") 19 public class AdminServlet extends HttpServlet { 20 private static final long serialVersionUID = 1L; 21 22 /** 23 * @see HttpServlet#HttpServlet() 24 */ 25 public AdminServlet() { 26 super(); 27 // TODO Auto-generated constructor stub 28 } 29 30 AdminDao dao=new AdminDao(); 31 32 /** 33 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) 34 */ 35 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 36 // TODO Auto-generated method stub 37 //response.getWriter().append("Served at: ").append(request.getContextPath()); 38 doPost(request,response); 39 } 40 41 /** 42 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) 43 */ 44 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 45 // TODO Auto-generated method stub 46 //doGet(request, response); 47 48 response.setCharacterEncoding("UTF-8"); 49 request.setCharacterEncoding("UTF-8"); 50 System.out.println("进入AdminServlet"); 51 String method = request.getParameter("method"); 52 System.out.println(method); 53 if("Look".equals(method)) { 54 Look(request,response); 55 } 56 57 } 58 59 public void Look(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 60 response.setCharacterEncoding("UTF-8"); 61 request.setCharacterEncoding("UTF-8"); 62 63 List<User> list=dao.Look(); 64 request.setAttribute("list", list); 65 request.getRequestDispatcher("Admin_User.jsp").forward(request,response); 66 67 } 68 69 }
（4）AdminDao.java
1 package dao; 2 3 import java.sql.Connection; 4 import java.sql.PreparedStatement; 5 import java.sql.ResultSet; 6 import java.util.ArrayList; 7 import java.util.List; 8 import database.Database; 9 import util.User; 10 11 public class AdminDao { 12 public List<User> Look() { 13 List<User> list = new ArrayList<>(); 14 Connection conn = null; 15 ResultSet rs = null; 16 PreparedStatement pstm = null; 17 User user = null; 18 try { 19 conn = Database.getConnection(); 20 String sql = "select * from user"; 21 pstm = conn.prepareStatement(sql); 22 rs = pstm.executeQuery(); 23 while (rs.next()) { 24 String name = rs.getString("name"); 25 String password = rs.getString("password"); 26 String department = rs.getString("department"); 27 String sex = rs.getString("sex"); 28 String phone = rs.getString("phone"); 29 String email = rs.getString("email"); 30 String address = rs.getString("address"); 31 String status=rs.getString("status"); 32 user = new User(name, password, department, sex, phone, email, address,status); 33 list.add(user); 34 } 35 } catch (Exception e) { 36 e.printStackTrace(); 37 } finally { 38 Database.close(conn, pstm, rs); 39 } 40 return list; 41 } 42 }
