Skip to content
Navigation Menu
{{ message }}
forked from maxliaops/Java_Web_Examples
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathBorrow.java
More file actions
191 lines (183 loc) · 8.85 KB
/
Copy pathBorrow.java
File metadata and controls
191 lines (183 loc) · 8.85 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
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);
}
}
You can’t perform that action at this time.