package postgresql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class SimplePostgreSqlConnector {
public static void main(String[] args) { conectaPG();
}
private static void conectaPG(){ try { Class.forName("org.postgresql.Driver"); Connection connection = null;
connection = DriverManager.getConnection("jdbc:postgresql://MiServidor:5432/NombreDeBaseDeDatos","usuario", "password"); Statement s = null;
if (connection != null)
{ s = connection.createStatement();
String query="select \"Columna\" from \"Tabla\" ";
ResultSet rs=s.executeQuery(query);
while(rs.next())
{ System.out.println(rs.getString(1));
}
}
else
System.out.println("Connection Failed!"); }
catch(Exception e){ e.printStackTrace();
}
}
}
Crear cuenta
Comentarios sobre la versión: 20190111 (0)
No hay comentarios