package db;
import java.sql.*;
public class Data{
	String sd="sun.jdbc.odbc.JdbcOdbcDriver";
	String sc="jdbc:odbc:busession";
	ResultSet rs=null;
	Connection conect=null;
	public Data(){
		try{
			Class.forName(sd);
		}catch(java.lang.ClassNotFoundException e){
			System.err.println(e.getMessage());
		}
	}
	public ResultSet executeQuery(String sql){
		try{
			conect=DriverManager.getConnection(sc);
			Statement stmt=conect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=stmt.executeQuery(sql);
		}catch(SQLException ex){
			System.err.println(ex.getMessage());
		}
		return rs;
	}
	public int executeUpdate(String sql){
		int result=0;
		try{
			conect=DriverManager.getConnection(sc);
			Statement stmt=conect.createStatement();
			result=stmt.executeUpdate(sql);
		}catch(SQLException er){
			System.err.println(er.getMessage());
		}
		return result;
	}
	public void close(){
		try{
			if(conect!=null){
				conect.close();
			}
		}catch(Exception e){
			System.out.println(e);	
		}
	}
	
}