package UIJ.UIJ03;

import org.apache.commons.dbcp.BasicDataSource;
/**
 * 创建oracle数据库连接池对象
 * @author WanLei
 * @Date 2016-4-10 下午11:11:42
 *
 */
public class DataSo {
//	private static String dataUrl = "jdbc:oracle:thin:@10.10.0.8:1521:SQMESDB";
//	private static String testUrl = "jdbc:oracle:thin:@172.16.0.8:1521:SQMESDB";
	private static BasicDataSource ds ;
	private static BasicDataSource ds2 ;
	/*
	 * 正式库： jdbc:oracle:thin:@172.16.0.111:1521:SQMESDB
	 * 测试库：jdbc:oracle:thin:@172.16.0.8:1521:SQMESDB
	 */
	public static BasicDataSource getDataSource(){
		if(ds==null){
		/*	ds = new BasicDataSource();
			ds.setDriverClassName("oracle.jdbc.driver.OracleDriver");
			ds.setUrl("jdbc:oracle:thin:@172.16.0.3:1521:sqmesdb");
			ds.setUsername("xg3q");
			ds.setPassword("xg3q123");
			ds.setMaxActive(4);*/
		}
		return ds;
	}
	public static BasicDataSource getDataSource2(){
		if(ds2==null){
			ds2 = new BasicDataSource();
			ds2.setDriverClassName("oracle.jdbc.driver.OracleDriver");
			ds2.setUrl("jdbc:oracle:thin:@172.16.81.101:1521:xgyt");
			ds2.setUsername("xmlz");
			ds2.setPassword("ytglz");
			ds2.setMaxActive(25);
			ds2.setMaxWait(9000);
			ds2.setValidationQuery("select 1 from dual");
		}
		return ds2;
	}

}