import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import com.mysql.jdbc.Driver;

class MainFrame extends JFrame implements ActionLister{
        JPanel contentPane;
        BorderLayout borderLayout1=new BorderLayout(5,10);
        Label prompt;
        Choice firstname;
        Button querybutton;
        TextArea result;
        
        pubilc MainFrame(){
                contentPane=(JPanel)this.getContentPane();
                contentPane.setLayout(borderLayout1);
                this.setTitle("DBQuery");
                addWindowListener(new WindowAdapter(){
                        pubilc void windowClosing(WindowEvent e){
                                System.exit(0);                
                        }
                });
                prompt=new Label("firstname");
                firstname=new Choice();
                querybutton=new Button("Query");
                result=new TextArea();
                try{
                        Class.forName("com.mysql.jdbc.Driver").newInstance();
                        String url="jdbc:mysql://localhost/test?user=root&password=147";
                        String ls_1="select firstname from employee";
                        
                        Connection con=DriverManager.getConnection(url);
            Stmt=con.createStatement();
            while(rs.next()){
                    firstname.add(rs.getString(1));
                    
            }
            rs.close();
            stmt.close();
            con.close();    
                }
                catch(SQLException sple){}
                catch(Exception e){}
                contentPane.add(prompt,BorderLayout.WEST);
                contentPane.add(firstname,BorderLayout.CENTER);
                contentPane.add(querybutton,BorderLayout.EAST);
                contentPane.add(result,BorderLayout.SOUTH);
            querybutton.addActionListener(this);
                
        }
        
        pubilc void actionPerformed(ActionEvent e){
                if(e.getSource()==querybutton){
                        try{
                                Class.forName("com.mysql.jdbc.Driver").newInstance();
                                
                                String url="jdbc:mysql://localhost/test?user=root&password=147";
                                String queryfirstname=firstname.getSelectedItem();
                                String ls_1="select*from employee"+"where firstname='"+queryfirstname+"'";
                                Connection con=DriverManager.getConnection(url,user,password);
                                Statement Stmt=con.createStatement();
                                ResultSet rs=stmt.executeQuery(ls_1);
                                result.setText("");
                                while(re.next()){
                                        String msg=rs.getString(1)+"|"+
                                        rs.getString(2)+"|"+
                                        rs.getString(3)+"|"+
                                        rs.getString(4)+"|"+
                                        rs.getString(5);
                                        result.append(msg);
                                        
                                }
                                rs.close();
                                stmt.close();
                                con.close();
                                
                        }
                        catch(SQLException sqle){}
                        catch(Exception exce){}
                        
                }
        }
        
        public static void main(String args[]){
                MainFrame frame=new MainFrame();
                frame.resize(400,300);
                frame.show();
        }
}