import java.sql.*;
import java.io.*;

public class NewPerson {
    public static void main(String args[]) {
        BufferedReader reader
            = new BufferedReader(new InputStreamReader(System.in));
        String numberString;
        int number;
        String name;
        String phone;
        try {
            System.out.println("Mata in en ny person.");
            System.out.print("Vad är personens nummer? ");
            numberString = reader.readLine();
            number = Integer.parseInt(numberString);
            System.out.print("Vad är personens namn? ");
            name = reader.readLine();
            System.out.print("Vad är personens telefonnummer? ");
            phone = reader.readLine();
        }
        catch (IOException e) {
            System.out.println("Kunde inte läsa!");
            return;
        }
        catch (NumberFormatException e) {
            System.out.println("Inte ett korrekt tal.");
            return;
        }

        try {
            Class.forName("com.mimer.jdbc.Driver");
            String url = "jdbc:mimer://bengt:soptipp@basen.oru.se/bilbasen";
            Connection con = DriverManager.getConnection(url);
            Statement stmt = con.createStatement();
            String sql = "insert into person values (" + number + ", '" + name + "', '" + phone + "')";
            System.out.println("SQL-kommandot: " + sql);
            int rowCount = stmt.executeUpdate(sql);
            System.out.println(rowCount + " rader ändrade.");
            stmt.close();
            con.close();
        }
        catch (SQLException e) {
            while (e != null) {
                System.out.println("SQLException:");
                System.out.println("    SQLState: " + e.getSQLState());
                System.out.println("    Message: " + e.getMessage());
                System.out.println("    ErrorCode: " + e.getErrorCode());
                e = e.getNextException();
            }
        } catch (Exception e) {
            System.out.println("Någon annan exception:");
            e.printStackTrace();
        }
        System.exit(0);
    } // main
} // class NewPerson