package cn.com.edu.gui.model;



import java.io.File;
import java.io.FileInputStream;
import java.sql.*;
import java.util.Enumeration;
import java.util.Properties;

public class DBConnection {

  public static  Connection getConnect(Properties pro,String dbType){
    Connection con = null;
    try{
      Enumeration enumer = pro.propertyNames();
      String name= null;
      while(enumer.hasMoreElements()){
        name= (String)enumer.nextElement();
        if(name.startsWith(dbType)){
          String orl = name.substring(0,name.lastIndexOf('.'));
          String driver = pro.getProperty(orl+".driver");
          String url = pro.getProperty(orl+".url");
          String user = pro.getProperty(orl+".user");
          String pwd = pro.getProperty(orl+".password");
          Class.forName(driver);
          con = DriverManager.getConnection(url,user,pwd); 
          return con;
        }
      }
    }catch(Exception e){
      System.out.println(e.getMessage());
    }
    return con;    
  }
  public static Properties getProperties(){
    Properties pro = new Properties();
    File f = new File("db.properties");
    try{
      FileInputStream in = new FileInputStream(f);
      pro.load(in);
    }catch(Exception e){
      System.out.println(e.getMessage());
    }
    return pro;
    
  }
  public static void main(String[] args){
    Connection con=getConnect(getProperties(),"oracle");
    if(con!=null){
      System.out.println("數據庫連接成功");
    }else{
      System.out.println("數據庫連接失敗");
    }
  }
}