package minta;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.*;
import java.util.Scanner;

public class ab2bead {
	private Connection conn = null;
	private Statement s = null;
	private ResultSet rs = null;

	public void Reg() {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			System.out.println("Sikeres driver regisztrálás\n");
		} catch (Exception ex) {
			System.err.println(ex.getMessage());
		}
	}

	public void Kapcs() {
		String url = "jdbc:oracle:thin:@localhost:1521:XE";
		try {
			conn = DriverManager.getConnection(url, "system", "jelszo");
			System.out.println("Sikeres kapcsolódás\n");
		} catch (Exception ex) {
			System.err.println(ex.getMessage());
		}
	}

	public void LeKapcs() {
		if (conn != null) {
			try {
				conn.close();
				System.out.println("Sikeres lekapcsolódás");
			} catch (Exception ex) {
				System.err.println(ex.getMessage());
			}
		}
	}

	public void SoforCreate() {
		String sqlp = "create table Sofor(id char(5) primary key, nev char(20), ber number(6), munkaora  number(2))";
		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp);
			System.out.println("sofor tabla letrehozva");
		} catch (Exception e) {
			System.err.println("hiba a sofor tabla letrehozasakor"
					+ e.getMessage());
		}
	}

	public void JaratCreate() {
		String sqlp = "create table Jarat( id char(5) primary key,  sofor char(5) not null references Sofor(id), idotartam number(2))";

		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp);
			System.out.println("jarat tabla letrehozva");
		} catch (Exception e) {
			System.err.println("hiba a jarat tabla letrehozasakor"
					+ e.getMessage());
		}
	}

	public void NaploCreate() {
		String sqlp = "create table Naplo(idopont date, esemeny char(200), adat char(200))";
		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp);
			System.out.println("naplo tabla letrehozva");
		} catch (Exception e) {
			System.err.println("hiba a naplo tabla letrehozasakor"
					+ e.getMessage());
		}
	}

	public void UtasCreate() {
		String sqlp = "create table Utas( id  char(5)primary key, nev char(20),jarat char(5) not null, constraint jaratid foreign key(Jarat) references  Jarat(id), kor number(2))";
		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp);
			System.out.println("utas tabla letrehozva");
		} catch (Exception e) {
			System.err.println("hiba az utas tabla letrehozasakor"
					+ e.getMessage());
		}
	}

	public void EllenorCreate() {
		String sqlp = "Create table Ellenor( id char(5) primary key, nev char(20), buntetes number(2))";
		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp);
			System.out.println("ellenor tabla letrehozva");
		} catch (Exception e) {
			System.err.println("hiba az ellenor tabla letrehozasakor"
					+ e.getMessage());
		}
	}

	public void JaratInsert() throws SQLException {
		conn.setAutoCommit(false);

		String sqlp1 = "insert into jarat values('jeres','784fs',14)";
		String sqlp2 = "insert into jarat values('oksld','qwesd',10)";
		String sqlp3 = "insert into jarat values('p784d','784fs',16)";
		String sqlp4 = "insert into jarat values('jfsls','784fs',17)";
		String sqlp5 = "insert into jarat values('745sf','ujd12',14)";
		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp1);
			s.executeUpdate(sqlp2);
			s.executeUpdate(sqlp3);
			s.executeUpdate(sqlp4);
			s.executeUpdate(sqlp5);
			System.out.println("jarat tabla feltoltve adatokkal");
			String sqlpn = "insert into naplo values(sysdate,'beszuras a jarat tablaba','')";
			s.executeUpdate(sqlpn);
			conn.commit();
		} catch (Exception exc) {
			try {
				System.err.println("nem sikerult a jarat tablat feltolteni :"
						+ exc.getMessage());
				conn.rollback();
			}

			catch (Exception e) {
				System.err.println(e.getMessage());
			}

		}

	}

	public void SoforInsert() throws SQLException {
		conn.setAutoCommit(false);
		String sqlp1 = "Insert into Sofor values('ujd12', 'Kiss Bela', 145632, 8)";
		String sqlp2 = "Insert into Sofor values('784fs', 'NagyBela', 128632, 12)";
		String sqlp3 = "Insert into Sofor values('df45e', 'Ferde Geza', 135832, 7)";
		String sqlp4 = "Insert into Sofor values('u78ds', 'Bodon Bela', 225434, 12)";
		String sqlp5 = "Insert into Sofor values('qwesd', 'János Mária', 325492, 4)";
		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp1);
			s.executeUpdate(sqlp2);
			s.executeUpdate(sqlp3);
			s.executeUpdate(sqlp4);
			s.executeUpdate(sqlp5);
			System.out.println("sofor tabla feltoltve adatokkal");
			String sqlpn = "insert into naplo values(sysdate,'beszuras a sofor tablaba','')";
			s.executeUpdate(sqlpn);
			conn.commit();
		} catch (Exception ex) {
			try {
				System.err.println("nem sikerult a sofor tablat feltolteni :"
						+ ex.getMessage());
				conn.rollback();
			} catch (Exception e) {

				System.err.println(e.getMessage());
			}
		}
	}

	public void UtasInsert() throws SQLException {
		conn.setAutoCommit(false);
		String sqlp1 = "insert into utas values('15236','Karoly Kar','jeres',12)";
		String sqlp2 = "insert into utas values('15fd4','Karoly Erika','745sf',18)";
		String sqlp3 = "insert into utas values('cd45e','Nagy Zsofia','oksld',19)";
		String sqlp4 = "insert into utas values('1asd4','Kerekes Judit','oksld',42)";
		String sqlp5 = "insert into utas values('78cde','Serki Peter','oksld',87)";
		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp1);
			s.executeUpdate(sqlp2);
			s.executeUpdate(sqlp3);
			s.executeUpdate(sqlp4);
			s.executeUpdate(sqlp5);
			System.out.println("utas tabla feltoltve adatokkal");
			String sqlpn = "insert into naplo values(sysdate,'beszuras az utas tablaba','')";
			s.executeUpdate(sqlpn);
			conn.commit();
		} catch (Exception ex) {
			try {
				System.err.println("nem sikerult az utas tablat feltolteni :"
						+ ex.getMessage());
				conn.rollback();
			} catch (Exception e) {
				System.err.println(e.getMessage());
			}
		}
	}

	public void EllenorInsert() throws SQLException {
		conn.setAutoCommit(false);
		String sqlp1 = "insert into ellenor values('12578','Nagy Tamara',2)";
		String sqlp2 = "insert into ellenor values('dse45','Herman Hanna ',10)";
		String sqlp3 = "insert into ellenor values('12548','Kiss Emma',8)";
		String sqlp4 = "insert into ellenor values('kloe4','Dolog Ádám',0)";
		String sqlp5 = "insert into ellenor values('412sf','Zoe Zalan',4)";
		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp1);
			s.executeUpdate(sqlp2);
			s.executeUpdate(sqlp3);
			s.executeUpdate(sqlp4);
			s.executeUpdate(sqlp5);
			System.out.println("ellenor tabla feltoltve adatokkal");
			String sqlpn = "insert into naplo values(sysdate,'beszuras sz ellenor tablaba','')";
			s.executeUpdate(sqlpn);
			conn.commit();
		} catch (Exception e) {
			try {
				conn.rollback();
				System.err
						.println("nem sikerult az ellenor tablat feltolteni :"
								+ e.getMessage());
			} catch (Exception ex) {
				System.out.println(ex.getMessage());
			}

		}
	}

	public void SoforLista() {
		String sqlp = "select * from sofor order by id";
		int ber = 0, munkaora = 0, sorszam = 0;
		String id = "", nev = "";
		System.out.println("sofor kilistazasa");

		try {
			s = conn.createStatement();
			s.executeQuery(sqlp);
			rs = s.getResultSet();
			while (rs.next()) {
				sorszam++;
				id = rs.getString("id");
				nev = rs.getString("nev").trim();
				ber = rs.getInt("ber");
				munkaora = rs.getInt("munkaora");

				System.out.println(sorszam + "id :" + id + "nev: " + nev
						+ "ber: " + ber);
			}
			rs.close();
			String sqlpn = "insert into naplo values(sysdate,'sofor tabla listazasa tablaba','')";
			s.executeUpdate(sqlpn);
			s.close();

		} catch (Exception e) {
			sorszam = -1;
			System.err.println("Hiba a sofor tabla adatainak listazasakor "
					+ e.getMessage());
		}

	}

	public void JaratLista() {
		String sqlp = "select * from jarat order by id";
		int idotartam = 0, sorszam = 0;
		String id = "", sofor = "";
		System.out.println("jarat kilistazasa");

		try {
			s = conn.createStatement();
			s.executeQuery(sqlp);
			rs = s.getResultSet();
			while (rs.next()) {
				sorszam++;
				id = rs.getString("id");
				sofor = rs.getString("sofor").trim();
				idotartam = rs.getInt("idotartam");

				System.out.println(sorszam + "id :" + id + "sofor: " + sofor
						+ "idotartam: " + idotartam);
			}
			rs.close();
			String sqlpn = "insert into naplo values(sysdate,'jarat tabla listazasa','')";
			s.executeUpdate(sqlpn);
			s.close();
		} catch (Exception e) {
			sorszam = -1;
			System.err.println("Hiba a jarat tabla adatainak listazasakor "
					+ e.getMessage());
		}

	}

	public void UtasLista() {
		String sqlp = "select * from utas order by id";
		int kor = 0, sorszam = 0;
		String id = "", nev = "", jarat = "";
		System.out.println("utas kilistazasa");

		try {
			s = conn.createStatement();
			s.executeQuery(sqlp);
			rs = s.getResultSet();
			while (rs.next()) {
				sorszam++;
				id = rs.getString("id");
				nev = rs.getString("nev");
				jarat = rs.getString("jarat").trim();
				kor = rs.getInt("kor");

				System.out.println(sorszam + "id :" + id + "nev: " + nev
						+ "jarat: " + jarat + "kor :" + kor);
			}
			rs.close();
			String sqlpn = "insert into naplo values(sysdate,'utas tabla listazasa','')";
			s.executeUpdate(sqlpn);
			s.close();
		} catch (Exception e) {
			sorszam = -1;
			System.err.println("Hiba az utas tabla adatainak listazasakor "
					+ e.getMessage());
		}

	}

	public void EllenorLista() {
		String sqlp = "select * from ellenor order by id";
		int buntetes = 0, sorszam = 0;
		String id = "", nev = "";
		System.out.println("ellenor kilistazasa");

		try {
			s = conn.createStatement();
			s.executeQuery(sqlp);
			rs = s.getResultSet();
			while (rs.next()) {
				sorszam++;
				id = rs.getString("id");
				nev = rs.getString("nev").trim();
				buntetes = rs.getInt("buntetes");
				System.out.println(sorszam + "id :" + id + "nev: " + nev
						+ "buntetes: " + buntetes);
			}
			rs.close();
			String sqlpn = "insert into naplo values(sysdate,'ellenor tabla listazasa','')";
			s.executeUpdate(sqlpn);
			s.close();
		} catch (Exception e) {
			sorszam = -1;
			System.err.println("Hiba az ellenor tabla adatainak listazasakor "
					+ e.getMessage());
		}

	}

	public void NaploLista() {
		String sqlp = "select * from naplo";
		int sorszam = 0;
		String esemeny = "", adat = "", idopont = "";
		System.out.println("naplo kilistazasa");

		try {
			s = conn.createStatement();
			s.executeQuery(sqlp);
			rs = s.getResultSet();
			while (rs.next()) {
				sorszam++;
				esemeny = rs.getString("esemeny");
				idopont = rs.getDate("idopont").toString();

				System.out.println(sorszam + "esemeny:" + esemeny + "adat: "
						+ adat + "idopont: " + idopont);
			}
			rs.close();
			String sqlpn = "insert into naplo values(sysdate,'naplo tabla elemeinek listazasa','')";
			s.executeUpdate(sqlpn);
			s.close();
		} catch (Exception e) {
			sorszam = -1;
			System.err.println("Hiba a naplo tabla adatainak listazasakor "
					+ e.getMessage());
		}

	}

	public void SoforBeszur(String id, String nev, int ber, int munkaora)
			throws SQLException {
		conn.setAutoCommit(false);
		String sqlp = "insert into sofor values ('" + id + "', '" + nev + "', "
				+ ber + ", '" + munkaora + "')";
		System.out.println("beszurunk a sofor tablaba");

		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp);
			System.out.println("sikeres beszuras a sofor tablaba");
			String sqlpn = "insert into naplo values(sysdate,'beszuras a sofor tablaba adott parametereke szerint','')";
			s.executeUpdate(sqlpn);
			s.close();
			conn.commit();
		} catch (Exception e) {
			try {
				conn.rollback();
				System.out.println("Hiba a sofor tablaba beszuraskor");
			} catch (Exception ex) {
				System.out.println(ex.getMessage());
			}
		}
	}

	public void EllenorBeszur() throws SQLException {
		conn.setAutoCommit(false);
		try {

			PreparedStatement ps = conn
					.prepareStatement("insert into ellenor values (?, ?, ?)");
			BufferedReader be = new BufferedReader(new InputStreamReader(
					System.in));
			System.out.println("Add meg az id-et");
			String id = be.readLine();
			System.out.println("Add meg a nevet");
			String nev = be.readLine();
			System.out.println("Add meg a buntetest");
			int buntetes = Integer.parseInt(be.readLine());
			ps.setString(1, id);
			ps.setString(2, nev);
			ps.setInt(3, buntetes);
			ps.executeUpdate();
			ps.close();
			System.out.println("Sikeres beszuras az ellenor tablaba");
			// be.close();
			s = conn.createStatement();
			String sqlpn = "insert into naplo values(sysdate,'beszuras az ellenor tablaba adott ertekeket ','')";
			s.executeUpdate(sqlpn);
			conn.commit();
		} catch (Exception e) {
			try {
				conn.rollback();
				System.err.println("Hiba az ellenor tabla beszurasanal:"
						+ e.getMessage());
			} catch (Exception ex) {
				System.out.println(ex.getMessage());
			}
		}

	}

	public void SoforModosit(String id, int ber) throws SQLException {
		conn.setAutoCommit(false);
		String sqlp = "update sofor set ber= " + ber + " where id= '" + id
				+ "'";
		System.out.println("Sofor tabla adott elemenek modositasa");

		try {
			s = conn.createStatement();

			s.executeUpdate(sqlp);

			String sqlpn = "insert into naplo values(sysdate,'modositas a sofor  tablaba adott ertekeket ','')";
			s.executeUpdate(sqlpn);
			s.close();
			System.out.println("Sikeres modositas");
			conn.commit();
		} catch (Exception e) {
			try {
				conn.rollback();
				System.err
						.println("hiba a sodot tabla elemenek modositasakor: "
								+ e.getMessage());
			} catch (Exception ex) {
				System.out.println(ex.getMessage());
			}
		}

	}

	public void EllenorModosit() throws SQLException {

		conn.setAutoCommit(false);
		try {
			PreparedStatement ps = conn
					.prepareStatement("update ellenor set buntetes = ? where id = ?");
			BufferedReader ss = new BufferedReader(new InputStreamReader(
					System.in));
			System.out.println("Add meg az id-et");

			String id = ss.readLine();
			System.out.println("Add meg a buntetest");
			int buntetesuj = Integer.parseInt(ss.readLine());
			ps.setInt(1, buntetesuj);
			ps.setString(2, id);
			ps.executeUpdate();
			ps.close();
			s = conn.createStatement();
			String sqlpn = "insert into naplo values(sysdate,'modositas az ellenor  tablaba adott ertekeket ','')";
			s.executeUpdate(sqlpn);

			conn.commit();
		} catch (Exception e) {
			try {
				conn.rollback();
				System.out.println("hiba az ellenor tabla modositasaban: "
						+ e.getMessage());
			} catch (Exception ex) {
				System.out.println(ex.getMessage());
			}
		}

	}

	public void EllenorTorol(String id) throws SQLException {
		conn.setAutoCommit(false);
		String sqlp = "delete from ellenor where id='" + id + "'";
		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp);

			String sqlpn = "insert into naplo values(sysdate,'torles az ellenor tablabol adott ertekeket ','')";
			s.executeUpdate(sqlpn);

			System.out.println("ellenor tablabol adott id torolve ");
			conn.commit();
		} catch (Exception e) {
			try {
				conn.rollback();

				System.err.println("nem sikerult az ellenor tablabol torolni :"
						+ e.getMessage());
			} catch (Exception ex) {
				System.out.println(ex.getMessage());
			}
		}
	}

	public void UtasTorol(String id) throws SQLException {
		conn.setAutoCommit(false);
		String sqlp = "delete from utas where id='" + id + "'";
		try {
			s = conn.createStatement();

			String sqlpn = "insert into naplo values(sysdate,'torles az utas tablabol adott ertekeket ','')";
			s.executeUpdate(sqlpn);
			s.executeUpdate(sqlp);

			System.out.println("utas tablabol adott id torolve ");
			conn.commit();
		} catch (Exception e) {
			try {
				conn.rollback();
				System.err.println("nem sikerult az utas tablabol torolni :"
						+ e.getMessage());
			} catch (Exception ex) {
				System.out.println(ex.getMessage());
			}
		}
	}

	public void SoforTaroltf() {
		String sqlp = "create or replace function kikereso2 return number as dbora number:=0;begin select count(munkaora) into dbora from Sofor; return dbora; end;";

		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp);

			String sqlpn = "insert into naplo values(sysdate,'sofor tarolt fuggveny letrehozva ','')";
			s.executeUpdate(sqlpn);
			System.out.println("kesz a sofor tarolt fuggveny");
		} catch (Exception e) {
			System.err.println("hiba a sofor tarolt fuggveny letrehozaskor :"
					+ e.getMessage());

		}
	}

	public void SoforTaroltfHiv() {
		String sqlp = "{? = call kikereso2()}";

		int db = 0;
		try {
			CallableStatement cs = conn.prepareCall(sqlp);
			cs.registerOutParameter(1, java.sql.Types.INTEGER);

			cs.execute();
			db = cs.getInt(1);
			cs.close();
			System.out.println("A soforok munkaorainak szama: " + db);
			s = conn.createStatement();
			String sqlpn = "insert into naplo values(sysdate,'sofor tarolt fuggveny hivasa ','')";
			s.executeUpdate(sqlpn);
		} catch (Exception e) {
			System.err.println("Hiba a tartolt fuggveny hivasakor: "
					+ e.getMessage());
		}
	}

	public void SoforTaroltE() {
		String sqlp = "create or replace procedure modosit1(ujid in char) is Begin update Sofor set ber=ber*1.1 where id=ujid; End;";

		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp);
			System.out.println("Kesz a  soforos tarolt eljaras");

			String sqlpn = "insert into naplo values(sysdate,'sofor tarolt eljaras keszitese','')";
			s.executeUpdate(sqlpn);
		} catch (Exception e) {
			System.out.println("Hiba a soforos tarolt eljaras keszitesekor: "
					+ e.getMessage());
		}

	}

	public void SoforTaroltEHiv(String id) throws SQLException {
		conn.setAutoCommit(false);
		String sqlp = "{call modosit1(?)}";

		try {
			CallableStatement cs = conn.prepareCall(sqlp);
			cs.setString(1, id);
			cs.execute();
			cs.close();
			s = conn.createStatement();
			String sqlpn = "insert into naplo values(sysdate,'sofor tarolt eljaras hivasa ','')";
			s.executeUpdate(sqlpn);
			System.out
					.println("Sikeres vegrehajtasa a soforos tarolt eljarasnak");
			conn.commit();
		} catch (Exception e) {
			try {

				conn.rollback();
				System.err
						.println("Hiba a soforos tarolt eljaras vegrehajtasakor: "
								+ e.getMessage());
			} catch (Exception ex) {
				System.out.println(ex.getMessage());
			}
		}
	}

	public void MindenTorol() throws SQLException {
		conn.setAutoCommit(false);
		String sqlp1 = "drop table naplo";

		String sqlp2 = "drop table utas";
		String sqlp3 = "drop table ellenor";
		String sqlp4 = "drop table jarat";
		String sqlp5 = "drop table sofor ";
		try {
			s = conn.createStatement();
			s.executeUpdate(sqlp1);
			s.executeUpdate(sqlp2);
			s.executeUpdate(sqlp3);
			s.executeUpdate(sqlp4);
			s.executeUpdate(sqlp5);
			System.out.println("minden tabla torlese");
			conn.commit();
		} catch (Exception e) {
			try {

				conn.rollback();
				System.err.println("nem sikerult a tablak torlese :"
						+ e.getMessage());
			} catch (Exception ex) {
				System.out.println(ex.getMessage());
			}
		}
	}

	public void MetaAdatok() {

		DatabaseMetaData meta;
		try {
			meta = conn.getMetaData();
			System.out.println("Driver major version "
					+ meta.getDatabaseMajorVersion() + " driver minor version "
					+ meta.getDatabaseMinorVersion()
					+ " database product name " + meta.getDatabaseProductName()
					+ " driver name " + meta.getDriverName()
					+ " driver version " + meta.getDriverVersion());
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	public void kiiros() {
		System.out
				.println("--------------------------------------------------------------");
		System.out.println("\n \n \n");
	}

	public static void main(String[] args) throws SQLException {

		ab2bead b = new ab2bead();

		int mitvalasztott;
		int[] csakegyszer = new int[15];
		for (int i = 0; i < csakegyszer.length; i++)
			csakegyszer[i] = 0;

		do {

			System.out.println("Busz adatbazis");
			System.out.println("opciok:");
			if (csakegyszer[0] != 1)
				System.out.println("1. regisztralas");
			if (csakegyszer[1] != 1)
				System.out.println("2.kapcsolodas ");
			if (csakegyszer[2] != 1)
				System.out.println("3. lekapcsolodas");
			if (csakegyszer[3] != 1)
				System.out.println("4.sofor tabla letrehozasa");
			if (csakegyszer[4] != 1)
				System.out.println("5. jarat tabla letrehozasa");
			if (csakegyszer[5] != 1)
				System.out.println("6. naplo tabla letrehozasa");
			if (csakegyszer[6] != 1)
				System.out.println("7. utas tabla letrehozasa");
			if (csakegyszer[7] != 1)
				System.out.println("8. Ellenor tabla letrehozasa");
			if (csakegyszer[8] != 1)
				System.out.println("9. sofor tablaba adatok beszurasa");
			if (csakegyszer[9] != 1)
				System.out.println("10. Jarat tablaba adatok beszurasa ");
			if (csakegyszer[10] != 1)
				System.out.println("11. utas tablaba adatok beszurasa");
			if (csakegyszer[11] != 1)
				System.out.println("12. ellenor tablaba adatok beszurasa");
			System.out.println("13. Sofor tabla kilistazasa ");
			System.out.println("14. Jarat tabla kilistazasa");
			System.out.println("15. utas tabla kilistazasa");
			System.out.println("16. ellenor tabla kilistazasa");
			System.out.println("17. naplo tabla kilistazasa");
			System.out.println("18. uj sofor beszurasa");
			System.out.println("19. uj ellenor beszurasa");
			System.out.println("20. sofor tabla modositasa");
			System.out.println("21. ellenor tabla modositasa");
			System.out.println("22. ellenor tablabol torles");
			System.out.println("23. utas tablabol torles");
			if (csakegyszer[12] != 1)
				System.out.println("24. sofőr tarolt fuggveny elkeszitese");
			System.out.println("25. sofor tarolt fuggveny hasznalata");
			if (csakegyszer[13] != 1)
				System.out.println("26. sofor tarolt eljaras elkeszitese");
			System.out.println("27. sofor tarolt eljaras hasznalata");
			if (csakegyszer[14] != 1)
				System.out.println("28. minden tabla torlese");
			System.out.println("29. metaadatok lekerdezese");

			Scanner s = new Scanner(System.in);

			mitvalasztott = s.nextInt();
			switch (mitvalasztott) {
			case 1:
				b.Reg();
				csakegyszer[0] = 1;
				break;
			case 2:
				b.Kapcs();
				csakegyszer[1] = 1;
				break;
			case 3:
				b.LeKapcs();
				csakegyszer[2] = 1;
				break;
			case 4:
				b.SoforCreate();
				csakegyszer[3] = 1;
				break;
			case 5:
				b.JaratCreate();
				csakegyszer[4] = 1;
				break;
			case 6:
				b.NaploCreate();
				csakegyszer[5] = 1;
				break;
			case 7:
				b.UtasCreate();
				csakegyszer[6] = 1;
				break;
			case 8:
				b.EllenorCreate();
				csakegyszer[7] = 1;
				break;
			case 9:
				b.SoforInsert();
				csakegyszer[8] = 1;
				break;
			case 10:
				b.JaratInsert();
				csakegyszer[9] = 1;
				break;
			case 11:
				b.UtasInsert();
				csakegyszer[10] = 1;
				break;
			case 12:
				b.EllenorInsert();
				csakegyszer[11] = 1;
				break;
			case 13:
				b.SoforLista();
				break;
			case 14:
				b.JaratLista();
				break;
			case 15:
				b.UtasLista();
				break;
			case 16:
				b.EllenorLista();
				break;
			case 17:
				b.NaploLista();
				break;
			case 18:
				BufferedReader s2 = new BufferedReader(new InputStreamReader(
						System.in));
				try {
					System.out.println("Add meg az id-et");
					String id = s2.readLine();
					System.out.println("add meg a nevet");
					String nev = s2.readLine();
					System.out.println("Add meg a bert");
					int ber = Integer.parseInt(s2.readLine());
					System.out.println("Add meg a munkaorat");
					int munkaora = Integer.parseInt(s2.readLine());
					b.SoforBeszur(id, nev, ber, munkaora);
				} catch (Exception e) {

					System.out.println(e.getMessage());
				}
				break;
			case 19:
				b.EllenorBeszur();
				break;
			case 20:
				try {
					BufferedReader ss2 = new BufferedReader(
							new InputStreamReader(System.in));
					System.out.println("Add meg az id-et");
					String id1 = ss2.readLine();
					System.out.println("Add meg a bert");
					int ber1 = Integer.parseInt(ss2.readLine());
					b.SoforModosit(id1, ber1);
				} catch (Exception ex) {
					System.out.println(ex.getMessage());
				}
				break;
			case 21:
				b.EllenorModosit();
				break;
			case 22:
				try {
					BufferedReader s3 = new BufferedReader(
							new InputStreamReader(System.in));
					System.out.println("Add meg az id-et");
					String id2 = s3.readLine();
					b.EllenorTorol(id2);
				} catch (Exception ex) {
					System.out.println(ex.getMessage());
				}
				break;
			case 23:
				try {
					BufferedReader s4 = new BufferedReader(
							new InputStreamReader(System.in));
					System.out.println("Add meg az id-et");
					String id3 = s4.readLine();
					b.UtasTorol(id3);
				} catch (Exception ex) {
					System.out.println(ex.getMessage());
				}
				break;
			case 24:
				b.SoforTaroltf();
				csakegyszer[12] = 1;
				break;
			case 25:
				b.SoforTaroltfHiv();
				break;
			case 26:
				b.SoforTaroltE();
				csakegyszer[13] = 1;
				break;
			case 27:
				try {
					BufferedReader s5 = new BufferedReader(
							new InputStreamReader(System.in));
					System.out.println("Add meg az id-et");
					String id4 = s5.readLine();
					b.SoforTaroltEHiv(id4);
				} catch (Exception ex) {
					System.out.println(ex.getMessage());
				}
				break;
			case 28:
				b.MindenTorol();
				csakegyszer[14] = 1;
				break;
			case 29:
				try {
					b.MetaAdatok();
					break;
				} catch (Exception ex) {
					System.out.println(ex.getMessage());
				}
			}
			b.kiiros();
		} while (mitvalasztott != 3 || mitvalasztott != 28);

	}
}