質問編集履歴
2
誤字
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -68,7 +68,7 @@
|
|
|
68
68
|
|
|
69
69
|
//SQL statement
|
|
70
70
|
|
|
71
|
-
String query = "INSERT INTO
|
|
71
|
+
String query = "INSERT INTO ORDER "
|
|
72
72
|
|
|
73
73
|
+ "(CUSTOMER_ID,ITEM_ID,NUMBER,PRICE,UPD_STAF_CD,UPD_DATE,INS_DATE) "
|
|
74
74
|
|
1
書式の改善
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -70,11 +70,11 @@
|
|
|
70
70
|
|
|
71
71
|
String query = "INSERT INTO shopping_koizumi.ORDER "
|
|
72
72
|
|
|
73
|
-
|
|
73
|
+
+ "(CUSTOMER_ID,ITEM_ID,NUMBER,PRICE,UPD_STAF_CD,UPD_DATE,INS_DATE) "
|
|
74
74
|
|
|
75
75
|
+ "VALUES (?,?,?,?,?,NOW(),NOW()); "
|
|
76
76
|
|
|
77
|
-
|
|
77
|
+
+"UPDATE PRODUCT_STOCK "
|
|
78
78
|
|
|
79
79
|
+ "SET STOCK = ?,UPD_STAF_CD = ?, UPD_DATE = NOW() "
|
|
80
80
|
|