工具类ConnectionFactory

package tools;



import java.sql.*;



public class ConnectionFactory {

	private static ConnectionFactory instance=new ConnectionFactory();



	private Connection conn = null;



	private String driver = "oracle.jdbc.driver.OracleDriver";



	private String dbUrl = "jdbc:oracle:thin:@127.0.0.1:1521:HOME";



	private String user = "username";



	private String password = "password";



	private ConnectionFactory() {

	}



	public static ConnectionFactory getConnectionFactory() {

		return instance;



	}



	public Connection getConnection() {

		try {

			Class.forName(driver);

			conn = DriverManager.getConnection(dbUrl, user, password);

		} catch (Exception e) {

			e.printStackTrace();

		}

		return conn;

	}

}