質問編集履歴
1
テーブル名を変更
test
CHANGED
File without changes
|
test
CHANGED
@@ -58,7 +58,7 @@
|
|
58
58
|
|
59
59
|
44:
|
60
60
|
|
61
|
-
45: sSql = "INSERT INTO t_
|
61
|
+
45: sSql = "INSERT INTO t_shikaku VALUES(" + sSyainno + ",";
|
62
62
|
|
63
63
|
46: sSql += "'" + sNendo + "',";
|
64
64
|
|
@@ -178,7 +178,7 @@
|
|
178
178
|
|
179
179
|
ResultSet rs;
|
180
180
|
|
181
|
-
String sSql = "SELECT COUNT (*) FROM t_
|
181
|
+
String sSql = "SELECT COUNT (*) FROM t_shikaku WHERE 社員番号 = '" + sSyainno + "'";
|
182
182
|
|
183
183
|
int count = rs.getInt("1");
|
184
184
|
|