質問編集履歴
2
誤字
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -33,7 +33,7 @@
|
|
|
33
33
|
int num = Integer.parseInt(stock[i]) - Integer.parseInt(numbr[i]);
|
|
34
34
|
|
|
35
35
|
//SQL statement
|
|
36
|
-
String query = "INSERT INTO
|
|
36
|
+
String query = "INSERT INTO ORDER "
|
|
37
37
|
+ "(CUSTOMER_ID,ITEM_ID,NUMBER,PRICE,UPD_STAF_CD,UPD_DATE,INS_DATE) "
|
|
38
38
|
+ "VALUES (?,?,?,?,?,NOW(),NOW()); "
|
|
39
39
|
+"UPDATE PRODUCT_STOCK "
|
1
書式の改善
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -34,9 +34,9 @@
|
|
|
34
34
|
|
|
35
35
|
//SQL statement
|
|
36
36
|
String query = "INSERT INTO shopping_koizumi.ORDER "
|
|
37
|
-
|
|
37
|
+
+ "(CUSTOMER_ID,ITEM_ID,NUMBER,PRICE,UPD_STAF_CD,UPD_DATE,INS_DATE) "
|
|
38
38
|
+ "VALUES (?,?,?,?,?,NOW(),NOW()); "
|
|
39
|
-
|
|
39
|
+
+"UPDATE PRODUCT_STOCK "
|
|
40
40
|
+ "SET STOCK = ?,UPD_STAF_CD = ?, UPD_DATE = NOW() "
|
|
41
41
|
+ "WHERE ITEM_ID = ? ";
|
|
42
42
|
|