Advertisement
Guest User

Untitled

a guest
Mar 28th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. {
  2. "data":
  3. [
  4. {
  5. "id": "1001",
  6. "door_lock_frnt_le_sts": 0,
  7. "door_lock_frnt_ri_sts": 0,
  8. "door_ajar_frnt_le_sts": 1,
  9. "door_ajar_frnt_ri_sts": 1,
  10. "door_ajar_re_le_sts": 0,
  11. "door_ajar_re_ri_sts": 1,
  12. "fst_chrg_port_ajar_sts": 1,
  13. "sec_chrg_port_ajar_sts": 1,
  14. "tailgate_ajar_sts": 1,
  15. "engine_hood_ajar_sts": 1,
  16. "vehicle_lock_status": null,
  17. "sample_time": "0000-00-00 00:00:00",
  18. "update_time": "2017-01-20 19:01:22"
  19. }
  20. ]
  21. }
  22.  
  23. =======
  24. 插入DB的sql语句
  25. INSERT INTO `status_door` (`id`, `door_lock_frnt_le_sts`, `door_lock_frnt_ri_sts`, `door_ajar_frnt_le_sts`, `door_ajar_frnt_ri_sts`, `door_ajar_re_le_sts`, `door_ajar_re_ri_sts`, `fst_chrg_port_ajar_sts`, `sec_chrg_port_ajar_sts`, `tailgate_ajar_sts`, `engine_hood_ajar_sts`, `vehicle_lock_status`, `sample_time`, `update_time`)
  26. VALUES
  27. ('1001', 0, 0, 1, 1, 0, 1, 1, 1, 1, 1, NULL, '0000-00-00 00:00:00', '2017-01-20 19:01:22');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement