public ResultSet retornarResultSet(String pSQL)throws Exception{
        Connection con = null;

        try {
            abrirConexao();
        } 
        catch (Exception ex) {
            throw ex;
        }
        try {
            
            Statement stmt = (Statement)conbco.createStatement();
            ResultSet retorno = stmt.executeQuery(pSQL);
            
            return retorno;
           
        }
        catch (SQLException sqle) {  
            return null;
        }
        catch (Exception ex) {
            ex.printStackTrace();
            return null;
        } 
        
        finally{
            //fecharconexao
        }
    }