Extraire l'information d'un Bean [Résolu]

[machipot]

Bonjour,
quelqu'un peut-il m'aider a me montrer comment extraire de l'information de ma bean et puis l'afficher sur ma page .jsp?
merci
voici le bout de ma page .jsp

Code :

1
2
3
4
5
6
 
<% 
BeanEmployee bean = new BeanEmployee();
findEmployeeId emp = new findEmployeeId();
bean = emp.findEmoloyeeId(request.getAttribute("employeeid");
%>

voici ma class bean:

Code :

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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
package DBconnect;
 
public class BeanEmployee {
 
    private int employeeid;
    private String username;
    private String password;
    private String team;
    private String firstname;
    private String lastname;
    private String email;
    private String telephone;
    private boolean supervisor;
    private boolean admin;
 
    public BeanEmployee() {
        employeeid = 0;
        username = null;
        password = null;
        team = null;
        firstname = null;
        lastname = null;
        email = null;
        telephone = null;
        supervisor = false;
        admin = false;
 
 
    }
 
    public int getEmployeeid() {
        return employeeid;
    }
 
    public void setEmployeeid(int employeeid) {
        this.employeeid = employeeid;
    }
 
    public String getUsername() {
        return username;
    }
 
    public void setUsername(String username) {
        this.username = username;
    }
 
    public String getPassword() {
        return password;
    }
 
    public void setPassword(String password) {
        this.password = password;
    }
 
    public String getTeam() {
        return team;
    }
 
    public void setTeam(String team) {
        this.team = team;
    }
 
    public String getFirstname() {
        return firstname;
    }
 
    public void setFirstname(String firstname) {
        this.firstname = firstname;
    }
 
    public String getLastname() {
        return lastname;
    }
 
    public void setLastname(String lastname) {
        this.lastname = lastname;
    }
 
    public String getEmail() {
        return email;
    }
 
    public void setEmail(String email) {
        this.email = email;
    }
 
    public String getTelephone() {
        return telephone;
    }
 
    public void setTelephone(String telephone) {
        this.telephone = telephone;
    }
 
    public boolean isSupervisor() {
        return supervisor;
    }
 
    public void setSupervisor(boolean supervisor) {
        this.supervisor = supervisor;
    }
 
    public boolean isAdmin() {
        return admin;
    }
 
    public void setAdmin(boolean admin) {
        this.admin = admin;
    }
 
 
}

et voici ma methode qui alimente la Bean pour etre utilisé plus tard au niveau de la page web.

Code :

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
package DBconnect;
 
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
public class findEmployeeId {
    public BeanEmployee findEmoloyeeId(int emplId) {
 
        BeanEmployee bEmployee = new BeanEmployee();
        try {
 
            Connect co = new Connect();
            Connection conn = Connect.ConnectDB();
 
            Statement st =
                    conn.createStatement(
                    ResultSet.TYPE_SCROLL_INSENSITIVE,
                    ResultSet.CONCUR_READ_ONLY);
            ResultSet rec;
 
            rec = st.executeQuery("SELECT EmployeeID, UserName, Password, Team, FirstName, LastName, Email, Tel, Supervisor, Admin "
                    + " FROM Users Where EmployeeID = " + emplId + ";");
 
            //rec.first();
            //System.out.println(rec.getInt("EmployeeID")+ "\n" + rec.getString("FirstName")+ "\n" + rec.getString("LastName") );
 
 
            // int ee = rec.getRow();
            while (rec.next()) {
 
                //be.setEmployeeid(new Integer(rec.getInt("EmployeeID")));
                bEmployee.setEmployeeid(rec.getInt("EmployeeID"));
                bEmployee.setUsername(rec.getString("UserName"));
 
                bEmployee.setPassword(rec.getString("Password"));
                bEmployee.setTeam(rec.getString("Team"));
                bEmployee.setFirstname(rec.getString("FirstName"));
                // bEmployee.setFirstname("aaaaFirstName");
 
 
                bEmployee.setLastname(rec.getString("LastName"));
                bEmployee.setEmail(rec.getString("Email"));
                bEmployee.setTelephone(rec.getString("Tel"));
                bEmployee.setSupervisor(rec.getBoolean("Supervisor"));
                bEmployee.setAdmin(rec.getBoolean("Admin"));
            }
 
            conn.close();
            st.close();
 
 
            System.out.println("passer apres ---<<>>---" + bEmployee.getEmployeeid() + "/" + bEmployee.getFirstname() + "/");
 
 
 
        } catch (SQLException s) {
            System.out.println("SQL Error: "
                    + "\n" + "s: " + s.toString() + " "
                    + "\n" + "Error code: " + s.getErrorCode() + " "
                    + "\n" + "sale state: " + s.getSQLState() + "  "
                    + "\n" + "message: " + s.getMessage());
 
            //     System.out.println(employeeID+"/" + "\n" + username+"/" + "\n" +password+"/"+ "\n" + team+"/"+ "\n" + firstname+"/"+ "\n" + lastname+"/"+ "\n" +email+"/"+ "\n" +telephone+"/"+ "\n" +supervisor+"/"+ "\n" +admin+"/"+ "\n" +createdBy+"/" ) ;
 
        } catch (Exception e) {
            System.out.println("Error: " + e.toString() + e.getMessage());
 
 
        }
 
 
        return bEmployee;
 
 
    }
}

[machipot]

Est-ce que j'ai oublié de donner plus de détails. Personne ne répond à ma question et pourtant c'est très basic.
Quelqu’un a-t-il une idée?
Merci pour l'aide.

[lucimed]

Bonjour,

En supposant que ton code fonctionne et que dans ta JSP, tu as bien récupéré les infos dans l'objet "bean", tu peux :
- soit continuer à utiliser les scriptlets pour afficher les propriétés de l'objet <%= bean.getUsername() %>
- soit utiliser JSTL <c:out value="${bean.username}" />

[machipot]

merci beaucoup Lucimed,
ça marche maintenant et c'est grace a toi...
et pourtant hier j'avais beau essayé, mais rien ne s'affichait.
A+