import java.awt.EventQueue;
import javax.swing.*;
import javax.swing.JFrame;
import javax.swing.GroupLayout;
import javax.swing.GroupLayout.Alignment;
import javax.swing.JLabel;
import java.awt.Font;
import javax.swing.JCheckBox;
import javax.swing.LayoutStyle.ComponentPlacement;
import javax.swing.JTextField;
import javax.swing.JButton;
import static alt.kom.przychodnia.Przychodnia.password;
import static alt.kom.przychodnia.Przychodnia.url;
import static alt.kom.przychodnia.Przychodnia.user;
import java.sql.PreparedStatement;



public class OknoB {

	private JFrame frame;
	private JTextField textField;
	private JTextField textField_1;
	private JTextField textField_2;
	private JTextField textField_3;
	private JTextField textField_4;
	String imie;





	public OknoB() {
		initialize();
	}


	private void initialize() {
		public static final String driver = "oracle.jdbc.OracleDriver";
	    public static final String url = "jdbc:oracle:thin:@localhost:1521:xe";
	    public static final String user = "chris";
	    public static final String password = "hwds9176";
	    Statement stmt = null;
	    Connection con = null;
	    ResultSet rs = null;
	    int aktRzad = 0;

		frame = new JFrame();
		frame.setBounds(100, 100, 682, 500);

		JLabel lblNewLabel = new JLabel("L E K A R Z E");
		lblNewLabel.setFont(new Font("Tahoma", Font.PLAIN, 57));

		JCheckBox chckbxWolnyTermin = new JCheckBox("Wolny termin");
		chckbxWolnyTermin.setFont(new Font("Tahoma", Font.PLAIN, 14));

		textField = new JTextField();
		textField.setColumns(10);
		imie=textField.getText().to string

		textField_1 = new JTextField();
		textField_1.setColumns(10);

		textField_2 = new JTextField();
		textField_2.setColumns(10);

		textField_3 = new JTextField();
		textField_3.setColumns(10);

		textField_4 = new JTextField();
		textField_4.setColumns(10);

		JLabel lblNewLabel_1 = new JLabel("Numer");
		lblNewLabel_1.setFont(new Font("Tahoma", Font.PLAIN, 14));

		JLabel lblNewLabel_2 = new JLabel("Imie");
		lblNewLabel_2.setFont(new Font("Tahoma", Font.PLAIN, 14));

		JLabel lblNewLabel_3 = new JLabel("Pesel");
		lblNewLabel_3.setFont(new Font("Tahoma", Font.PLAIN, 14));

		JLabel lblNewLabel_4 = new JLabel("");

		JLabel lblNewLabel_5 = new JLabel("Nazwisko");
		lblNewLabel_5.setFont(new Font("Tahoma", Font.PLAIN, 14));

		JLabel lblNewLabel_6 = new JLabel("Telefon");
		lblNewLabel_6.setFont(new Font("Tahoma", Font.PLAIN, 14));

		JButton btnNewButton = new JButton("Poka\u017C wszystkich");

		JButton button = new JButton("Dodaj do Bazy");
		GroupLayout groupLayout = new GroupLayout(frame.getContentPane());
		groupLayout.setHorizontalGroup(
			groupLayout.createParallelGroup(Alignment.TRAILING)
				.addGroup(groupLayout.createSequentialGroup()
					.addContainerGap(166, Short.MAX_VALUE)
					.addComponent(lblNewLabel, GroupLayout.PREFERRED_SIZE, 344, GroupLayout.PREFERRED_SIZE)
					.addGap(155))
				.addGroup(groupLayout.createSequentialGroup()
					.addGap(57)
					.addGroup(groupLayout.createParallelGroup(Alignment.TRAILING)
						.addComponent(lblNewLabel_1)
						.addComponent(lblNewLabel_2)
						.addComponent(lblNewLabel_4)
						.addComponent(lblNewLabel_3)
						.addComponent(lblNewLabel_5)
						.addComponent(lblNewLabel_6))
					.addPreferredGap(ComponentPlacement.RELATED, 28, Short.MAX_VALUE)
					.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
						.addComponent(chckbxWolnyTermin)
						.addGroup(groupLayout.createParallelGroup(Alignment.TRAILING, false)
							.addGroup(groupLayout.createSequentialGroup()
								.addComponent(btnNewButton, GroupLayout.PREFERRED_SIZE, 144, GroupLayout.PREFERRED_SIZE)
								.addPreferredGap(ComponentPlacement.RELATED, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
								.addComponent(button, GroupLayout.PREFERRED_SIZE, 144, GroupLayout.PREFERRED_SIZE))
							.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
								.addComponent(textField_2, GroupLayout.PREFERRED_SIZE, 384, GroupLayout.PREFERRED_SIZE)
								.addComponent(textField, GroupLayout.PREFERRED_SIZE, 384, GroupLayout.PREFERRED_SIZE)
								.addComponent(textField_3, GroupLayout.PREFERRED_SIZE, 384, GroupLayout.PREFERRED_SIZE)
								.addComponent(textField_1, GroupLayout.PREFERRED_SIZE, 384, GroupLayout.PREFERRED_SIZE)
								.addComponent(textField_4, GroupLayout.PREFERRED_SIZE, 384, GroupLayout.PREFERRED_SIZE))))
					.addGap(141))
		);
		groupLayout.setVerticalGroup(
			groupLayout.createParallelGroup(Alignment.LEADING)
				.addGroup(groupLayout.createSequentialGroup()
					.addGap(33)
					.addComponent(lblNewLabel, GroupLayout.PREFERRED_SIZE, 48, GroupLayout.PREFERRED_SIZE)
					.addGap(58)
					.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
						.addComponent(textField, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
						.addComponent(lblNewLabel_1))
					.addGap(9)
					.addGroup(groupLayout.createParallelGroup(Alignment.TRAILING)
						.addComponent(lblNewLabel_2)
						.addComponent(textField_1, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
					.addPreferredGap(ComponentPlacement.UNRELATED)
					.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
						.addComponent(textField_2, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
						.addComponent(lblNewLabel_5))
					.addPreferredGap(ComponentPlacement.UNRELATED, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
					.addGroup(groupLayout.createParallelGroup(Alignment.TRAILING)
						.addGroup(groupLayout.createSequentialGroup()
							.addComponent(textField_3, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
							.addPreferredGap(ComponentPlacement.UNRELATED)
							.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
								.addComponent(textField_4, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
								.addComponent(lblNewLabel_6))
							.addGap(12))
						.addGroup(groupLayout.createSequentialGroup()
							.addGroup(groupLayout.createParallelGroup(Alignment.TRAILING)
								.addComponent(lblNewLabel_3)
								.addComponent(lblNewLabel_4))
							.addGap(50)))
					.addGap(16)
					.addComponent(chckbxWolnyTermin)
					.addGap(29)
					.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
						.addComponent(button, GroupLayout.PREFERRED_SIZE, 60, GroupLayout.PREFERRED_SIZE)
						.addComponent(btnNewButton, GroupLayout.PREFERRED_SIZE, 60, GroupLayout.PREFERRED_SIZE))
					.addGap(47))
		);
		frame.getContentPane().setLayout(groupLayout);
		frame.setVisible(true);
	}

	public void Wczytaj()
    {
        try{
            con = DriverManager.getConnection(url,user,password);
            stmt = con.createStatement();

            String SQL = "SELECT * FROM Nazwa tabeli";
            ResultSet rs = stmt.executeQuery(SQL);

                while(rs.next())
                {

                String id = Integer.toString(element 1);
                String imie = rs.getString("element2");
                String nazwisko = rs.getString("element3");
                String ulica = rs.getString("Element 4");
                String nr_domu_lokalu = rs.getString("Element5");


                model.addRow(new Object[] {imie,nazwisko,telefon,pesel});
                }



        } catch (SQLException err) {
            JOptionPane.showMessageDialog(PrzychodniaJFrame.this, err.getMessage());
        }

    }
	public void Zapisz(){

		String id = textField.getText();
        String imie = textField_2.getText();
        String nazwisko = textField_3.getText();
        String ulica = textField_4.getText();
        String domu = textField_5.getText();

        String SQL = "INSERT INTO Lekarze"
                + "(element 1,element 2,element 3,element 4,element 5) VALUES"
                + "(?,?,?,?,?)";
        try{
        	  PreparedStatement preparedStatement = con.prepareStatement(SQL);

              preparedStatement.setString(2,imie);
              preparedStatement.setString(3,nazwisko);
              preparedStatement.setString(4,ulica);
              preparedStatement.setString(5,domu);
        }
	}