Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
- ResultSet result = 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();
- 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{
- scanner.close();
- callable.close();
- connect.close();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement