質問編集履歴
2
更新しました。
test
CHANGED
File without changes
|
test
CHANGED
@@ -62,11 +62,9 @@
|
|
62
62
|
|
63
63
|
import javax.servlet.http.HttpServletResponse;
|
64
64
|
|
65
|
-
|
65
|
+
|
66
|
-
|
67
|
-
|
68
|
-
|
66
|
+
|
69
|
-
import be
|
67
|
+
import bean.Member;
|
70
68
|
|
71
69
|
import dao.KHDataAccess;
|
72
70
|
|
@@ -86,9 +84,7 @@
|
|
86
84
|
|
87
85
|
private static final long serialVersionUID = 1L;
|
88
86
|
|
89
|
-
|
90
|
-
|
91
|
-
protected void doPost(HttpServletRequest request, HttpServletResponse response)
|
87
|
+
protected void doPost(HttpServletRequest request, HttpServletResponse response)
|
92
88
|
|
93
89
|
throws ServletException, IOException {
|
94
90
|
|
@@ -102,11 +98,9 @@
|
|
102
98
|
|
103
99
|
KHDataAccess KH = new KHDataAccess();
|
104
100
|
|
105
|
-
List<Member>
|
101
|
+
List<Member> MMlist = KH.findALL();
|
106
|
-
|
107
|
-
|
102
|
+
|
108
|
-
|
109
|
-
|
103
|
+
request.setAttribute("members",MMlist);
|
110
104
|
|
111
105
|
RequestDispatcher dispatcher = request.getRequestDispatcher("/member002.jsp");
|
112
106
|
|
@@ -122,18 +116,12 @@
|
|
122
116
|
|
123
117
|
List<Member> memberlist = SH.findALL();
|
124
118
|
|
125
|
-
HttpSession session = request.getSession();
|
126
|
-
|
127
|
-
|
119
|
+
request.setAttribute("members",memberlist);
|
128
|
-
|
129
|
-
|
130
|
-
|
120
|
+
|
131
|
-
|
121
|
+
RequestDispatcher dispatcher = request.getRequestDispatcher("/member002.jsp");
|
132
122
|
|
133
123
|
dispatcher.forward(request, response);
|
134
124
|
|
135
|
-
|
136
|
-
|
137
125
|
}
|
138
126
|
|
139
127
|
}
|
@@ -142,6 +130,8 @@
|
|
142
130
|
|
143
131
|
|
144
132
|
|
133
|
+
|
134
|
+
|
145
135
|
-----------------------------------------------------------------------------------------------
|
146
136
|
|
147
137
|
|
@@ -154,6 +144,8 @@
|
|
154
144
|
|
155
145
|
package dao;
|
156
146
|
|
147
|
+
package dao;
|
148
|
+
|
157
149
|
|
158
150
|
|
159
151
|
import java.sql.Connection;
|
@@ -172,21 +164,23 @@
|
|
172
164
|
|
173
165
|
|
174
166
|
|
175
|
-
import be
|
167
|
+
import bean.Member;
|
176
168
|
|
177
169
|
|
178
170
|
|
179
171
|
public class KHDataAccess {
|
180
172
|
|
181
|
-
|
173
|
+
|
182
|
-
|
183
|
-
|
184
|
-
|
174
|
+
|
185
|
-
String user = "****";
|
175
|
+
String user = "*****";
|
186
|
-
|
176
|
+
|
187
|
-
String passwd = "*****
|
177
|
+
String passwd = "*****";
|
188
|
-
|
178
|
+
|
189
|
-
String url = "
|
179
|
+
String url = "jdbc:mysql://localhost:3306/test";
|
180
|
+
|
181
|
+
|
182
|
+
|
183
|
+
public List<Member>findALL() {
|
190
184
|
|
191
185
|
Connection con = null;
|
192
186
|
|
@@ -194,6 +188,8 @@
|
|
194
188
|
|
195
189
|
ResultSet rs = null;
|
196
190
|
|
191
|
+
List<Member> memberList = new ArrayList<Member>();
|
192
|
+
|
197
193
|
|
198
194
|
|
199
195
|
try{//ドライバの読み込み
|
@@ -208,8 +204,6 @@
|
|
208
204
|
|
209
205
|
stmt = con.createStatement();
|
210
206
|
|
211
|
-
List<Member> memberList = new ArrayList<Member>();
|
212
|
-
|
213
207
|
|
214
208
|
|
215
209
|
//SELECT文の実行--昇順で取得
|
@@ -232,6 +226,8 @@
|
|
232
226
|
|
233
227
|
memberList.add(member);
|
234
228
|
|
229
|
+
|
230
|
+
|
235
231
|
}
|
236
232
|
|
237
233
|
|
@@ -262,92 +258,90 @@
|
|
262
258
|
|
263
259
|
}
|
264
260
|
|
261
|
+
return memberList;
|
262
|
+
|
263
|
+
|
264
|
+
|
265
265
|
}
|
266
266
|
|
267
|
-
|
267
|
+
}
|
268
|
+
|
269
|
+
|
270
|
+
|
268
|
-
|
271
|
+
--------------------------------------------------------------------------------------------------
|
272
|
+
|
273
|
+
|
274
|
+
|
275
|
+
|
276
|
+
|
277
|
+
been
|
278
|
+
|
279
|
+
------------------------------------------------------------------------------------------------
|
280
|
+
|
281
|
+
package been;
|
282
|
+
|
283
|
+
|
284
|
+
|
285
|
+
public class Member {
|
286
|
+
|
287
|
+
private String ID;
|
288
|
+
|
289
|
+
private String Name;
|
290
|
+
|
291
|
+
private String Department;
|
292
|
+
|
293
|
+
|
294
|
+
|
295
|
+
public String getId() {
|
296
|
+
|
297
|
+
return ID;
|
298
|
+
|
299
|
+
}
|
300
|
+
|
269
|
-
public
|
301
|
+
public void setId(String ID) {
|
302
|
+
|
270
|
-
|
303
|
+
this.ID = ID;
|
304
|
+
|
305
|
+
}
|
306
|
+
|
307
|
+
public String getName() {
|
308
|
+
|
271
|
-
return
|
309
|
+
return Name;
|
310
|
+
|
311
|
+
}
|
312
|
+
|
313
|
+
public void setName(String Name) {
|
314
|
+
|
315
|
+
this.Name = Name;
|
316
|
+
|
317
|
+
}
|
318
|
+
|
319
|
+
public String getDs() {
|
320
|
+
|
321
|
+
return Department;
|
322
|
+
|
323
|
+
}
|
324
|
+
|
325
|
+
public void setDs(String Department) {
|
326
|
+
|
327
|
+
this.Department = Department;
|
328
|
+
|
329
|
+
}
|
330
|
+
|
331
|
+
|
332
|
+
|
333
|
+
public Member(String ID, String Name, String Department) {
|
334
|
+
|
335
|
+
this.ID = ID;
|
336
|
+
|
337
|
+
this.Name = Name;
|
338
|
+
|
339
|
+
this.Department = Department;
|
340
|
+
|
341
|
+
}
|
272
342
|
|
273
343
|
}
|
274
344
|
|
275
|
-
}
|
276
|
-
|
277
|
-
--------------------------------------------------------------------------------------------------
|
278
|
-
|
279
|
-
|
280
|
-
|
281
|
-
|
282
|
-
|
283
|
-
been
|
284
|
-
|
285
|
-
------------------------------------------------------------------------------------------------
|
286
|
-
|
287
|
-
package been;
|
288
|
-
|
289
|
-
|
290
|
-
|
291
|
-
public class Member {
|
292
|
-
|
293
|
-
private String ID;
|
294
|
-
|
295
|
-
private String Name;
|
296
|
-
|
297
|
-
private String Department;
|
298
|
-
|
299
|
-
|
300
|
-
|
301
|
-
public String getId() {
|
302
|
-
|
303
|
-
return ID;
|
304
|
-
|
305
|
-
}
|
306
|
-
|
307
|
-
public void setId(String ID) {
|
308
|
-
|
309
|
-
this.ID = ID;
|
310
|
-
|
311
|
-
}
|
312
|
-
|
313
|
-
public String getName() {
|
314
|
-
|
315
|
-
return Name;
|
316
|
-
|
317
|
-
}
|
318
|
-
|
319
|
-
public void setName(String Name) {
|
320
|
-
|
321
|
-
this.Name = Name;
|
322
|
-
|
323
|
-
}
|
324
|
-
|
325
|
-
public String getDs() {
|
326
|
-
|
327
|
-
return Department;
|
328
|
-
|
329
|
-
}
|
330
|
-
|
331
|
-
public void setDs(String Department) {
|
332
|
-
|
333
|
-
this.Department = Department;
|
334
|
-
|
335
|
-
}
|
336
|
-
|
337
|
-
|
338
|
-
|
339
|
-
public Member(String ID, String Name, String Department) {
|
340
|
-
|
341
|
-
this.ID = ID;
|
342
|
-
|
343
|
-
this.Name = Name;
|
344
|
-
|
345
|
-
this.Department = Department;
|
346
|
-
|
347
|
-
}
|
348
|
-
|
349
|
-
}
|
350
|
-
|
351
345
|
-------------------------------------------------------------------------------------------------
|
352
346
|
|
353
347
|
|
@@ -356,17 +350,15 @@
|
|
356
350
|
|
357
351
|
JSP
|
358
352
|
|
359
|
-
------------------------------------------------------------------------------------------------
|
360
|
-
|
361
|
-
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
|
353
|
+
------------------------------------------------------------------------------------------------<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
|
362
354
|
|
363
355
|
<%@ page import="java.util.List"%>
|
364
356
|
|
365
|
-
<%@ page import="be
|
357
|
+
<%@ page import="bean.Member"%>
|
366
|
-
|
358
|
+
|
367
|
-
<% List<Member>
|
359
|
+
<% List<Member>MMList=(List<Member>)request.getAttribute("members"); %>
|
368
|
-
|
360
|
+
|
369
|
-
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML
|
361
|
+
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 5 Transitional//EN" "http://www.w3.org/TR/html5/loose.dtd">
|
370
362
|
|
371
363
|
<html>
|
372
364
|
|
@@ -384,7 +376,7 @@
|
|
384
376
|
|
385
377
|
<center>
|
386
378
|
|
387
|
-
<font face="HGS明朝B" size="8" color="#00008b" class=h4>名簿</font>
|
379
|
+
<font face="HGS明朝B" size="8" color="#00008b" class=h4>従業員名簿</font>
|
388
380
|
|
389
381
|
<table>
|
390
382
|
|
@@ -400,9 +392,9 @@
|
|
400
392
|
|
401
393
|
<tr>
|
402
394
|
|
403
|
-
<% for (Member member:
|
395
|
+
<% for (Member member: MMList) {%>
|
404
|
-
|
396
|
+
|
405
|
-
|
397
|
+
<%=member.getId()%>
|
406
398
|
|
407
399
|
<%=member.getName()%>
|
408
400
|
|
@@ -419,75 +411,3 @@
|
|
419
411
|
</body>
|
420
412
|
|
421
413
|
</html>
|
422
|
-
|
423
|
-
---------------------------------------------------------------------------------------------------
|
424
|
-
|
425
|
-
|
426
|
-
|
427
|
-
|
428
|
-
|
429
|
-
エラー文
|
430
|
-
|
431
|
-
--------------------------------------------------------------------------------------------
|
432
|
-
|
433
|
-
|
434
|
-
|
435
|
-
java.lang.NullPointerException
|
436
|
-
|
437
|
-
|
438
|
-
|
439
|
-
The server encountered an internal error that prevented it from fulfilling this request.
|
440
|
-
|
441
|
-
|
442
|
-
|
443
|
-
org.apache.jasper.JasperException: java.lang.NullPointerException
|
444
|
-
|
445
|
-
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:556)
|
446
|
-
|
447
|
-
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
|
448
|
-
|
449
|
-
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
|
450
|
-
|
451
|
-
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
|
452
|
-
|
453
|
-
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
|
454
|
-
|
455
|
-
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
|
456
|
-
|
457
|
-
servlet.MemberServlet.doPost(MemberServlet.java:36)
|
458
|
-
|
459
|
-
javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
|
460
|
-
|
461
|
-
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
|
462
|
-
|
463
|
-
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
|
464
|
-
|
465
|
-
|
466
|
-
|
467
|
-
|
468
|
-
|
469
|
-
java.lang.NullPointerException
|
470
|
-
|
471
|
-
org.apache.jsp.member002_jsp._jspService(member002_jsp.java:87)
|
472
|
-
|
473
|
-
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
|
474
|
-
|
475
|
-
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
|
476
|
-
|
477
|
-
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
|
478
|
-
|
479
|
-
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
|
480
|
-
|
481
|
-
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
|
482
|
-
|
483
|
-
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
|
484
|
-
|
485
|
-
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
|
486
|
-
|
487
|
-
servlet.MemberServlet.doPost(MemberServlet.java:36)
|
488
|
-
|
489
|
-
javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
|
490
|
-
|
491
|
-
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
|
492
|
-
|
493
|
-
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
|
1
追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -22,6 +22,20 @@
|
|
22
22
|
|
23
23
|
|
24
24
|
|
25
|
+
環境は
|
26
|
+
|
27
|
+
・JSP
|
28
|
+
|
29
|
+
・Java
|
30
|
+
|
31
|
+
・Tomcat
|
32
|
+
|
33
|
+
・MYSQL
|
34
|
+
|
35
|
+
です。
|
36
|
+
|
37
|
+
|
38
|
+
|
25
39
|
サーブレット
|
26
40
|
|
27
41
|
-----------------------------------------------------------------------------
|
@@ -407,3 +421,73 @@
|
|
407
421
|
</html>
|
408
422
|
|
409
423
|
---------------------------------------------------------------------------------------------------
|
424
|
+
|
425
|
+
|
426
|
+
|
427
|
+
|
428
|
+
|
429
|
+
エラー文
|
430
|
+
|
431
|
+
--------------------------------------------------------------------------------------------
|
432
|
+
|
433
|
+
|
434
|
+
|
435
|
+
java.lang.NullPointerException
|
436
|
+
|
437
|
+
|
438
|
+
|
439
|
+
The server encountered an internal error that prevented it from fulfilling this request.
|
440
|
+
|
441
|
+
|
442
|
+
|
443
|
+
org.apache.jasper.JasperException: java.lang.NullPointerException
|
444
|
+
|
445
|
+
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:556)
|
446
|
+
|
447
|
+
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
|
448
|
+
|
449
|
+
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
|
450
|
+
|
451
|
+
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
|
452
|
+
|
453
|
+
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
|
454
|
+
|
455
|
+
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
|
456
|
+
|
457
|
+
servlet.MemberServlet.doPost(MemberServlet.java:36)
|
458
|
+
|
459
|
+
javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
|
460
|
+
|
461
|
+
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
|
462
|
+
|
463
|
+
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
|
464
|
+
|
465
|
+
|
466
|
+
|
467
|
+
|
468
|
+
|
469
|
+
java.lang.NullPointerException
|
470
|
+
|
471
|
+
org.apache.jsp.member002_jsp._jspService(member002_jsp.java:87)
|
472
|
+
|
473
|
+
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
|
474
|
+
|
475
|
+
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
|
476
|
+
|
477
|
+
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
|
478
|
+
|
479
|
+
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
|
480
|
+
|
481
|
+
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
|
482
|
+
|
483
|
+
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
|
484
|
+
|
485
|
+
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
|
486
|
+
|
487
|
+
servlet.MemberServlet.doPost(MemberServlet.java:36)
|
488
|
+
|
489
|
+
javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
|
490
|
+
|
491
|
+
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
|
492
|
+
|
493
|
+
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
|