java timestamp 转date,如何在Java中将TimeStamp转换为Date？

How do I convert 'timeStamp' to date after I get the count in java?

My current code is as follows:

public class GetCurrentDateTime {

public int data() {

int count = 0;

java.sql.Timestamp timeStamp = new Timestamp(System.currentTimeMillis());

java.sql.Date date = new java.sql.Date(timeStamp.getTime());

System.out.println(date);

//count++;

try {

Class.forName("com.mysql.jdbc.Driver");

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/pro", "root", "");

PreparedStatement statement = con.prepareStatement("select * from orders where status='Q' AND date=CURDATE()");

ResultSet result = statement.executeQuery();

while (result.next()) {

// Do something with the row returned.

count++; //if the first col is a count.

}

} catch (Exception exc) {

System.out.println(exc.getMessage());

}

return count;

}

}

This is my database:

Here the output I got was 2012-08-07 0, but the equivalent query returns 3. Why do I get 0?

解决方案

Just make a new Date object with the stamp's getTime value as a paramater

Here's an example (I use an example timestamp of the current time):

Timestamp stamp = new Timestamp(System.currentTimeMillis());

Date date = new Date(stamp.getTime());

System.out.println(date);