質問編集履歴
3
Logicの変更
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -340,9 +340,9 @@
|
|
|
340
340
|
|
|
341
341
|
|
|
342
342
|
|
|
343
|
-
ServletRequest request = null;
|
|
343
|
+
// ServletRequest request = null;
|
|
344
|
-
|
|
344
|
+
|
|
345
|
-
request.setAttribute("SqlResult", rset);
|
|
345
|
+
// request.setAttribute("SqlResult", rset);
|
|
346
346
|
|
|
347
347
|
// 使用したオブジェクトを終了させる
|
|
348
348
|
|
|
@@ -352,6 +352,10 @@
|
|
|
352
352
|
|
|
353
353
|
return rset;
|
|
354
354
|
|
|
355
|
+
|
|
356
|
+
|
|
357
|
+
|
|
358
|
+
|
|
355
359
|
|
|
356
360
|
|
|
357
361
|
// conn.close(); Webサーバー側のコネクションを使っているためコネクションはクローズしない
|
2
LogicとControllerの一部
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -112,17 +112,19 @@
|
|
|
112
112
|
|
|
113
113
|
BudgetTrackerSearchLogic btSearchLogic = BudgetTrackerSearchLogicFactory.createBudgetTrackerLogic(request, ds, mode);
|
|
114
114
|
|
|
115
|
+
|
|
116
|
+
|
|
115
|
-
|
|
117
|
+
ResultSet rset = null;
|
|
116
118
|
|
|
117
119
|
try {
|
|
118
120
|
|
|
119
|
-
btSearchLogic.searchData();
|
|
121
|
+
rset = btSearchLogic.searchData();
|
|
120
122
|
|
|
121
123
|
} catch (Exception e) {
|
|
122
124
|
|
|
123
|
-
|
|
125
|
+
e.printStackTrace();
|
|
124
|
-
|
|
126
|
+
|
|
125
|
-
|
|
127
|
+
status = "Failed!";
|
|
126
128
|
|
|
127
129
|
}
|
|
128
130
|
|
|
@@ -134,7 +136,7 @@
|
|
|
134
136
|
|
|
135
137
|
request.setAttribute("status", status);
|
|
136
138
|
|
|
137
|
-
|
|
139
|
+
request.setAttribute("SqlResult", rset);
|
|
138
140
|
|
|
139
141
|
request.getRequestDispatcher("/searchResult.jsp").forward(request, response);
|
|
140
142
|
|
|
@@ -242,7 +244,7 @@
|
|
|
242
244
|
|
|
243
245
|
// データの追加を実施
|
|
244
246
|
|
|
245
|
-
public
|
|
247
|
+
public ResultSet searchData() throws Exception {
|
|
246
248
|
|
|
247
249
|
|
|
248
250
|
|
|
@@ -342,19 +344,23 @@
|
|
|
342
344
|
|
|
343
345
|
request.setAttribute("SqlResult", rset);
|
|
344
346
|
|
|
345
|
-
|
|
346
|
-
|
|
347
347
|
// 使用したオブジェクトを終了させる
|
|
348
348
|
|
|
349
349
|
pstmt.close();
|
|
350
350
|
|
|
351
|
+
|
|
352
|
+
|
|
353
|
+
return rset;
|
|
354
|
+
|
|
355
|
+
|
|
356
|
+
|
|
351
357
|
// conn.close(); Webサーバー側のコネクションを使っているためコネクションはクローズしない
|
|
352
358
|
|
|
353
359
|
|
|
354
360
|
|
|
355
361
|
|
|
356
362
|
|
|
357
|
-
return res;
|
|
363
|
+
//return res;
|
|
358
364
|
|
|
359
365
|
}
|
|
360
366
|
|
1
request.setAttribute("SqlResult", rset);のコメントアウトを外しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -180,6 +180,8 @@
|
|
|
180
180
|
|
|
181
181
|
import javax.naming.InitialContext;
|
|
182
182
|
|
|
183
|
+
import javax.servlet.ServletRequest;
|
|
184
|
+
|
|
183
185
|
import javax.servlet.http.HttpServletRequest;
|
|
184
186
|
|
|
185
187
|
import javax.sql.DataSource;
|
|
@@ -336,7 +338,9 @@
|
|
|
336
338
|
|
|
337
339
|
|
|
338
340
|
|
|
341
|
+
ServletRequest request = null;
|
|
342
|
+
|
|
339
|
-
|
|
343
|
+
request.setAttribute("SqlResult", rset);
|
|
340
344
|
|
|
341
345
|
|
|
342
346
|
|