asdaa

package StoredProc;
import java.sql.*;
import java.util.Scanner;

public class Uppgift2 {


	public static void main(String[] args) throws SQLException {
		Connection connect = null;
		CallableStatement callable = null;
		Scanner scanner = new Scanner(System.in);

		System.out.println("Slå in ditt Personnummer Max 10 siffror");
		String personnummer1 = scanner.nextLine();
		System.out.println("Ditt förnamn");
		String fornamn1 = scanner.nextLine();
		System.out.println("Ditt efternamn");
		String efternamn1= scanner.nextLine();
		System.out.println("Din epost");
		String epost1=scanner.nextLine();
		System.out.println("Ditt telefonnummer");
		String telefon1 = scanner.nextLine();
		System.out.println("Ort ?");
		String ort1 = scanner.nextLine();
		System.out.println("Din klass");
		String klass1= scanner.nextLine();
		try {
			connect = DriverManager.getConnection("jdbc:mysql://localhost/Skola?noAccessToProcedureBodies=true","Zaher","hej123");
			connect.setAutoCommit(false);
			callable = connect.prepareCall("{CALL RegistreraElev(?,?,?,?,?,?,?)}");
			callable.setString(1, personnummer1);
			callable.setString(2, fornamn1);
			callable.setString(3, efternamn1);
			callable.setString(4, epost1);
			callable.setString(5, telefon1);
			callable.setString(6, ort1);
			callable.setString(7, klass1);
			callable.execute();

		   System.out.println(personnummer1 +" "+ fornamn1 +" " + efternamn1 +" "+ epost1 +" "+ telefon1+ " "+ ort1 + " "+ klass1 );

		   connect.commit();
		}catch(SQLException e){
			e.printStackTrace();
			connect.rollback();
		}finally{
			scanner.close();
			callable.close();
			connect.close();
		}

	}

}