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
| package com.test;
import com.test.TechnicalException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ManagedBeanO {
private String valeur;
private static String host, port, baseName, user, mdp, driver, url;
private static Connection connection;
public static String getHost() {
return host;
}
public static void setHost(String host) {
ManagedBeanO.host = host;
}
public static String getPort() {
return port;
}
public static void setPort(String port) {
ManagedBeanO.port = port;
}
public static String getBaseName() {
return baseName;
}
public static void setBaseName(String baseName) {
ManagedBeanO.baseName = baseName;
}
public static String getUser() {
return user;
}
public static void setUser(String user) {
ManagedBeanO.user = user;
}
public static String getMdp() {
return mdp;
}
public static void setMdp(String mdp) {
ManagedBeanO.mdp = mdp;
}
public static String getDriver() {
return driver;
}
public static void setDriver(String driver) {
ManagedBeanO.driver = driver;
}
public static String getUrl() {
return url;
}
public static void setUrl(String url) {
ManagedBeanO.url = url;
}
public static Connection getConnection() {
return connection;
}
public static void setConnection(Connection connection) {
ManagedBeanO.connection = connection;
}
public String getValeur() {
return this.valeur;
}
public void setValeur(String valeur) {
this.valeur= valeur;
}
/**
* 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 TechnicalException {
// Driver Oracle
driver = "oracle.jdbc.driver.OracleDriver";
// URL de la connexion
url = "jdbc:oracle:thin:@"+host+":"+port+":"+baseName;
try {
Class.forName(driver);
// On obtient la connexion
connection = DriverManager.getConnection(url, user, password);
//logger.info("Connection obtenue");
// On retourne la connexion
return connection;
} catch (SQLException e) {
//logger.warn("Incorrect Connection Data.");
throw new TechnicalException("No-Connexion-Established-003");
}
catch (ClassNotFoundException e) {
//logger.fatal("Inexistent or Incorrect Driver.");
throw new TechnicalException("Driver-Not-Exist-004");
}
}
} |
