package opgave1;

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 Opgave1 {

	static Connection minConnection;
	static Statement stmt;
	static BufferedReader inLine;

	public static void opgave1() {
	try {
		String regNr = "";
		String navn = "";
		String adresse = "";
		String tlfNr = "";
		String sql = "select regNr, navn, adresse, tlfNr from Afdeling";
		System.out.println("SQL-streng er "+sql);
		ResultSet res=stmt.executeQuery(sql);
		// genneml�ber svaret
		while (res.next()) {
			regNr = res.getString("regNr");
			navn = res.getString("navn");
			adresse = res.getString("adresse");
			tlfNr = res.getString("tlfNr");
			System.out.println("RegNr: " + regNr + ", navn: " + navn + ", adresse: "
					+ adresse + ", tlfNr: " + tlfNr);
		}
		// p�n lukning
 		if (!minConnection.isClosed()) minConnection.close();
		}
		catch (Exception e) {
			System.out.println("fejl:  "+e.getMessage());
		}
	}

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		try {
			inLine = new BufferedReader(new InputStreamReader(System.in));
			//generel ops�tning
			//via native driver
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			minConnection = DriverManager.getConnection("jdbc:sqlserver://localhost\\SQLEXPRESS;databaseName=andebybank;user=sa;password=far76esk;");
			stmt = minConnection.createStatement();
			//Indl�sning og kald af den rigtige metode
			System.out.println("Indtast  ");
			System.out.println("q for opgave 1");
			String in=inLine.readLine();
			switch (in)
			{case "q"  : {opgave1();break;}
			default : System.out.println("ukendt indtastning");
			}
		}
		catch (Exception e) {
			System.out.println("fejl:  "+e.getMessage());
		}
	}


}