首页 > 其他 > 详细

图书管理系统

时间:2020-12-19 12:20:21      阅读:35      评论:0      收藏:0      [点我收藏+]

图书管理系统

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;

    }
}
View Code

 

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 }
View Code

 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 }
View Code

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 }
View Code

 

图书管理系统

原文:https://www.cnblogs.com/lixiaoy/p/14158210.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!