图书管理系统

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;

    }
}

  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 }

 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 }

  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 }