Friday, 9 November 2007

JDBC access any kind of tabular data in a relational database

Basic procedures.

1) Connecting to a data source, like database.
Connection con = DriverManager.getConnection( "jdbc:myDriver:wombat", "myLogin","myPassword");

2)Sending query or update statements to the database.
Statement stmt = con.createStatement();

3) Retrieve and process the results received from database in answer to the query.
while (rs.next()) {
int x = rs.getInt("a");
String s = rs.getString("b");
float f = rs.getFloat("c"); }

Can Jackson Deserialize Java Time ZonedDateTime

Yes, but must include JSR310. Thus ZonedDateTime can be deserialized directly from JSON response to POJO field. <dependency> <g...