hentHold()

public void hentHold() {
		try {
			Connection minConnection;
			minConnection = DriverManager
					.getConnection("jdbc:sqlserver://Dennis;databaseName=YodaFitness;user=sa;password=HelloWorld;");

			Statement stmt = minConnection.createStatement();

			int id = Integer.parseInt(txfIdOpdater.getText().trim());

			ResultSet res = stmt.executeQuery("exec hentHold " + id);
			while (res.next()) {
				System.out.println(res.getString(1) + "\t" + "\t" + res.getString(2) + "\t" + "\t" + res.getString(3));
				txfNavnOpdater.setText(res.getString(2));
				txfDagOpdater.setText(res.getString(3));
				txfUgeOpdater.setText(res.getString(4));
				txfStartTidOpdater.setText(res.getString(5));
				txfStatusOpdater.setText(res.getString(6));
				txfVaringhedOpdater.setText(res.getString(7));
				txfMaxAntalOpdater.setText(res.getString(8));
				txfSalNrOpdater.setText(res.getString(9));
				txfInsOpdater.setText(res.getString(10));

			}

			if (res != null) {
				res.close();
			}
			if (stmt != null) {
				stmt.close();
			}
			if (minConnection != null) {
				minConnection.close();
			}

		} catch (Exception e) {
			System.out.println("fejl:  " + e.getMessage());
		}

	}