Mam problem taki jak w temacie. Co ciekawe jak próbuje wywołać jakiekolwiek query w pgadmin to nie daje ono żadnych rezultatów. Już pokazuje co się dzieje:
public class dbConnection {
static private String urlDatabase = "jdbc:postgresql://localhost:5432/BM_Database";
static private String user = "postgres";
static private String pass = xxx";
static private Connection conn;
static private Statement statement;
static private ResultSet resultset;
public static Connection dbConn() {
try {
DriverManager.registerDriver(new org.postgresql.Driver());
conn = DriverManager.getConnection(urlDatabase, user , pass);
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static Statement statement() throws SQLException {
statement = conn.createStatement();
return statement;
}
public static void resultset(String query) throws SQLException {
resultset = statement.executeQuery(query);
while(resultset.next()) {
System.out.println(resultset.getString("budget_id") + " " + resultset.getString("budget_name"));
}
resultset.close();
statement.close();
conn.close();
}
}