将JSON数据转化成数据库表中的数据,并将SQL编译处理,谢谢
时间: 2024-02-24 17:56:38 浏览: 21
好的,以下是将JSON数据插入到上面所创建的数据库表中的SQL语句:
```sql
INSERT INTO expense (AUFNR, BKTXT, BLART, BLDAT, BSCHL, BUDAT, BUKRS, DMBTR, HKONT, KOSTL, KURSF, MONAT, MWSKZ, POSN2, PRCTR, PROJK, RMVCT, RSTGR, SAKNR, SGTXT, UMSKZ, VALUT, VBEL2, WAERS, WRBTR, XBLNR, XREF1, XREF1_HD, ZFBDT, ZUONR, ZZFI01, ZZFI02, expenseCode, formType)
VALUES ('', 'MK123050403_A23013_戴唯', 'ZB', '2023-05-29', '40', '2023-05-30', '2010', '50.00', '', '201L007', '1', '2023-05-30', '', '', '', '', '', '70030015', 'A15456_陈沁_2023-05-21-2023-05-21_高铁/火车票', '', '', '', 'CNY', '50.00', 'MK123050403', '', '', '', '', '', '', '101001007003', 'FA25680423260527740', '员工其他费用报销流程');
INSERT INTO expense (AUFNR, BKTXT, BLART, BLDAT, BSCHL, BUDAT, BUKRS, DMBTR, HKONT, KOSTL, KURSF, MONAT, MWSKZ, POSN2, PRCTR, PROJK, RMVCT, RSTGR, SAKNR, SGTXT, UMSKZ, VALUT, VBEL2, WAERS, WRBTR, XBLNR, XREF1, XREF1_HD, ZFBDT, ZUONR, ZZFI01, ZZFI02, expenseCode, formType)
VALUES ('', 'MK123050403_A23013_戴唯', 'ZB', '2023-05-29', '50', '2023-05-30', '2010', '50.00', '', '201L007', '1', '2023-05-30', '', '', '', '', '', '70030022', 'A15456_陈沁_2023-05-21-2023-05-21_高铁/火车票', '', '', '', 'CNY', '50.00', 'MK123050403', '', '', '', '', '', '', '101001007003', 'FA25680423260527740', '员工其他费用报销流程');
```
这两条SQL语句分别将JSON数据中的两个对象插入到expense表中。由于JSON数据中的字段名与数据库表中的字段名是一一对应的,所以可以直接将JSON数据转化成SQL语句插入到表中。