Connecting to Postgres Databases with Java (Netbeans)
Como conectarte a postgres desde java.
Descarga del Driver : http://jdbc.postgresql.org/download.html
Codigo:
String cadena = "jdbc:postgresql://localhost:5433/pruebaReportes";
String user ="postgres";
String pass = "097073290";
try {
Class.forName("org.postgresql.Driver");
Connection conex = DriverManager.getConnection(cadena,user,pass);
java.sql.Statement st = conex.createStatement();
String sql =
"SELECT nom_usu, cla_usu FROM usuarios ";
ResultSet result = st.executeQuery(sql);
while(result.next()) {
String usuario = result.getString("nom_usu");
String clave = result.getString("cla_usu");
System.out.println("User: "+usuario + " Pass: " + clave);
}
result.close();
st.close();
conex.close();
} catch(Exception exc) {
System.out.println("Errorx:"+exc.getMessage());
}