返回顶部

一缕半夏微光

温柔半两，从容一生

导航

期刊论文在线投稿审稿系统⑦（管理员功能页）

一、功能

二、效果如下

三、代码如下

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 identity = (String) session.getAttribute("identity");
25                 out.print(identity);
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"
44                         target="frame">用户管理</a></li>
45                 </ul>
46             </div>
47         </div>
48         <div class="layui-body">
49             <!-- 内容主体区域 -->
50             <iframe name="frame" width="100%" height="100%"
51                 style="border: 1px solid #CCC;"></iframe>
52         </div>
53         <div>
54             <div>
55                 <input type="text" id="date" />
56             </div>
57         </div>
58     </div>
59 
60 </body>
61 </html>

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     <button class="layui-btn layui-btn-normal"
15         onclick="window.location.href='Admin_Add_User.jsp'">新增</button>
16     <table class="layui-table">
17         <thead>
18             <tr>
19                 <th>id</th>
20                 <th>姓名</th>
21                 <th>身份</th>
22                 <th>电话</th>
23                 <th>邮箱</th>
24                 <th>地址</th>
25                 <th>状态</th>
26                 <th>操作</th>
27             </tr>
28         </thead>
29         <tbody>
30             <c:forEach items="${list}" var="user" varStatus="status">
31                 <tr>
32                     <td>${ status.index + 1}</td>
33                     <td>${user.name}</td>
34                     <td>${user.identity}</td>
35                     <td>${user.phone}</td>
36                     <td>${user.email}</td>
37                     <td>${user.address}</td>
38                     <td>${user.status}</td>
39                     <td>
40                         <button class="layui-btn layui-btn-normal"
41                             onclick="window.location.href='AdminServlet?method=stop&name=${user.name}'">暂停</button>
42                         <button class="layui-btn layui-btn-normal"
43                             onclick="window.location.href='AdminServlet?method=recover&name=${user.name}'">恢复</button>
44                         <button class="layui-btn layui-btn-normal"
45                             onclick="window.location.href='AdminServlet?method=find&name=${user.name}'">查看</button>
46                         <button class="layui-btn layui-btn-normal"
47                             onclick="window.location.href='AdminServlet?method=delete&name=${user.name}'">删除</button>
48                         <button class="layui-btn layui-btn-normal"
49                             onclick="window.location.href='AdminServlet?method=alter&name=${user.name}'">修改</button>
50                     </td>
51                 </tr>
52             </c:forEach>
53         </tbody>
54     </table>
55 </body>
56 </html>

Admin_FindUser.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 </head>
10 <body>
11     <form action="AdminServlet?method=find" method="post">
12         <table align="center">
13             <c:forEach items="${list}" var="user">
14                 <tr>
15                     <td>姓名：</td>
16                     <td>${user.name}</td>
17                 </tr>
18                 <tr>
19                     <td>密码：</td>
20                     <td>${user.password}</td>
21                 </tr>
22                 <tr>
23                     <td>身份：</td>
24                     <td>${user.identity}</td>
25                 </tr>
26                 <tr>
27                     <td>性别：</td>
28                     <td>${user.sex}</td>
29                 </tr>
30                 <tr>
31                     <td>电话：</td>
32                     <td>${user.phone}</td>
33                 </tr>
34                 <tr>
35                     <td>邮箱：</td>
36                     <td>${user.email}</td>
37                 </tr>
38                 <tr>
39                     <td>地址：</td>
40                     <td>${user.address}</td>
41                 </tr>
42                 <tr>
43                     <td colspan="2"><a href="AdminServlet?method=Look">返回</a></td>
44                 </tr>
45             </c:forEach>
46         </table>
47     </form>
48 </body>
49 </html>

