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 ssn, lname;
		double salary;
		String stmt1 = "select Salary from EMPLOYEE ";
		PreparedStatement p = conn.prepareStatement(stmt1);
		System.out.print("Enter a Social Security Number: ");
		Scanner scanner = new Scanner(System.in);
		ssn = scanner.nextLine();
		p.clearParameters();
		p.setString(1,ssn);
		ResultSet r = p.executeQuery();
		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();
	}
}