                        課程
                    
                        /后端開(kāi)發(fā)
                        
                            /Java
                        
                        /Java高并發(fā)秒殺API之業(yè)務(wù)分析與DAO層

這樣的報(bào)錯(cuò)內(nèi)容

?Error attempting to get column 'create_time' from result set.? Cause: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp

; ]; Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp; nested exception is java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp

pert

2020-05-10

源自：Java高并發(fā)秒殺API之業(yè)務(wù)分析與DAO層 4-9

關(guān)注問(wèn)題我要回答

1019

操作

收起

2 回答

JA_JA
2020-05-18

CREATE?TABLE?success_killed(
???`seckill_id`?BIGINT?NOT?NULL?COMMENT?'秒殺商品ID',
???`user_phone`?BIGINT?NOT?NULL?COMMENT?'用戶手機(jī)號(hào)',
???`state`?TINYINT?NOT?NULL?DEFAULT?-1?COMMENT?'狀態(tài)標(biāo)識(shí):-1:無(wú)效?0:成功?1:已付款?2:已發(fā)貨',
????`create_time`?TIMESTAMP?NOT?NULL?DEFAULT??CURRENT_TIMESTAMP??COMMENT?'創(chuàng)建時(shí)間',
????PRIMARY?KEY?(seckill_id,user_phone),/*聯(lián)合主鍵*/
???KEY?idx_create_time(create_time)
)ENGINE=INNODB?DEFAULT?CHARSET=utf8?COMMENT='秒殺成功明細(xì)表';

create_time要設(shè)置默認(rèn)值

0 回復(fù) 有任何疑惑可以回復(fù)我~

收起回答

JA_JA
2020-05-18

創(chuàng)建秒殺成功表的時(shí)候有create_time這個(gè)屬性，但是在在插入記錄insertSuccessKilled()時(shí)候沒(méi)有涉及create_time，因此create_time是空值，導(dǎo)致queryByIdWithSeckill()測(cè)試失?。╯k.create_time為空）。

我三月份遇到這個(gè)問(wèn)題，還沒(méi)解決。。。。