package test;
import java.sql.*;
public class JdbcBean
{
    Connection con=null;
    ResultSet rs=null;
    //實例化，裝載JDBC驅動程序
	public JdbcBean()
	{
		try{
		     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		    }
		    catch(ClassNotFoundException e) {}
	}
	//返回查詢后的數據集
	public ResultSet executeQuery(String sql)
	{
	    String url="jdbc:odbc:TestData";
        String username="";
        String password="";
        try{
		     con=DriverManager.getConnection(url,username,password);
		     Statement stmt=con.createStatement();
		     rs=stmt.executeQuery(sql);
		   }
		   catch(SQLException e) {}
		return rs;
	}
	//關閉數據庫
	public void closeDB()
	{
		try{
		    rs.close();
		    con.close();
		  }catch(SQLException e) {}
	}
}