import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class Update{
   public static void main( String args[] )
     {
       Connection c = null;
       Statement stmt = null;
       try {
       Class.forName("org.postgresql.Driver");
         c = DriverManager
            .getConnection("jdbc:postgresql://localhost:5432/temadeproiect",
            "postgres", "usametalica22");
         c.setAutoCommit(false);
         System.out.println("Baza de date este disponibila pentru Update");

         stmt = c.createStatement();
         String sql = "UPDATE evid_persoana3 set adresa = 'Strada Noua,nr.9 ,Craiovita Noua,Romania' where nume='Popescu';";
         stmt.executeUpdate(sql);
         c.commit();

         ResultSet rs = stmt.executeQuery( "SELECT * FROM evid_persoana3;" );
         while ( rs.next() ) {

            String cnp = rs.getString("cnp");
            String  nrpermis = rs.getString("nrpermis");
            String nume = rs.getString("nume");
            String adresa = rs.getString("adresa");


            System.out.println( "Cnp = " + cnp );
            System.out.println( "NrPermis = " + nrpermis );
            System.out.println( "Nume = " + nume );
            System.out.println( "Adresa = " + adresa );

            System.out.println();
         }
         rs.close();
         stmt.close();
         c.close();
       } catch ( Exception e ) {
         System.err.println( e.getClass().getName()+": "+ e.getMessage() );
         System.exit(0);
       }
       System.out.println("Operatie de actualizare reusita .");
     }
}