返回顶部

一缕半夏微光

温柔半两，从容一生

导航

每周总结⑧

 

这周在写系统管理功能页的用户管理，效果如下（界面有一些不太好看，后期再精进，暂时先将功能做好）：

数据库表的设计如下：

工程目录如下：

代码如下（有些之前已经贴过的，这里便不再贴了）：

AdminDao.java

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

AdminServlet.java

  1 package fileServlet;
  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 fileDao.AdminDao;
 13 import fileUtil.LoginUser;
 14 import fileUtil.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 adminDao=new AdminDao();
 32     
 33     public void Look(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 34         response.setCharacterEncoding("UTF-8");
 35         request.setCharacterEncoding("UTF-8");
 36         
 37         List<User> list=adminDao.Look();
 38         request.setAttribute("list", list);
 39         request.getRequestDispatcher("User.jsp").forward(request,response);
 40         
 41     }
 42     public void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 43         response.setCharacterEncoding("UTF-8");
 44         request.setCharacterEncoding("UTF-8");
 45         
 46         String number=request.getParameter("number");
 47         System.out.println("删除number:"+number);
 48         
 49         if(adminDao.delete(number)){
 50             System.out.println("删除成功");
 51             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
 52         }else {
 53             System.out.println("删除失败");
 54             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
 55         }
 56         
 57     }
 58     public void stop(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 59         response.setCharacterEncoding("UTF-8");
 60         request.setCharacterEncoding("UTF-8");
 61         
 62         String number=request.getParameter("number");
 63         
 64         if(adminDao.stop(number)){
 65             System.out.println("暂停成功");
 66             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
 67         }else {
 68             System.out.println("暂停失败");
 69             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
 70         }
 71         
 72     }
 73     public void recover(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 74         response.setCharacterEncoding("UTF-8");
 75         request.setCharacterEncoding("UTF-8");
 76         
 77         String number=request.getParameter("number");
 78         
 79         if(adminDao.recover(number)){
 80             System.out.println("恢复成功");
 81             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
 82         }else {
 83             System.out.println("恢复失败");
 84             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
 85         }
 86         
 87     }
 88     public void add(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 89         response.setCharacterEncoding("UTF-8");
 90         request.setCharacterEncoding("UTF-8");
 91         
 92         String number=request.getParameter("number");
 93         String password=request.getParameter("password");
 94         String name=request.getParameter("name");
 95         String job=request.getParameter("job");
 96         String sex=request.getParameter("sex");
 97         String phone=request.getParameter("phone");
 98         String time=request.getParameter("time");
 99         
100         User user=new User(number,password,name,job,sex,phone,time,"1");
101         
102         char s = job.charAt(0);//获取字符串的第一个字符
103         String status = String.valueOf(s);
104         LoginUser loginUser=new LoginUser(number, password,status, "1");
105         
106         if(adminDao.add(user)&&adminDao.add(loginUser)){
107             System.out.println("添加成功");
108             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
109         }else {
110             System.out.println("添加失败");
111             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
112         }
113         
114     }
115     public void alter(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
116         response.setCharacterEncoding("UTF-8");
117         request.setCharacterEncoding("UTF-8");
118         
119         String number=request.getParameter("number");
120         List<User> list=adminDao.alter(number);
121         request.setAttribute("list", list);
122         request.getRequestDispatcher("AlterUser.jsp").forward(request,response);
123         
124     }
125     public void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
126         response.setCharacterEncoding("UTF-8");
127         request.setCharacterEncoding("UTF-8");
128         
129         String number=request.getParameter("number");
130         String password=request.getParameter("password");
131         String name=request.getParameter("name");
132         String sex=request.getParameter("sex");
133         String job=request.getParameter("job");
134         String phone=request.getParameter("phone");
135         User user=new User(password,name,job,sex,phone,number);
136         
137         if(adminDao.update(user)){
138             System.out.println("修改成功");
139             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
140         }else {
141             System.out.println("修改失败");
142             request.getRequestDispatcher("AdminServlet?method=Look").forward(request,response);
143         }
144         
145     }
146     public void find(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
147         response.setCharacterEncoding("UTF-8");
148         request.setCharacterEncoding("UTF-8");
149         String number=request.getParameter("number");
150         List<User> list=adminDao.find(number);
151         request.setAttribute("list", list);
152         request.getRequestDispatcher("FindUser.jsp").forward(request,response);
153         
154     }
155     
156     /**
157      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
158      */
159     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
160         // TODO Auto-generated method stub
161         response.setCharacterEncoding("UTF-8");
162         request.setCharacterEncoding("UTF-8");
163         System.out.println("进入AdminServlet");
164         String method = request.getParameter("method");
165           System.out.println(method);
166           if("Look".equals(method)) {
167               Look(request,response);
168           }else if("delete".equals(method)) {
169               delete(request,response);
170           }else if("add".equals(method)) {
171               add(request,response);
172           }else if("stop".equals(method)) {
173               stop(request,response);
174           }else if("recover".equals(method)) {
175               recover(request,response);
176           }else if("alter".equals(method)) {
177               alter(request,response);
178           }else if("update".equals(method)) {
179               update(request,response);
180           }else if("find".equals(method)) {
181               find(request,response);
182           }
183     }
184 
185     /**
186      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
187      */
188     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
189         // TODO Auto-generated method stub
190         doGet(request, response);
191     }
192 
193 }

