title: Best way for creating database connections
body: <p>What is the best way to create database connections in a Java application? Using Singleton, Static Method, Service Locator, Connection Pool or something else?</p>
  
  <p>Please would you let me know the pros and cons of each of the above approaches?</p>