Admin_Alter.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     <form class="layui-form" action="AdminServlet?method=update"
15         method="post">
16         <c:forEach items="${list}" var="user">
17             <div class="layui-form-item">
18                 <label class="layui-form-label">姓名</label>
19                 <div class="layui-input-block">
20                     <input type="text" name="name" required lay-verify="required"
21                         placeholder="请输入姓名" autocomplete="off" class="layui-input"
22                         value="${user.name}"> <input type="hidden"
23                         name="judgename" required lay-verify="required"
24                         placeholder="请输入姓名" autocomplete="off" class="layui-input"
25                         value="${user.name}">
26                 </div>
27             </div>
28             <div class="layui-form-item layui-form-text">
29                 <label class="layui-form-label">身份</label>
30                 <div class="layui-input-block">
31                     <input type="text" name="identity" required lay-verify="required"
32                         placeholder="请输入身份" autocomplete="off" class="layui-input"
33                         value="${user.identity}">
34                 </div>
35             </div>
36             <div class="layui-form-item">
37                 <label class="layui-form-label">性别</label>
38                 <div class="layui-inline">
39                     <input type="text" name="sex" required lay-verify="required"
40                         placeholder="请输入性别" autocomplete="off" class="layui-input"
41                         value="${user.sex}">
42                 </div>
43             </div>
44             <div class="layui-form-item">
45                 <label class="layui-form-label">电话</label>
46                 <div class="layui-inline">
47                     <input type="text" name="phone" required lay-verify="required"
48                         placeholder="请输入电话" autocomplete="off" class="layui-input"
49                         value="${user.phone}">
50                 </div>
51             </div>
52             <div class="layui-form-item">
53                 <label class="layui-form-label">邮箱</label>
54                 <div class="layui-inline">
55                     <input type="text" name="email" required lay-verify="required"
56                         placeholder="请输入邮箱" autocomplete="off" class="layui-input"
57                         value="${user.email}">
58                 </div>
59             </div>
60             <div class="layui-form-item">
61                 <label class="layui-form-label">地址</label>
62                 <div class="layui-inline">
63                     <input type="text" name="email" required lay-verify="required"
64                         placeholder="请输入地址" autocomplete="off" class="layui-input"
65                         value="${user.email}">
66                 </div>
67             </div>
68             <div class="layui-form-item">
69                 <div class="layui-input-block">
70                     <button class="layui-btn" lay-submit>修改</button>
71                 </div>
72             </div>
73         </c:forEach>
74     </form>
75 </body>
76 </html>

Admin_Add_User.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 <script src=".//layui/layui.js"></script>
 9 <meta name="renderer" content="webkit">
10 <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
11 <meta name="viewport"
12     content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
13 <link rel="stylesheet" href=".//layui/css/layui.css" media="all">
14 <link rel="stylesheet" href=".//style/admin.css" media="all">
15 <link rel="stylesheet" href=".//style/login.css" media="all">
16 </head>
17 <body>
18     <form action="AdminServlet?method=add" method="post">
19         <div class="layadmin-user-login layadmin-user-display-show"
20             id="LAY-user-login" style="display: none;">
21             <div class="layadmin-user-login-main">
22                 <div class="layadmin-user-login-box layadmin-user-login-header">
23                     <h2>增加用户</h2>
24                 </div>
25                 <div
26                     class="layadmin-user-login-box layadmin-user-login-body layui-form">
27                     <div class="layui-form-item">
28                         <label class="layadmin-user-login-icon layui-icon layui-icon-username"
29                             for="LAY-user-login-name"></label> <input type="text" name="name"
30                             id="LAY-user-login-nickname" lay-verify="name" placeholder="用户名"
31                             class="layui-input">
32                     </div>
33                     <div class="layui-form-item">
34                         <label
35                             class="layadmin-user-login-icon layui-icon layui-icon-password"
36                             for="LAY-user-login-password"></label> <input type="password"
37                             name="password" id="LAY-user-login-password"
38                             lay-verify="password" placeholder="密码" class="layui-input">
39                     </div>
40                     <div class="layui-form-item">
41                         <label
42                             class="layadmin-user-login-icon layui-icon layui-icon-password"
43                             for="LAY-user-login-repass"></label> <input type="password"
44                             name="repass" id="LAY-user-login-repass" lay-verify="required"
45                             placeholder="确认密码" class="layui-input">
46                     </div>
47                     <div class="layui-input-item">
48                         <lable class="layui-form-label">性别</lable>
49                         <input type="radio" name="sex" value="男" title="男" checked="">
50                         <input type="radio" name="sex" value="女" title="女">
51                     </div>
52                     <div class="layui-form-item">
53                         <label class="layui-form-label">身份</label>
54                         <div class="layui-input-inline">
55                             <select id="identity" name="identity">
56                                 <option value="">请选择</option>
57                                 <option value="系统管理员">系统管理员</option>
58                                 <option value="总编">总编</option>
59                                 <option value="审稿人">审稿人</option>
60                                 <option value="校稿人">校稿人</option>
61                                 <option value="投稿人">投稿人</option>
62                                 <option value="普通用户">普通用户</option>
63                             </select>
64                         </div>
65                     </div>
66                     <div class="layui-form-item">
67                         <label
68                             class="layadmin-user-login-icon layui-icon layui-icon-cellphone"
69                             for="LAY-user-login-phone"></label> <input type="text"
70                             name="phone" id="LAY-user-login-phone" lay-verify="phone"
71                             placeholder="电话号码" class="layui-input">
72                     </div>
73                     <div class="layui-form-item">
74                         <label
75                             class="layadmin-user-login-icon layui-icon layui-icon-email"
76                             for="LAY-user-login-email"></label> <input type="text"
77                             name="email" id="LAY-user-login-email" lay-verify="email"
78                             placeholder="电子邮箱" class="layui-input">
79                     </div>
80                     <div class="layui-form-item">
81                         <label
82                             class="layadmin-user-login-icon layui-icon layui-icon-location"
83                             for="LAY-user-login-address"></label> <input type="text"
84                             name="address" id="LAY-user-login-address" lay-verify="address"
85                             placeholder="家庭住址" class="layui-input">
86                     </div>
87                     <div class="layui-form-item">
88                         <button class="layui-btn layui-btn-fluid" lay-submit
89                             lay-filter="LAY-user-reg-submit">增加</button>
90                     </div>
91                 </div>
92             </div>
93         </div>
94     </form>
95 </body>
96 </html>

