Sqlclient

* @(#)SQLClient.java
*
*
* @author
* @version 1.00 2009/7/23
*/

import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.ResultSetMetaData;
import java.util.Vector;
import javax.swing.*;
import javax.swing.border.*;
import java.awt.*;
import java.awt.event.*;



public class SQLClient extends JFrame
{
private Connection connection;
private Statement statement;
private JTextArea TextSQLCommand = new JTextArea();
private JTextArea TextSQLResult = new JTextArea();
private JTextField username = new JTextField();
private JTextField password = new JTextField();
private JComboBox URl = new JComboBox( new String[]{"","",""});
private JComboBox DriverManage = new JComboBox(new String []{
"com.mysql.jdbc.Driver","sun.jdbc.odbc.JdbcOdbcDriver","oracle.jdbc.driver.OracleDriver"});

private JButton ButtonExecuteSQL = new JButton("Execute SQL Command");
private JButton cleanSQLCommad = new JButton("Clear");
private JButton ConnectDB = new JButton("Connect to Database");
private JButton cleanSQLResult = new JButton("Clear Result");

private Border border1 = new TitledBorder(" Enter Any SQL Command : ");
private Border border2 = new TitledBorder(" SQL Execution Results : ");
private Border border3 = new TitledBorder(" Enter Database Information :");

private JLabel ConnectionStates = new JLabel(" No Connection Now ");

public SQLClient()
{

JScrollPane jsp1 = new JScrollPane(TextSQLCommand);
jsp1.setBorder(border1);

JScrollPane jsp2 = new JScrollPane(TextSQLResult);
jsp2.setBorder(border2);

JPanel panel1 = new JPanel(new FlowLayout(FlowLayout.RIGHT));
panel1.add(cleanSQLCommad);
panel1.add(ButtonExecuteSQL);

JPanel panel2 = new JPanel();
panel2.setLayout(new BorderLayout());
panel2.add(jsp1,BorderLayout.CENTER);
panel2.add(jsp2,BorderLayout.SOUTH);
panel2.setPreferredSize( new Dimension(100,100));

JPanel panel3 = new JPanel();
panel3.setLayout(new BorderLayout());
panel3.add(ConnectionStates,BorderLayout.CENTER);
panel3.add(ConnectDB,BorderLayout.EAST);

JPanel panel4 = new JPanel();
panel4.setLayout(new GridLayout(4,1,10,5));
panel4.add(URl);
panel4.add(DriverManage);
panel4.add(username);
panel4.add(password);

JPanel panel5 = new JPanel();
panel5.setLayout(new GridLayout(4,1));
panel5.add(new JLabel("JDBC Driver :"));
panel5.add(new JLabel("Database URl:"));
panel5.add(new JLabel("Username :"));
panel5.add(new JLabel("Password :"));

JPanel panel6 = new JPanel();
panel6.setLayout(new BorderLayout());
panel6.setBorder(border3);
panel6.add(panel4,BorderLayout.CENTER);
panel6.add(panel5,BorderLayout.WEST);

JPanel panel7 = new JPanel();
panel7.setLayout(new BorderLayout());
panel7.add(panel3,BorderLayout.SOUTH);
panel7.add(panel6,BorderLayout.CENTER);

JPanel panel8 = new JPanel();
panel8.setLayout(new BorderLayout());
panel8.add(panel2,BorderLayout.CENTER);
panel8.add(panel7,BorderLayout.WEST);

JPanel panel9 = new JPanel(new FlowLayout(FlowLayout.LEFT));
panel9.add(cleanSQLResult);

URl.setEditable(true);
DriverManage.setEditable(true);


}


public static void main(String[] args)
{
JFrame frame = new SQLClient();
frame.setSize(400,400);
frame.setVisible(true);

}



}

/**