質問編集履歴
3
写真追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -233,4 +233,10 @@
|
|
|
233
233
|
|
|
234
234
|
コンソール出力内容
|
|
235
235
|
|
|
236
|
-
|
|
236
|
+
|
|
237
|
+
|
|
238
|
+
|
|
239
|
+
|
|
240
|
+
追記.2
|
|
241
|
+
|
|
242
|
+
|
2
ソース変更
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -217,16 +217,15 @@
|
|
|
217
217
|
public List<User> getUserList() {
|
|
218
218
|
// 結果取得
|
|
219
219
|
List<Map<String, Object>> result = session.selectList("test.sql.selectUser");
|
|
220
|
-
|
|
220
|
+
|
|
221
221
|
System.out.println("件数:" + result.size());
|
|
222
|
-
|
|
223
|
-
|
|
222
|
+
|
|
224
|
-
|
|
223
|
+
result.forEach(row -> {
|
|
224
|
+
row.forEach((columnName, value) -> {
|
|
225
|
-
System.out.
|
|
225
|
+
System.out.printf("columnName=%s, value=%s%n", columnName, value);
|
|
226
|
-
} else {
|
|
227
|
-
System.out.println(result.get(i));
|
|
228
|
-
}
|
|
226
|
+
});
|
|
229
|
-
}
|
|
227
|
+
});
|
|
228
|
+
|
|
230
229
|
return session.selectList("test.sql.selectUser");
|
|
231
230
|
}
|
|
232
231
|
}
|
|
@@ -234,4 +233,4 @@
|
|
|
234
233
|
|
|
235
234
|
コンソール出力内容
|
|
236
235
|
|
|
237
|
-
|
1
ソース追記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -188,4 +188,50 @@
|
|
|
188
188
|
|
|
189
189
|
ローカルで同様のselect文実行時のEVD
|
|
190
190
|
|
|
191
|
-
|
|
191
|
+
|
|
192
|
+
|
|
193
|
+
|
|
194
|
+
|
|
195
|
+
|
|
196
|
+
追記
|
|
197
|
+
|
|
198
|
+
|
|
199
|
+
```ここに言語を入力
|
|
200
|
+
package spring.test;
|
|
201
|
+
|
|
202
|
+
import java.util.ArrayList;
|
|
203
|
+
import java.util.HashMap;
|
|
204
|
+
import java.util.List;
|
|
205
|
+
import java.util.Map;
|
|
206
|
+
|
|
207
|
+
import org.apache.ibatis.session.SqlSession;
|
|
208
|
+
|
|
209
|
+
public class UserDaoImpl implements UserDao {
|
|
210
|
+
|
|
211
|
+
private SqlSession session;
|
|
212
|
+
|
|
213
|
+
public void setSession(SqlSession ss) {
|
|
214
|
+
this.session = ss;
|
|
215
|
+
}
|
|
216
|
+
|
|
217
|
+
public List<User> getUserList() {
|
|
218
|
+
// 結果取得
|
|
219
|
+
List<Map<String, Object>> result = session.selectList("test.sql.selectUser");
|
|
220
|
+
|
|
221
|
+
System.out.println("件数:" + result.size());
|
|
222
|
+
|
|
223
|
+
for (int i = 0; i < result.size(); i++) {
|
|
224
|
+
if (result.get(i) == null) {
|
|
225
|
+
System.out.println("値はnull");
|
|
226
|
+
} else {
|
|
227
|
+
System.out.println(result.get(i));
|
|
228
|
+
}
|
|
229
|
+
}
|
|
230
|
+
return session.selectList("test.sql.selectUser");
|
|
231
|
+
}
|
|
232
|
+
}
|
|
233
|
+
```
|
|
234
|
+
|
|
235
|
+
コンソール出力内容
|
|
236
|
+
|
|
237
|
+
|