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
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
| /*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package csl;
import java.io.IOException;
import java.sql.*;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.logging.Level;
//import org.apache.log4j.Logger;
import java.util.logging.Logger;
import javax.faces.bean.ApplicationScoped;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.SessionScoped;
import javax.faces.model.SelectItem;
import javax.sql.rowset.CachedRowSet;
/**
*
* @author */
@ManagedBean (name="ManagedBeanO")
@ApplicationScoped
public class ManagedBeanO{
private List<SelectItem> mesElements = null;
private static Statement statement;
private String maValeur;
private Connection connectedUser;
private String host;
private String port;
private String baseName, user, mdp, driver, url;
private Connection connection=null;
private String Orac= "Connect";
private final static Logger logger = Logger.getLogger(ManagedBeanO.class.getName());
public String getMaValeur() {
return maValeur;
}
public void setMaValeur(String maValeur) {
this.maValeur = maValeur;
}
public String getHost() {
return host;
}
public void setHost(String host) {
this.host = host;
}
public String getPort() {
return port;
}
public void setPort(String port) {
this.port = port;
}
public String getBaseName() {
return baseName;
}
public void setBaseName(String baseName) {
this.baseName = baseName;
}
public String getUser() {
return user;
}
public void setUser(String user) {
this.user = user;
}
public String getMdp() {
return mdp;
}
public void setMdp(String mdp) {
this.mdp = mdp;
}
public String getDriver() {
return driver;
}
public void setDriver(String driver) {
this.driver = driver;
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
public Connection getConnection() {
return connection;
}
public void setConnection(Connection connection) {
this.connection = connection;
}
public String navigation () throws Exception
{
return Orac;
}
public String process() throws Exception
{
if(connectedUser == null) {
connectedUser = getConnection(host,port,baseName,user,mdp );
}
return Orac;
}
public Connection getConnectedUser() throws Exception {
if(connectedUser == null) {
connectedUser = getConnection(host,port,baseName,user,mdp );
}
return connectedUser ;
}
public void setConnectedUser(Connection connectedUser) {
this.connectedUser = connectedUser;
}
/**
* Gets connection
* @param host host
* @param port port number
* @param baseName base name
* @param user user name
* @param password password
* @return connection
* @throws TechnicalException
*/
private Connection getConnection(String host, String port, String baseName, String user, String password) throws Exception
{
// Driver Oracle
driver = "oracle.jdbc.driver.OracleDriver";
// URL de la connexion
//url = "jdbc:oracle:thin:@"+host+":"+port+":"+baseName;
url = "jdbc:oracle:thin:@"+"172.30.2.21"+":"+"1521"+":"+"PC9BIDEV";
try {
Class.forName(driver);
// On obtient la connexion
connection = DriverManager.getConnection(url, "TMA_LOGICA", "TMA_LOGICA");
logger.info("Connection obtenue");
// On retourne la connexion
return connection;
} catch (SQLException e) {
logger.warning("Incorrect Connection Data.");
throw new TechnicalException("No-Connexion-Established-003");
}
catch (ClassNotFoundException e) {
// logger).fatal("Inexistent or Incorrect Driver.");
throw new Exception("Driver-Not-Exist-004");
}
}
public Iterable<String> getAll()
{ try {
ArrayList<String> unelist = new ArrayList();
try {
statement = connectedUser.createStatement();
} catch (SQLException ex) {
Logger.getLogger(ManagedBeanO.class.getName()).log(Level.SEVERE, null, ex);
}
Statement stmt = null;
try {
stmt = connectedUser.createStatement();
} catch (SQLException ex) {
Logger.getLogger(ManagedBeanO.class.getName()).log(Level.SEVERE, null, ex);
}
ResultSet result = null;
try {
result = stmt.executeQuery("SELECT TABLE_NAME FROM all_tables");
} catch (SQLException ex) {
Logger.getLogger(ManagedBeanO.class.getName()).log(Level.SEVERE, null, ex);
}
try {
while(result.next())
{
String name=result.getString("TABLE_NAME").toString();
unelist.add(name);
}
} catch (SQLException ex) {
Logger.getLogger(ManagedBeanO.class.getName()).log(Level.SEVERE, null, ex);
}
// CachedRowSet crs = new com.sun.rowset.CachedRowSetImpl();
//crs.populate(result);
return (List)unelist;
}
finally {
try {
connectedUser.close();
} catch (SQLException ex) {
Logger.getLogger(ManagedBeanO.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
public List<SelectItem> getMesElements()
{
if (mesElements == null) {
mesElements = new ArrayList<SelectItem>();
for (String val : getAll())
{
mesElements.add(new SelectItem(val));
}
}
return mesElements;
}
} |
Afficher le résultat d'une requête dans combo
Répondre avec citation
Partager