Error in schedule creation

0

My problem is that I need to create a schedule with data from a database But what happens is that at times like 10: 00-15: 00 classes are not added in the rows of 10: 00-15 only in the first and last hour I leave an image of how it should look

This is my code of my initial class

DefaultTableModel modelotabla=new DefaultTableModel();
    String lunes,martes,miercoles,jueves,viernes,sabado,domingo,dias;
    String sql="SELECT * from clases";
    ResultSet rs;
    Connection conn;
    conn = conexion.getConnection(); //Para tener conexión a la Base de Datos.
    try{
        Statement stmt = conn.createStatement();
        rs=stmt.executeQuery(sql);
        rs.beforeFirst();
        rs.next();
        dias=rs.getString(4);
        String [] dia = dias.split(",");
        for(int i=0;i<dia.length;i++){
            switch (dia[i]) {
                case "Lunes":
                    lunes();
                    break;
                case "Martes":

                    break;
                case "Miercoles":

                    break;
                case "Jueves":

                    break;
                case "Viernes":

                    break;
                case "Sabado":

                    break;
                case "Domingo":

                    break;
                default:

                    break;
            }
    }}
    catch(Exception e){
        System.out.println(e);
    }

Here is my class code Monday

ResultSet rs;
    String nuevalinea = System.getProperty("line.separator");
    jTable1.setRowHeight(40);
        Connection conn;
        conn = conexion.getConnection(); //Para tener conexión a la Base de Datos.
        String sql = "SELECT * FROM clases ";
        try{
        Statement stmt = conn.createStatement();
        rs=stmt.executeQuery(sql);
        rs.beforeFirst();

        while (rs.next()) {
        String lunes = rs.getString(5);
        String Clase=rs.getString(2);
        String[] lun=lunes.split("-");
        for(int c=0;c<2;c++){
            switch(lun[c]){
            case"10:00":
                String a=String.valueOf(jTable1.getValueAt(0, 1));
                String b = a+Clase+",";
                jTable1.setValueAt(b, 0, 1);
        break;
            case"11:00":
                a=String.valueOf(jTable1.getValueAt(1, 1));
                b = a+Clase+",";
                jTable1.setValueAt(b, 1, 1);
        break;
            case"12:00":
                a=String.valueOf(jTable1.getValueAt(2, 1));
                b = a+Clase+",";
                jTable1.setValueAt(b, 2, 1);
        break;
            case"13:00":
                a=String.valueOf(jTable1.getValueAt(3, 1));
                b = a+Clase+",";
                jTable1.setValueAt(b, 3, 1);
        break;
            case"14:00":
                a=String.valueOf(jTable1.getValueAt(4, 1));
                b = a+Clase+",";
                jTable1.setValueAt(b, 4, 1);
        break;
            case"15:00":
                a=String.valueOf(jTable1.getValueAt(5, 1));
                b = a+Clase+",";
                jTable1.setValueAt(b, 5, 1);
        break;
            case"15:30-16:00":
                a=String.valueOf(jTable1.getValueAt(6, 1));
                b = a+Clase+",";
                jTable1.setValueAt(b, 6, 1);
        break;
            case"16:00-16:30":
                a=String.valueOf(jTable1.getValueAt(7, 1));
                b = a+Clase+",";
                jTable1.setValueAt(b, 7, 1);
        break;
            case"16:30-17:00":
                a=String.valueOf(jTable1.getValueAt(8, 1));
                b = a+Clase+",";
                jTable1.setValueAt(b, 8, 1);
        break;
            case"17:00-17:30":
                a=String.valueOf(jTable1.getValueAt(9, 1));
                b = a+Clase+",";
                jTable1.setValueAt(b, 9, 1);
        break;
            case"17:30-18:00":
                a=String.valueOf(jTable1.getValueAt(10, 1));
                b = a+Clase+",";
                jTable1.setValueAt(b, 10, 1);
        break;
            case"18:00-18:30":
                a=String.valueOf(jTable1.getValueAt(11, 1));
                b = a+Clase+",";
                jTable1.setValueAt(b, 11, 1);
        break;
            case"18:30-19:00":
                a=String.valueOf(jTable1.getValueAt(11, 1));
                b = a+Clase+",";
                jTable1.setValueAt(b, 11, 1);
        break;
        }
        }
        }
        }catch(Exception e){
            System.out.println(e);
        }

Thank you very much

    
asked by Martinez Obed Noe 25.04.2018 в 07:32
source

0 answers