JAVA /JDBC/GUI

[Vivek Shetty]

Hi
I was doing some program
My objective is to create a table in database with 5 fields .
I have created buttons and corresponding text fields
now i want those buttons to perform .
I am not getting any idea to move forward .
Please guide me
I have copy pasted the program below
If there is any mistake or the program could be written in simpler and efficient way that this please post it
I do not know if this is right way to show the codes
Please forgive me if i am wrong
Thank You in advance
Vivek

   package database;

import java.sql.*;

public class  MainClass1
{
	Connection con=null;

	public static void main(String arg[]) throws Exception 

	{
	Statement stmt=null;
	ResultSet rsSelect=null;
	String url = "jdbc:mysql://localhost/QueryBrowser";
	String user= "root";
	String pwd = "picavox";
	GuiCreation1 Gui = new GuiCreation1();
	}
	public Connection  dbconn()
		{
		try{
				Class.forName("com.mysql.jdbc.Driver").newInstance();
			    con = DriverManager.getConnection("jdbc:mysql://localhost:3306/QueryBrowser", "root", "picavox");
				return con;
		   }
		   catch(Exception e)
			{
			   System.out.println("Exception occured while creating the connection ");
			   e.printStackTrace();
			}
			return con;

		}
} 

  
package database;

import java.io.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.applet.*;
import java.sql.*;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;


