java 插入mysql 日期_如何使用Java在MySQL中插入当前时间

I need to insert the current date and time (milliseconds) into MySQL. I did the following:

long time = System.currentTimeMillis();

java.sql.Timestamp timestamp = new java.sql.Timestamp(time);

System.out.println("Time in milliseconds :" + timestamp);

And I got the time in milliseconds correctly (e.g. 2013-03-21 00:08:33.523). However, I need to insert this information into MySQL database. I tried the following using PreparedStatement

prepStmt.setTimestamp(2,timestamp);

But the time is inserted without milliseconds (e.g. 2013-03-21 00:08:33).

How can I insert the time with milliseconds.

EDIT: The column in the database is of DATETIME type.

解决方案java.util.Date date = new java.util.Date();

java.sql.Timestamp timestamp = new java.sql.Timestamp(date.getTime());

preparedStatement.setTimestamp(1, timestamp);