package uebungen;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;

public class uebungen extends JFrame {

	public static void main(String[] args) {
		new uebungen();
	}

	ResultSet res = null;
	Statement s = null;
	Connection con = null;
	boolean fett = false;

	boolean passworttest = false;
	boolean benutzertest = false;

	String benutzersql;
	String passwortsql;

	JPanel panel1 = new JPanel(new FlowLayout());
	JPanel panel2 = new JPanel(new FlowLayout());

	JDialog login = new JDialog();
	JLabel benutzer = new JLabel("Benutzername:");
	JLabel passwort = new JLabel("Passwort:");

	JTextField benutzertext = new JTextField();
	JTextField passworttext = new JTextField();

	JButton loginbutton = new JButton("Einloggen");

	JLabel name = new JLabel("Nachname");
	JLabel vname = new JLabel("Vorname");
	JLabel strasse = new JLabel("Straße");
	JLabel plz = new JLabel("Postleitzahl");
	JLabel ort = new JLabel("Ort");
	JLabel hausnr = new JLabel("Hausnummer");
	JLabel gebdat = new JLabel("Geburtsdatum");

	JTextField nametext = new JTextField();
	JTextField vnametext = new JTextField();
	JTextField strassetext = new JTextField();
	JTextField plztext = new JTextField();
	JTextField orttext = new JTextField();
	JTextField hausnrtext = new JTextField();
	JTextField gebdattext = new JTextField();

	JButton zurück = new JButton("Zurück");
	JButton anzeigen = new JButton("Anzeigen");
	JButton vor = new JButton("Vor");

	public uebungen() {
		this.setTitle("Datenbank: uebungen");
		this.setSize(300, 300);
		this.setResizable(false);
		this.login();

	}

	public void login() {
		login.setLayout(new FlowLayout());
		login.setVisible(true);
		login.setSize(300, 150);
		login.add(benutzer);
		benutzer.setPreferredSize(new Dimension(80, 20));
		login.add(benutzertext);
		benutzertext.setPreferredSize(new Dimension(150, 20));
		login.add(passwort);
		passwort.setPreferredSize(new Dimension(80, 20));
		login.add(passworttext);
		passworttext.setPreferredSize(new Dimension(150, 20));
		login.add(loginbutton);
		loginbutton.setPreferredSize(new Dimension(200, 20));
		loginbutton.addActionListener(new loginListener());

		if (benutzertest == true && passworttest == true) {

			this.setVisible(true);
			this.init();
			login.setVisible(false);

		}
	}

	public void con1() {
		try {
			fett = true;
			Connection con = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/uebungen", "root", "");
			Statement s = con.createStatement();
			ResultSet res = s.executeQuery("select *  from  t_ma;");

			if (fett == true) {
				res.next();
				nametext.setText(res.getString("name"));
				vnametext.setText(res.getString("vname"));
				strassetext.setText(res.getString("str"));
				plztext.setText(res.getString("plz"));
				orttext.setText(res.getString("ort"));
				hausnrtext.setText(res.getString("hnr"));
				gebdattext.setText(res.getString("gebdat"));
			}
		}

		catch (SQLException ex) {
			ex.printStackTrace();
		}
	}

	public void init() {
		this.getContentPane().add(BorderLayout.CENTER, panel1);
		this.getContentPane().add(BorderLayout.SOUTH, panel2);

		panel1.add(vname);
		vname.setPreferredSize(new Dimension(90, 20));
		panel1.add(vnametext);
		vnametext.setPreferredSize(new Dimension(150, 20));
		panel1.add(name);
		name.setPreferredSize(new Dimension(90, 20));
		panel1.add(nametext);
		nametext.setPreferredSize(new Dimension(150, 20));
		panel1.add(strasse);
		strasse.setPreferredSize(new Dimension(90, 20));
		panel1.add(strassetext);
		strassetext.setPreferredSize(new Dimension(150, 20));
		panel1.add(plz);
		plz.setPreferredSize(new Dimension(90, 20));
		panel1.add(plztext);
		plztext.setPreferredSize(new Dimension(150, 20));
		panel1.add(ort);
		ort.setPreferredSize(new Dimension(90, 20));
		panel1.add(orttext);
		orttext.setPreferredSize(new Dimension(150, 20));
		panel1.add(hausnr);
		hausnr.setPreferredSize(new Dimension(90, 20));
		panel1.add(hausnrtext);
		hausnrtext.setPreferredSize(new Dimension(150, 20));
		panel1.add(gebdat);
		gebdat.setPreferredSize(new Dimension(90, 20));
		panel1.add(gebdattext);
		gebdattext.setPreferredSize(new Dimension(150, 20));

		panel2.add(zurück);
		zurück.setPreferredSize(new Dimension(80, 20));
		panel2.add(anzeigen);
		anzeigen.setPreferredSize(new Dimension(100, 20));
		panel2.add(vor);
		vor.setPreferredSize(new Dimension(80, 20));

		zurück.addActionListener(new zurückListener());
		anzeigen.addActionListener(new anzeigenListener());
		vor.addActionListener(new vorListener());

	}

	public class zurückListener implements ActionListener {
		public void actionPerformed(ActionEvent e) {

			try {

				if (res.previous()) {

					nametext.setText(res.getString("name"));
					vnametext.setText(res.getString("vname"));
					strassetext.setText(res.getString("str"));
					plztext.setText(res.getString("plz"));
					orttext.setText(res.getString("ort"));
					hausnrtext.setText(res.getString("hnr"));
					gebdattext.setText(res.getString("gebdat"));
				}

			} catch (SQLException ex) {
				ex.printStackTrace();
			}

		}
	}

	public class anzeigenListener implements ActionListener {
		public void actionPerformed(ActionEvent e) {
			con1();

		}

	}

	public class vorListener implements ActionListener {
		public void actionPerformed(ActionEvent e) {

			// try {
			//
			// if (res.next()) {
			//
			// nametext.setText(res.getString("name"));
			// vnametext.setText(res.getString("vname"));
			// strassetext.setText(res.getString("str"));
			// plztext.setText(res.getString("plz"));
			// orttext.setText(res.getString("ort"));
			// hausnrtext.setText(res.getString("hnr"));
			// gebdattext.setText(res.getString("gebdat"));
			// }
			//
			// }
			// catch (SQLException ex) {
			// ex.printStackTrace();
			// }
			//
		}

	}

	public class loginListener implements ActionListener {
		public void actionPerformed(ActionEvent e) {
			try {
				Connection con2 = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/login", "root", "");
				Statement s2 = con2.createStatement();
				ResultSet res2 = s2.executeQuery("select *  from  login;");

				if (res2.next()) {
					benutzersql = res2.getString(1);
					passwortsql = res2.getString(2);
					if (benutzertext.getText().equals(benutzersql)
							&& passworttext.equals(passwortsql)) {

						benutzertest = true;
						passworttest = true;
						login();



					} else {
						JDialog falscheeingabe = new JDialog();
						JLabel loginfailed = new JLabel("Falsche Eingabe!");
						falscheeingabe.setVisible(true);
						falscheeingabe.setSize(100, 100);
						falscheeingabe.setLayout(new FlowLayout());
						falscheeingabe.add(loginfailed);
					}


				}
			} catch (SQLException ex) {
				ex.printStackTrace();
			}

		}
	}
}