package opgaver;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class TestSQL {

	public static void main(String[] args) {
		// TODO Auto-generated method stub

		try {
			System.out.println("Program startet");
			Connection minConnection;
			BufferedReader inLine = new BufferedReader(new InputStreamReader(System.in));
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			minConnection = DriverManager.getConnection("jdbc:sqlserver://localhost\\SQLEXPRESS;" +
					"databaseName=konto;user=sa;password=mathlikser1;");

			Statement stmt = minConnection.createStatement();
			System.out.println("indtast frakontoNR:");
			int frakonto = Integer.parseInt(inLine.readLine());
			System.out.println("indtast tilkontoNR:");
			int tilkonto = Integer.parseInt(inLine.readLine());
			System.out.println("indtast beløb:");
			int beløb = Integer.parseInt(inLine.readLine());

			ResultSet res=stmt.executeQuery("select * from konto where kontonr = " + frakonto);
			if (res.next()) {
				int fraSaldo = res.getInt(2);
				System.out.println("frakonto har saldo: " + fraSaldo);
				if (fraSaldo > beløb) {
					ResultSet res2=stmt.executeQuery("select * from konto where kontonr = " + tilkonto);
					if (res2.next()) {
						int tilSaldo = res2.getInt(2);
						System.out.println("tilkonto har saldo: " + tilSaldo);
						fraSaldo = fraSaldo - beløb;
						tilSaldo = tilSaldo + beløb;
						stmt.execute("update konto set saldo = " + fraSaldo + " where kontonr = " + frakonto);
						stmt.execute("update konto set saldo = " + tilSaldo + " where kontonr = " + tilkonto);
						System.out.println("Kontoer opdateret!");
					}
				}
			}
		if (stmt != null)
		  stmt.close();
		if (minConnection != null)
		  minConnection.close();
		}
		catch (Exception e) {
			System.out.print("fejl:  "+e.getMessage());
		}

	}


}