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");
}
}
} |
Partager