package ay.db;

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

import ay.util.SysInfo;
/*******************************************************************************
 * 
 * 项目名称：转库
 * 
 * 版权所有： 重庆安运科技
 * 
 * 
 * 
 * 模块名称:获得连接
 * 
 * 模块功能: 
 * 
 * 编写人员:张德亮
 * 
 * 编写日期:2015.12.6
 * 
 * 
 * 备注:
 * 
 * 
 ******************************************************************************/
public class ConnTools {
	
/**
 * 在线理论 oracle库
 * @return
 */
     public static Connection make_oracle_ayth_conn() { 
    	 String dirverClassName ="";  
    	 Connection conn = null; 
         try { 
        	 if(SysInfo.getSys_debug_level()==null)SysInfo.setInfo();      
        	 dirverClassName = "oracle.jdbc.driver.OracleDriver";       
        	 Class.forName(dirverClassName); 
        	 conn = DriverManager.getConnection(SysInfo.getJdbc_oracle_ayth_url(),SysInfo.getJdbc_oracle_ayth_username(),SysInfo.getJdbc_oracle_ayth_password());
         } catch (Exception e) { 
                 e.printStackTrace(); 
         } 
         return conn;
     }
          
     /**
      * 在线理论  ppas 库
      * @return
      */
     public static Connection make_ppas_ayth_conn() { 
    	 String dirverClassName ="";  
    	 Connection conn = null; 
         try { 
        	 if(SysInfo.getSys_debug_level()==null)SysInfo.setInfo();
        	 dirverClassName = "org.postgresql.Driver";            	 
        	 Class.forName(dirverClassName); 
        	 conn = DriverManager.getConnection(SysInfo.getJdbc_ppas_ayth_url(),SysInfo.getJdbc_ppas_ayth_username(),SysInfo.getJdbc_ppas_ayth_password());
         } catch (Exception e) { 
                 e.printStackTrace(); 
         } 
         return conn;
     }
     
     /**
      * 继续教育 oracle库
      * @return
      */
          public static Connection make_oracle_ayjxjy_conn() { 
         	 String dirverClassName ="";  
         	 Connection conn = null; 
              try { 
             	 if(SysInfo.getSys_debug_level()==null)SysInfo.setInfo();      
             	 dirverClassName = "oracle.jdbc.driver.OracleDriver";       
             	 Class.forName(dirverClassName); 
             	 conn = DriverManager.getConnection(SysInfo.getJdbc_oracle_ayjxjy_url(),SysInfo.getJdbc_oracle_ayjxjy_username(),SysInfo.getJdbc_oracle_ayjxjy_password());
              } catch (Exception e) { 
                      e.printStackTrace(); 
              } 
              return conn;
          }
          
          //继续教育 河南  总库
          public static Connection make_oracle_ayjxjy_zk_conn() { 
          	 String dirverClassName ="";  
          	 Connection conn = null; 
               try { 
              	 if(SysInfo.getSys_debug_level()==null)SysInfo.setInfo();      
              	 dirverClassName = "oracle.jdbc.driver.OracleDriver";       
              	 Class.forName(dirverClassName); 
              	 System.out.println(SysInfo.getJdbc_oracle_ayjxjy_zk_url()+"     "+SysInfo.getJdbc_oracle_ayjxjy_zk_username()+"     "+SysInfo.getJdbc_oracle_ayjxjy_zk_password()+"     ");
              	 
              	 conn = DriverManager.getConnection(SysInfo.getJdbc_oracle_ayjxjy_zk_url(),SysInfo.getJdbc_oracle_ayjxjy_zk_username(),SysInfo.getJdbc_oracle_ayjxjy_zk_password());
               } catch (Exception e) { 
                       e.printStackTrace(); 
               } 
               return conn;
           }
               
          /**
           * 继续教育  ppas 库
           * @return
           */
          public static Connection make_ppas_ayjxjy_conn() { 
         	 String dirverClassName ="";  
         	 Connection conn = null; 
              try { 
             	 if(SysInfo.getSys_debug_level()==null)SysInfo.setInfo();
             	 dirverClassName = "org.postgresql.Driver";            	 
             	 Class.forName(dirverClassName); 
             	 conn = DriverManager.getConnection(SysInfo.getJdbc_ppas_ayjxjy_url(),SysInfo.getJdbc_ppas_ayjxjy_username(),SysInfo.getJdbc_ppas_ayjxjy_password());
              } catch (Exception e) { 
                      e.printStackTrace(); 
              } 
              return conn;
          }  
          
          //继续教育 周口  出租车
          public static Connection make_oracle_ayjxjy_zk_czc_conn() { 
          	 String dirverClassName ="";  
          	 Connection conn = null; 
               try { 
              	 if(SysInfo.getSys_debug_level()==null)SysInfo.setInfo();      
              	 dirverClassName = "oracle.jdbc.driver.OracleDriver";       
              	 Class.forName(dirverClassName); 
              	 conn = DriverManager.getConnection(SysInfo.getJdbc_oracle_ayjxjy_zk_czc_url(),SysInfo.getJdbc_oracle_ayjxjy_zk_czc_username(),SysInfo.getJdbc_oracle_ayjxjy_zk_czc_password());
               } catch (Exception e) { 
                       e.printStackTrace(); 
               } 
               return conn;
           }
    
          //山西吕梁
          public static Connection make_sqlserver_conn() { 
         	 String dirverClassName ="";  
         	 Connection conn = null; 
              try { 
             	 if(SysInfo.getSys_debug_level()==null)SysInfo.setInfo();      
             	 dirverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";       
             	 Class.forName(dirverClassName); 
             	 conn = DriverManager.getConnection(SysInfo.getJdbc_sqlserver_ayjxjy_url(),SysInfo.getJdbc_sqlserver_ayjxjy_username(),SysInfo.getJdbc_sqlserver_ayjxjy_password());
              } catch (Exception e) { 
                      e.printStackTrace(); 
              } 
              return conn;
          }
          
          
          public static Connection make_mysql_conn() { 
          	 String dirverClassName ="";  
          	 Connection conn = null; 
               try { 
              	 if(SysInfo.getSys_debug_level()==null)SysInfo.setInfo();      
              	 dirverClassName = "com.mysql.jdbc.Driver";       
              	 Class.forName(dirverClassName); 
              	 conn = DriverManager.getConnection(SysInfo.getJdbc_mysql_url(),SysInfo.getJdbc_mysql_username(),SysInfo.getJdbc_mysql_password());
               } catch (Exception e) { 
                       e.printStackTrace(); 
               } 
               return conn;
           }
          public static void main(String args[]) throws Exception{
        	  Connection conn=make_oracle_ayjxjy_zk_conn();
        	  conn.close();
        	  
          }
}