RE:Conexión Java a Postgresql
TE PASO EJEMPLOS QUE ENCONTRE EN INTERNET Y ME SIRVIERON EN SU MOMENTO...
va el example para borrar un registro
////////////////////////////////////////////////////////////////
public String url = "jdbc:postgresql://servidor/basededatos";
try{
Class.forName("postgresql.Driver");
Connection con = DriverManager.getConnection( url,
"USUARIO","PASSWORD");
Statement stmt = con.createStatement();
stmt.execute("BEGIN");
stmt.execute("delete from nota where CONDICION ");
stmt.execute("END");
stmt.close();
con.close();
} catch(Exception e){
System.out.println(e.getMessage());
e.printStackTrace();
}
///////////////////////////////////////////
Para consultar
////////////////
public String url = "jdbc:postgresql://servidor/basededatos";
try{
Class.forName("postgresql.Driver");
Connection con = DriverManager.getConnection( url,
"USUARIO","PASSWORD");
Statement stmt = con.createStatement();
ResultSet rs;
stmt.execute("BEGIN");
stmt.execute("DECLARE fotos CURSOR FOR select titulo,code from
nota order by code DESC ");
rs = stmt.executeQuery("FETCH 10 in fotos");
while ( rs.next()){
System.out.println("Codigo " + rs.getInt("code"));
System.out.println("Titulo " + rs.getString("titulo"));
}
stmt.execute("END");
stmt.close();
con.close();
}
catch( Exception e ){
System.out.println(e.getMessage());
e.printStackTrace();
}
////////////////////////
para insertar
////
public String url = "jdbc:postgresql://servidor/basededatos";
try{
Class.forName("postgresql.Driver");
Connection con = DriverManager.getConnection( url,
"USUARIO","PASSWORD");
Statement stm = con.createStatement();
stm.execute("BEGIN");
String YO = "insert into tabla values (1 , 'UNO')";
stm.excecuteUpdate ( YO );
stm.execute("END");
stmt.close();
con.close();
}
catch( Exception e ){
System.out.println(e.getMessage());
e.printStackTrace();
}