package com.huang.common.DB;

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.ArrayList;

public class DBpool {

	private static String driver = "oracle.jdbc.driver.OracleDriver";
	private static String url = "jdbc:oracle:thin:@localhost:1521:sccp";
	private static String username = "system";
	private static String password = "sccp456";
	
	private static ArrayList list = null;
	private static Connection conn;
	
	private static int conMax = 10;
	
	private static Connection createConnection() {
		try {
			java.lang.Class.forName(driver);
			return DriverManager.getConnection(url, username, password);
		}catch(Exception e) {	
			e.printStackTrace();
			return null;
		}
	}
	
	public static Connection getConnection() {
		if(list == null) {
			list = new ArrayList();
		}
		if(list.isEmpty()) {
			return createConnection();
		}else {
			System.out.println("************conection************"+list.size());
			conn = (Connection)list.get(list.size()-1);
			list.remove(list.size()-1);
			return conn;
		}
	}
	
	public static void returnTOConnection(Connection con) {
		if(list.size() == conMax) {
			try {
				con.close();
			}catch(Exception e) {
				e.printStackTrace();
			}
		}else {
			list.add(con);
		}
	}
	
}