public void testQuery() {
Connection con = null;
Statement stmt = null;
ResultSet resultSet = null;
try {
con = getConnection();
stmt = con.createStatement();
String sql = "select * from message_log where log_timestamp
>= CURRENT_TIMESTAMP
-12/24";
resultSet = stmt.executeQuery(sql);
if(resultSet.next()) {
System.out.println("Trade No XX: " +
resultSet.getInt(1));
System.out.println("Message Timestamp: " +
resultSet.getTimestamp(2).getTime());
}
} catch (Exception e) {
e.printStackTrace();
System.out.println("Error running test " + e.getMessage());
} finally {
closeConnection(resultSet, stmt, con);
}
}
Received on Wed Sep 21 2005 - 12:54:23 CDT
