daofactory.java

js 异步加载 tree 采用ajax技术

package yuwu.cn.com.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DaoFactory {
	private  static DaoFactory factory=null;

	private static String ORACLE_VERSION="ORACLE";

	private static String SQLSERVER_VERSION="SQLSERVER";

	private static String MYSQL_VERSION="MYSQL";

	private DaoFactory(){

	}

	/**
	 *实现单例模式 
	 */
	public static DaoFactory getInstance(){
		
		if(factory == null){
			factory = new DaoFactory();
		}
		return factory;
	}
	

	/**
	 *提供数据库连接方法 
	 */ 
	public Connection getConnection(String version) {
    Connection con = null;
    if(version.equals(ORACLE_VERSION)){
    	con = getConnectionOfOracle();
    }
    return con;
	}


	/** 连接 oracle 
	 * @return Connection
	 */
	private  Connection getConnectionOfOracle() {
		
		Connection con = null;
		String driver = "oracle.jdbc.driver.OracleDriver";
		String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
		String user = "yuwu";
		String pwd = "123456";
		try{
			Class.forName(driver);
			con = DriverManager.getConnection(url,user,pwd);
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}catch(SQLException ex){
			ex.printStackTrace();
		}
		return con;
	}
	


}