package com.lonton.par;

import java.sql.*;

public class ConnectDB {
	Connection conn = null;
	//Statement stmt = null;
	//通過jdbc-odbc橋連接數據庫
    public Connection getConnection(){
    	String uri = "sun.jdbc.odbc.JdbcOdbcDriver";
    	String url = "jdbc:odbc:UnionMSC";
    	try{
    		Class.forName(uri);
    		conn = DriverManager.getConnection(url,"system","lonton");
    	}catch(Exception e){
    		e.printStackTrace();
    	}
    	return conn;
    }
    
    //關閉數據庫連接
    public void closeCon(){
    	try{
    	}
    	finally{
    		try{
	    		if(conn != null){
	    			conn.close();
    		}
    		}catch(SQLException e){
    			e.printStackTrace();
    		}
    	}
    	
    }
}