cars表里有如下數(shù)據(jù)：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中執(zhí)行查詢，SELECT * FROM cars WHERE vendor='China'根據(jù)resultSet遍歷獲取各列的值，ctime和utime和數(shù)據(jù)庫里的有差別。[{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有什么問題還是什么。。補(bǔ)充：這一條數(shù)據(jù)數(shù)據(jù)庫里是9:45:32
3 回答
慕村9548890
TA貢獻(xiàn)1884條經(jīng)驗(yàn) 獲得超4個贊
首先確認(rèn)是不是同一個庫，其次確認(rèn)是時(shí)區(qū)是否一致，最后寫一個demo，單獨(dú)拿出對時(shí)間處理的邏輯看是否有問題；如果會debug的話可以打個斷點(diǎn)看下在處理日期之前的值是什么，處理之后的值是什么來鎖定錯誤位置
添加回答
舉報(bào)
0/150
提交
取消