package com.vsked.DbOperate;

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

import org.apache.log4j.Logger;
import org.apache.log4j.PropertyConfigurator;

public class ConnectDb {
	static Connection conn=null;
	static PreparedStatement pt=null;
	static ResultSet rs=null;	
	public static Connection getSqlConnect(){
		com.vsked.LogOperate.LogOperate.setLogs("ConnectDb.class");
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			String url="jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs";
			conn=DriverManager.getConnection(url, "sa", "sa");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			//e.printStackTrace();
			com.vsked.LogOperate.LogOperate.getLogs().debug(e);
			
			 
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			com.vsked.LogOperate.LogOperate.getLogs().debug(e);
		    // e.printStackTrace();
		}
		return conn;
	}	
	
	//連接示例 
	//String oracleUrlToConnect = "jdbc:oracle:thin:@IP地址:端口號（默認為1521）:實例名稱";
	
	public static Connection getOracleConnect(){	
		String oraUrl="jdbc:oracle:thin:@127.0.0.1:1521:vsked";
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");		
			conn=DriverManager.getConnection(oraUrl, "scott", "tiger");
			System.out.println("connect ok");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();			
		} catch (SQLException e) {			
			e.printStackTrace();
		}
		return conn;
		
	}
	
	public static Connection getSqlConnectODBC(){		
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			String url="jdbc:odbc:northwind";
			conn=DriverManager.getConnection(url, "sa", "sa");
			System.out.println("conok");
		} catch (ClassNotFoundException e) {			
			// TODO Auto-generated catch block
			//e.printStackTrace();
			//com.vsked.LogOperate.LogOperate.getLogs().debug(e);
			
			 
		} catch (SQLException e) {
			System.out.println("con no");
			// TODO Auto-generated catch block
			//com.vsked.LogOperate.LogOperate.getLogs().debug(e);
		    // e.printStackTrace();
		}
		return conn;
	}
}