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
|
try {
//Creation of the driver to use the Connection Pool
System.out.println("Loading underlying JDBC driver.");
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
System.out.println("JDBC driver loading : Done.");
} catch (ClassNotFoundException e) {
System.out.println("Error Setting up driver.");
e.printStackTrace();
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
}
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@test:1515:ORCL","system","system");
Statement stmt= con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String myReq= "(Select reference from document where id_nature=170 intersect select reference from document where revision='-')";
if(stmt.execute(myReq)){
System.out.println("requete ok");
ResultSet myResult = stmt.getResultSet();
while (myResult.next()){
System.out.println(myResult.getString(1));
}
}
else{
System.out.println("requete ko");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} |
Partager