import java.util.*;
import java.io.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class gui implements ActionListener {
	
	private static JButton addButton;
	private static JButton dropButton;
	private static JButton alterButton;
	private static JButton viewButton;
      	private static JButton exitButton;

	//private static Connection con;
	
	public gui () {
		this.addButton = new JButton("Create Tables");
		this.dropButton = new JButton("Drop Tables");
		this.alterButton = new JButton("Alter Tables");
		this.viewButton = new JButton("View Tables");
	      	this.exitButton = new JButton("Exit");
		
		this.addButton.addActionListener(this);
      		this.dropButton.addActionListener(this);
      		this.alterButton.addActionListener(this);
      		this.viewButton.addActionListener(this);
      		this.exitButton.addActionListener(this);
	}
	

	private static class HelloWorldDisplay extends JPanel {
		public void paintComponent(Graphics g) {
         		super.paintComponent(g);
         		g.drawString("Hello World", 20, 30);
      		}
   	}
   
   	private static class exitHandler implements ActionListener {
      		public void actionPerformed(ActionEvent e) {
         	System.exit(0);
		}
      	}
	


	public void actionPerformed(ActionEvent e) {

		if (e.getSource() == addButton) {
			try{
			//step1 load the driver class  
			Class.forName("oracle.jdbc.driver.OracleDriver");  
			  
			//step2 create  the connection object  
			Connection con=DriverManager.getConnection(  
			"jdbc:oracle:thin:@oracle.scs.ryerson.ca:1521:orcl","etkim","04229574");  
			Statement stmt = con.createStatement();
			ResultSet rs=stmt.executeQuery("");
			while(rs.next())  
			System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"  "+rs.getString(3));  
			  
			//step5 close the connection object  
			con.close(); 
			}catch(Exception error){System.out.println(error);}
		}
		
		if (e.getSource() == viewButton) {
			try{
			//step1 load the driver class  
			Class.forName("oracle.jdbc.driver.OracleDriver");  
			  
			//step2 create  the connection object  
			Connection con=DriverManager.getConnection(  
			"jdbc:oracle:thin:@oracle.scs.ryerson.ca:1521:orcl","etkim","04229574");  
			Statement stmt = con.createStatement();
			ResultSet rs=stmt.executeQuery("SELECT table_name FROM user_tables");
			ResultSetMetaData rsmd = rs.getMetaData();
			int columnsNumber = rsmd.getColumnCount();
			while(rs.next())  {
				for (int i = 1; i <= columnsNumber; i++) {
				   if (i > 1) System.out.print(",  ");
				   String columnValue = rs.getString(i);
				   System.out.print(columnValue + " " + rsmd.getColumnName(i));
			       }
			       System.out.println("");
			}
				
			  
			//step5 close the connection object  
			con.close(); 
			}catch(Exception error){System.out.println(error);}
		}
	}

 
   
   	public static void main(String[] args) {
		gui g = new gui();

		try{  
			//step1 load the driver class  
			Class.forName("oracle.jdbc.driver.OracleDriver");  
			  
			//step2 create  the connection object  
			Connection con=DriverManager.getConnection(  
			"jdbc:oracle:thin:@oracle.scs.ryerson.ca:1521:orcl","etkim","04229574");  
			  
			//step3 create the statement object  
			Statement stmt=con.createStatement();  
			  
			//step4 execute query  
			ResultSet rs=stmt.executeQuery("select * from emp");  
			while(rs.next())  
			System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"  "+rs.getString(3));  
			  
			//step5 close the connection object  
			con.close();  
			  
			}catch(Exception e){ System.out.println(e);}  

      
      		HelloWorldDisplay displayPanel = new HelloWorldDisplay();
		


      		JPanel content = new JPanel();
      		content.setLayout(new GridLayout(5,1));
		content.add(addButton);
		content.add(dropButton);
		content.add(alterButton);
		content.add(viewButton);
      		content.add(exitButton);

                //SELECT table_name FROM user_tables


      		JFrame window = new JFrame("Database GUI");
      		window.setContentPane(content);
      		window.setSize(250,400);
      		window.setLocation(100,100);
      		window.setVisible(true);

		

   	
	}	
}