package bean;
import java.sql.*;
public class restaurantJdbcBean{
	String jdbcOdbcDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	String gConnection = "jdbc:odbc:restaurant";
	Connection connect = null;
	ResultSet rs = null;
	public restaurantJdbcBean(){
		try{
			Class.forName(jdbcOdbcDriver);
		}
		catch(java.lang.ClassNotFoundException e){
			System.err.println(e.getMessage());
		}
	}             
	public ResultSet executeQuery(String sql){
		try{
		connect = DriverManager.getConnection(gConnection);
		Statement stmt = connect.createStatement();
		rs = stmt.executeQuery(sql);
		}
		catch(SQLException ex){
			System.err.println(ex.getMessage());
		}
		return rs;
	}
	public int executeUpdate(String sql){
		int result=0;
		try{
			connect=DriverManager.getConnection(gConnection);
			Statement stmt=connect.createStatement();
			result=stmt.executeUpdate(sql);
		}
		catch(SQLException ex){
		   System.err.println(ex.getMessage());
		}
		return result;
	}
}