package com.ahbay.DataBaseMgr;

import java.util.*;
import java.sql.*;
import javax.sql.*;
import java.io.*;
 
import org.apache.struts.action.Action;
import javax.naming.*;
	
	/**
　　* 通過thin方式獲得Oracle數據庫連接
	*/
public class InterfDataBaseConn extends Action
{
	public InterfDataBaseConn(){}
/**
	public Connection GetConnection() 
	{
		Connection ConnectionHandle=null;	
		
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 
			String url="jdbc:oracle:thin:@192.168.10.202:1521:saas"; //orcl為數據庫的SID 
			String user="dev"; 
			String password="111111"; 
			ConnectionHandle= DriverManager.getConnection(url,user,password);
			ConnectionHandle.setAutoCommit(true);
		}	 
	  	catch(ClassNotFoundException cnf){
			System.out.println("driver not find");
			return null;
  		}
  		catch(SQLException sqle)
  		{
			System.out.println("can't connection db");
			return null;
  		}
		catch (Exception e) 
		{
	  		System.out.println("Failed to load JDBC/ODBC driver.");
	  		return null;
   		}
	
		
		return ConnectionHandle;
	}
**/		
	public Connection GetConnection() 
	{
		String username = "root";
        String password = "111111";
        
        Connection ConnectionHandle = null;
        
        String driver =  "org.gjt.mm.mysql.Driver";//
        String link = "jdbc:mysql://192.168.10.86:3306/soft_xsaas?useUnicode=true&characterEncoding=GBK";
        try
        {
        	Class.forName(driver).newInstance();
        	ConnectionHandle = DriverManager.getConnection(link,username,password);      
        	ConnectionHandle.setAutoCommit(true);   
        }
        catch(Exception e)
        {
        	System.out.println("insert Edit error message :"+e.getMessage());
        }
        return ConnectionHandle;
	} 
    public Connection getInterfConnection()
    {
        String username = "root";
        String password = "wwwxsaascom";
        
        Connection ConnectionHandle = null;
        
        String driver =  "org.gjt.mm.mysql.Driver";//
        String link = "jdbc:mysql://192.168.10.112:3306/saasnews?useUnicode=true&characterEncoding=GBK";
        try
        {
        	Class.forName(driver).newInstance();
        	ConnectionHandle = DriverManager.getConnection(link,username,password);      
        	ConnectionHandle.setAutoCommit(false);   
        }
        catch(Exception e)
        {
        	System.out.println("insert Edit error message :"+e.getMessage());
        }
        return ConnectionHandle;
    }
}