Guest User

Untitled

a guest
Oct 24th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.ResultSet;
  4. import java.sql.SQLException;
  5. import java.sql.Statement;
  6.  
  7.  
  8. class StockReduzido {
  9. // Select "jdbc:postgresql://localhost/tbd" if using a local database
  10.  
  11. private static final String LIGACAO ="jdbc:postgresql://localhost:5432/postgres"; //URL
  12. private static final String UTILIZADOR = "postgres"; //USER
  13. private static final String SENHA = "meio5"; //PASS
  14. private static final String INTERROGACAO = "SELECT ref, desig,stock " + "FROM produto WHERE (stock < 5) ORDER BY stock ASC";
  15. public static void main(String args[])
  16. throws SQLException {
  17. Connection objLigacao = null;
  18. Statement objComando = null;
  19. ResultSet objResultado = null;
  20. int intRef = 0;
  21. String strDesig = "";
  22. int intStock = 0;
  23. try {
  24. Class.forName("org.postgresql.Driver");
  25. } catch (ClassNotFoundException e) {
  26. e.printStackTrace();
  27. }
  28. objLigacao = DriverManager.getConnection(LIGACAO,
  29. UTILIZADOR, SENHA);
  30. objComando = objLigacao.createStatement();
  31. objResultado = objComando.executeQuery(INTERROGACAO);
  32. while (objResultado.next()) {
  33. intRef = objResultado.getInt("ref");
  34. strDesig = objResultado.getString("desig");
  35. intStock = objResultado.getInt("stock");
  36. System.out.println("Ref=" + intRef + "; " +
  37. "Desig=" + strDesig + "; " +
  38. "Stock=" + intStock + ";");
  39. }
  40. objResultado.close();
  41. objComando.close();
  42. objLigacao.close();
  43. }
  44. }
  45.  
  46. java.lang.ClassNotFoundException: org.postgresql.Driver
  47. at java.lang.Class.forNameImpl(Native Method)
  48. at java.lang.Class.forName(Class.java:273)
  49. at StockReduzido.main(StockReduzido.java:24)
  50. Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/postgres
  51. at java.sql.DriverManager.getConnection(DriverManager.java:700)
  52. at java.sql.DriverManager.getConnection(DriverManager.java:258)
  53. at StockReduzido.main(StockReduzido.java:28)
Add Comment
Please, Sign In to add comment