package modele;
import java.sql.SQLException;
import KClass.KAssurer_lecon;
import KClass.KEleve;
import net.ko.creator.KernelCreator;
import net.ko.kobject.KListObject;
import net.ko.ksql.KDBMysql;
public class RDVMoniteurEleve {
private KDBMysql db = new KDBMysql("localhost", "admin", "admin","autoecole");
private KAssurer_lecon assurerlecon = new KAssurer_lecon();
private KListObject<KAssurer_lecon> ListeAssurerLecon = new KListObject<KAssurer_lecon>(KAssurer_lecon.class);
public RDVMoniteurEleve() {
connexion();
}
public void connexion() {
try {
db.connect();
KernelCreator knl = new KernelCreator();
knl.connect(db);
knl.createClasses();
knl.saveAs("KClass");
System.out.println("Connexion � "+db.getBaseName());
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
System.out.println("Echec de la connexion");
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
System.out.println("Echec de la connexion");
}
}
public KListObject<KAssurer_lecon> recupererListeEleve(int idEleve) {
System.out.println("id eleve : "+idEleve);
KListObject<KAssurer_lecon> Kliste = new KListObject<KAssurer_lecon>(KAssurer_lecon.class);
Kliste.loadFromDb(db);
System.out.println(Kliste);
for (int i=0; i<Kliste.count(); i++){
if (Kliste.get(i).getIdELEVE() != idEleve){
Kliste.delete(i);
i--;
}
}
System.out.println(Kliste);
return Kliste;
}
public KAssurer_lecon getAssurerlecon() {
return assurerlecon;
}
public void setAssurerlecon(KAssurer_lecon assurerlecon) {
this.assurerlecon = assurerlecon;
}
public KListObject<KAssurer_lecon> getListeAssurerLecon() {
return ListeAssurerLecon;
}
public void setListeAssurerLecon(KListObject<KAssurer_lecon> listeAssurerLecon) {
ListeAssurerLecon = listeAssurerLecon;
}
}