1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
while(k<nbr_emp)
{
JOptionPane.showMessageDialog(null, String.valueOf(Tab[k]));
R = (ResultSet) St.executeQuery("SELECT Heure_arrivée,Heure_départ,Temps_pause FROM plannifier WHERE Num_service=" + num_service + " AND Num_Emp=" + Tab[k] + ";");
Planning.calcul_heures ch = new Planning.calcul_heures();
String[] TabResult = new String[7];
int i = 0;
while(R.next())
{
arrive = R.getString(1);
depart = R.getString(2);
pause = R.getString(3);
TabResult[i] = ch.Recup_Infos(arrive, depart, pause);
JOptionPane.showMessageDialog(null, TabResult[i]);
i++;
}
Total = ch.Total_heures(TabResult[0], TabResult[1], TabResult[2], TabResult[3], TabResult[4], TabResult[5], TabResult[6]);
JOptionPane.showMessageDialog(null, Total);
//edt_impr ep = new edt_impr();
//ep.lb_l1.setText(TabResult[0]);
// Fin - Récupération des horaires par jour pour l'employé en cours
k++;
} |
Partager