package dbBean;
import java.sql.*;
public class DBBean
{
	private String driverStr="sun.jdbc.odbc.JdbcOdbcDriver";
	private String connStr="jdbc:odbc:USER";
	private Connection conn;
	private Statement stmt;

	public DBBean()
	{
		try{
			//加載驅動程序
			System.out.println("driver error!?????????????");
			Class.forName(driverStr);
			
		}
		catch(ClassNotFoundException ex){
			//System.out.println(ex.getMessage());
			System.out.println("driver error!?????????????");
			
		}
	}
	
	public ResultSet executeQuery(String sql)
	{
		ResultSet rs=null;
		try{
			//獲取驅動程序對象和指定數據庫之間的連接對象
			conn=DriverManager.getConnection(connStr,"","");
			//建立語句對象
			stmt=conn.createStatement();
			//執行SQL語句，返回一個結果集對象
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException ex){
			System.out.println(ex.getMessage());
		}
		return rs;
	}
	
	public int executeUpdate(String sql)
	{
		int result=0;
		try{
			conn=DriverManager.getConnection(connStr,"","");
			stmt=conn.createStatement();
			result=stmt.executeUpdate(sql);
		}
		catch(SQLException ex){
			System.out.println(ex.getMessage());
		}
		return result;
	}
	
	public void close()
	{
		try{
			//關閉語句對象
			stmt.close();
			//關閉連接對象
			conn.close();
		}
		catch(SQLException ex){
			System.out.println(ex.getMessage());
		}
	}
}