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