Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DB ErrorFInder
- import java.sql.*;
- import java.io.*;
- public class DBErrorFinder {
- static String queryString = "select * from projects";
- public static void main (String[] args) throws ClassNotFoundException {
- String url =
- "jdbc:postgresql://pgdbs8.inf.brad.ac.uk/sd2?user=sd2user&password=sd2user";
- try {
- Class.forName("org.postgresql.Driver");
- Connection con = DriverManager.getConnection(url);
- Statement stmt = con.createStatement();
- ResultSet rs = stmt.executeQuery(queryString);
- while (rs.next()) {
- if (rs.getString(5).equals(args[0]))
- System.out.println(rs.getString(1));
- System.out.println(rs.getString(2));
- System.out.println(rs.getString(3));
- System.out.println(rs.getString(4));
- System.out.println(rs.getString(5));
- }
- rs.close();
- stmt.close();
- con.close();
- }
- catch (Exception e) {
- System.out.println("Error: " + e.getMessage() + "\n" + e.toString());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement