/***************************************************
 *  
 *  源文件名:  DBConnecion.java
 *  功    能： 夢想年華新聞系統 - 數據庫連接類
 *	作者：夢想年華 [DreamTime]
 *	Email:fanwsp@126.com
 *  QQ:122142023 
 * 	CopyRight(c)2005-2006 by DreamTime 
 *
 ****************************************************
*/


package dreamtime.dreamnews;			//指定類所在的包
import java.sql.*;						//導入數據庫操作的類
import java.util.*;
import java.io.*;

public class DBConnection					
{

    private String FileName;			//配置文件名
    private int DBType;					//數據庫類型
   
    private Connection conn;			//連接對象
	private Statement stmt;				//語句對象
	private ResultSet rs;				//結果集對象
	
    private String AccessDriver;		//保存Access驅動程序
    private String AccessURL; 			//保存Access連接字符串	
    private String AccessPath; 			//保存Access數據庫的路徑	
    
    private String MySqlDriver;			//MYSQL Server驅動程序
    private String MySqlURL; 			//MYSQL Server連接字符串
        
    private String SqlDriver;			//SQL Server驅動程序
    private String SqlURL; 				//SQL Server連接字符串
    
    private String OracleDriver;		//Oracle驅動程序
    private String OracleURL; 			//Oracle連接字符串
	
    
    
    public DBConnection()
    {
    	conn = null;
    }

	public  Connection getConn()
	{

		DBType= new Function().StrToInt(getPara("DBType"));
	
		switch(DBType)
		{
			case 0:return(getConnToAccess());
			case 1:return(getConnToMySql());
			case 2:return(getConnToSql());
			case 3:return(getConnToOracle());
			default:return null;
		}	
	}
	
	
	
	public String getPara(String ParaName) 
	{
		FileName="../../DBConfig.property";
		Properties prop= new Properties();
		try
		{
			InputStream is = getClass().getResourceAsStream(FileName);
			prop.load(is);
			if(is!=null) is.close();
		}
		catch(Exception e) {
			return "Error!";
		}
		return prop.getProperty(ParaName);
	}
	
	
	
    public Connection getConnToAccess()
    {
		try{
	    	AccessDriver = getPara("AccessDriver");		
	    	AccessURL = getPara("AccessURL");
	    	AccessPath = getPara("AccessPath");
			AccessURL=AccessURL+AccessPath;
	    	Class.forName(AccessDriver).newInstance();
	    	conn = DriverManager.getConnection(AccessURL);
	    	}catch(Exception e){
	    		//e.printStackTrace();
		    	//return "操作數據庫出錯，請仔細檢查" ;
	    		//System.err.println(e.getMessage());
	    	}
	    return conn;
    }
     
     
    public Connection getConnToMySql()
    {
		try{
	 		MySqlDriver = getPara("MySQLDriver");	
	    	MySqlURL = getPara("MySQLURL");
	    	Class.forName(MySqlDriver).newInstance();
	    	conn = DriverManager.getConnection(MySqlURL);
	    	}catch(Exception e){
	    		//e.printStackTrace();
		    	//return "操作數據庫出錯，請仔細檢查" ;
		    	//System.err.println(e.getMessage());
	    	}
	    return conn;
    } 
    
	 
	public Connection getConnToSql()
	{     	
     	try{
     		SqlDriver = getPara("SQLDriver");
        	SqlURL = getPara("SQLURL");
	    	Class.forName(SqlDriver).newInstance();
	    	conn = DriverManager.getConnection(SqlURL);
	    	}catch(Exception e){
	    		e.printStackTrace();
	    		//return "操作數據庫出錯，請仔細檢查" ;
	    		//System.err.println(e.getMessage());
	    	}
	    return conn;
    }
    
	 
    public Connection getConnToOracle()
    {     	
		try{
	 		OracleDriver = getPara("OracleDriver");	
	    	OracleURL = getPara("OracleURL");
	    	Class.forName(OracleDriver).newInstance();
	    	conn = DriverManager.getConnection(OracleURL);
	    	}catch(Exception e){
	    		//e.printStackTrace();
	    		//return "操作數據庫出錯，請仔細檢查" ;
	    		//System.err.println(e.getMessage());
	    	}
    return conn;
    }
    
    	
   //關閉數據庫連接
   /* public void Close()
    {
        try{
            Conn.close(); 
        }catch(SQLException sqlexception){
            sqlexception.printStackTrace();
        }
    }*/
    
    
    public static void main(String[] args)
	{	
		DBConnection DBConn = new DBConnection();
		try
		{
			Connection Conn = DBConn.getConn();	
			ResultSet rs = null;
			Statement stmt = Conn.createStatement(1004,1007);
	    	String Sql = "select * from Admin where AdminName='dream' and AdminPwd='dream'";
	    	rs = stmt.executeQuery(Sql);
	    	rs.next();
	    	if (!rs.isAfterLast()) 
			{
				System.out.println(rs.getString("AdminName")+"登錄成功!");
			}
			else
			{
				System.out.println("登錄失敗!");
			}
		}
		catch(SQLException e)
		{
			System.out.println(e.getMessage().toString());
		}
	}
    
}