@Override
    // Buscar todos los alojamientos disponibles
    public int seleccionarUsuarios(JTable pTable){       
        Connection conn = null;
        PreparedStatement stmt;
        ResultSet rs;
        
        try{              
            conn = SQLServerDAOFactory.createConnection();
            stmt = conn.prepareStatement("EXEC SPUSeleccionarUsuarios");
            rs = stmt.executeQuery();
            
            DefaultTableModel tabla= new DefaultTableModel();

            tabla.addColumn("Id Usuario");
            tabla.addColumn("Nombre");
            tabla.addColumn("Apellidos");
            tabla.addColumn("Tipo");

            while (rs.next()){
                Object dato[] = new  Object[4];
                for (int i=0; i<4; i++){
                    dato[i]=rs.getString(i+1);
                    if(i == 3){
                        switch(dato[i].toString()){
                            case "1":
                                dato[i] = "Administrador";
                                break;
                            case "2":
                                dato[i] = "Agente";
                                break;
                            case "3":
                                dato[i] = "Participante";
                                break;
                        }
                    }
                }
                tabla.addRow(dato);
            }

            pTable.setModel(tabla);
            
            return 1;
        } 
        catch(SQLException e){
            System.out.println("Message: " + e.getMessage() + "\n" + "Code: " + e.getErrorCode());
        } 
        finally{
            if(conn != null){
                try{
                    conn.close();
                }
                catch(SQLException e){
                    System.out.println("Message: " + e.getMessage() + "\n" + "Code: " + e.getErrorCode());
                }
            }
        }
        return -1;
    }