User.java

  1 package fileUtil;
  2 
  3 public class User {
  4     private String id;
  5     private String number;
  6     private String password;
  7     private String name;
  8     private String job;
  9     private String sex;
 10     private String phone;
 11     private String time;
 12     private String state;
 13 
 14     public User() {
 15     }
 16 
 17     public User(String number, String password, String name, String job, String sex, String phone, String time,
 18             String state) {
 19         super();
 20         this.number = number;
 21         this.password = password;
 22         this.name = name;
 23         this.job = job;
 24         this.sex = sex;
 25         this.phone = phone;
 26         this.time = time;
 27         this.state = state;
 28     }
 29 
 30     public User(String password, String name, String job,String sex, String phone, String number) {
 31         super();
 32         this.number = number;
 33         this.password = password;
 34         this.name = name;
 35         this.job=job;
 36         this.sex = sex;
 37         this.phone = phone;
 38     }
 39 
 40     public User(String id, String number, String password, String name, String job, String sex, String phone,
 41             String time, String state) {
 42         super();
 43         this.setId(id);
 44         this.number = number;
 45         this.password = password;
 46         this.name = name;
 47         this.job = job;
 48         this.sex = sex;
 49         this.phone = phone;
 50         this.time = time;
 51         this.state = state;
 52     }
 53 
 54     @Override
 55     public String toString() {
 56         return "User{" + "id=" + id + '\'' + ",number=" + number + '\'' + ", password='" + password + '\'' + ", name="
 57                 + name + '\'' + ", job=" + job + '\'' + ", sex=" + sex + '\'' + ", phone=" + phone + '\'' + ", time="
 58                 + time + '\'' + ", state=" + state + '}';
 59     }
 60 
 61     public String getNumber() {
 62         return number;
 63     }
 64 
 65     public void setNumber(String number) {
 66         this.number = number;
 67     }
 68 
 69     public String getPassword() {
 70         return password;
 71     }
 72 
 73     public void setPassword(String password) {
 74         this.password = password;
 75     }
 76 
 77     public String getName() {
 78         return name;
 79     }
 80 
 81     public void setName(String name) {
 82         this.name = name;
 83     }
 84 
 85     public String getJob() {
 86         return job;
 87     }
 88 
 89     public void setJob(String job) {
 90         this.job = job;
 91     }
 92 
 93     public String getSex() {
 94         return sex;
 95     }
 96 
 97     public void setSex(String sex) {
 98         this.sex = sex;
 99     }
100 
101     public String getPhone() {
102         return phone;
103     }
104 
105     public void setPhone(String phone) {
106         this.phone = phone;
107     }
108 
109     public String getTime() {
110         return time;
111     }
112 
113     public void setTime(String time) {
114         this.time = time;
115     }
116 
117     public String getState() {
118         return state;
119     }
120 
121     public void setState(String state) {
122         this.state = state;
123     }
124 
125     public String getId() {
126         return id;
127     }
128 
129     public void setId(String id) {
130         this.id = id;
131     }
132 }

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 <meta name="viewport" content="width=device-width, initial-scale=1">
 10 <style type="text/css">
 11 html {
 12     font-family: sans-serif;
 13     -ms-text-size-adjust: 100%;
 14     -webkit-text-size-adjust: 100%;
 15 }
 16 
 17 body {
 18     margin: 10px;
 19 }
 20 
 21 table {
 22     border-collapse: collapse;
 23     border-spacing: 0;
 24 }
 25 
 26 td, th {
 27     padding: 0;
 28 }
 29 
 30 .pure-table {
 31     border-collapse: collapse;
 32     border-spacing: 0;
 33     empty-cells: show;
 34     border: 1px solid #cbcbcb;
 35 }
 36 
 37 .pure-table caption {
 38     color: #000;
 39     font: italic 85%/1 arial, sans-serif;
 40     padding: 1em 0;
 41     text-align: center;
 42 }
 43 
 44 .pure-table td, .pure-table th {
 45     border-left: 1px solid #cbcbcb;
 46     border-width: 0 0 0 1px;
 47     font-size: inherit;
 48     margin: 0;
 49     overflow: visible;
 50     padding: .5em 1em;
 51 }
 52 
 53 .pure-table thead {
 54     background-color: #e0e0e0;
 55     color: #000;
 56     text-align: left;
 57     vertical-align: bottom;
 58 }
 59 
 60 .pure-table td {
 61     background-color: transparent;
 62 }
 63 
 64 .pure-table-bordered td {
 65     border-bottom: 1px solid #cbcbcb;
 66 }
 67 
 68 .pure-table-bordered tbody>tr:last-child>td {
 69     border-bottom-width: 0;
 70 }
 71 </style>
 72 </head>
 73 <body>
 74     <input type="button" value="增加"
 75         style="width: 100px; height: 45px; border: 0px; border-radius: 5px; background-color: #0271CD; color: white;"
 76         onclick="window.location.href='AddUser.jsp'">
 77 
 78     <form action="AdminServlet?method=Look" method="post">
 79         <table class="pure-table pure-table-bordered">
 80             <thead>
 81                 <tr>
 82                     <th>序号</th>
 83                     <th>帐号</th>
 84                     <th>密码</th>
 85                     <th>姓名</th>
 86                     <th>职位</th>
 87                     <th>性别</th>
 88                     <th>电话</th>
 89                     <th>时间</th>
 90                     <th>状态</th>
 91                     <th>操作</th>
 92                 </tr>
 93             </thead>
 94             <tbody>
 95                 <c:forEach items="${list}" var="user">
 96                     <tr>
 97                         <td>${user.id}</td>
 98                         <td>${user.number}</td>
 99                         <td>${user.password}</td>
