package project3;
import java.sql.*;
public class condb //構選函數必須同包名一致
{
	String sd="sun.jdbc.odbc.JdbcOdbcDriver";
	String sc="jdbc:odbc:prodb";
	Connection con=null;
	ResultSet rs=null;
	public condb()
	{
		try
		{
			Class.forName(sd);
		}
		catch(java.lang.ClassNotFoundException e)
		{
			System.err.println(e.getMessage());
		}
	}
	public ResultSet executeQuery(String sql)
	{
		try
		{
			con=DriverManager.getConnection(sc);
			Statement stmt=con.createStatement();
			rs=stmt.executeQuery(sql);

		}
		catch(SQLException ex)
		{
			System.err.println(ex.getMessage());
		}
		return rs;
	}
	public int executeUpdate(String sql)
	{
		int result=0;
		try
		{
			con=DriverManager.getConnection(sc);
			Statement stmt=con.createStatement();
			result=stmt.executeUpdate(sql);
		}
		catch(SQLException ex)
		{
			System.err.println(ex.getMessage());
		}
		return result;
		
	}
	public void close(){
		try{
			if(con!=null)
			con.close();
		}catch(Exception e){
			System.out.print(e);
		}
	}
}