Cant get multiple row result in UI

[Sandeep Swaminathan]

I get ouput for this program but if there are something like 10 row I only get 1, the last result of the 10 .. what could be the problem?

 import javax.swing.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
//import java.awt.Component.*;
//import java.awt.Container.*;

public class demoProject extends JFrame
{
    private Connection connec;
    private JList D;
    private JButton R;
    private JComboBox A, B, C;
    private JTextArea TA;
    private ResultSet rs;
    
    Container c = getContentPane();
    
    public demoProject()
    {
        try
        {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
        }
        
        catch(Exception e)
        {
            System.err.println("Unable to connect to Driver");
            System.exit(1);
        }
        
    }
    
    private void alpha()
    {
         Vector v = new Vector();
         A = new JComboBox(v);
         JLabel lbl = new JLabel("A");
         add(lbl);
         try
         {
             Statement statement = connec.createStatement();
             rs = statement.executeQuery("select distinct A from ABCD");
            
             while(rs.next())
             {
                 A.addItem(rs.getString("A"));
             }
            
             rs.close();
         }
        
         catch(SQLException ee)
         {
             displaySQLErrors(ee);
         }
    }
    
    private void beta()
    {
         Vector v = new Vector();
         B = new JComboBox(v);
         JLabel lbl = new JLabel("B");
         add(lbl);
         try
         {
             
             Statement statement = connec.createStatement();
             rs = statement.executeQuery("select distinct B from ABCD");
            
             while(rs.next())
             {
                 B.addItem(rs.getString("B"));
             }
            
             rs.close();
             
         }
         
         catch(SQLException ee)
         {
             displaySQLErrors(ee);
         }
    }
    
    private void cat()
    {
        Vector v = new Vector();
        C = new JComboBox(v);
        JLabel lbl1 = new JLabel("C");
        add(lbl1);
        try
        {
            Statement statement = connec.createStatement();
      	    rs = statement.executeQuery("select distinct C from ABCD");
                while(rs.next())
                {
                    C.addItem(rs.getString("C"));
              	}
            rs.close();
         }
        
         catch(SQLException ee)
         {
             displaySQLErrors(ee);
         }
    }
        
    private void dog()
    {
         Vector v = new Vector();
         JLabel lbl = new JLabel("D");
         add(lbl);
         try
         {
             Statement statement = connec.createStatement();
             rs = statement.executeQuery("select distinct D from ABCD");
            
             while(rs.next())
             {
                 v.addElement(rs.getString("D"));
             }
           rs.close();
         }
        
         catch(SQLException ee)
         {
             displaySQLErrors(ee);
         }
        
         D.setListData(v);
    }
    
    private void buildA()
    {
        c.setLayout(new FlowLayout());
        alpha();
        JPanel first = new JPanel();
        first.add(A);
        c.add(first);
        show();
    }
    
    private void buildB()
    {
       	c.setLayout(new FlowLayout());
        beta();
        JPanel first = new JPanel();
        first.add(B);
        c.add(first);
        show();
    }
    
    private void buildC()
    {
        c.setLayout(new FlowLayout());
        cat();
        JPanel first = new JPanel();
        first.add(C);
        c.add(first);
        show();
    }
    
    private void buildD()
    {
        
        c.setLayout(new FlowLayout());
        D = new JList();
        dog();
        
       	D.setVisibleRowCount(8);
        
        JScrollPane scrollPane = new JScrollPane(D);
        
        R = new JButton("R"); 
        R.addActionListener(new ActionListener()
        {
            public void actionPerformed(ActionEvent e)
            {
                try
                {
                    Statement statement = connec.createStatement();
                    rs = statement.executeQuery("select EF from ABCD where B="+B.getSelectedItem()+"&&"+"A="+A.getSelectedItem()+"&&"+"D="+D.getSelectedValue()+"&&"+"C="+" "+ "'"+C.getSelectedItem()+"'");
                    
                   while(rs.next())
                    {
                        TA.setText(rs.getString("EF"));
                    }
                 }   
                    
                catch(SQLException eg)
                {
                    displaySQLErrors(eg);
                }
            }
        }
       );
       
        JPanel first = new JPanel();
        first.add(scrollPane);
        
	JPanel second = new JPanel();
        second.add(R);
        
	TA = new JTextArea(5,15);
        TA.setEditable(false);
        JPanel third = new JPanel();
        third.add(TA);
        
        c.add(first);
        c.add(second);
        c.add(third);
        
        setSize(840,380);
        show();
    }
    
    private void displaySQLErrors(SQLException e)
    {
        System.out.println("SQLException:" + e.getMessage());
        System.out.println("Vendor Error:" + e.getErrorCode());
        System.out.println("SQL State:" + e.getSQLState());
    }
    
    private void init()
    {
        connectTODB();
    }
    
    public void connectTODB()
    {
        try
        {
            connec = DriverManager.getConnection("jdbc:mysql://localhost/test");
        }
        
        catch(SQLException ef)
        {
            displaySQLErrors(ef);
        }
    }
    
    public static void main(String args[])
    {
        demoProject demoproject = new demoProject();
        
        demoproject.addWindowListener(new WindowAdapter()
            {
                public void windowClosing(WindowEvent e)
                {
                    System.exit(0);
                }
            }
        );
        
        demoproject.init();
        demoproject.buildA();
        demoproject.buildB();
        demoproject.buildC();
        demoproject.buildD();
    }
}   

[Michael Dunn]

possibly this
TA.setText(rs.getString("EF"));

perhaps it should be
TA.append(rs.getString("EF")+"\n");

but it's only a guess - can't compile it, and too many lines to read (other than a quick glance)

[Sandeep Swaminathan]

Wow! Thanks a lot! It worked .. But tell me how to introduce a scrollbar in a text area? if the data goes beyond the limit scrollbar must be enabled!

[Maneesh Godbole]

Just wrap the text area in a JScrollPane and add the scroll pane to the container

[Sandeep Swaminathan]

You mean to say something exactly similar to enabling scroll pane in jtable right?

[Maneesh Godbole]

Yes

[Sandeep Swaminathan]

Well I do have another doubt! but since its a related one I'm posting in the same forum! I use myjTextArea.setLineWrap(true) to wrap the line and myjTextArea.setWrapStyleWord(true)
wraps the word at whitespace. The requirement is to wrap at strings.

data is in datetime format which is something like 2008-12-20 17:35:45.02008-12-20 17:36:45.0 etc

If I use setWrapStyleWord(true) it gives me
2008-12-08
17:35:45.02008-12-20
17:36:45.0 etc

How to specify wrap like this

2008-12-20 17:35:45.0
2008-12-20 17:36:45.0
etc???