package Classes_SFA;

import java.sql.*;
import java.util.Vector;

public class Conexao{
   private Connection con = null;
   private Statement stmt = null;
	
   private String user = "root";
   private String password = "master";
   private String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
   private String url = "jdbc:odbc:DSI_SFA";
   

   public Conexao()
   {
   	
   }

   
   public ResultSet getResultSet(String sql)
   {
        
        ResultSet rs=null;
        
        try{
           Class.forName(driver);
        }
        catch(Exception e){
           System.out.println("O driver do banco não foi encontrado.");

        }

           try{
              con = DriverManager.getConnection(url, user, password);
              Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
              rs = stmt.executeQuery(sql);
   }
              catch(SQLException e){
              System.out.println(e.toString());
           }
	return rs;
	}
}