import java.io.BufferedInputStream;
import java.io.DataInputStream;
import java.io.EOFException;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.*;
import java.io.*;
import java.util.*;

public class baza_2 {
        public static void main(String[] args)throws IOException{
                String nazwisko;
                int kwota;

                String url = "jdbc:postgresql://localhost/baza?user=login&password=haslo";
                try {
                    Class.forName("org.postgresql.Driver");
                    Connection db = DriverManager.getConnection(url);

                    Statement st = db.createStatement();


                    st.executeUpdate("UPDATE dane SET kwota=kwota+10 WHERE miesiac='3';");
                    ResultSet rs = st.executeQuery("SELECT * FROM dane;");

                    while (rs.next()) {
                        System.out.printf("Nazwisko: ");
                        System.out.println(rs.getString(1));
                        System.out.printf("Miesiac : ");
                        System.out.println(rs.getInt   (2));
                        System.out.printf("Kwota   : ");
                        System.out.println(rs.getInt   (3));
                        System.out.println("\n");
                    }
                    rs.close();
                    st.close();

                } catch (SQLException e) {
                    System.err.println("Wyjatek z zapytania SQL: " + e.getMessage());
                    e.printStackTrace(System.err);
                } catch (ClassNotFoundException e) {
                    System.err.println("Wyjatek przy ladowaniu klas: " + e.getMessage());
                    e.printStackTrace(System.err);
                }

            }
}