/* * ConnectionFactory.java * * Created on June 9, 2005, 2:11 PM * * To change this template, choose Tools | Options and locate the template under * the Source Creation and Management node. Right-click the template and choose * Open. You can then make changes to the template in the Source Editor. */package common;import java.io.*;import java.sql.*;import java.util.*;import javax.sql.*;/** * * @author kevin */public class ConnectionFactory {    private static ConnectionFactory factory = new ConnectionFactory();    private String driverName = null;    private String dbURL = null;    private String userName = null;    private String password = null;    /** Creates a new instance of ConnectionFactory */    private ConnectionFactory() {        init();    }        private void init(){        InputStream is = getDriverInfo();        Properties props = new Properties();        try{            props.load(is);            driverName = (String)props.getProperty("driver");            dbURL = (String)props.getProperty("dburl");            userName = (String)props.getProperty("username");            password = (String)props.getProperty("password");        }catch(Exception e){            e.printStackTrace();        }    }    private InputStream getDriverInfo(){        return getClass()            .getResourceAsStream("properties/jdbcinfo.properties");    }        public Connection getConnection()throws SQLException,ClassNotFoundException{        Class.forName(driverName);        Connection conn =             DriverManager.getConnection(dbURL, userName, password);        return conn;    }        public static ConnectionFactory getConnectionFactory(){        return factory;    }}