Advertisement
Guest User

Ali 2

a guest
May 15th, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. DB ErrorFInder
  2.  
  3. import java.sql.*;
  4. import java.io.*;
  5.  
  6. public class DBErrorFinder {
  7.  
  8. static String queryString = "select * from projects";
  9.  
  10. public static void main (String[] args) throws ClassNotFoundException {
  11.  
  12. String url =
  13. "jdbc:postgresql://pgdbs8.inf.brad.ac.uk/sd2?user=sd2user&password=sd2user";
  14. try {
  15. Class.forName("org.postgresql.Driver");
  16. Connection con = DriverManager.getConnection(url);
  17. Statement stmt = con.createStatement();
  18. ResultSet rs = stmt.executeQuery(queryString);
  19. while (rs.next()) {
  20. if (rs.getString(5).equals(args[0]))
  21.  
  22. System.out.println(rs.getString(1));
  23.  
  24. System.out.println(rs.getString(2));
  25.  
  26. System.out.println(rs.getString(3));
  27.  
  28. System.out.println(rs.getString(4));
  29.  
  30. System.out.println(rs.getString(5));
  31.  
  32. }
  33. rs.close();
  34. stmt.close();
  35. con.close();
  36. }
  37. catch (Exception e) {
  38. System.out.println("Error: " + e.getMessage() + "\n" + e.toString());
  39. }
  40. }
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement