Package GeneracionHorarios

Examples of GeneracionHorarios.Salon


        String cadObtClases = "SELECT horaIni,horaFin,codCurso,salon,dia FROM Clase;";
        Statement stm = AccesoBD.conn.createStatement();
        ResultSet rs = stm.executeQuery(cadObtClases);
        ArrayList<Clase> arrClases = new ArrayList<Clase>();
        while (rs.next()){
            Salon salon=SalonBD.buscarSalon(rs.getString(4),rs.getString(5));
            Clase clase =  new Clase (rs.getInt(1),rs.getInt(2),salon,CursoBD.buscarCurso(rs.getInt(3)));
            arrClases.add(clase);
        }
        rs.close();
        stm.close();
View Full Code Here


        pst.setString(1,salon);
        pst.setInt(2,tipoAlgoritmo);
        ResultSet rs = pst.executeQuery();
        ArrayList<Clase> arrClases = new ArrayList<Clase>();
        while (rs.next()){
            Salon salonClase=SalonBD.buscarSalon(rs.getString(4),rs.getString(5));
            Clase clase =  new Clase (rs.getInt(1),rs.getInt(2),salonClase,CursoBD.buscarCurso(rs.getInt(3)));
            arrClases.add(clase);
        }
        rs.close();
        pst.close();
View Full Code Here

            this.tblHorario.setValueAt(hora,i-8,0);
        }
    }

    private void cargarDisponibilidadSalon(String salon) {
        Iterator<Salon> itSalon;Salon auxSalon;
        try {
            AccesoBD.conexionODBC("horariosBD");
            itSalon = SalonBD.obtenerDisponibilidad(salon).iterator();
             while (itSalon.hasNext()){
                auxSalon = itSalon.next();
                for (int i=0;i<this.tblHorario.getRowCount();i++){
                    int dia = obtenerIndiceDia(auxSalon.getDia());
                    if (i<auxSalon.getHoraIni()|| i>(auxSalon.getHoraFin()-1))
                    {
//                        if (arrHorario[i][dia]==0)
//                        {
//                            this.tblHorario.setValueAt("NO DISPONIBLE",i,dia+1);
//                        }
View Full Code Here

        pst.setString(1,nombre);
        pst.setString(2,dia);
       
        ResultSet rs = pst.executeQuery();
        rs.next();
        Salon salonBuscado = new Salon(rs.getString(1),rs.getString(2),rs.getInt(3),rs.getString(4),rs.getInt(5),
                                       rs.getInt(6));
        pst.close();
        rs.close();
        return salonBuscado;
    }
View Full Code Here

        String cadBuscar = "SELECT salon,tipo, capacidad, dia,horaIni, horaFin FROM Salon WHERE salon =?;";
        PreparedStatement pst = AccesoBD.conn.prepareStatement(cadBuscar);
        pst.setString(1,nombre);
        ResultSet rs = pst.executeQuery();
        ArrayList<Salon> arrDisponibilidad = new ArrayList<Salon>();
        Salon salon;
        while (rs.next()){
            salon = new Salon(rs.getString(1),rs.getString(2),rs.getInt(3),rs.getString(4),rs.getInt(5),
                                       rs.getInt(6));
            arrDisponibilidad.add(salon);
        }
       
        pst.close();
View Full Code Here

    public Salon leer(String dia) throws IOException {
        String lineaSalon = lector.readLine();
        if (lineaSalon==null)
            throw new IOException();
        String [] datosSalon = lineaSalon.split(",");
        return new Salon (datosSalon[0],datosSalon[1],Integer.parseInt(datosSalon[2]),dia,Integer.parseInt(datosSalon[3])-8,
                          Integer.parseInt(datosSalon[4])-8);
    }
View Full Code Here

TOP

Related Classes of GeneracionHorarios.Salon

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.