1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Connection conRes = null;
ResultSet resultset = null;
Statement statement = null;
// Chargement des Drivers JDBC d'Oracle
Class.forName("oracle.jdbc.driver.OracleDriver");
// Connexion a la base
Class.forName("oracle.jdbc.driver.OracleDriver");
String oracleURL = "jdbc:oracle:thin:@xxx.xxx.Xx.xxx:1521:ORACLE1"; //oracle23
String username = "e-work";
String password = "e-work";
conRes = DriverManager.getConnection( oracleURL , username , password );
String query = new String();
query = "SELECT TXTTRAVELLER, TXTSERVICE, TXTCDR, OM, TXTPROJET, TXTTELEPHONE, AEROPORTDEPART, AEROPORTARRIVEE, DATEALLER, HEUREALLER, NUMEROALLER, DATERETOUR, HEURERETOUR, NUMERORETOUR, CLASSE, PRIX, OM from DEMANDE_DE_BILLET where EFOLDERID="+FolderID;
statement = conRes.createStatement();
resultset = statement.executeQuery(query);
if(resultset.next())
{ ... |
Partager