teratail
回答率
85.48%
質問するログイン新規登録
トップに関する質問SQLで取得した値をJSPで表示

編集履歴

質問編集履歴

2

更新しました。

2016/04/21 16:34

投稿

junpi-ya
junpi-ya

スコア17

test CHANGED
File without changes
test CHANGED
@@ -62,11 +62,9 @@
62
62
 
63
63
  import javax.servlet.http.HttpServletResponse;
64
64
 
65
- import javax.servlet.http.HttpSession;
65
+
66
-
67
-
68
-
66
+
69
- import been.Member;
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> memberList = KH.findALL();
101
+ List<Member> MMlist = KH.findALL();
106
-
107
- HttpSession session = request.getSession();
102
+
108
-
109
- session.setAttribute("members",memberList);
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
- session.setAttribute("members",memberlist);
119
+ request.setAttribute("members",memberlist);
128
-
129
-
130
-
120
+
131
- RequestDispatcher dispatcher = request.getRequestDispatcher("/member002.jsp");
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 been.Member;
167
+ import bean.Member;
176
168
 
177
169
 
178
170
 
179
171
  public class KHDataAccess {
180
172
 
181
- public static void main(String[] args) {
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 List<Member> findALL() {
301
+ public void setId(String ID) {
302
+
270
-
303
+ this.ID = ID;
304
+
305
+ }
306
+
307
+ public String getName() {
308
+
271
- return null;
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="been.Member"%>
357
+ <%@ page import="bean.Member"%>
366
-
358
+
367
- <% List<Member> memberList = (List<Member>)session.getAttribute("members"); %>
359
+ <% List<Member>MMList=(List<Member>)request.getAttribute("members"); %>
368
-
360
+
369
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
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: memberList) {%>
395
+ <% for (Member member: MMList) {%>
404
-
396
+
405
- <%=member.getId()%>
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

追加

2016/04/21 16:34

投稿

junpi-ya
junpi-ya

スコア17

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)