基于Jsp+Servlet+MySQL的高校图书借阅管理系统

管理系统"/>

基于Jsp+Servlet+MySQL的高校图书借阅管理系统

登陆

借阅列表

图书馆信息

读者管理

新增读者

新增借阅

新增续借

图书归还

图书查询

分类查询

技术描述

开发工具： Idea/Eclipse
数据库： mysql
Jar包仓库： Jar包
前段框架：jquery/Jsp
后端框架： Jsp/Servlet

package com.action;import java.io.IOException;import javax.servlet.ServletException;
import javax.servlet.http.*;import com.dao.*;
import com.actionForm.*;public class Borrow extends HttpServlet {/******************在构造方法中实例化Borrow类中应用的持久层类的对象**************************/private BorrowDAO borrowDAO = null;private ReaderDAO readerDAO=null;private BookDAO bookDAO=null;private ReaderForm readerForm=new ReaderForm();public Borrow() {this.borrowDAO = new BorrowDAO();this.readerDAO=new ReaderDAO();this.bookDAO=new BookDAO();}/******************************************************************************************/public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {String action =request.getParameter("action");if(action==null||"".equals(action)){request.setAttribute("error","您的操作有误！");request.getRequestDispatcher("error.jsp").forward(request, response);}else if("bookBorrowSort".equals(action)){bookBorrowSort(request,response); }else if("bookborrow".equals(action)){bookborrow(request,response);  //图书借阅}else if("bookrenew".equals(action)){bookrenew(request,response);  //图书续借}else if("bookback".equals(action)){bookback(request,response);  //图书归还}else if("Bremind".equals(action)){bremind(request,response);  //借阅到期提醒}else if("borrowQuery".equals(action)){borrowQuery(request,response);  //借阅信息查询}}/*********************图书借阅排行***********************/private void bookBorrowSort(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {request.setAttribute("bookBorrowSort",borrowDAO.bookBorrowSort());request.getRequestDispatcher("bookBorrowSort.jsp").forward(request, response);}/*********************图书借阅查询***********************/private void borrowQuery(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {String str=null;String flag[]=request.getParameterValues("flag");if (flag!=null){String aa = flag[0];if ("a".equals(aa)) {if (request.getParameter("f") != null) {str = request.getParameter("f") + " like '%" +request.getParameter("key") + "%'";}}if ("b".equals(aa)) {String sdate = request.getParameter("sdate");String edate = request.getParameter("edate");if (sdate != null && edate != null) {str = "borrowTime between '" + sdate + "' and '" + edate +"'";}System.out.println("日期" + str);}//同时选择日期和条件进行查询if (flag.length == 2) {if (request.getParameter("f") != null) {str = request.getParameter("f") + " like '%" +request.getParameter("key") + "%'";}System.out.println("日期和条件");String sdate = request.getParameter("sdate");String edate = request.getParameter("edate");String str1 = null;if (sdate != null && edate != null) {str1 = "borrowTime between '" + sdate + "' and '" + edate +"'";}str = str + " and borr." + str1;System.out.println("条件和日期：" + str);}}request.setAttribute("borrowQuery",borrowDAO.borrowQuery(str));System.out.print("条件查询图书借阅信息时的str:"+str);request.getRequestDispatcher("borrowQuery.jsp").forward(request, response);}/*********************到期提醒***********************/private void bremind(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {request.setAttribute("Bremind",borrowDAO.bremind());request.getRequestDispatcher("bremind.jsp").forward(request, response);}/*********************图书借阅***********************/private void bookborrow(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {//查询读者信息readerForm.setBarcode(request.getParameter("barcode"));ReaderForm reader = (ReaderForm) readerDAO.queryM(readerForm);request.setAttribute("readerinfo", reader);//查询读者的借阅信息request.setAttribute("borrowinfo",borrowDAO.borrowinfo(request.getParameter("barcode")));//完成借阅String f = request.getParameter("f");String key = request.getParameter("inputkey");if (key != null && !key.equals("")) {String operator = request.getParameter("operator");BookForm bookForm=bookDAO.queryB(f, key);if (bookForm!=null){int ret = borrowDAO.insertBorrow(reader, bookDAO.queryB(f, key),operator);if (ret == 1) {request.setAttribute("bar", request.getParameter("barcode"));request.getRequestDispatcher("bookBorrow_ok.jsp").forward(request, response);} else {request.setAttribute("error", "添加借阅信息失败!");request.getRequestDispatcher("error.jsp").forward(request, response);}}else{request.setAttribute("error", "没有该图书!");request.getRequestDispatcher("error.jsp").forward(request, response);}}else{request.getRequestDispatcher("bookBorrow.jsp").forward(request, response);}}/*********************图书继借***********************/private void bookrenew(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {//查询读者信息readerForm.setBarcode(request.getParameter("barcode"));ReaderForm reader = (ReaderForm) readerDAO.queryM(readerForm);request.setAttribute("readerinfo", reader);//查询读者的借阅信息request.setAttribute("borrowinfo",borrowDAO.borrowinfo(request.getParameter("barcode")));if(request.getParameter("id")!=null){int id = Integer.parseInt(request.getParameter("id"));if (id > 0) { //执行继借操作int ret = borrowDAO.renew(id);if (ret == 0) {request.setAttribute("error", "图书继借失败!");request.getRequestDispatcher("error.jsp").forward(request, response);} else {request.setAttribute("bar", request.getParameter("barcode"));request.getRequestDispatcher("bookRenew_ok.jsp").forward(request, response);}}}else{request.getRequestDispatcher("bookRenew.jsp").forward(request, response);}}/*********************图书归还***********************/private void bookback(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {//查询读者信息readerForm.setBarcode(request.getParameter("barcode"));ReaderForm reader = (ReaderForm) readerDAO.queryM(readerForm);request.setAttribute("readerinfo", reader);//查询读者的借阅信息request.setAttribute("borrowinfo",borrowDAO.borrowinfo(request.getParameter("barcode")));if(request.getParameter("id")!=null){int id = Integer.parseInt(request.getParameter("id"));String operator=request.getParameter("operator");if (id > 0) { //执行归还操作int ret = borrowDAO.back(id,operator);if (ret == 0) {request.setAttribute("error", "图书归还失败!");request.getRequestDispatcher("error.jsp").forward(request, response);} else {request.setAttribute("bar", request.getParameter("barcode"));request.getRequestDispatcher("bookBack_ok.jsp").forward(request, response);}}}else{request.getRequestDispatcher("bookBack.jsp").forward(request, response);}}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {doGet(request, response);
}
}