how to display list data on separate lines?

[Jade Davidson]

I am finally having some success getting my program to work. I connected to the database and am getting the data back. But how do I get the column data to display on separate lines in the listbox? I am adapting it from a non-GUI program which used /n.
This is the code:

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.net.*;
import java.io.*;
   public class DatabaseFrame extends Frame
                     implements ActionListener, ItemListener {
      
      List tables = new List(5);
      List columns = new List(5);
      TextArea input = new TextArea(5,50);
      TextArea output = new TextArea(10,50);
      Button clear = new Button("Clear");
      Button execute = new Button("Execute");
      static Connection conClient;
      static Statement stmtClient;
   public DatabaseFrame (String title) {
      setTitle(title);
      setLayout(new BorderLayout());
      Panel p1 = new Panel();
      p1.setLayout(new GridLayout(1,2));
      tables.addActionListener(this);
      tables.addItemListener(this);
      columns.addActionListener(this);
      columns.addItemListener(this);
      p1.add(tables);
      p1.add(columns);
      Panel p2 = new Panel();
      p2.setLayout(new GridLayout(2,2));
      p2.add(input);
      p2.add(output);
      Panel p3 = new Panel();
      p3.setLayout(new GridLayout(1,2));
      clear.addActionListener(this);
      execute.addActionListener(this);
      addWindowListener(new CloseWindow());
      p3.add(clear);
      p3.add(execute);
      add(p1, "North");
      add(p2, "Center");
      add(p3, "South");
      
      try{ 
         // 1.) Register the ODBC/JDBC DSN
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         // 2.) Instantiate connection and statement objects
         String sURL = "jdbc :-o	 dbc:JavaClassDSN";
         conClient = DriverManager.getConnection(sURL);
         stmtClient = conClient.createStatement();
    
         // 3.) Get all the tables found in the database
         DatabaseMetaData dbMetaData = conClient.getMetaData();
         String[] sTables = {"TABLE"};   
         ResultSet rsTables = dbMetaData.getTables(null, null, "%", sTables);
         while (rsTables.next()) {  
            String name  = rsTables.getString("TABLE_NAME");   
            giveTableDetails(name);  
            tables.add(name);
         }
          
          }catch (Exception e) {
          System.out.println("DatabaseFrame.java Error occured:");
          e.printStackTrace();
     }
   }
   private void giveTableDetails(String sTableName) throws Exception {
      String sColumnHeadings = "";
      //tables.add(sTableName, 2);
      
   // Open a result set for the passed in table name:
      String sQuery = "SELECT * FROM " + sTableName;
      ResultSet rsTableInfo = stmtClient.executeQuery(sQuery);
      
   // Open a meta result set for the passed in table name
  //     showing the column name and type:
         ResultSetMetaData rsMetaData = rsTableInfo.getMetaData();
         
         for (int iCount = 1; iCount <= rsMetaData.getColumnCount(); iCount++)  {
           
          
           sColumnHeadings += rsMetaData.getColumnLabel(iCount);  
              
         }      
   
 // (3) Write out the data details:
        columns.add(sColumnHeadings, 1);
        while (rsTableInfo.next()) {
           String sColumnData = "   ";
           for (int iCount = 1; iCount <= rsMetaData.getColumnCount(); iCount++)  {
               sColumnData += rsTableInfo.getString(iCount);  
                 
           }   
        columns.add(sColumnData, 3);
        }
   }
   public void actionPerformed(ActionEvent event) {
      Object source = event.getSource();
         if (source == "clear") {
            removeAll();
         }
   }
   public void itemStateChanged(ItemEvent event) {
      
   
   }
   public static void main(String[] args) {
      DatabaseFrame f = new DatabaseFrame("DatabaseFrame");
      f.setSize(500,400);
      f.show();
   }
   class CloseWindow extends WindowAdapter {
      public void windowClosing(WindowEvent event) {
      try{
         stmtClient.close();
      }catch (Exception e) {
          System.out.println("DatabaseFrame.java Error occured:");
          e.printStackTrace();
       } 
       System.exit(0);
      }
   }
 } 
 

[Jade Davidson]

Never mind. I just handed the program in.