mysql插入 datetime没有时间

Question

preparedStatement.setDate(6, new Date(newsLikeBean.getCreateTime()));

字段是datetime类型的

怎么能把时分秒带上啊？

Answer 1

preparedStatement.setTimestamp(6, new Timestamp(newsLikeBean.getCreateTime()));

Answer 2

Normally, java.sql.Date only returns Date value and time will be discarded.
So, in order to get time also, java.sql.TimeStamp must be used.
TimeStamp Constructs a Timestamp object using a milliseconds time value

Answer 3

private Timestamp datetime;

public Timestamp getDatetime() {
    return new Timestamp(System.currentTimeMillis());
}

Answer 4

需要传毫秒值

Answer 5

preparedStatement.setTimeStamp