質問編集履歴
2
誤字修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -112,11 +112,11 @@
|
|
|
112
112
|
|
|
113
113
|
Statement state = users.createStatement();
|
|
114
114
|
|
|
115
|
-
ResultSet result = state.executeQuery
|
|
115
|
+
//ResultSet result = state.executeQuery
|
|
116
|
-
|
|
116
|
+
|
|
117
|
-
("create table Users (id varchar(20) primary key, password varchar(20))");
|
|
117
|
+
// ("create table Users (id varchar(20) primary key, password varchar(20))");
|
|
118
|
-
|
|
118
|
+
|
|
119
|
-
|
|
119
|
+
ResultSet result = state.executeQuery("SELECT * FROM Users");
|
|
120
120
|
|
|
121
121
|
String html = "<table border=\"1\">";
|
|
122
122
|
|
1
該当エラーのCREATE文が間違っているというご指摘をいただいたため、修正しました。現在のSELECT文での記載が教材通りのプログラムになります。またこの状態でも同じ内容のエラーが出てきてしまう状況で
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -54,7 +54,7 @@
|
|
|
54
54
|
|
|
55
55
|
|
|
56
56
|
|
|
57
|
-
org.apache.jasper.JasperException: An exception occurred processing JSP page /sampleJSP.jsp at line 1
|
|
57
|
+
org.apache.jasper.JasperException: An exception occurred processing JSP page /sampleJSP.jsp at line 14
|
|
58
58
|
|
|
59
59
|
|
|
60
60
|
|
|
@@ -64,11 +64,11 @@
|
|
|
64
64
|
|
|
65
65
|
11: Statement state = users.createStatement();
|
|
66
66
|
|
|
67
|
-
12: ResultSet result = state.executeQuery
|
|
67
|
+
12: //ResultSet result = state.executeQuery
|
|
68
|
-
|
|
68
|
+
|
|
69
|
-
13: ("create table Users (id varchar(20) primary key, password varchar(20))");
|
|
69
|
+
13: // ("create table Users (id varchar(20) primary key, password varchar(20))");
|
|
70
|
-
|
|
70
|
+
|
|
71
|
-
14:
|
|
71
|
+
14: ResultSet result = state.executeQuery("SELECT * FROM Users");
|
|
72
72
|
|
|
73
73
|
15: String html = "<table border=\"1\">";
|
|
74
74
|
|
|
@@ -76,6 +76,10 @@
|
|
|
76
76
|
|
|
77
77
|
|
|
78
78
|
|
|
79
|
+
|
|
80
|
+
|
|
81
|
+
|
|
82
|
+
|
|
79
83
|
### 該当のソースコード
|
|
80
84
|
|
|
81
85
|
|
|
@@ -254,7 +258,7 @@
|
|
|
254
258
|
|
|
255
259
|
|
|
256
260
|
|
|
257
|
-
・該当SQL文の内容を
|
|
261
|
+
・該当SQL文の内容をCREATE文などに変更
|
|
258
262
|
|
|
259
263
|
・データベースのEclipseからの接続、切断をした状況でそれぞれ確認
|
|
260
264
|
|