AdminServlet.java（在servlet文件下建立此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 import javax.swing.JOptionPane;
 12 
 13 import dao.AdminDao;
 14 import util.User;
 15 
 16 /**
 17  * Servlet implementation class AdminServlet
 18  */
 19 @WebServlet("/AdminServlet")
 20 public class AdminServlet extends HttpServlet {
 21     private static final long serialVersionUID = 1L;
 22        
 23     /**
 24      * @see HttpServlet#HttpServlet()
 25      */
 26     public AdminServlet() {
 27         super();
 28         // TODO Auto-generated constructor stub
 29     }
 30     
 31     AdminDao dao=new AdminDao();
 32 
 33     /**
 34      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
 35      */
 36     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 37         // TODO Auto-generated method stub
 38         //response.getWriter().append("Served at: ").append(request.getContextPath());
 39         doPost(request, response);
 40     }
 41 
 42     /**
 43      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
 44      */
 45     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 46         // TODO Auto-generated method stub
 47         //doGet(request, response);
 48         
 49         response.setCharacterEncoding("UTF-8");
 50         request.setCharacterEncoding("UTF-8");
 51         System.out.println("进入AdminServlet");
 52         String method = request.getParameter("method");
 53           System.out.println(method);
 54           if("Look".equals(method)) {
 55               Look(request,response);
 56           }else if("stop".equals(method)) {
 57               stop(request,response);
 58           }else if("recover".equals(method)) {
 59               recover(request,response);
 60           }else if("add".equals(method)) {
 61               add(request,response);
 62           }else if("delete".equals(method)) {
 63               delete(request,response);
 64           }else if("find".equals(method)) {
 65               find(request,response);
 66           }else if("alter".equals(method)) {
 67               alter(request,response);
 68           }else if("update".equals(method)) {
 69               update(request,response);
 70           }
 71         
 72     }
 73     
 74     public void Look(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 75         response.setCharacterEncoding("UTF-8");
 76         request.setCharacterEncoding("UTF-8");
 77         
 78         List<User> list=dao.Look();
 79         request.setAttribute("list", list);
 80         request.getRequestDispatcher("Admin_User.jsp").forward(request,response);
 81         
 82     }
 83     
 84     public void stop(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 85         response.setCharacterEncoding("UTF-8");
 86         request.setCharacterEncoding("UTF-8");
 87         
 88         String name=request.getParameter("name");
 89         
 90         if(dao.stop(name)){
 91             System.out.println("暂停成功");
 92             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
 93         }else {
 94             System.out.println("暂停失败");
 95             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
 96         }
 97         
 98     }
 99     public void recover(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
100         response.setCharacterEncoding("UTF-8");
101         request.setCharacterEncoding("UTF-8");
102         
103         String name=request.getParameter("name");
104         
105         if(dao.recover(name)){
106             System.out.println("恢复成功");
107             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
108         }else {
109             System.out.println("恢复失败");
110             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
111         }
112         
113     }
114     public void add(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {     
115         response.setCharacterEncoding("UTF-8");
116         request.setCharacterEncoding("UTF-8");
117         
118         String name = request.getParameter("name");
119         String password = request.getParameter("password");
120         String identity = request.getParameter("identity");
121         String sex = request.getParameter("sex");
122         String phone = request.getParameter("phone");
123         String email = request.getParameter("email");
124         String address = request.getParameter("address");
125 
126         User user = new User(name, password, identity, sex, phone, email, address, "1");
127 
128         if (dao.add(user)) {
129             request.getRequestDispatcher("AdminServlet?method=Look").forward(request, response);
130         } else {
131             request.getRequestDispatcher("TestFail.jsp").forward(request, response);
132         }
133 
134     }
135     public void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
136         response.setCharacterEncoding("UTF-8");
137         request.setCharacterEncoding("UTF-8");
138         
139         String name=request.getParameter("name");
140         
141         if(dao.delete(name)){
142             System.out.println("删除成功");
143             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
144         }else {
145             System.out.println("删除失败");
146             request.getRequestDispatcher("TestFail.jsp").forward(request,response);
147         }
148         
149     }
150     public void find(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
151         response.setCharacterEncoding("UTF-8");
152         request.setCharacterEncoding("UTF-8");
153         String name=request.getParameter("name");
154         List<User> list=dao.find(name);
155         request.setAttribute("list", list);
156         request.getRequestDispatcher("Admin_FindUser.jsp").forward(request,response);
157         
158     }
159     
160     public void alter(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
161         response.setCharacterEncoding("UTF-8");
162         request.setCharacterEncoding("UTF-8");
163         
164         String name=request.getParameter("name");
165         List<User> list=dao.alter(name);
166         request.setAttribute("list", list);
167         request.getRequestDispatcher("Admin_Alter.jsp").forward(request,response);
168         
169     }
170     public void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
171         response.setCharacterEncoding("UTF-8");
172         request.setCharacterEncoding("UTF-8");
173         
174         String name=request.getParameter("name");
175         String judgename=request.getParameter("judgename");
176         String identity=request.getParameter("identity");
177         String sex=request.getParameter("sex");
178         String phone=request.getParameter("phone");
179         String email=request.getParameter("email");
180         String address=request.getParameter("address");
181         
182         User user=new User(name,identity,sex,phone,email,address);
183         
184         if(dao.update(user,judgename)){
185             JOptionPane.showMessageDialog(null, "修改成功", "success", JOptionPane.PLAIN_MESSAGE);
186             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
187         }else {
188             request.getRequestDispatcher("TestFail.jsp").forward(request,response);
189         }
190         
191     }
192 
193 }

