cars表里有如下數據：mysql> select * from cars;+------+--------+--------+---------------------+---------------------+| id | name | vendor | ctime | utime |+------+--------+--------+---------------------+---------------------+| 801 | China1 | China | 2019-05-07 09:45:32 | 2019-05-07 09:45:32 || 802 | China2 | China | 2019-05-07 09:45:37 | 2019-05-07 09:45:37 || 803 | Japan | Japan | 2019-05-07 09:45:37 | 2019-05-07 09:45:37 || 1001 | China1 | China | 2019-05-07 10:18:21 | 2019-05-07 10:18:21 || 1002 | China2 | China | 2019-05-07 10:18:22 | 2019-05-07 10:18:22 || 1003 | Japan | Japan | 2019-05-07 10:18:22 | 2019-05-07 10:18:22 || 1004 | China1 | China | 2019-05-07 10:18:56 | 2019-05-07 10:18:56 || 1005 | China2 | China | 2019-05-07 10:18:56 | 2019-05-07 10:18:56 || 1006 | Japan | Japan | 2019-05-07 10:18:56 | 2019-05-07 10:18:56 || 1201 | China1 | China | 2019-05-07 10:49:44 | 2019-05-07 10:49:44 || 1202 | China2 | China | 2019-05-07 10:49:44 | 2019-05-07 10:49:44 || 1203 | Japan | Japan | 2019-05-07 10:49:44 | 2019-05-07 10:49:44 |+------+--------+--------+---------------------+---------------------+12 rows in set (0.00 sec)java中執行查詢，SELECT * FROM cars WHERE vendor='China'根據resultSet遍歷獲取各列的值，ctime和utime和數據庫里的有差別。[{utime: "2019-05-07 10:45:32",vendor: "China",name: "China1",ctime: "2019-05-07 10:45:32",id: 801},{utime: "2019-05-07 10:45:37",vendor: "China",name: "China2",ctime: "2019-05-07 10:45:37",id: 802},{utime: "2019-05-07 11:18:21",vendor: "China",name: "China1",ctime: "2019-05-07 11:18:21",id: 1001},{utime: "2019-05-07 11:18:22",vendor: "China",name: "China2",ctime: "2019-05-07 11:18:22",id: 1002},{utime: "2019-05-07 11:18:56",vendor: "China",name: "China1",ctime: "2019-05-07 11:18:56",id: 1004},{utime: "2019-05-07 11:18:56",vendor: "China",name: "China2",ctime: "2019-05-07 11:18:56",id: 1005},{請大佬們看看問題在哪，是resultSet.getObject有什么問題還是什么。。補充：這一條數據數據庫里是9:45:32
3 回答
慕村9548890
TA貢獻1884條經驗 獲得超4個贊
首先確認是不是同一個庫，其次確認是時區是否一致，最后寫一個demo，單獨拿出對時間處理的邏輯看是否有問題；如果會debug的話可以打個斷點看下在處理日期之前的值是什么，處理之后的值是什么來鎖定錯誤位置
添加回答
舉報
0/150
提交
取消