package put.pp.jse.bk;

import java.awt.BorderLayout;
import java.awt.FlowLayout;
import java.awt.Frame;
import java.awt.Label;
import java.awt.MouseInfo;
import java.awt.Point;
import java.awt.PointerInfo;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;
import java.awt.event.MouseMotionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.awt.image.ComponentColorModel;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.border.Border;

public class DatabaseViewer extends Frame implements MouseMotionListener
{

    public JFrame f;
    public JLabel j;
    public JButton b;
    public JButton b1;
    public JTextField t1;
    public JTextField t2;

    public int pX;
    public int pY;

    public void initComponents()
    {

        f = new JFrame("DatabaseViewer");

        f.setLayout(new BorderLayout());

        f.setSize(800, 600);

        b = new JButton("Wyczysc");
        b.setBounds(0, 50, 100, 400);
        b1 = new JButton("Wykonaj");
        b1.setBounds(690, 50, 100, 400);

        t1 = new JTextField("wprowadz sql statement");
        t1.setBounds(100, 50, 590, 400);


        t2 = new JTextField("lol");
        t2.setBounds(100,400, 590, 600);



        j=new JLabel("cos");
        j.setBounds(20,20,100,20);

        f.add(b1,BorderLayout.PAGE_START);
        f.add(b,BorderLayout.WEST);
        f.add(t1,BorderLayout.CENTER);

        //f.add(t2,BorderLayout.SOUTH);

        f.setLayout(null);
        f.setVisible(true);

        f.add(j);



        f.addMouseMotionListener(new MouseMotionListener()
        {

			@Override
			public void mouseDragged(MouseEvent e) {
				// TODO Auto-generated method stub

			}

			@Override
			public void mouseMoved(MouseEvent e) {
				j.setText(e.getX() + " " + e.getY());

			}
        });
        t1.addMouseMotionListener(new MouseMotionListener()
        {

			@Override
			public void mouseDragged(MouseEvent e) {
				// TODO Auto-generated method stub

			}

			@Override
			public void mouseMoved(MouseEvent e) {
				j.setText("x: " + e.getX() + " y: " + e.getY());

			}
        });

        b.addMouseMotionListener(new MouseMotionListener()
        {

			@Override
			public void mouseDragged(MouseEvent e) {
				// TODO Auto-generated method stub

			}

			@Override
			public void mouseMoved(MouseEvent e) {
				j.setText(e.getX() + " " + e.getY());

			}
        });
        b1.addMouseMotionListener(new MouseMotionListener()
        {

			@Override
			public void mouseDragged(MouseEvent e) {
				// TODO Auto-generated method stub

			}

			@Override
			public void mouseMoved(MouseEvent e) {
				j.setText(e.getX() + " " + e.getY());

			}
        });



        b.addActionListener(new ActionListener() {

            @Override
            public void actionPerformed(ActionEvent e) {
            	t1.setText("");
                //your actions
            }
        });

        t1.addActionListener(new ActionListener() {

            @Override
            public void actionPerformed(ActionEvent e) {

            	try {
					Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
				} catch (ClassNotFoundException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}

                String connectionUrl = "jdbc:sqlserver://localhost:1433;"
                        + "databaseName=NORTHWND;user=Bartek;password=q1w2e3r4;";
                try
                {
                    Connection con = DriverManager.getConnection(connectionUrl);
                    //PreparedStatement statement = con.prepareStatement("select * from Orders");
                    //String nowy = t1.getText();
                     PreparedStatement statement=con.prepareStatement("select * from Orders");


                     //statement.setString(1, "Ms.");

                    ResultSet myRes = statement.executeQuery();
                   String pom = "";
                    while (myRes.next())
                    {
                        System.out.println(myRes.getString("FirstName"));
                        pom+=myRes.getString("FirstName");
                        pom+="\n";
                    }
                    t1.setText(pom);
                    myRes.close();
                    con.close();

                }
                catch (SQLException z)
                {
                    // TODO Auto-generated catch block
                    z.printStackTrace();
                }
            }
        });
        //bazadanych

        b1.addActionListener(new ActionListener() {

            @Override
            public void actionPerformed(ActionEvent e) {

            	try {
					Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
				} catch (ClassNotFoundException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}

                String connectionUrl = "jdbc:sqlserver://localhost:1433;"
                        + "databaseName=NORTHWND;user=Bartek;password=q1w2e3r4;";
                try
                {
                    Connection con = DriverManager.getConnection(connectionUrl);
                    //PreparedStatement statement = con.prepareStatement("select * from Orders");
                    String nowy = t1.getText();
                     PreparedStatement statement=con.prepareStatement(nowy);


                     //statement.setString(1, "Ms.");

                    ResultSet myRes = statement.executeQuery();
                   String pom = "";
                    while (myRes.next())
                    {
                        System.out.println(myRes.getString("FirstName"));
                        pom+=myRes.getString("FirstName");
                        pom+="\n";
                    }
                    t1.setText(pom);
                    myRes.close();
                    con.close();

                }
                catch (SQLException z)
                {
                    // TODO Auto-generated catch block
                    z.printStackTrace();
                }


                //your actions
            }
        });






    }



    public static void main(String[] args)
    {
        DatabaseViewer b = new DatabaseViewer();
        b.initComponents();

//      java.awt.EventQueue.invokeLater(new Runnable()
//      {
//          @Override
//          public void run()
//          {
//              b.initComponents();
//              new DatabaseViewer().setVisible(true);
//          }
//      });

    }



	@Override
	public void mouseDragged(MouseEvent e) {
		// TODO Auto-generated method stub

	}



	@Override
	public void mouseMoved(MouseEvent e) {
		System.out.println("X : " + e.getX());
	       System.out.println("Y : " + e.getY());

	}

}