AdminDao.java（在servlet文件下建立此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 
  9 import util.User;
 10 import databse.Database;
 11 
 12 public class AdminDao {
 13     public List<User> Look() {
 14         List<User> list = new ArrayList<>();
 15         Connection conn = null;
 16         ResultSet rs = null;
 17         PreparedStatement pstm = null;
 18         User user = null;
 19         try {
 20             conn = Database.getConnection();
 21             String sql = "select * from user";
 22             pstm = conn.prepareStatement(sql);
 23             rs = pstm.executeQuery();
 24             while (rs.next()) {
 25                 String name = rs.getString("name");
 26                 String password = rs.getString("password");
 27                 String identity = rs.getString("identity");
 28                 String sex = rs.getString("sex");
 29                 String phone = rs.getString("phone");
 30                 String email = rs.getString("email");
 31                 String address = rs.getString("address");
 32                 String status = rs.getString("status");
 33                 user = new User(name,password,identity,sex,phone,email,address,status);
 34                 list.add(user);
 35             }
 36         } catch (Exception e) {
 37             e.printStackTrace();
 38         } finally {
 39             Database.close(conn, pstm, rs);
 40         }
 41         return list;
 42     }
 43     /**
 44      * 暂停用户
 45      * @param number
 46      * @return
 47      */
 48     public boolean stop(String name) {
 49         Connection conn = null;
 50         PreparedStatement pstm = null;
 51         PreparedStatement pstm1 = null;
 52         boolean judge = false;
 53         try {
 54             conn = Database.getConnection();
 55             String sql = "update user set status=? where name=?";
 56             pstm = conn.prepareStatement(sql);
 57             pstm.setString(1, "0");
 58             pstm.setString(2, name);
 59             String sql1 = "update login set status=? where name=?";
 60             pstm1 = conn.prepareStatement(sql1);
 61             pstm1.setString(1, "0");
 62             pstm1.setString(2, name);
 63             // 执行插入操作
 64             int num = pstm.executeUpdate();
 65             int num1 = pstm1.executeUpdate();
 66             if (num > 0 && num1 > 0) {
 67                 System.out.println("暂停成功");
 68                 judge = true;
 69             } else {
 70                 System.out.println("暂停失败");
 71                 judge = false;
 72             }
 73         } catch (Exception e) {
 74             e.printStackTrace();
 75         } finally {
 76             // SQL执行完成后释放相关资源
 77             Database.close(conn, pstm);
 78         }
 79         return judge;
 80     }
 81     /**
 82      * 恢复
 83      * @param number
 84      * @return
 85      */
 86     public boolean recover(String name) {
 87         Connection conn = null;
 88         PreparedStatement pstm = null;
 89         PreparedStatement pstm1 = null;
 90         boolean judge = false;
 91         try {
 92             conn = Database.getConnection();
 93             String sql = "update user set status=? where name=?";
 94             pstm = conn.prepareStatement(sql);
 95             pstm.setString(1, "1");
 96             pstm.setString(2, name);
 97             String sql1 = "update login set status=? where name=?";
 98             pstm1 = conn.prepareStatement(sql1);
 99             pstm1.setString(1, "1");
100             pstm1.setString(2, name);
101             // 执行插入操作
102             int num = pstm.executeUpdate();
103             int num1 = pstm1.executeUpdate();
104             if (num > 0 && num1 > 0) {
105                 System.out.println("恢复成功");
106                 judge = true;
107             } else {
108                 System.out.println("恢复失败");
109                 judge = false;
110             }
111         } catch (Exception e) {
112             e.printStackTrace();
113         } finally {
114             // SQL执行完成后释放相关资源
115             Database.close(conn, pstm);
116         }
117         return judge;
118     }
119     /**
120      * 增加用户
121      * @param user
122      * @return
123      */    
124     public boolean add(User user) {
125         Connection conn=null;
126         PreparedStatement pstm=null;
127         PreparedStatement ps=null;
128         boolean judge=false;
129         try {
130             conn=Database.getConnection();
131             String sql="insert into user(name,password,identity,sex,phone,email,address,status) values(?,?,?,?,?,?,?,?)";
132             String loginsql="insert into login(name,password,identity,status) values(?,?,?,?)";
133             System.out.println(sql);
134             System.out.println(loginsql);
135             pstm=conn.prepareStatement(sql);
136             ps=conn.prepareStatement(loginsql);
137             
138             pstm.setString(1, user.getName());
139             pstm.setString(2, user.getPassword());
140             pstm.setString(3, user.getIdentity());
141             pstm.setString(4, user.getSex());
142             pstm.setString(5, user.getPhone());
143             pstm.setString(6, user.getEmail());
144             pstm.setString(7, user.getAddress());
145             pstm.setString(8, user.getStatus());
146             
147             ps.setString(1, user.getName());
148             ps.setString(2, user.getPassword());
149             ps.setString(3, user.getIdentity());
150             ps.setString(4, user.getStatus());
151             
152             //执行插入操作
153             int num=pstm.executeUpdate();
154             int num1=ps.executeUpdate();
155             if(num>0&&num1>0) {
156                 System.out.println("增加用户成功");
157                 judge=true;
158             }else {
159                 System.out.println("增加用户失败");
160                 judge=false;
161             }
162         }catch(Exception e) {
163             e.printStackTrace();
164         }finally {
165             //SQL执行完成后释放相关资源
166             Database.close(conn,pstm);
167         }
168         return judge;
169     }
170     /**
171      * 删除
172      * @param name
173      * @return
174      */
175     public boolean delete(String name) {
176         Connection conn = null;
177         PreparedStatement pstm = null;
178         PreparedStatement pstm1 = null;
179         ResultSet rs = null;
180         boolean judge = false;
181         try {
182             conn = Database.getConnection();
183             String sql = "delete from user where name=?";
184             pstm = conn.prepareStatement(sql);
185             pstm.setString(1, name);
186             String sql1 = "delete from login where name=?";
187             pstm1 = conn.prepareStatement(sql1);
188             pstm1.setString(1, name);
189             int num = pstm.executeUpdate();
190             int num1 = pstm1.executeUpdate();
191             if (num > 0 && num1 > 0) {
192                 System.out.println("删除成功");
193                 judge = true;
194             } else {
195                 System.out.println("删除失败");
196                 judge = false;
197             }
198         } catch (Exception e) {
199             e.printStackTrace();
200         } finally {
201             // SQL执行完成后释放相关资源
202             Database.close(conn, pstm, rs);
203         }
204         return judge;
205     }
206     /**
207      * 查看
208      * @param name
209      * @return
210      */
211     public List<User> find(String name) {
212         List<User> list = new ArrayList<>();
213         Connection conn = null;
214         ResultSet rs = null;
215         PreparedStatement pstm = null;
216         User user = null;
217         try {
218             conn = Database.getConnection();
219             String sql = "select * from user where name=?";
220             pstm = conn.prepareStatement(sql);
221             pstm.setString(1, name);
222             rs = pstm.executeQuery();
223             while (rs.next()) {
224                 String namee = rs.getString("name");
225                 String identity = rs.getString("identity");
226                 String sex = rs.getString("sex");
227                 String phone = rs.getString("phone");
228                 String email = rs.getString("email");
229                 String address = rs.getString("address");
230                 String status = rs.getString("status");
231                 user = new User(namee,identity,sex,phone,email,address,status);
232                 list.add(user);
233             }
234         } catch (Exception e) {
235             e.printStackTrace();
236         } finally {
237             Database.close(conn, pstm, rs);
238         }
239         return list;
240     }
241     /**
242      * 修改
243      * @param name
244      * @return
245      */
246     public List<User> alter(String name){
247         List<User> list=new ArrayList<>();
248         Connection conn=null;
249         ResultSet rs=null;
250         PreparedStatement pstm=null;
251         User user=null;
252         try {
253             conn=Database.getConnection();
254             String sql="select * from user where name=?";
255             pstm=conn.prepareStatement(sql);
256             pstm.setString(1,name);
257             rs=pstm.executeQuery();
258             while(rs.next()) {
259                 String namee = rs.getString("name");
260                 String identity = rs.getString("identity");
261                 String sex = rs.getString("sex");
262                 String phone = rs.getString("phone");
263                 String email = rs.getString("email");
264                 String address = rs.getString("address");
265                 String status = rs.getString("status");
266                 user = new User(namee,identity,sex,phone,email,address,status);
267                 list.add(user);
268             }
269         }catch(Exception e) {
270             e.printStackTrace();
271         }finally {
272             Database.close(conn, pstm, rs);
273         }
274         return list;
275     }
276     /**
277      * 修改更新
278      * @param user
279      * @param judgename
280      * @return
281      */
282     public boolean update(User user,String judgename) {
283         Connection conn=null;
284         PreparedStatement pstm=null;
285         boolean judge=false;
286         try {
287             conn=Database.getConnection();
288             String sql="update user set name=?,identity=?,sex=?,phone=?,email=?,address=? where name=?";
289             pstm=conn.prepareStatement(sql);
290             pstm.setString(1, user.getName());
291             pstm.setString(2, user.getIdentity());
292             pstm.setString(3, user.getSex());
293             pstm.setString(4, user.getPhone());
294             pstm.setString(5, user.getEmail());
295             pstm.setString(6, user.getAddress());
296             pstm.setString(7, judgename);
297             //执行插入操作
298             int num=pstm.executeUpdate();
299             if(num>0) {
300                 System.out.println("修改成功");
301                 judge=true;
302             }else {
303                 System.out.println("修改失败");
304                 judge=false;
305             }
306         }catch(Exception e) {
307             e.printStackTrace();
308         }finally {
309             //SQL执行完成后释放相关资源
310             Database.close(conn,pstm);
311         }
312         return judge;
313     }
314 }

 

posted on 2021-10-04 21:49  一缕半夏微光  阅读(199)  评论(0)  编辑  收藏  举报