質問編集履歴
3
写真追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -469,3 +469,15 @@
|
|
|
469
469
|
|
|
470
470
|
|
|
471
471
|
|
|
472
|
+
|
|
473
|
+
|
|
474
|
+
|
|
475
|
+
|
|
476
|
+
|
|
477
|
+
|
|
478
|
+
|
|
479
|
+
追記.2
|
|
480
|
+
|
|
481
|
+
|
|
482
|
+
|
|
483
|
+
|
2
ソース変更
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -436,25 +436,23 @@
|
|
|
436
436
|
|
|
437
437
|
List<Map<String, Object>> result = session.selectList("test.sql.selectUser");
|
|
438
438
|
|
|
439
|
-
|
|
439
|
+
|
|
440
440
|
|
|
441
441
|
System.out.println("件数:" + result.size());
|
|
442
442
|
|
|
443
|
-
|
|
444
|
-
|
|
445
|
-
|
|
443
|
+
|
|
446
|
-
|
|
444
|
+
|
|
447
|
-
|
|
445
|
+
result.forEach(row -> {
|
|
446
|
+
|
|
448
|
-
|
|
447
|
+
row.forEach((columnName, value) -> {
|
|
448
|
+
|
|
449
|
-
System.out.print
|
|
449
|
+
System.out.printf("columnName=%s, value=%s%n", columnName, value);
|
|
450
|
-
|
|
451
|
-
|
|
450
|
+
|
|
452
|
-
|
|
453
|
-
System.out.println(result.get(i));
|
|
454
|
-
|
|
455
|
-
}
|
|
451
|
+
});
|
|
456
|
-
|
|
452
|
+
|
|
457
|
-
}
|
|
453
|
+
});
|
|
454
|
+
|
|
455
|
+
|
|
458
456
|
|
|
459
457
|
return session.selectList("test.sql.selectUser");
|
|
460
458
|
|
|
@@ -470,4 +468,4 @@
|
|
|
470
468
|
|
|
471
469
|
|
|
472
470
|
|
|
473
|
-
|
1
ソース追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -379,3 +379,95 @@
|
|
|
379
379
|
|
|
380
380
|
|
|
381
381
|
|
|
382
|
+
|
|
383
|
+
|
|
384
|
+
|
|
385
|
+
|
|
386
|
+
|
|
387
|
+
|
|
388
|
+
|
|
389
|
+
|
|
390
|
+
|
|
391
|
+
追記
|
|
392
|
+
|
|
393
|
+
|
|
394
|
+
|
|
395
|
+
|
|
396
|
+
|
|
397
|
+
```ここに言語を入力
|
|
398
|
+
|
|
399
|
+
package spring.test;
|
|
400
|
+
|
|
401
|
+
|
|
402
|
+
|
|
403
|
+
import java.util.ArrayList;
|
|
404
|
+
|
|
405
|
+
import java.util.HashMap;
|
|
406
|
+
|
|
407
|
+
import java.util.List;
|
|
408
|
+
|
|
409
|
+
import java.util.Map;
|
|
410
|
+
|
|
411
|
+
|
|
412
|
+
|
|
413
|
+
import org.apache.ibatis.session.SqlSession;
|
|
414
|
+
|
|
415
|
+
|
|
416
|
+
|
|
417
|
+
public class UserDaoImpl implements UserDao {
|
|
418
|
+
|
|
419
|
+
|
|
420
|
+
|
|
421
|
+
private SqlSession session;
|
|
422
|
+
|
|
423
|
+
|
|
424
|
+
|
|
425
|
+
public void setSession(SqlSession ss) {
|
|
426
|
+
|
|
427
|
+
this.session = ss;
|
|
428
|
+
|
|
429
|
+
}
|
|
430
|
+
|
|
431
|
+
|
|
432
|
+
|
|
433
|
+
public List<User> getUserList() {
|
|
434
|
+
|
|
435
|
+
// 結果取得
|
|
436
|
+
|
|
437
|
+
List<Map<String, Object>> result = session.selectList("test.sql.selectUser");
|
|
438
|
+
|
|
439
|
+
|
|
440
|
+
|
|
441
|
+
System.out.println("件数:" + result.size());
|
|
442
|
+
|
|
443
|
+
|
|
444
|
+
|
|
445
|
+
for (int i = 0; i < result.size(); i++) {
|
|
446
|
+
|
|
447
|
+
if (result.get(i) == null) {
|
|
448
|
+
|
|
449
|
+
System.out.println("値はnull");
|
|
450
|
+
|
|
451
|
+
} else {
|
|
452
|
+
|
|
453
|
+
System.out.println(result.get(i));
|
|
454
|
+
|
|
455
|
+
}
|
|
456
|
+
|
|
457
|
+
}
|
|
458
|
+
|
|
459
|
+
return session.selectList("test.sql.selectUser");
|
|
460
|
+
|
|
461
|
+
}
|
|
462
|
+
|
|
463
|
+
}
|
|
464
|
+
|
|
465
|
+
```
|
|
466
|
+
|
|
467
|
+
|
|
468
|
+
|
|
469
|
+
コンソール出力内容
|
|
470
|
+
|
|
471
|
+
|
|
472
|
+
|
|
473
|
+
|