Awesome JDBC Usage with Design Patterns

1) Follow the link below for a well written example on JDBC Singleton Connectivity.

http://theopentutorials.com/tutorials/java/jdbc/jdbc-examples-introduction/#Singleton_design_pattern

2) A simple JDBC Application
http://www.tutorialspoint.com/jdbc/jdbc-sample-code.htm