如何在 Java 中将日历转换为 java.sql.Date?

Calendar cal;
String sql = "INSERT INTO ttable (dt) values (?);"
//dt is a dateTime field in ttable

PreparedStatement stmt = connection.prepareStatement(sql);

stmt = setDate(1,cal); //not working

stmt.execute();
stmt.close();

我想将 cal 转换为 Date 类型以插入到表格中.

I would like to convert cal to a Date type to insert into table.

推荐答案

有一个getTime() 方法(不确定为什么不叫 getDate).

There is a getTime() method (unsure why it's not called getDate).

刚刚意识到您需要一个 java.sql.Date.使用 cal.getTimeInMillis() 的答案之一就是您所需要的.

Just realized you need a java.sql.Date. One of the answers which use cal.getTimeInMillis() is what you need.