Fxia

package StoredProc;
import java.sql.*;

public class Uppgift2 {


	public static void main(String[] args) throws SQLException {
		Connection connect = null;
		CallableStatement callable = null;
		ResultSet result = null;


		try {
			connect = DriverManager.getConnection("jdbc:mysql://localhost/Skola?noAccessToProcedureBodies=true","Zaher","hej123");
			connect.setAutoCommit(false);
			callable = connect.prepareCall("{CALL RegistreraElev(?,?,?,?,?,?,?)}");
			callable.setString(1, "8105181234");
			callable.setString(2, "Erik");
			callable.setString(3, "Fjollson");
			callable.setString(4, "Erik@Fjollson.com");
			callable.setString(5, "666444555");
			callable.setString(6, "Brandbergen");
			callable.setString(7, "Sociala Medier");
			callable.execute();
			result = callable.getResultSet();

			while(result.next()){
				String personnummer = result.getString("Personnummer");
				String fornamn = result.getString("Fornman");
				String efternamn = result.getString("Efternamn");
				String epost = result.getString("Epost");
				String telefon = result.getString("Telefon");
				String ort = result.getString("Ort");
				String klassnamn = result.getString("Klassnamn");
				System.out.println(personnummer +" "+ fornamn +" " + efternamn +" "+ epost +" "+ telefon + " "+ ort + " "+ klassnamn );
			}
		   connect.commit();
		}catch(SQLException e){
			e.printStackTrace();
			connect.rollback();
		}finally{

			callable.close();
			connect.close();
		}

	}

}