Advertisement
Guest User

Untitled

a guest
May 11th, 2019
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. public class Jdbc {
  2. public Connection connection;
  3. public Jdbc() {
  4. try{
  5. Class.forName("oracle.jdbc.driver.OracleDriver");
  6. connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","DENIS","DENIS");
  7. connection.setAutoCommit(false);
  8. }catch(Exception e) {
  9. System.out.println("Error : " + e);
  10. }
  11. }
  12. public void executeQuery(String stringParam){
  13. ResultSet rs;
  14. try (Statement stmt = connection.createStatement()) {
  15. rs = stmt.executeQuery(stringParam);
  16. while(rs.next())
  17. System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3));
  18. }catch(Exception e){
  19. System.out.println(e);
  20. }
  21. }
  22.  
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement