Scala for Data Science

References

The API documentation for JDBC is very complete: http://docs.oracle.com/javase/7/docs/api/java/sql/package-summary.html

The API documentation for the ResultSet interface (http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html), for the PreparedStatement class (http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html) and the Connection class (http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html) is particularly relevant.

The data mapper pattern is described extensively in Martin Fowler's Patterns of Enterprise Application Architecture. A brief description is also available on his website (http://martinfowler.com/eaaCatalog/dataMapper.html).

For an introduction to SQL, I suggest Learning SQL by ...