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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
|
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
import javax.faces.bean.ManagedBean;
import javax.faces.bean.SessionScoped;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.faces.model.SelectItem;
/**
*
* @author utilisateur
*/
@ManagedBean(name="Beanequi")
@SessionScoped
public class Beanequi {
private String numequi;
private String nomresp;
private String selectedItem;
private Connection con;
public void setnumequi(String numequi){
this.numequi=numequi;
}
public void setnomresp(String nomresp){
this.nomresp=nomresp;
}
public String getnumequi()
{
return numequi;
}
public String getnomresp()
{
return nomresp;
}
public String getSelectedItem() {
return selectedItem;
}
public void setSelectedItem(String selectedItem) {
this.selectedItem = selectedItem;
}
public List getSelectItems() {
List selectItems = new ArrayList();
selectItems.add(new SelectItem(null, "-- Choisissez --"));
selectItems.add(new SelectItem("MACHINES TOURNANTES", "MACHINES TOURNANTES"));
selectItems.add(new SelectItem("CHAUDRONNERIE", "CHAUDRONNERIE"));
selectItems.add(new SelectItem("ELECTRICITE", "ELECTRICITE"));
selectItems.add(new SelectItem("INSTRUMENTATION", "INSTRUMENTATION"));
selectItems.add(new SelectItem("LOGISTIQUE", "LOGISTIQUE"));
selectItems.add(new SelectItem("PEINTURE", "PEINTURE"));
selectItems.add(new SelectItem("GENIE CIVIL", "GENIE CIVIL"));
selectItems.add(new SelectItem("MANUTENTION", "MANUTENTION"));
selectItems.add(new SelectItem("ECHAFFAUDAGE", "ECHAFFAUDAGE"));
// The values are the keys passed to the selectItem property.
// The labels are those what you see on the menu.
return selectItems;
}
public String connexionBD() throws SQLException {
String result=" ";
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println ("driver etablie");
}
catch(Exception e)
{
System.out.println ("erreur:Driver int" +
"rouvable");
}
try
{
String URL = "jdbc:oracle:thin:@localhost:1521:gmao";
String USER = "pfe";
String PASSWD = "gmao";
con =DriverManager.getConnection(URL,USER, PASSWD);
System.out.println ("connexion base pfe etablie");
}
catch(Exception e)
{
System.out.println ("erreur: base introuvable");
}
Statement st = con.createStatement();
int val = 0;
try {
val = st.executeUpdate("insert into equipe_execution values( '"+numequi+"','" +nomresp + "', '"+selectedItem+"')");
} catch (SQLException ex) {
Logger.getLogger(Beanequi.class.getName()).log(Level.SEVERE, null, ex);
}
System.out.println(val);
return result;
}
/** Creates a new instance of Beanequi */
public Beanequi() {
}
} |
richfaces: probléme avec a4j:commandButton
Répondre avec citation
Partager