且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何从结果集中获取日期

更新时间:2023-02-05 23:42:07

在您的情况下,您没有提供要检索的Date字段的columnName.

In your case you were not providing the columnName of the Date field to be retrieved.

这应该可以完成工作

 while (rs.next()) {
    java.sql.Time dbSqlTime = rs.getTime("columnName");
    java.sql.Date dbSqlDate = rs.getDate("columnName");
    java.sql.Timestamp dbSqlTimestamp = rs.getTimestamp("columnName");     
    java.util.Date dbSqlTimeConverted = new java.util.Date(dbSqlTime.getTime());
    java.util.Date dbSqlDateConverted = new java.util.Date(dbSqlDate.getTime());
    System.out.println(dbSqlTimeConverted);
    System.out.println(dbSqlDateConverted);
 }

ResultSetObject上迭代,从java.sql.DateResultSetObject获取日期,然后将其转换为java.util.Date

iterate over the ResultSetObject get the Date from the ResultSetObject which is java.sql.Date then convert it to java.util.Date