100                         <td>${user.name}</td>
101                         <td>${user.job}</td>
102                         <td>${user.sex}</td>
103                         <td>${user.phone}</td>
104                         <td>${user.time}</td>
105                         <td>${user.state}</td>
106                         <td><a href="AdminServlet?method=stop&number=${user.number}">暂停</a>
107                             <a href="AdminServlet?method=recover&number=${user.number}">恢复</a>
108                             <a href="AdminServlet?method=find&number=${user.number}">查看</a> <a
109                             href="AdminServlet?method=delete&number=${user.number}">删除</a> <a
110                             href="AdminServlet?method=alter&number=${user.number}">修改</a></td>
111                     </tr>
112                 </c:forEach>
113             </tbody>
114         </table>
115     </form>
116 </body>
117 </html>

AddUser.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 </head>
 9 <body>
10     <form action="AdminServlet?method=add" method="post">
11         <table align="center">
12             <tr>
13                 <td>帐号：</td>
14                 <td><input type="text" id="number" name="number"
15                     placeholder="请输入帐号"></td>
16             </tr>
17             <tr>
18                 <td>密码：</td>
19                 <td><input type="text" id="password" name="password"
20                     placeholder="请输入密码"></td>
21             </tr>
22             <tr>
23                 <td>姓名：</td>
24                 <td><input type="text" id="name" name="name" placeholder="请输姓名"></td>
25             </tr>
26             <tr>
27                 <td>职位：</td>
28                 <td><select name="job" id="job">
29                         <option value="0" selected>--请选择--</option>
30                         <option value="1.管理员">1.管理员</option>
31                         <option value="2。厂长">2.厂长</option>
32                         <option value="3。副厂长">3.副厂长</option>
33                         <option value="4。办公室">4.办公室</option>
34                         <option value="5。财务部">5.财务部</option>
35                         <option value="6。销售部">6.销售部</option>
36                         <option value="7。生产部">7.生产部</option>
37                 </select></td>
38             </tr>
39             <tr>
40                 <td>性别：</td>
41                 <td><input type="radio" id="sex" name="sex" checked="checked"
42                     value="男">男 <input type="radio" id="sex" name="sex"
43                     value="女">女</td>
44             </tr>
45             <tr>
46                 <td>电话：</td>
47                 <td><input type="text" id="phone" name="phone"
48                     placeholder="请输入电话"></td>
49             </tr>
50             <tr>
51                 <td>时间：</td>
52                 <td><input type="text" name="time" id="time"
53                     placeholder="点击获取时间"></td>
54             </tr>
55         </table>
56         <table align="center">
57             <tr style="text-align: center">
58                 <td><input type="submit" value="增加"></td>
59                 <td><input type="reset" value="重置"></td>
60                 <td><input type="button" value="返回"
61                     onclick="window.location.href='AdminServlet?method=Look'"></td>
62             </tr>
63         </table>
64     </form>
65 </body>
66 </html>

