public class DBConnectionManager { private static DBConnectionManager instance = null; private static Logger log = Logger.getLogger(DBConnectionManager.class); ComboPooledDataSource cpds = null; private DBConnectionManager() { try{ cpds = new ComboPooledDataSource(); cpds.setDriverClass( "com.mysql.jdbc.Driver" ); //loads the jdbc driver cpds.setJdbcUrl( "jdbc:mysql://localhost/uso" ); cpds.setUser("root"); cpds.setPassword("123456"); }catch(Exception ex){ } } public static synchronized DBConnectionManager getInstance() { if (instance == null){ instance = new DBConnectionManager(); } return instance; } public Connection getConnection() throws SQLException{ log.info("GET CONNECTION"); try{ Connection conn = cpds.getConnection(); log.info(conn); return conn; }catch(Exception ex){ return null; } } } <p class="indent">
猜你喜欢
其他人在看