图书管理系统
1、项目需求:
图书馆管理系统,能进图书管理系统软件图书管理系统软件行图书馆管理系统能实测国民经济和企业的各种运行情况;利用过去的数据预测未来;从企业全局出发辅助企业进行管理决策;利用信息控制企业的行为;帮助企业实现其规划目标。
2.系统要求与功能设计
2.1 页面要求
(1)能够在Tomcat服务器中正确部署,并通过浏览器查看;
(2)网站页面整体风格统一;
(3)首页(登录页)要求实现不同用户登录后,进入的功能页不相同。
(4)读者功能页:有浏览图书信息、查询图书信息、借阅图书,浏览催还书目、归还图书五个功能模块。
(5)管理员功能页:有添加读者信息、添加新书信息、打印催还书目信息三个模块。
2.2功能要求:
(1)浏览图书信息:读者登录后以列表形式可以查看所有图书基本信息,包括唯一编号、书名、作者名、出版社名称信息、可借阅数量;
(2)查询图书信息:可以按照书名或作者名进行模糊检索,以列表形式查看符合条件的图书信息。
(3)借阅图书功能:读者选择查询图书相应信息,跳转到书目的详细信息界面,当可借阅数量大于零,点击借阅按钮,提示用户借阅成功,并显示归还日期(三个月),否则提示用户该书可借阅数量为0,无法借阅。
(4)浏览催还书目:读者查看个人超期的图书列表信息。
(5)归还图书功能:读者可以查看个人借阅的所有书目列表信息,选择其中一项,则跳转到书目的详细信息界面,点击归还按钮,提示用户还书成功,如果该书超期,以一天0.1元计算罚金,提示用户需要缴纳罚金。
(6)添加读者基本信息:管理员可以添加读者基本信息,读者基本信息包括学号(八位数字组成,例如20180052)、读者姓名、读者性别、所在学院组成;
(7)添加新书基本信息:管理员可以添加新书基本信息,新书基本信息包括唯一编号、书名、作者名、出版社名称,可借阅数量;
(8)打印催还书目功能:显示所有用户的超期图书信息;
(9)登陆功能:管理员、读者登陆后可以看到不同的功能页面,读者登陆后只能看到自己的相关信息,不同读者登陆后无法查看其他人的信息。(要求至少创建五个读者用户演示选课过程)
3数据库设计:
要求实现图书基本信息表、借阅基本信息表、催还基本信息表、读者基本信息表。
4、WEB发布:
要求可以实现在浏览器直接访问系统。
Bean
package Bean; public class Beanid { private String id; private String password; private String jiese; public String getJiese() { return jiese; } public void setJiese(String jiese) { this.jiese = jiese; } public String getId() { return id; } public void setId(String id) { this.id = id; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public Beanid() { } public Beanid(String password) { this.password = password; } ; public Beanid(String jiese, String id, String password) { this.jiese = jiese; this.id = id; this.password = password; } }
dao
1 package Dao; 2 3 import DBUitl.DBUtil; 4 5 import java.sql.Connection; 6 import java.sql.ResultSet; 7 import java.sql.SQLException; 8 import java.sql.Statement; 9 10 public class Dao { 11 // 12 13 14 public static boolean id(String id, String pwd) { 15 boolean f = false; 16 String sql = "select * from denglu where idc = ‘" + id + "‘ and password = ‘" + pwd + "‘"; 17 // 18 Connection conn = DBUtil.getConn(); 19 Statement state = null; 20 ResultSet rs = null; 21 try { 22 state = conn.createStatement(); 23 rs = state.executeQuery(sql); 24 if (rs.next()) { 25 f = true; 26 } 27 } catch (SQLException e) { 28 e.printStackTrace(); 29 } finally { 30 DBUtil.close(rs, state, conn); 31 } 32 return f; 33 } 34 } 35 36 37 38 39 40 package Dao; 41 42 import Bean.Book; 43 import Bean.Student; 44 import DBUitl.DBUtil; 45 46 import java.sql.Connection; 47 import java.sql.ResultSet; 48 import java.sql.SQLException; 49 import java.sql.Statement; 50 import java.text.ParseException; 51 import java.text.SimpleDateFormat; 52 import java.util.ArrayList; 53 import java.util.Calendar; 54 import java.util.Date; 55 import java.util.List; 56 57 public class TSDao { 58 59 public static String change(String date) { 60 Date parse = null; 61 String dateString = ""; 62 try { 63 parse = new SimpleDateFormat("yyyyMMdd").parse(date); 64 dateString = new SimpleDateFormat("yyyy-MM-dd").format(parse); 65 } catch (ParseException e) { 66 dateString = null; 67 } 68 69 return dateString; 70 } 71 72 public static int peoplenumbernow(String name) { 73 String sql = "select * from chosebook where book like ‘%" + name + "%‘"; 74 int i = 0; 75 Connection conn = DBUtil.getConn(); 76 Statement state = null; 77 ResultSet rs = null; 78 79 try { 80 state = conn.createStatement(); 81 rs = state.executeQuery(sql); 82 while (rs.next()) { 83 i++; 84 } 85 } catch (SQLException e) { 86 e.printStackTrace(); 87 } finally { 88 DBUtil.close(rs, state, conn); 89 } 90 91 return i; 92 } 93 94 95 public static boolean addbook(Book book) { 96 boolean f = false; 97 String sql = "insert into book(name,idc,author,chubanshe,peoplenumber) values(‘" + book.getName() + "‘,‘" + book.getIdc() + "‘,‘" + book.getAuthor() + "‘,‘" + book.getChubanshe() + "‘,‘" + book.getPeoplenumber() + "‘)"; 98 // 99 Connection conn = DBUtil.getConn(); 100 Statement state = null; 101 int a = 0; 102 try { 103 state = conn.createStatement(); 104 a = state.executeUpdate(sql); 105 } catch (SQLException e) { 106 e.printStackTrace(); 107 } finally { 108 DBUtil.close(state, conn); 109 } 110 111 if (a > 0) { 112 f = true; 113 } 114 return f; 115 } 116 117 public static boolean addstudent(Student student) { 118 boolean f = false; 119 String sql = "insert into denglu(name,idc,password,sex,major) values(‘" + student.getName() + "‘,‘" + student.getIdc() + "‘,‘" + student.getPassword() + "‘,‘" + student.getSex() + "‘,‘" + student.getMajor() + "‘)"; 120 // 121 Connection conn = DBUtil.getConn(); 122 Statement state = null; 123 int a = 0; 124 try { 125 state = conn.createStatement(); 126 a = state.executeUpdate(sql); 127 } catch (SQLException e) { 128 e.printStackTrace(); 129 } finally { 130 DBUtil.close(state, conn); 131 } 132 133 if (a > 0) { 134 f = true; 135 } 136 return f; 137 } 138 139 140 public static List<Book> search(String name, String author) { 141 String sql = "select * from book where "; 142 143 if (name != "") { 144 sql += "name like ‘%" + name + "%‘"; 145 } else if (author != "") { 146 sql += "author like ‘%" + author + "%‘"; 147 } else { 148 } 149 150 List<Book> list = new ArrayList<>(); 151 Connection conn = DBUtil.getConn(); 152 Statement state = null; 153 ResultSet rs = null; 154 155 try { 156 state = conn.createStatement(); 157 rs = state.executeQuery(sql); 158 Book bean = null; 159 while (rs.next()) { 160 String name2 = rs.getString("name"); 161 String idc = rs.getString("idc"); 162 String author2 = rs.getString("author"); 163 String chubanshe = rs.getString("chubanshe"); 164 String peoplenumber = rs.getString("peoplenumber"); 165 bean = new Book(name2, author2, idc, peoplenumber, chubanshe); 166 list.add(bean); 167 } 168 } catch (SQLException e) { 169 e.printStackTrace(); 170 } finally { 171 DBUtil.close(rs, state, conn); 172 } 173 174 return list; 175 } 176 177 178 public static String getbyid(String name) { 179 String sql = "select * from book where name =‘" + name + "‘"; 180 Connection conn = DBUtil.getConn(); 181 Statement state = null; 182 ResultSet rs = null; 183 String number = new String(); 184 try { 185 state = conn.createStatement(); 186 rs = state.executeQuery(sql); 187 while (rs.next()) { 188 number = rs.getString("peoplenumber"); 189 } 190 } catch (Exception e) { 191 e.printStackTrace(); 192 } finally { 193 DBUtil.close(rs, state, conn); 194 } 195 196 return number; 197 } 198 199 200 public static List<Book> getbyid2(String name) { 201 String sql = "select * from book where name =‘" + name + "‘"; 202 Connection conn = DBUtil.getConn(); 203 Statement state = null; 204 ResultSet rs = null; 205 Book bean = null; 206 List<Book> list = new ArrayList<>(); 207 try { 208 state = conn.createStatement(); 209 rs = state.executeQuery(sql); 210 while (rs.next()) { 211 String name2 = rs.getString("name"); 212 String idc = rs.getString("idc"); 213 String author2 = rs.getString("author"); 214 String chubanshe = rs.getString("chubanshe"); 215 String peoplenumber = rs.getString("peoplenumber"); 216 bean = new Book(name2, author2, idc, peoplenumber, chubanshe); 217 list.add(bean); 218 } 219 } catch (Exception e) { 220 e.printStackTrace(); 221 } finally { 222 DBUtil.close(rs, state, conn); 223 } 224 225 return list; 226 } 227 228 public static Book getbyid3(String name) { 229 String sql = "select * from book where name =‘" + name + "‘"; 230 Connection conn = DBUtil.getConn(); 231 Statement state = null; 232 ResultSet rs = null; 233 Book bean = null; 234 try { 235 state = conn.createStatement(); 236 rs = state.executeQuery(sql); 237 while (rs.next()) { 238 String name2 = rs.getString("name"); 239 String idc = rs.getString("idc"); 240 String author2 = rs.getString("author"); 241 String chubanshe = rs.getString("chubanshe"); 242 String peoplenumber = rs.getString("peoplenumber"); 243 bean = new Book(name2, author2, idc, peoplenumber, chubanshe); 244 } 245 } catch (Exception e) { 246 e.printStackTrace(); 247 } finally { 248 DBUtil.close(rs, state, conn); 249 } 250 251 return bean; 252 } 253 254 255 public static Student getbyid4(String id) { 256 String sql = "select * from chosestudent where id =‘" + id + "‘"; 257 Connection conn = DBUtil.getConn(); 258 Statement state = null; 259 ResultSet rs = null; 260 Student bean = null; 261 try { 262 state = conn.createStatement(); 263 rs = state.executeQuery(sql); 264 while (rs.next()) { 265 String name2 = rs.getString("name"); 266 String idc = rs.getString("idc"); 267 String sex = rs.getString("sex"); 268 String major = rs.getString("major"); 269 String book = rs.getString("book"); 270 String date = rs.getString("date"); 271 bean = new Student(name2, idc, book, major, sex, date); 272 } 273 } catch (Exception e) { 274 e.printStackTrace(); 275 } finally { 276 DBUtil.close(rs, state, conn); 277 } 278 279 return bean; 280 } 281 282 283 public static Student getbyid5(String id) { 284 String sql = "select * from chosestudent where id =‘" + id + "‘"; 285 Connection conn = DBUtil.getConn(); 286 Statement state = null; 287 ResultSet rs = null; 288 Student bean = new Student(); 289 try { 290 state = conn.createStatement(); 291 rs = state.executeQuery(sql); 292 while (rs.next()) { 293 String book = rs.getString("book"); 294 String date = rs.getString("date"); 295 bean.setBook(book); 296 bean.setDate(date); 297 bean.setName(id); 298 } 299 } catch (Exception e) { 300 e.printStackTrace(); 301 } finally { 302 DBUtil.close(rs, state, conn); 303 } 304 305 return bean; 306 } 307 308 309 public static List<Book> booklist() { 310 String sql = "select * from book"; 311 List<Book> list = new ArrayList<>(); 312 Connection conn = DBUtil.getConn(); 313 Statement state = null; 314 ResultSet rs = null; 315 316 317 try { 318 state = conn.createStatement(); 319 rs = state.executeQuery(sql); 320 Book bean = null; 321 while (rs.next()) { 322 String name = rs.getString("name"); 323 String author = rs.getString("author"); 324 String idc = rs.getString("idc"); 325 String peoplenumber = rs.getString("peoplenumber"); 326 String chubanshe = rs.getString("chubanshe"); 327 bean = new Book(name, author, idc, peoplenumber, chubanshe); 328 list.add(bean); 329 } 330 } catch (SQLException e) { 331 e.printStackTrace(); 332 } finally { 333 DBUtil.close(rs, state, conn); 334 } 335 336 return list; 337 } 338 339 340 public static List<Book> booklist2(String idc) throws Exception { 341 String sql = "select * from chosestudent where idc like ‘%" + idc + "%‘"; 342 List<Book> list = new ArrayList<>(); 343 Connection conn = DBUtil.getConn(); 344 Statement state = null; 345 ResultSet rs = null; 346 347 try { 348 state = conn.createStatement(); 349 rs = state.executeQuery(sql); 350 while (rs.next()) { 351 String date = rs.getString("date"); 352 String book = rs.getString("book"); 353 int renewalsdata = 3; 354 SimpleDateFormat df = new SimpleDateFormat("yyyyMMdd"); 355 Date sd = df.parse(date); 356 Calendar calendar = Calendar.getInstance(); 357 calendar.setTime(sd); 358 int month = calendar.get(Calendar.MONTH) + 1; 359 if (month > 9) { 360 calendar.add(Calendar.YEAR, 1); 361 } 362 calendar.add(Calendar.MONTH, renewalsdata); 363 String NOW = df.format(new Date()); 364 Integer i = NOW.compareTo(df.format(calendar.getTime())); 365 if (i > 0) { 366 list.add(getbyid3(book)); 367 } 368 } 369 } catch (SQLException e) { 370 e.printStackTrace(); 371 } finally { 372 DBUtil.close(rs, state, conn); 373 } 374 375 return list; 376 } 377 378 379 public static List<Student> booklist4(String idc) throws Exception { 380 String sql = "select * from chosestudent where idc like ‘%" + idc + "%‘"; 381 List<Student> list = new ArrayList<>(); 382 Connection conn = DBUtil.getConn(); 383 Statement state = null; 384 ResultSet rs = null; 385 386 try { 387 state = conn.createStatement(); 388 rs = state.executeQuery(sql); 389 while (rs.next()) { 390 String id = rs.getString("id"); 391 list.add(getbyid5(id)); 392 } 393 } catch (SQLException e) { 394 e.printStackTrace(); 395 } finally { 396 DBUtil.close(rs, state, conn); 397 } 398 399 return list; 400 } 401 402 403 public static List<Student> booklist3() throws Exception { 404 String sql = "select * from chosestudent"; 405 List<Student> list = new ArrayList<>(); 406 Connection conn = DBUtil.getConn(); 407 Statement state = null; 408 ResultSet rs = null; 409 410 try { 411 state = conn.createStatement(); 412 rs = state.executeQuery(sql); 413 while (rs.next()) { 414 String date = rs.getString("date"); 415 String id = rs.getString("id"); 416 int renewalsdata = 3; 417 SimpleDateFormat df = new SimpleDateFormat("yyyyMMdd"); 418 Date sd = df.parse(date); 419 Calendar calendar = Calendar.getInstance(); 420 calendar.setTime(sd); 421 int month = calendar.get(Calendar.MONTH) + 1; 422 if (month > 9) { 423 calendar.add(Calendar.YEAR, 1); 424 } 425 calendar.add(Calendar.MONTH, renewalsdata); 426 String NOW = df.format(new Date()); 427 Integer i = NOW.compareTo(df.format(calendar.getTime())); 428 if (i > 0) { 429 list.add(getbyid4(id)); 430 } 431 } 432 } catch (SQLException e) { 433 e.printStackTrace(); 434 } finally { 435 DBUtil.close(rs, state, conn); 436 } 437 438 return list; 439 } 440 441 442 public static boolean chosebook(String book, String studentidc) { 443 boolean f = false; 444 String sql = "select * from denglu where idc like ‘%" + studentidc + "%‘"; 445 Connection conn = DBUtil.getConn(); 446 Statement state = null; 447 ResultSet rs = null; 448 Student student = null; 449 try { 450 state = conn.createStatement(); 451 rs = state.executeQuery(sql); 452 while (rs.next()) { 453 String name = rs.getString("name"); 454 String sex = rs.getString("sex"); 455 String major = rs.getString("major"); 456 student = new Student(name, studentidc, sex, major); 457 } 458 } catch (SQLException e) { 459 e.printStackTrace(); 460 } finally { 461 DBUtil.close(rs, state, conn); 462 } 463 java.sql.Date time = new java.sql.Date(new Date().getTime()); 464 String sql1 = "insert into chosestudent(name,idc,major,sex,book,date) values(‘" + student.getName() + "‘,‘" + studentidc + "‘,‘" + student.getMajor() + "‘,‘" + student.getSex() + "‘,‘" + book + "‘,‘" + time + "‘)"; 465 // 466 Connection conn1 = DBUtil.getConn(); 467 Statement state1 = null; 468 int a = 0; 469 try { 470 state1 = conn1.createStatement(); 471 a = state1.executeUpdate(sql1); 472 } catch (SQLException e) { 473 e.printStackTrace(); 474 } finally { 475 DBUtil.close(state1, conn1); 476 } 477 478 if (a > 0) { 479 f = true; 480 } 481 return f; 482 } 483 484 485 public static boolean delete(String id) { 486 boolean f = false; 487 String sql = "delete from chosestudent where id=‘" + id + "‘"; 488 // 489 Connection conn = DBUtil.getConn(); 490 Statement state = null; 491 int a = 0; 492 try { 493 state = conn.createStatement(); 494 a = state.executeUpdate(sql); 495 } catch (SQLException e) { 496 e.printStackTrace(); 497 } finally { 498 DBUtil.close(state, conn); 499 } 500 501 if (a > 0) { 502 f = true; 503 } 504 return f; 505 } 506 507 508 public static List<Student> chosecoursestudentlist(String course) { 509 String sql = "select * from chosestudent where course like ‘%" + course + "%‘"; 510 List<Student> list = new ArrayList<>(); 511 Connection conn = DBUtil.getConn(); 512 Statement state = null; 513 ResultSet rs = null; 514 515 516 try { 517 state = conn.createStatement(); 518 rs = state.executeQuery(sql); 519 Student bean = null; 520 while (rs.next()) { 521 String name1 = rs.getString("name"); 522 String idc = rs.getString("idc"); 523 String class1 = rs.getString("class"); 524 String major = rs.getString("major"); 525 bean = new Student(name1, idc, class1, major); 526 list.add(bean); 527 } 528 } catch (SQLException e) { 529 e.printStackTrace(); 530 } finally { 531 DBUtil.close(rs, state, conn); 532 } 533 534 return list; 535 } 536 537 }
DButil
1 package DBUitl; 2 3 import java.sql.*; 4 5 public class DBUtil { 6 7 public static String db_url = "jdbc:mysql://localhost:3306/library1?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone = GMT&allowPublicKeyRetrieval=true"; 8 public static String db_user = "root"; 9 public static String db_pass = "15732767817lxy11"; 10 11 public static Connection getConn() { 12 Connection conn = null; 13 14 try { 15 Class.forName("com.mysql.cj.jdbc.Driver");//加载驱动 16 conn = DriverManager.getConnection(db_url, db_user, db_pass); 17 } catch (Exception e) { 18 e.printStackTrace(); 19 } 20 21 return conn; 22 } 23 24 /*10鍏抽棴杩炴帴*/ 25 public static void close(Statement state, Connection conn) { 26 if (state != null) { 27 try { 28 state.close(); 29 } catch (SQLException e) { 30 e.printStackTrace(); 31 } 32 } 33 34 if (conn != null) { 35 try { 36 conn.close(); 37 } catch (SQLException e) { 38 e.printStackTrace(); 39 } 40 } 41 } 42 43 public static void close(ResultSet rs, Statement state, Connection conn) { 44 if (rs != null) { 45 try { 46 rs.close(); 47 } catch (SQLException e) { 48 e.printStackTrace(); 49 } 50 } 51 52 if (state != null) { 53 try { 54 state.close(); 55 } catch (SQLException e) { 56 e.printStackTrace(); 57 } 58 } 59 60 if (conn != null) { 61 try { 62 conn.close(); 63 } catch (SQLException e) { 64 e.printStackTrace(); 65 } 66 } 67 } 68 69 public static void main(String[] args) throws SQLException { 70 } 71 }
Servlet
1 package Servlet; 2 3 import Bean.Beanid; 4 import Dao.Dao; 5 6 import javax.servlet.ServletException; 7 import javax.servlet.annotation.WebServlet; 8 import javax.servlet.http.Cookie; 9 import javax.servlet.http.HttpServlet; 10 import javax.servlet.http.HttpServletRequest; 11 import javax.servlet.http.HttpServletResponse; 12 import java.io.IOException; 13 14 @WebServlet("/Servlet") 15 public class Servlet extends HttpServlet { 16 private static final long serialVersionUID = 1L; 17 18 /** 19 * @see HttpServlet#HttpServlet() 20 */ 21 22 23 protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 24 request.setCharacterEncoding("utf-8"); 25 denglu(request, response); 26 } 27 28 private void denglu(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { 29 request.setCharacterEncoding("utf-8"); 30 String jiese = request.getParameter("jiese"); 31 String idc = request.getParameter("id"); 32 String password = request.getParameter("password"); 33 Beanid Beanid = new Beanid(jiese, idc, password); 34 if (Dao.id(idc, password)) { 35 if ((Beanid.getJiese()).equals("1")) { 36 request.setAttribute("message", "登录成功"); 37 Cookie cookie = new Cookie("id", idc); 38 response.addCookie(cookie); 39 response.sendRedirect("menu1.jsp"); 40 } else if ((Beanid.getJiese()).equals("2")) { 41 request.setAttribute("message", "登录成功"); 42 Cookie cookie = new Cookie("id", idc); 43 response.addCookie(cookie); 44 response.sendRedirect("menu2.jsp"); 45 } else { 46 request.setAttribute("message", "登录失败"); 47 request.getRequestDispatcher("begin.jsp").forward(request, response); 48 } 49 } else { 50 request.setAttribute("message", "登录失败"); 51 request.getRequestDispatcher("begin.jsp").forward(request, response); 52 } 53 54 } 55 56 57 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 58 59 doGet(request, response); 60 } 61 62 63 /** 64 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) 65 */ 66 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 67 // TODO Auto-generated method stub 68 response.getWriter().append("Served at: ").append(request.getContextPath()); 69 } 70 71 /** 72 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) 73 */ 74 75 76 } 77 78 79 80 81 82 package Servlet; 83 84 import Bean.Book; 85 import Bean.Student; 86 import Dao.TSDao; 87 88 import javax.servlet.ServletException; 89 import javax.servlet.annotation.WebServlet; 90 import javax.servlet.http.HttpServlet; 91 import javax.servlet.http.HttpServletRequest; 92 import javax.servlet.http.HttpServletResponse; 93 import java.io.IOException; 94 import java.util.List; 95 96 @WebServlet("/TSservlet") 97 public class TSservlet extends HttpServlet { 98 private static final long serialVersionUID = 1L; 99 100 /** 101 * @see HttpServlet#HttpServlet() 102 */ 103 104 105 protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 106 request.setCharacterEncoding("utf-8"); 107 String method = request.getParameter("method"); 108 if ("addbook".equals(method)) { 109 addbook(request, response); 110 } else if ("addstudent".equals(method)) { 111 addstudent(request, response); 112 } else if ("search".equals(method)) { 113 search(request, response); 114 } else if ("chosebook".equals(method)) { 115 chosebook(request, response); 116 } else if ("booklist".equals(method)) { 117 booklist(request, response); 118 } else if ("booklist1".equals(method)) { 119 booklist1(request, response); 120 } else if ("booklist2".equals(method)) { 121 try { 122 booklist2(request, response); 123 } catch (Exception e) { 124 // TODO Auto-generated catch block 125 e.printStackTrace(); 126 } 127 } else if ("booklist3".equals(method)) { 128 try { 129 booklist3(request, response); 130 } catch (Exception e) { 131 // TODO Auto-generated catch block 132 e.printStackTrace(); 133 } 134 } else if ("deletebook".equals(method)) { 135 deletebook(request, response); 136 } else if ("chosebookstudentlist".equals(method)) { 137 try { 138 chosebookstudentlist(request, response); 139 } catch (Exception e) { 140 // TODO Auto-generated catch block 141 e.printStackTrace(); 142 } 143 } 144 145 } 146 147 private void addbook(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { 148 request.setCharacterEncoding("utf-8"); 149 String name = request.getParameter("name"); 150 String chubanshe = request.getParameter("chubanshe"); 151 String idc = request.getParameter("idc"); 152 String author = request.getParameter("author"); 153 String peoplenumber = request.getParameter("peoplenumber"); 154 Book book = new Book(name, author, idc, peoplenumber, chubanshe); 155 if (TSDao.addbook(book)) { 156 request.setAttribute("message", "添加图书信息成功"); 157 request.getRequestDispatcher("menu1.jsp").forward(request, response); 158 } else { 159 request.setAttribute("message", "添加图书信息失败"); 160 request.getRequestDispatcher("menu1.jsp").forward(request, response); 161 } 162 163 } 164 165 166 private void addstudent(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { 167 request.setCharacterEncoding("utf-8"); 168 String name = request.getParameter("name"); 169 String idc = request.getParameter("idc"); 170 String sex = request.getParameter("sex"); 171 String password = request.getParameter("password"); 172 String major = request.getParameter("major"); 173 Student student = new Student(name, idc, password, major, sex); 174 if (TSDao.addstudent(student)) { 175 request.setAttribute("message", "添加学生信息成功"); 176 request.getRequestDispatcher("menu1.jsp").forward(request, response); 177 } else { 178 request.setAttribute("message", "添加学生信息失败"); 179 request.getRequestDispatcher("menu1.jsp").forward(request, response); 180 } 181 182 } 183 184 185 private void search(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException { 186 req.setCharacterEncoding("utf-8"); 187 String name = req.getParameter("name"); 188 String author = req.getParameter("author"); 189 190 List<Book> books = TSDao.search(name, author); 191 req.setAttribute("books", books); 192 req.getRequestDispatcher("list.jsp").forward(req, resp); 193 } 194 195 196 private void chosebook(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException { 197 req.setCharacterEncoding("utf-8"); 198 String name = req.getParameter("name"); 199 String studentidc = req.getParameter("studentidc"); 200 int i = TSDao.peoplenumbernow(name); 201 String number = TSDao.getbyid(name); 202 if (i < Integer.parseInt(number)) { 203 if (TSDao.chosebook(name, studentidc)) { 204 req.setAttribute("message", "选课成功!"); 205 req.getRequestDispatcher("menu2.jsp").forward(req, resp); 206 } else { 207 req.setAttribute("message", "选课失败!"); 208 req.getRequestDispatcher("menu2.jsp").forward(req, resp); 209 } 210 } else { 211 req.setAttribute("message", "选课失败!"); 212 req.getRequestDispatcher("menu2.jsp").forward(req, resp); 213 } 214 } 215 216 217 private void booklist(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException { 218 req.setCharacterEncoding("utf-8"); 219 List<Book> books = TSDao.booklist(); 220 req.setAttribute("books", books); 221 req.getRequestDispatcher("booklist.jsp").forward(req, resp); 222 } 223 224 225 private void booklist1(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException { 226 req.setCharacterEncoding("utf-8"); 227 List<Book> books = TSDao.booklist(); 228 req.setAttribute("books", books); 229 req.getRequestDispatcher("booklist1.jsp").forward(req, resp); 230 } 231 232 233 private void booklist2(HttpServletRequest req, HttpServletResponse resp) throws Exception { 234 req.setCharacterEncoding("utf-8"); 235 String idc = req.getParameter("idc"); 236 List<Book> books = TSDao.booklist2(idc); 237 req.setAttribute("books", books); 238 req.getRequestDispatcher("booklist2.jsp").forward(req, resp); 239 } 240 241 242 private void booklist3(HttpServletRequest req, HttpServletResponse resp) throws Exception { 243 req.setCharacterEncoding("utf-8"); 244 String idc = req.getParameter("idc"); 245 List<Student> Students = TSDao.booklist4(idc); 246 req.setAttribute("Students", Students); 247 req.getRequestDispatcher("booklist3.jsp").forward(req, resp); 248 } 249 250 private void deletebook(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException { 251 req.setCharacterEncoding("utf-8"); 252 String id = req.getParameter("id"); 253 if (TSDao.delete(id)) { 254 req.setAttribute("message", "还书成功!"); 255 req.getRequestDispatcher("booklist3.jsp").forward(req, resp); 256 } else { 257 req.setAttribute("message", "还书失败!"); 258 req.getRequestDispatcher("menu2.jsp").forward(req, resp); 259 } 260 } 261 262 private void chosebookstudentlist(HttpServletRequest req, HttpServletResponse resp) throws Exception { 263 req.setCharacterEncoding("utf-8"); 264 List<Student> Students = TSDao.booklist3(); 265 req.setAttribute("Students", Students); 266 req.getRequestDispatcher("chosebooksstudentlist.jsp").forward(req, resp); 267 } 268 269 270 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 271 272 doGet(request, response); 273 } 274 275 276 /** 277 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) 278 */ 279 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 280 // TODO Auto-generated method stub 281 response.getWriter().append("Served at: ").append(request.getContextPath()); 282 } 283 284 /** 285 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) 286 */ 287 288 289 }
原文:https://www.cnblogs.com/lixiaoy/p/14158210.html