Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "data":
- [
- {
- "id": "1001",
- "door_lock_frnt_le_sts": 0,
- "door_lock_frnt_ri_sts": 0,
- "door_ajar_frnt_le_sts": 1,
- "door_ajar_frnt_ri_sts": 1,
- "door_ajar_re_le_sts": 0,
- "door_ajar_re_ri_sts": 1,
- "fst_chrg_port_ajar_sts": 1,
- "sec_chrg_port_ajar_sts": 1,
- "tailgate_ajar_sts": 1,
- "engine_hood_ajar_sts": 1,
- "vehicle_lock_status": null,
- "sample_time": "0000-00-00 00:00:00",
- "update_time": "2017-01-20 19:01:22"
- }
- ]
- }
- =======
- 插入DB的sql语句
- 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`)
- VALUES
- ('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