/** *******************图书借阅********************** */
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 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);
}
}
/** *******************图书借阅查询********************** */
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 bookBorrowSort(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setAttribute("bookBorrowSort", borrowDAO.bookBorrowSort());
request.getRequestDispatcher("bookBorrowSort.jsp").forward(request, response);
}