import java.io.*;
import java.sql.*;
import java.util.Scanner;

class JDBC1
{
    public static void main( String[] args )
        throws Exception
    {
        Connection conn;
        try
        {

            Class.forName("org.postgresql.Driver"); // fyrir PostgreSQL
            java.util.Properties props = new java.util.Properties();
            props.setProperty("user",args[0]);
            props.setProperty("password",args[1]);
            conn = DriverManager.getConnection("jdbc:postgresql:COMPANY",props);
        }
        catch( Exception e )
        {
            try
            {
                Class.forName("org.sqlite.JDBC");
                //Finnum company
                conn = DriverManager.getConnection("jdbc:sqlite:/Users/ColdFusion/Desktop/company.db");
            }
            catch( Exception e2 )
            {

                conn = DriverManager.getConnection("jdbc:odbc:COMPANY");

            }
        }
        // (B)
        Statement statement = conn.createStatement();
        statement.executeUpdate("UPDATE EMPLOYEE SET salary = salary + 1000");

        String stmt1 = "select Salary from EMPLOYEE ";
        PreparedStatement p = conn.prepareStatement(stmt1);

        ResultSet r = p.executeQuery();
        double salary = 0;
        while( r.next() )
        {
            salary = salary + r.getDouble(1);
        }
        System.out.println(salary);
        String ssnum;
        String stmt2 = "select ssn from EMPLOYEE";
        PreparedStatement p1 = conn.prepareStatement(stmt2);
        ResultSet r1 = p1.executeQuery();
        while( r1.next() )
        {
            ssnum = r1.getString(1);
            String stmt3 = "UPDATE EMPLOYEE SET salary = salary + 1000 WHERE ssn = ?";
            PreparedStatement p2 = conn.prepareStatement(stmt3);
            p2.setString(1,ssnum);
            p2.executeUpdate();
        }
        r.close();
        conn.close();
    }
}