1 23 24 package org.dbforms.conprovider; 25 26 import java.sql.Connection ; 27 import java.sql.DriverManager ; 28 import java.sql.SQLException ; 29 30 import java.util.Properties ; 31 32 33 34 39 public class SingleConnectionProvider extends ConnectionProvider { 40 private static Connection con; 41 42 49 public SingleConnectionProvider() throws Exception { 50 super(); 51 } 52 53 60 protected synchronized Connection getConnection() throws SQLException { 61 if (con == null) { 62 Properties props = getPrefs() 63 .getProperties(); 64 65 if ((props != null) && !props.isEmpty()) { 67 props.put("user", getPrefs().getUser()); 68 props.put("password", getPrefs().getPassword()); 69 con = DriverManager.getConnection(getPrefs().getJdbcURL(), props); 70 } 71 else { 73 con = DriverManager.getConnection(getPrefs().getJdbcURL(), 74 getPrefs().getUser(), 75 getPrefs().getPassword()); 76 } 77 } 78 79 return new SingleConnectionWrapper(con); 80 } 81 82 83 88 protected void init() throws Exception { 89 Class.forName(getPrefs().getJdbcDriver()) 90 .newInstance(); 91 } 92 } 93 | Popular Tags |