import java.sql.*;
import java.io.*;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.UnavailableException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
import javax.swing.*;
import java.awt.*;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.awt.event.KeyEvent;
import java.awt.event.KeyListener;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.event.ChangeEvent;
import javax.swing.event.ChangeListener;
import javax.swing.text.Document;
import javax.swing.event.DocumentEvent;
import javax.swing.event.DocumentListener;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.awt.datatransfer.DataFlavor;
import java.awt.datatransfer.StringSelection;
import java.awt.Toolkit;
import java.awt.datatransfer.Clipboard;


public class Esimerkki extends JFrame {

	private   		JTextField nameText = new JTextField(10);
	private			JButton DB1 = new JButton("Print Database");
	private			JButton DB2 = new JButton("Insert to Database");


	private			JTextField emailText = new JTextField(10);

	private			JLabel nimi= new JLabel("Nimi");
	private			JLabel maili = new JLabel("Email");

	private			JPanel panel1 = new JPanel();
	private			JPanel panel2 = new JPanel();
	private			JPanel panel3 = new JPanel();
	private			JPanel panel4 = new JPanel();
	private 		JTextArea textArea = new JTextArea();
	public  		ResultSet rs= null;

	protected static Connection con = null;


   public void  printDB() throws IOException{



   try {
    	 ResultSet tableRs = con.getMetaData().getTables(null,
    		        "", "HEPPI", null);
    	 if   (!tableRs.next()) {
   String sql;
     sql = "CREATE TABLE HEPPI" +" ( NIMI VARCHAR(45), EMAIL VARCHAR(65) )";

     Statement stmt = con.createStatement();
     stmt.executeUpdate(sql);
     stmt.close(); }
     } catch (Exception e) {
         System.out.println("Taulun lisäys epäonnistui!");
     }




     try {

         Statement Stmt = con.createStatement();


         rs = Stmt.executeQuery("SELECT * FROM HEPPI");
          while (rs.next()) {



        	  System.out.println ("hippi: " + rs.getString(1));
        	  System.out.println ("heppa: " + rs.getString(2));
        	  }
        	  } catch (SQLException e) {
        	  e.printStackTrace();
        	  }



}




        	  public  void  insertToDB() throws IOException {

        		  try {
        		    	 PreparedStatement insertStmt;

        		    	 insertStmt = con.prepareStatement("INSERT INTO HEPPI VALUES(?, ?)");
        		         insertStmt.setString(1, nameText.getText());
        		         insertStmt.setString(2, emailText.getText());

        		         insertStmt.executeUpdate();
        		         insertStmt.close();
        		         System.out.println("Lisäys onnistui");
        		       } catch(Exception e) {
        		         System.out.println("Lisäys epäonnistui!");
        		       }
        		     }







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

				String url= "jdbc:mysql://localhost:3306/javatesti";
			     String ajuri= "com.mysql.jdbc.Driver";
			     String tunnus = "testaaja";
			     String salasana = "sala";




			        Class.forName(ajuri);
			        con = DriverManager.getConnection(url,tunnus,salasana);



			     }
			        catch (Exception e)
			           {
			               System.err.println ("Cannot connect to database server");
			               System.out.println(e);
			           }
			        new Esimerkki ();
			     }



		Esimerkki (){


			GridLayout gridLayout = new GridLayout(0,1);
			FlowLayout napit = new FlowLayout();
			napit.setAlignment(FlowLayout.LEADING);
			napit.setHgap(10);

			Container content = getContentPane();

		   nameText.addActionListener(new ActionListener() {
		    	public void actionPerformed(ActionEvent evt) {
		    	    String text1 = nameText.getText();

		    	}
		   });

		   emailText.addActionListener(new ActionListener() {
		    	public void actionPerformed(ActionEvent evt) {
		    	    String text2 = emailText.getText();

		    	}
		   });



			/*  DB1.addActionListener(new ActionListener() {
				      public void actionPerformed(ActionEvent e) {
				        try {printDB(); }
				        catch (Exception ee) { }
				      }
				    }); */
			  DB2.addActionListener(new ActionListener() {
			      public void actionPerformed(ActionEvent e) {
			        try {insertToDB(); }
			        catch (Exception ee) { }
			      }
			    });

			  DB1.addActionListener(new ActionListener() {
			  public void actionPerformed(ActionEvent e) {
				  try {

				         Statement Stmt = con.createStatement();


				         rs = Stmt.executeQuery("SELECT * FROM HEPPI");
				          while (rs.next()) {

				        String hep =	  rs.getString(1);


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



				}

			});


			  	textArea.setPreferredSize(new Dimension(700, 300));


			  	panel4.add(textArea);
			  	panel4.add(panel3);
			   panel4.add(panel2);



			   panel1.setLayout(napit);
			   panel1.add(DB1);
			   panel1.add(DB2);

			   panel3.setLayout(gridLayout);
			   panel3.add(nimi);
			   panel3.add(maili);

			   panel2.setLayout(gridLayout);
			   panel2.add(nameText);
			   panel2.add(emailText);

			   content.add(panel4, BorderLayout.NORTH);
			 /*  content.add(panel3, BorderLayout.WEST);

			    content.add(panel2, BorderLayout.CENTER); */
			    content.add(panel1, BorderLayout.SOUTH);
			    pack();
			    setVisible(true);



	  }
}