| 12
 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