package Opgave8;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class Create {

	public static void main(String[] args) {
		try {
			System.out.println("Vi vil nu indsætte en række i TestType: ");
			BufferedReader inLine = new BufferedReader(new InputStreamReader(
					System.in));
			System.out.print("navn (char 10): ");
			String navn = inLine.readLine();
			System.out.println("Indtast navn2 (varchar(10)): ");
			String navn2 = inLine.readLine();
			System.out.println("Indtast alder(int): ");
			int alder = Integer.parseInt(inLine.readLine());
			System.out.println("Indtast varme(decimal): ");
			double varme = Double.parseDouble(inLine.readLine());
			System.out.println("Indtast lol(bit): ");
			int oprettelse = Integer.parseInt(inLine.readLine());

			Connection minConnection;
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			minConnection = DriverManager
					.getConnection("jdbc:sqlserver://LAPTOP-32KIS2JP\\DANIELSSQL;databaseName=YodaFitness2;user=sa;password=dani6602;");
			String sql = "insert into Opgave8 values (?,?,?,?,?)";// preparedStatement
			PreparedStatement prestmt = minConnection.prepareStatement(sql);
			prestmt.clearParameters();
			prestmt.setString(1, navn);
			prestmt.setString(2, navn2);
			prestmt.setInt(3, alder);
			prestmt.setDouble(4, varme);
			prestmt.setInt(5, oprettelse);
			prestmt.execute();
			System.out.println("Medlemet er nu registreret");
			if (prestmt != null)
				prestmt.close();
			if (minConnection != null)
				minConnection.close();

		} catch (SQLException e) {
			System.out.println(e.getErrorCode());
			switch (e.getErrorCode()) {
			case 8152: {
				System.out.println("Inputdata er for langt");
				break;
			}
			case 2627: {
				System.out.println("den pågældende instruktør er allerede oprettet");
				break;
			}
			default:
				System.out.println("fejlSQL:  " + e.getMessage());
			}
			;
		} catch (Exception e) {
			System.out.println("fejl:  " + e.getMessage());
		}
	}

}