Import java.sql.*;
     
public class Test2  {

   public static void main(String args[]) {
      String url = "jdbc:postgresql://249.1.16.8/giga";
      Connection con;
      String query = "select version_ver, campania_ver from VERSIONES "+
	"where  version_ver like 'prueba3333'";
      String update = "update VERSIONES set campania_ver = 'Niños del cañón' "+
	"where  version_ver like 'prueba3333'";
      Statement stmt;

      System.out.println("Test2, update: "+update+"\n");
      try {
	 Class.forName("org.postgresql.Driver");
      } catch(java.lang.ClassNotFoundException e) {
	 System.err.print("ClassNotFoundExceptionx: ");
	 System.err.println(e.getMessage());
      }
	
      try {
	 con = DriverManager.getConnection(url, 
					   "store", "xk8yta2");
	 
	 stmt = con.createStatement();
	 stmt.executeUpdate(update);
	 
	 ResultSet rs = stmt.executeQuery(query);
	 ResultSetMetaData rsmd = rs.getMetaData();
	 int numberOfColumns = rsmd.getColumnCount();
	 int rowCount = 1;
	 System.out.println("Columnas "+ numberOfColumns+ "\n");
	 while (rs.next()) {
	    System.out.println("Row " + rowCount + ":  ");
	    for (int i = 1; i <= numberOfColumns; i++) {
	       System.out.print("   Column " + i + ":  ");
	       System.out.println(rs.getString(i));
	    }
	    System.out.println("");
	    rowCount++;
	 }
	 stmt.close();
	 con.close();
	 
      } catch(SQLException ex) {
	 System.err.print("SQLException: ");
	 System.err.println(ex.getMessage());
      }	
   }
}