数据库的字段是date java里面能用timestamp吗,从数据库中显示java中的时间戳值

the value of date in database is

2011-03-19 18:49:04

Timestamp date;

ResultSet rs=smt.executeQuery("select * from posttopic where name='"+logn+"'");

while(rs.next()){

name=rs.getString(1);

title=rs.getString(2);

subject=rs.getString(3);

message=rs.getString(4);

date=rs.getTimestamp(5);

System.out.print(date);

}

the value of date the the above function is returning is 2011-03-19 18:49:04.0.

Why it is appending .0 at the end?How to remove it?

解决方案

The question is about formatting the Date/Timestamp, not the internal precision (Date holds milliseconds). Try formatting the Timestamp to not show the fractional seconds, use SimpleDateFormat for example:

Timestamp date;

ResultSet rs=smt.executeQuery("select * from posttopic where name='"+logn+"'");

// Create a date formatter with pattern as required: year-month-day hour:minute:second

java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

while(rs.next())

{

name=rs.getString(1);

title=rs.getString(2);

subject=rs.getString(3);

message=rs.getString(4);

date=rs.getTimestamp(5);

System.out.print(sdf.format(date)); // Format the date using the specified pattern.

}