質問編集履歴

1

コードを追記しました

2018/07/30 15:33

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -1,3 +1,237 @@
1
+ ```Java
2
+
3
+
4
+
5
+ public boolean update(Gyomu gyomu) throws SQLException, ClassNotFoundException {
6
+
7
+
8
+
9
+ boolean flag = false;
10
+
11
+
12
+
13
+ Connection conn = null;
14
+
15
+
16
+
17
+ try {
18
+
19
+
20
+
21
+ conn = connectManager.getConn(false);
22
+
23
+
24
+
25
+ // UPDATE文の準備(idは自動連番なので指定しない)WHERE句で指定する
26
+
27
+ // StringBuilderで文字列の連結ができる
28
+
29
+
30
+
31
+ //業務報告テーブルのUPDATE
32
+
33
+ StringBuilder sb = new StringBuilder();
34
+
35
+ sb.append("UPDATE");
36
+
37
+ sb.append(" GYOMUHOKOKU");
38
+
39
+ sb.append(" SET");
40
+
41
+ sb.append(" HOKOKUHIDUKE = ?");
42
+
43
+ sb.append(" , YOTEI = ?");
44
+
45
+ sb.append(" , ZISSEKI = ?");
46
+
47
+ sb.append(" , TOKKIZIKOU = ?");
48
+
49
+ sb.append(" , SHOKAN = ?");
50
+
51
+ sb.append(" , KAKUNOSAKI = ?");
52
+
53
+ sb.append(" , ZIKAIYOTEI = ?");
54
+
55
+ sb.append(" , KOMENTO = ?");
56
+
57
+ sb.append(" , BIKO = ?");
58
+
59
+ sb.append(" , CREATEDATE = ?");
60
+
61
+ sb.append(" , CREATEUSER = ?");
62
+
63
+ sb.append(" , UPDATEDATE = ?");
64
+
65
+ sb.append(" , UPDATEUSER = ?");
66
+
67
+ sb.append(" WHERE KANRINO = ?");
68
+
69
+
70
+
71
+
72
+
73
+ StringBuilder sb2 = new StringBuilder();
74
+
75
+
76
+
77
+ sb2.append("UPDATE");
78
+
79
+ sb2.append(" HOKOKUSAKI");
80
+
81
+ sb2.append(" SET");
82
+
83
+ sb2.append(" USERID = ?");
84
+
85
+ sb2.append(" , CREATEDATE = ?");
86
+
87
+ sb2.append(" , CREATEUSER = ?");
88
+
89
+ sb2.append(" , UPDATEDATE = ?");
90
+
91
+ sb2.append(" , UPDATEUSER = ?");
92
+
93
+ sb2.append(" WHERE KANRINO = ?");
94
+
95
+
96
+
97
+
98
+
99
+ // sb.toStringで、文字列にする
100
+
101
+ // sbのままだと、prepareStatementが受け取れない
102
+
103
+ PreparedStatement pStmt = conn.prepareStatement(sb.toString());
104
+
105
+ PreparedStatement pStmt2 = conn.prepareStatement(sb2.toString());
106
+
107
+
108
+
109
+ // UPDATE文中の「?」に使用する値を設定し、SQLを完成
110
+
111
+
112
+
113
+
114
+
115
+ //報告先seqに値が入るようにする
116
+
117
+
118
+
119
+
120
+
121
+ pStmt.setString(1, gyomu.getHokokuhiduke());
122
+
123
+ pStmt.setString(2, gyomu.getYotei());
124
+
125
+ pStmt.setString(3, gyomu.getZisseki());
126
+
127
+ pStmt.setString(4, gyomu.getTokkizikou());
128
+
129
+ pStmt.setString(5, gyomu.getShokan());
130
+
131
+ pStmt.setString(6, gyomu.getKakunosaki());
132
+
133
+ pStmt.setString(7, gyomu.getZikaiyotei());
134
+
135
+ pStmt.setString(8, gyomu.getKomento());
136
+
137
+ pStmt.setString(9, gyomu.getBiko());
138
+
139
+ pStmt.setString(10, gyomu.getCreatedate());
140
+
141
+ pStmt.setString(11, gyomu.getCreateuser());
142
+
143
+ pStmt.setString(12, gyomu.getUpdatedate());
144
+
145
+ pStmt.setString(13, gyomu.getUpdateuser());
146
+
147
+ pStmt.setString(14, gyomu.getKanrino());
148
+
149
+
150
+
151
+ //ステータステーブルのUPDATE
152
+
153
+
154
+
155
+ pStmt2.setString(1, gyomu.getUserId());
156
+
157
+ pStmt2.setString(2, gyomu.getCreatedate());
158
+
159
+ pStmt2.setString(3, gyomu.getCreateuser());
160
+
161
+ pStmt2.setString(4, gyomu.getUpdatedate());
162
+
163
+ pStmt2.setString(5, gyomu.getUpdateuser());
164
+
165
+ pStmt2.setString(6, gyomu.getKanrino());
166
+
167
+
168
+
169
+ // INSERT文を実行
170
+
171
+ int result = pStmt.executeUpdate();
172
+
173
+ int result2 = pStmt2.executeUpdate();
174
+
175
+
176
+
177
+
178
+
179
+ if (result == 1 && result2 == 1) {
180
+
181
+ // 1件更新されたら正常
182
+
183
+ conn.commit();
184
+
185
+ flag = true;
186
+
187
+ } else {
188
+
189
+ conn.rollback();
190
+
191
+ }
192
+
193
+
194
+
195
+ } catch (SQLException e) {
196
+
197
+ e.printStackTrace();
198
+
199
+ try {
200
+
201
+ conn.rollback();
202
+
203
+ } catch (SQLException e1) {
204
+
205
+ e1.printStackTrace();
206
+
207
+ }
208
+
209
+ } finally {
210
+
211
+ connectManager.close(conn);
212
+
213
+ }
214
+
215
+
216
+
217
+ return flag;
218
+
219
+ }
220
+
221
+
222
+
223
+
224
+
225
+
226
+
227
+ ```
228
+
229
+
230
+
231
+
232
+
233
+
234
+
1
235
  ```sql
2
236
 
3
237
  create table GYOMUHOKOKU (