package put.pp.jse.pg;
import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;
import java.awt.event.MouseMotionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

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

public class DatabaseViewer extends JFrame{
	static int x = 800, y=600;
	static JFrame frame;
	static JButton button1, button2;
	static JLabel j;
	static JTextField text;
	static MouseMotionListener MML = new MouseMotionListener(){

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

		}

		@Override
		public void mouseMoved(MouseEvent e) {
			// TODO Auto-generated method stub
			String tmp = "Pozycja myszki: x = "+e.getX()+" y = "+e.getY();
			j.setText(tmp);
		}


	};




	public static void main(String[] args) {
		java.awt.EventQueue.invokeLater(new Runnable() {
			@Override
			public void run() {
			new DatabaseViewer().initComponents();
			}
			}) ;
	}

	public void initComponents(){
		frame = new JFrame("SuperBaza");
		frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		//frame.getContentPane().add(, BorderLayout.CENTER);
		frame.setSize(x, y);

		frame.setLayout(new BorderLayout());

		button1 = new JButton("Wyczysc");
		button1.setBounds(0, 50, 100, y-50);
		button1.addMouseMotionListener(MML);
		button1.addActionListener(new ActionListener(){

			@Override
			public void actionPerformed(ActionEvent e) {
				text.setText("");

			}

		});
		button2 = new JButton("Wykonaj");
		button2.setBounds(x-100, 50, 100, y-50);
		button2.addMouseMotionListener(MML);

		button2.addActionListener(new ActionListener(){

			@Override
			public void actionPerformed(ActionEvent e) {


				   final String DB_URL = "jdbc:sqlserver://localhost:1433;" +
			         "databaseName=NORTHWND;user=nag;password=admin1234";

				   Connection conn = null;
				   Statement stmt = null;
				   try{

				      Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");


				      System.out.println("Connecting to database...");
				      conn = DriverManager.getConnection(DB_URL);


				      System.out.println("Creating statement...");
				      stmt = conn.createStatement();
				      String sql ="USE NORTHWND;";
				      sql = text.getText();
				      ResultSet rs = stmt.executeQuery(sql);

				      String all="";
				      while(rs.next()){
				         //Retrieve by column name
				         all += rs.getString("ContactName");
				         all+='\n';
				         //int age = rs.getInt("age");
				         //String first = rs.getString("first");
				         //String last = rs.getString("last");

				         //Display values
				         //System.out.print(", Age: " + age);
				         //System.out.print(", First: " + first);
				         //System.out.println(", Last: " + last);
				      }
				      text.setText(all);
				      //STEP 6: Clean-up environment
				      rs.close();
				      stmt.close();
				      conn.close();
				   }catch(SQLException se){
				      //Handle errors for JDBC
				      se.printStackTrace();
				   }catch(Exception e1){
				      //Handle errors for Class.forName
				      e1.printStackTrace();
				   }finally{
				      //finally block used to close resources
				      try{
				         if(stmt!=null)
				            stmt.close();
				      }catch(SQLException se2){
				      }// nothing we can do
				      try{
				         if(conn!=null)
				            conn.close();
				      }catch(SQLException se){
				         se.printStackTrace();
				      }//end finally try
				   }//end try
				   System.out.println("Goodbye!");
				   }});


		text = new JTextField();
	    text.setBounds(100, 50, x-200, y-50);
		text.addMouseMotionListener(MML);

	    j=new JLabel("");
	    j.setBounds(10,5,1000,20);
		j.addMouseMotionListener(MML);
		frame.addMouseMotionListener(MML);





	    frame.add(j,  BorderLayout.NORTH);
	    frame.add(button1, BorderLayout.EAST);
	    frame.add(button2, BorderLayout.WEST);
	    frame.add(text);
		frame.setVisible(true);

	}
}