AlterUser.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>增加用户</title>
</head>
<body>
    <form action="AdminServlet?method=update" method="post">
        <table align="center">
            <c:forEach items="${list}" var="user">
                <tr>
                    <td>帐号：</td>
                    <td>${user.number}</td>
                    <td>|</td>
                    <td>帐号：</td>
                    <td><input type="text" id="number" name="number"
                        value="${user.number}"></td>
                </tr>
                <tr>
                    <td>密码：</td>
                    <td>${user.password}</td>
                    <td>|</td>
                    <td>密码：</td>
                    <td><input type="text" id="password" name="password"
                        placeholder="密码可修改"></td>
                </tr>
                <tr>
                    <td>姓名：</td>
                    <td>${user.name}</td>
                    <td>|</td>
                    <td>姓名：</td>
                    <td><input type="text" id="name" name="name"
                        placeholder="姓名可修改"></td>
                </tr>
                <tr>
                    <td>职位：</td>
                    <td>${user.job}</td>
                    <td>|</td>
                    <td>职位：</td>
                    <td><select name="job" id="job">
                            <option value="0" selected>--请选择--</option>
                            <option value="1.管理员">1.管理员</option>
                            <option value="2。厂长">2.厂长</option>
                            <option value="3。副厂长">3.副厂长</option>
                            <option value="4。办公室">4.办公室</option>
                            <option value="5。财务部">5.财务部</option>
                            <option value="6。销售部">6.销售部</option>
                            <option value="7。生产部">7.生产部</option>
                    </select></td>
                </tr>
                <tr>
                    <td>性别：</td>
                    <td>${user.sex}</td>
                    <td>|</td>
                    <td>性别：</td>
                    <td><input type="radio" id="sex" name="sex" checked="checked"
                        value="男">男 <input type="radio" id="sex" name="sex"
                        value="女">女</td>
                </tr>
                <tr>
                    <td>电话：</td>
                    <td>${user.phone}</td>
                    <td>|</td>
                    <td>电话：</td>
                    <td><input type="text" id="phone" name="phone"
                        placeholder="电话可修改"></td>
                </tr>
                <tr>
                    <td>时间：</td>
                    <td>${user.time}</td>
                    <td>|</td>
                    <td>时间：</td>
                    <td><input type="text" name="time" id="time"
                        value="${user.time}"></td>
                </tr>
            </c:forEach>
        </table>
        <table align="center">
            <tr style="text-align: center">
                <td><input type="submit" value="修改"></td>
                <td><input type="reset" value="重置"></td>
                <td><input type="button" value="返回"
                    onclick="window.location.href='AdminServlet?method=Look'"></td>
            </tr>
        </table>
    </form>
</body>
</html>

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.number}</td>
17                 </tr>
18                 <tr>
19                     <td>密码：</td>
20                     <td>${user.password}</td>
21                 </tr>
22                 <tr>
23                     <td>姓名：</td>
24                     <td>${user.name}</td>
25                 </tr>
26                 <tr>
27                     <td>职位：</td>
28                     <td>${user.job}</td>
29                 </tr>
30                 <tr>
31                     <td>性别：</td>
32                     <td>${user.sex}</td>
33                 </tr>
34                 <tr>
35                     <td>电话：</td>
36                     <td>${user.phone}</td>
37                 </tr>
38                 <tr>
39                     <td>时间：</td>
40                     <td>${user.time}</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>

posted on 2021-08-22 19:03  一缕半夏微光  阅读(37)  评论(0)  编辑  收藏  举报