質問編集履歴
1
指摘いただいたSQL文の間違いについて修正しました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -193,7 +193,7 @@
|
|
|
193
193
|
try (Connection conn = DriverManager.getConnection(JDBC_URL, DB_USER, DB_PASS)) {
|
|
194
194
|
|
|
195
195
|
//select文を追加
|
|
196
|
-
String sql = "SELECT ID NAME TEL GENDER FROM MUTTER ORDER BY ID DESC";
|
|
196
|
+
String sql = "SELECT ID, NAME, TEL, GENDER FROM MUTTER ORDER BY ID DESC";
|
|
197
197
|
PreparedStatement pStmt = conn.prepareStatement(sql);
|
|
198
198
|
|
|
199
199
|
//select文を実行し、結果表を取得
|