class GuiCreation1 

	{
		PreparedStatement pstmt;
		Statement stmt = null;
		ResultSet rs = null;
		Connection connection = null;
		JPanel Contentpanel,PX;
		JTextField JTF1,JTF2,JTF3,JTF4,JTF5,JTF6;
		TextField dataInfo1,dataInfo2,dataInfo3,dataInfo4,dataInfo5;
		Choice datatypes1,datatypes2,datatypes3,datatypes4,datatypes5;
		
GuiCreation1()
		
	{
		JPanel Buttonpanel = new JPanel();
		JPanel Executepanel = new JPanel();
			   Contentpanel = new JPanel();
		JPanel   Fieldpanel = new JPanel(); 
		       PX = new JPanel();
		JPanel P1 = new JPanel();
		JPanel P2 = new JPanel();
		JPanel P3 = new JPanel();
		JPanel P4 = new JPanel();
		JPanel P5 = new JPanel();
		JPanel Title = new JPanel();

		JLabel JL = new JLabel(" TABLE CREATION ");
		
		JTF1 = new JTextField(10);
		JTF2 = new JTextField(10);
		JTF3 = new JTextField(10);
		JTF4 = new JTextField(10);
		JTF5 = new JTextField(10);
		JTF6 = new JTextField(10);
		JLabel l1,l2,l3,l4,l5,l6;
			   
		JFrame V = new JFrame("NEW WINDOW");
	
		JButton CREATE = new JButton ( " CREATE  " );
		JButton DELETE = new JButton ( " DELETE  " );
		JButton UPDATE = new JButton ( " UPDATE " );
		JButton EXECUTE = new JButton ( "EXECUTE" );
		JButton EXIT = new JButton ( "   EXIT      " );
		JButton REMOVE = new JButton ( "REMOVE " );

			   datatypes1 = new Choice();
		       datatypes2 = new Choice();
			   datatypes3 = new Choice();
		       datatypes4 = new Choice();
		       datatypes5 = new Choice();

		datatypes1.add("VARCHAR");
		datatypes1.add("INTEGER");
		datatypes1.add("FLOAT");
		datatypes1.add("CHAR");
		datatypes1.add("DOUBLE");

		datatypes2.add("VARCHAR");
		datatypes2.add("INTEGER");
		datatypes2.add("FLOAT");
		datatypes2.add("CHAR");
		datatypes2.add("DOUBLE");

		datatypes3.add("VARCHAR");
		datatypes3.add("INTEGER");
		datatypes3.add("FLOAT");
		datatypes3.add("CHAR");
		datatypes3.add("DOUBLE");

		datatypes4.add("VARCHAR");
		datatypes4.add("INTEGER");
		datatypes4.add("FLOAT");
		datatypes4.add("CHAR");
		datatypes4.add("DOUBLE");

		datatypes5.add("VARCHAR");
		datatypes5.add("INTEGER");
		datatypes5.add("FLOAT");
		datatypes5.add("CHAR");
		datatypes5.add("DOUBLE");
		

		V.setSize(750,500);
		V.setLocation(250,200);
		EXECUTE.setPreferredSize(new Dimension(120,50));


CREATE.addActionListener(new ActionListener()
	{
		public void actionPerformed(ActionEvent e)
			{
				Contentpanel.setVisible(true);
				PX.setVisible(true);
			}});
		

DELETE.addActionListener(new ActionListener()
	{
		public void actionPerformed(ActionEvent e)
			{
			Contentpanel.setVisible(false);
			PX.setVisible(true);
			try
					{
					MainClass1 mc = new MainClass1();
					connection = mc.dbconn();
					stmt = connection.createStatement();
					pstmt = connection.prepareStatement("DROP TABLE");
					pstmt.setString(1,JTF1.getText());
					int del = pstmt.executeUpdate();
					System.out.println(del+ " RECORD DELETED");
					}
				catch (SQLException s)
					{
						s.printStackTrace();
						System.out.println("SQL statement is not executed!");
					}
			}
	});

UPDATE.addActionListener(new ActionListener()
	{
		public void actionPerformed(ActionEvent e)
			{
			}
	});

EXECUTE.addActionListener(new ActionListener()
	{
		public void actionPerformed(ActionEvent e)
			{
			}
	});

EXIT.addActionListener(new ActionListener()
	{
		public void actionPerformed(ActionEvent e)
			{
				System.exit(0);
			}
	});

REMOVE.addActionListener(new ActionListener()
	{
		public void actionPerformed(ActionEvent e)
			{
				Contentpanel.setVisible(false);
				PX.setVisible(false);
			}
	});

	LayoutManager layout = new BoxLayout(Buttonpanel, BoxLayout.Y_AXIS);
	Buttonpanel.setLayout(layout);
	Buttonpanel.add(Box.createRigidArea(new Dimension(50,25)));
	Buttonpanel.add(CREATE);
	Buttonpanel.add(Box.createRigidArea(new Dimension(0,25)));
	Buttonpanel.add(DELETE);
	Buttonpanel.add(Box.createRigidArea(new Dimension(0,25)));
	Buttonpanel.add(UPDATE);
	Buttonpanel.add(Box.createRigidArea(new Dimension(0,25)));
	
	layout = new BoxLayout(Executepanel, BoxLayout.Y_AXIS);
    Executepanel.setLayout(layout);
	Executepanel.add(Box.createRigidArea(new Dimension(0,25)));
	Executepanel.add(EXECUTE);
	Executepanel.add(Box.createRigidArea(new Dimension(0,25)));
	Executepanel.add(EXIT);
	Executepanel.add(Box.createRigidArea(new Dimension(0,25)));
	Executepanel.add(REMOVE);
	Executepanel.add(Box.createRigidArea(new Dimension(0,25)));

	layout = new BoxLayout(PX , BoxLayout.X_AXIS);
	PX.setLayout(layout);
	l1 = new JLabel ( " TABLE NAME   :" );
	PX.add(Box.createRigidArea(new Dimension(150,10)));
	PX.add(l1);
	PX.add(JTF1);
	l2 = new JLabel ( " FIELD NAME 01  :" );
	l3 = new JLabel ( " FIELD NAME 02  :" );
	l4 = new JLabel ( " FIELD NAME 03  :" );
	l5 = new JLabel ( " FIELD NAME 04  :" );
	l6 = new JLabel ( " FIELD NAME 05  :" );

	layout = new BoxLayout(P1 , BoxLayout.X_AXIS);
	P1.setLayout(layout);
	P1.add(l2);
	P1.add(JTF2);
	P1.add(datatypes1);
	dataInfo1 = new TextField(10);
	dataInfo1.setEditable(true);
	P1.add(dataInfo1);

	layout = new BoxLayout(P2, BoxLayout.X_AXIS);
	P2.setLayout(layout);
	P2.add(l3);
	P2.add(JTF3);
	P2.add(datatypes2);
	dataInfo2 = new TextField(10);
	dataInfo2.setEditable(true);
	P2.add(dataInfo2);

	layout = new BoxLayout(P3, BoxLayout.X_AXIS);
	P3.setLayout(layout);
	P3.add(l4);
	P3.add(JTF4);
	P3.add(datatypes3);
	dataInfo3 = new TextField(10);
	dataInfo3.setEditable(true);
	P3.add(dataInfo3);

	layout = new BoxLayout(P4, BoxLayout.X_AXIS);
	P4.setLayout(layout);
	P4.add(l5);
	P4.add(JTF5);
	P4.add(datatypes4);
	dataInfo4 = new TextField(10);
	dataInfo4.setEditable(true);
	P4.add(dataInfo4);

	layout = new BoxLayout(P5, BoxLayout.X_AXIS);
	P5.setLayout(layout);
	P5.add(l6);
	P5.add(JTF6);
	P5.add(datatypes5);
	dataInfo5 = new TextField(10);
	dataInfo5.setEditable(true);
	P5.add(dataInfo5);

	layout = new BoxLayout(Fieldpanel, BoxLayout.Y_AXIS);
	Fieldpanel.setLayout(layout);
	Fieldpanel.add(Box.createRigidArea(new Dimension(0,25)));
	Fieldpanel.add(P1);
	Fieldpanel.add(Box.createRigidArea(new Dimension(0,25)));
	Fieldpanel.add(P2);
	Fieldpanel.add(Box.createRigidArea(new Dimension(0,25)));
	Fieldpanel.add(P3);
	Fieldpanel.add(Box.createRigidArea(new Dimension(0,25)));
	Fieldpanel.add(P4);
	Fieldpanel.add(Box.createRigidArea(new Dimension(0,25)));
	Fieldpanel.add(P5);

	datatypes1.addItemListener(new ItemListener()
		{
		public void itemStateChanged(ItemEvent ie)
			{
			String str = (String)datatypes1.getSelectedItem();
			dataInfo1.setText(str);
			}
		});

	datatypes2.addItemListener(new ItemListener()
		{
		public void itemStateChanged(ItemEvent ie)
			{
			String str = (String)datatypes2.getSelectedItem();
			dataInfo2.setText(str);
			}
		});


	datatypes3.addItemListener(new ItemListener()
		{
		public void itemStateChanged(ItemEvent ie)
			{
			String str = (String)datatypes3.getSelectedItem();
			dataInfo3.setText(str);
			}
		});


	datatypes4.addItemListener(new ItemListener()
		{
		public void itemStateChanged(ItemEvent ie)
			{
			String str = (String)datatypes4.getSelectedItem();
			dataInfo4.setText(str);
			}
		});


	datatypes5.addItemListener(new ItemListener()
		{
		public void itemStateChanged(ItemEvent ie)
			{
			String str = (String)datatypes5.getSelectedItem();
			dataInfo5.setText(str);
			}
		});		
	
		
	Contentpanel.add(PX);
	Contentpanel.add(Fieldpanel);
	Contentpanel.setVisible(false);
	PX.setVisible(false);
	
	Title.add(JL);
	V.add(Title , BorderLayout.NORTH);
	V.add(Buttonpanel , BorderLayout.WEST );
	V.add(Executepanel , BorderLayout.EAST);
	V.add(Contentpanel , BorderLayout.CENTER);
	V.add(PX , BorderLayout.NORTH);
	

	V.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	V.setVisible(true);
	}
	}