Noname1.java *

import java.util.*;
import pd.dbWrap.*;
/**
* Liste des employés - version Wrapper.
* - Source de données ODBC: EmplDept
*
* @author Peter DAEHNE - HEG-Genève
* @version Version 2.0
*/
public class ListeEmployes {
private static void lister (EmployeColl emplColl) throws DataBaseException {
System.out.println("Liste des employés"); System.out.println("==================");
Vector aL = emplColl.getAll("NomEmpl, PrenomEmpl");
Iterator it = aL.iterator();
while (it.hasNext()) {
Employe e = (Employe)it.next();
System.out.println(e.getNomEmpl() + " " + e.getPrenomEmpl());
}
}// lister
public static void main (String args[]) throws Exception {
DataBaseConnection dbCon = new DataBaseConnection("EmplDept");
lister(EmployeColl.getInstance(dbCon));
dbCon.close();
}// main
}// ListeEmployes
import java.util.*;
import pd.dbWrap.*;
/**
* Création d'un employé - version Wrapper.
* - Source de données ODBC: EmplDept
*
* @author Peter DAEHNE - HEG-Genève
* @version Version 2.0
*/
public class CreerEmploye {
private static java.sql.Timestamp dateDuJour = new java.sql.Timestamp(Calendar.getInstance().getTimeInMillis());
private static void creer (DataBaseConnection dbCon) throws DataBaseException {
Employe employe = new Employe(null,"DAEHNE","Peter",new Integer(3), dateDuJour, new Integer(1), new Integer(2));
employe.insert();
System.out.println("Employé inséré: " + employe.getNomEmpl() + " " + employe.getPrenomEmpl());
}// creer
public static void main (String args[]) throws DataBaseException {
DataBaseConnection dbCon = new DataBaseConnection("EmplDept");
Employe.connect(dbCon);
creer(dbCon);
dbCon.close();
}// main
}// CreerEmploye

import java.util.*;
import pd.dbWrap.*;
/**
* Modification d'un employé - version Wrapper.
* - Source de données ODBC: EmplDept
*
* @author Peter DAEHNE - HEG-Genève
* @version Version 2.0
*/
public class ModifEmploye {
private static void modif (EmployeColl emplColl) throws DataBaseException {
Vector aL = emplColl.getWhere("NomEmpl = 'DAEHNE'",null);
Employe employe = (Employe)aL.get(0);
employe.setPrenomEmpl("Alexis");
employe.update();
System.out.println("Employé modifié: " + employe.getNomEmpl() + " " + employe.getPrenomEmpl());
}// modif
public static void main (String args[]) throws DataBaseException {
DataBaseConnection dbCon = new DataBaseConnection("EmplDept");
Employe.connect(dbCon);
modif(EmployeColl.getInstance(dbCon));
dbCon.close();
}// main
}// ModifEmploye
import java.util.*;
import pd.dbWrap.*;
/**
* Suppression d'un employé - version Wrapper.
* - Source de données ODBC: EmplDept
*
* @author Peter DAEHNE - HEG-Genève
* @version Version 2.0
*/
public class DeleteEmploye {
private static void del (EmployeColl emplColl) throws DataBaseException {
Vector aL = emplColl.getWhere("NomEmpl = 'DAEHNE'",null);
Employe employe = (Employe)aL.get(0);
employe.delete();
System.out.println("Employé supprimé: " + employe.getNomEmpl() + " " + employe.getPrenomEmpl());
}// modif
public static void main (String args[]) throws DataBaseException {
DataBaseConnection dbCon = new DataBaseConnection("EmplDept");
Employe.connect(dbCon);
del(EmployeColl.getInstance(dbCon));
dbCon.close();
}// main
}// DeleteEmploye