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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
|
public class EmployeListeAction extends Action {
protected ArrayList getEmployes(){
Employe employe = null;
ArrayList employes = new ArrayList();
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
ServletContext context = servlet.getServletContext();
DataSource dataSource = (DataSource)context.getAttribute(Globals.DATA_SOURCE_KEY);
try{
conn = dataSource.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from employes"
while (rs.next()){
employe = new Employe();
employe.setUserName(rs.getString("username"));
employe.setName(rs.getString("name"));
...
...
...
employes.add(employe);
}
}catch (SQLException e){
System.err.println(e.getMessage());
}finally{
if (rs !=null){
try{
rs.close();
}catch (SQLException sqle){
System.err.println(sqle.getMessage());
}
rs = null;
}
if (stmt !=null){
try{
stmt.close();
}catch (SQLException sqle){
System.err.println(sqle.getMessage());
}
stmt = null;
}
if (conn !=null){
try{
conn.close();
}catch (SQLException sqle){
System.err.println(sqle.getMessage());
}
conn = null;
}
}
return employes;
}
public ActionForward execute(ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException {
//Cible par défaut en cas de succés
String target = new String("success");
ArrayList employes = null;
employes = getEmployes();
//Cible en cas d'echec
if (employes == null){
target = new String("login");
}else{
request.setAttribute("employes", employes);
System.out.println("EmployeListeAction EMPLOYES"+request.getAttribute("employes"));
}
System.out.println("EmployeListeAction LoginAction ********** FINAL ************* execution...");
System.err.println("EmployeListeAction done.");
return (mapping.findForward(target));
}
} |
Partager