JTable - JDBC - Vectors

[Peter Phung]

Can anyone tell me of anywhere that i can find a good example of how to populate a JTable with data from a database using a vector.
I'd like to ask a more specific question about my code but i'm not sure where it's not working, and there's about 6-7 hundred lines of code. But if anyone's brave enough to read all of it, let me know and i'll post it.

[Renee Zhang]

Hi Peter,
In my project, I have several tables to display the data which I retrieved from the database. I have 2 type of tables. In one table each row is a vector. This kind of table is to display data only. Another type of table each row is an object. If you don't mind, post your code and let us take a look.
Sincerely
Renee

[Peter Phung]

Ok, here's all of the code:

//======================================================================
//            Title:results table for db_queryTool.java/ArchiveTool
//          Version:1
//           Author    :-P	    eter Phung
//    Creation date:22-02-2002
// Revision History:   
//      Description:Frame to display database results        
//======================================================================
package archivetool;
import java.awt.*;
import java.awt.Color;
import java.net.*;
import java.lang.*;
import java.io.*;
import java.awt.event.*;
import java.util.*;
import java.sql.*;
import javax.swing.event.*;
import javax.swing.AbstractButton;
import javax.swing.table.*;
import javax.swing.*;
public class resultsTable extends JDialog {
    JLabel messages;
    JPanel resPanel;
    JTable resTable;
    JScrollPane sp;
    JButton okResult, emailResult, printResult;
    JTextArea tf;
    GridBagLayout resLayout;
    GridBagConstraints resConstraints;
    Color maroon = new Color(102,0,0);
    ResultTableData t_data;
    
    public resultsTable(Frame frame, String title, boolean modal, String params) {
super(frame, title, modal);
try {
    init(params);
    pack();
}
catch (Exception ex) {
    ex.printStackTrace();
}
    }
    public void init(String params) {
t_data = new ResultTableData(params);
resPanel = new JPanel();
okResult = new JButton("Ok");
emailResult = new JButton("Email results");
printResult = new JButton("Print Table");
resLayout = new GridBagLayout();
resConstraints = new GridBagConstraints();
messages = new JLabel("messages");
resConstraints.fill = GridBagConstraints.HORIZONTAL;
resConstraints.anchor = GridBagConstraints.CENTER;
resPanel.setLayout(resLayout);
resPanel.setForeground(maroon);
resPanel.setBackground(Color.white);
resTable = new JTable();
resTable.setForeground(maroon);
resTable.setBackground(Color.white);
resTable.setAutoCreateColumnsFromModel(false);
resTable.setModel(t_data);
for (int k = 0; k < ResultTableData.m_columns.length; k++) {
    DefaultTableCellRenderer renderer = new DefaultTableCellRenderer();
    renderer.setHorizontalAlignment(
ResultTableData.m_columns[k].m_alignment);
    TableColumn column = new TableColumn(k, ResultTableData.m_columns[k].m_width, renderer, null);
    resTable.addColumn(column);
}
sp = new JScrollPane();
sp.getViewport().add(resTable);
resConstraints.gridx = 0;
resConstraints.gridy = 1;
resConstraints.gridheight = 1;
resConstraints.gridwidth = 5;
resLayout.setConstraints(sp, resConstraints);
resPanel.add(sp);
//constraints omitted
okResult.setForeground(maroon);
okResult.setBackground(Color.white);
resConstraints.gridx = 4;
resConstraints.gridy = 2;
resConstraints.gridheight = 1;
resConstraints.gridwidth = 1;
resLayout.setConstraints(okResult, resConstraints);
resPanel.add(okResult);
ActionListener okListener = new ActionListener() {
public void actionPerformed (ActionEvent event) {
    messages.setText("Closing");
    hide();
    dispose();
}
    };
okResult.addActionListener(okListener);

emailResult.setForeground(maroon);
emailResult.setBackground(Color.white);
resConstraints.gridx = 0;
resConstraints.gridy = 2;
resConstraints.gridheight = 1;
resConstraints.gridwidth = 1;
resLayout.setConstraints(emailResult, resConstraints);
resPanel.add(emailResult);
ActionListener emailListener = new ActionListener() {
public void actionPerformed (ActionEvent event) {
    messages.setText("Emailing");
    emaiOps();//line don't work yet
    //hide();
    //dispose();
}
    };
emailResult.addActionListener(emailListener);

printResult.setForeground(maroon);
printResult.setBackground(Color.white);
resConstraints.gridx = 3;
resConstraints.gridy = 2;
resConstraints.gridheight = 1;
resConstraints.gridwidth = 1;
resLayout.setConstraints(printResult, resConstraints);
resPanel.add(printResult);
ActionListener printListener = new ActionListener() {
public void actionPerformed (ActionEvent event) {
    messages.setText("Printing");
    hide();
    dispose();
}
    };
printResult.addActionListener(printListener);
getContentPane().add(resPanel);
setTitle("ArvinMeritor : Database Query Results");
pack();
WindowListener wndCloser = new WindowAdapter() {
public void windowClosing(WindowEvent e) {
    hide();
    dispose();
}
    };
addWindowListener(wndCloser);
//====================================================================
//center the frame
//====================================================================
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = this.getSize();
if (frameSize.height > screenSize.height)
    frameSize.height = screenSize.height;
if (frameSize.width > screenSize.width)
    frameSize.width = screenSize.width;
this.setLocation((screenSize.width - frameSize.width) / 2, (screenSize.height - frameSize.height) / 2);
show();
    }
    
    public void emaiOps() {
//do something
    }    
}
class TableData {
    public String m_fileName;
    public String m_drawingSize;
    public String m_format;
    public String m_drawingName;
    public String m_revision;
    public String m_projectNumber;
    public String m_customerName;
    public String m_drawingStatus;
    public String m_fileLocation;
    public String m_designerName;
    public String m_archivingTime;
    public String m_description;
    public int m_fileSize;
    public TableData (String fileName, String drawingSize, String format, String drawingName,
 String revision, String projectNumber, String customerName, String drawingStatus, String
 fileLocation, String designerName, String archivingTime, String description, int fileSize) {
m_fileName = fileName;
m_drawingSize = drawingSize;
m_format = format;
m_drawingName = drawingName;
m_revision = revision;
m_projectNumber = projectNumber;
m_customerName = customerName;
m_drawingStatus = drawingStatus;
m_fileLocation = fileLocation;
m_designerName = designerName;
m_archivingTime = archivingTime;
m_description = description;
m_fileSize = fileSize;
    }
}
class ResultTableData extends AbstractTableModel {
    protected Vector resVector;
    protected Statement Stmt;
    protected Connection C;
    protected ResultSet RS;
    protected JTextArea tf;
    protected String query;
    static final public ColumnData m_columns[] = {
    new ColumnData("File Name", 100, JLabel.LEFT),
    new ColumnData("Drawing Size", 100, JLabel.LEFT),
    new ColumnData("CAD Format", 100, JLabel.LEFT),
    new ColumnData("Part Number", 100, JLabel.LEFT),
    new ColumnData("Revision", 100, JLabel.LEFT),
    new ColumnData("Project Number", 100, JLabel.LEFT),
    new ColumnData("Customer Name", 100, JLabel.LEFT),
    new ColumnData("Drawing Status", 100, JLabel.LEFT),
    new ColumnData("File Location", 100, JLabel.LEFT),
    new ColumnData("Designer Name", 100, JLabel.LEFT),
    new ColumnData("Archiving Time", 100, JLabel.LEFT),
    new ColumnData("Description", 100, JLabel.LEFT),
    new ColumnData("File Size", 100, JLabel.LEFT),
};
    public ResultTableData(String params) {
//====================================================================
//Connect to the database
//====================================================================
if (loadDriver()) {
    if(!getConnection()) 
System.out.println("\n*** Error ***\nConnection Error!");
}else{
    System.out.println("\n*** Error ***\n Driver load error!");
}
resVector = new Vector();
queryBuild(params);
    }
    protected boolean queryDB(String qu) {
try {
    Stmt = C.createStatement();
    RS = Stmt.executeQuery(qu);
    boolean hasData = false;
    while (RS.next()) {
if (!hasData) {
    resVector.removeAllElements();
    hasData = true;
}
String fileName = RS.getString(1);
String drawingSize = RS.getString(2);
String format = RS.getString(3);
String drawingName = RS.getString(4);
String revision = RS.getString(5);
String projectNumber = RS.getString(6);
String customerName = RS.getString(7);
String drawingStatus = RS.getString(8);
String fileLocation = RS.getString(9);
String designerName = RS.getString(10);
String archivingTime = RS.getString(11);
String description = RS.getString(12);
int fileSize = RS.getInt(13);
resVector.addElement(new TableData(fileName, drawingSize, format,
 drawingName, revision, projectNumber, customerName, drawingStatus, fileLocation,
 designerName, archivingTime, description, fileSize));
    }
    RS.close();
    Stmt.close();
    C.close();
}
catch (SQLException E) {
    E.printStackTrace();
      System.out.println("\nSQLException: " + E.getMessage());
      System.out.println("\nSQLState:     " + E.getSQLState());
      System.out.println("\nVendorError:  " + E.getErrorCode());
    return false;
}
return true;
    }
    protected boolean getConnection() {
try {
    C = DriverManager.getConnection(
"jdbc:mysql://*SERVER*:*PORT*/*DATABASE NAME*?user=USER&password=*****");
}
        catch (SQLException E) {
            System.out.println("\nSQLException: " + E.getMessage());
            System.out.println("\nSQLState:     " + E.getSQLState());
            System.out.println("\nVendorError:  " + E.getErrorCode());
    return false;
}
return true;
   }
    protected boolean loadDriver() {
try {
    Class.forName("org.gjt.mm.mysql.Driver").newInstance();
} catch (Exception E) {
    System.out.println("\nUnable to load driver.");
    return false;
}
return true;
    }
    public void queryBuild(String params) {
tf = new JTextArea();
params = params.replace('*', '%');
StringTokenizer eaParam = new StringTokenizer(params, "@");
int noRecs = eaParam.countTokens();
String condArr[] = new String[noRecs];
int i = 0;
while (eaParam.hasMoreTokens()) {
    condArr[i] = eaParam.nextToken();
    i++;
}
//====================================================================
//====================================================================
String optionsArray[] = new String[noRecs];
String tableArray[] = new String[noRecs];
String joinConditionsArray[] = new String[noRecs];
String booleanLogicArray[] = new String[noRecs];
String conditionsArray[] = new String[noRecs];
int k = 0;
while (k<noRecs) {
    StringTokenizer indiParam = new StringTokenizer(condArr[k], "+");
    int countParam = indiParam.countTokens();
    String indivParam[] = new String[countParam];
    int l = 0;
    while (indiParam.hasMoreTokens()) {
indivParam[l] = indiParam.nextToken();
l++;
    }
    int lastEntry = countParam-1;
    int equals1 = countParam-3;
    int equals2 = countParam-4;
    int cond1 = countParam-2;
    int cond2 = countParam-3;
    if ((indivParam[0].equals("Drawing")) || (indivParam[1].equals("Name"))) {
optionsArray[k] = "Part.Name";
tableArray[k] = "Part";
joinConditionsArray[k] = "Part.ID = File.PartID";
    }else if (indivParam[0].equals("Format")) {
optionsArray[k] = "CADFormat.Format";
tableArray[k] = "CADFormat";
joinConditionsArray[k] = "CADFormatID=CADFormat.ID";
    }else if (indivParam[0].equals("Customer")) {
optionsArray[k] = "Customer.Name";
tableArray[k] = "Customer";
joinConditionsArray[k] = "Customer.ID=Projects.CustomerID AND Projects.ID=File.ProjectsID";
    }else if (indivParam[0].equals("Project")) {
optionsArray[k] = "Projects.PDP";
tableArray[k] = "Projects";
joinConditionsArray[k] = "Projects.ID=File.ProjectsID";
    }else if (indivParam[0].equals("Status")) {
optionsArray[k] = "DrawingStatus.Status";
tableArray[k] = "DrawingStatus";
joinConditionsArray[k] = "File.DrawingStatusID=DrawingStatus.ID";
    }else if (indivParam[0].equals("Designer")) {
optionsArray[k] = "Designer.Name";
tableArray[k] = "Designer";
joinConditionsArray[k] = "Designer.ID=File.DesignerID";
    }else if (indivParam[0].equals("Archiving")) {
optionsArray[k] = "File.ArchivingTime";
tableArray[k] = "File";
joinConditionsArray[k] = " ";
    }else if (indivParam[0].equals("File")) {
optionsArray[k] = "Locations.Name";
tableArray[k] = "Location";
joinConditionsArray[k] = "File.LocationsID = Locations.ID";
    }
    if ((indivParam[lastEntry].equals("AND"))||(indivParam[lastEntry].equals("OR"))) {
booleanLogicArray[k] = indivParam[lastEntry];
    } else {
booleanLogicArray[k] = "NONE";
    }
    if (indivParam[equals1].equals("=")) {
conditionsArray[k] = indivParam[cond1];
    }else if (indivParam[equals2].equals("=")) {
conditionsArray[k] = indivParam[cond2]+" "+indivParam[cond1];
    }
    k++;
}
//============================================================
//eliminate duplicate values in the table names array
//============================================================
TreeSet treeset = new TreeSet();
for (int z=0; z<tableArray.length; z++) {
    treeset.add(tableArray[z]);
}
int m = treeset.size();
String tableArr[] = new String[m];
int z = 0;
while (z<m) {
    tableArr[z] = treeset.first().toString();
    treeset.remove(treeset.first());
    z++;
}
//============================================================
//eliminate duplicate values in the join conditions array
//============================================================
TreeSet joinSet = new TreeSet();
for (z=0; z<joinConditionsArray.length; z++) {
    joinSet.add(joinConditionsArray[z]);
}
m = joinSet.size();
String jcArray[] = new String[m];
z = 0;
while (z<m) {
    jcArray[z] = joinSet.first().toString();
    joinSet.remove(joinSet.first());
    z++;
}
tf.append("SELECT ");
m = optionsArray.length;
z = 0;
while (z<m) {
    tf.append(optionsArray[z]+", ");
    z++;
}
tf.append("File.Filesize FROM ");
z = 0;
m = tableArr.length;
while (z<m) {
    if (!tableArr[z].equals("File")) {
if (!tableArr[z].equals("Projects")) {
    tf.append(tableArr[z]+", ");
}
    }
    z++;
}
tf.append("File, Projects WHERE (");
z = 0;
m = optionsArray.length;
while (z<m) {
    tf.append("("+optionsArray[z]+" LIKE '"+conditionsArray[z]+"')");
    if (!booleanLogicArray[z].equals("NONE")) {
tf.append(" "+booleanLogicArray[z]+" ");
    }
    z++;
}
tf.append(")");
z = 0;
m = jcArray.length;
while (z<m) {
    if (!jcArray[z].equals(" ")) {
tf.append(" AND "+jcArray[z]);
    }
    z++;
}
//====================================================================
//
//====================================================================
tf.setText("SELECT Part.Name, CADFormat.Format, Customer.Name, Projects.PDP,
 DrawingStatus.Status, Designer.Name, Locations.Name, File.ArchivingTime, File.Name,
 DrawingSize.Size, Revision.Revision, File.Description, File.Filesize FROM Part, CADFormat, Customer, Projects, DrawingStatus,
 Designer, File, Locations, DrawingSize, Revision WHERE ((");
z = 0;
m = optionsArray.length;
while (z<m) {
    tf.append("("+optionsArray[z]+" LIKE '"+conditionsArray[z]+"')");
    if (!booleanLogicArray[z].equals("NONE")) {
tf.append(" "+booleanLogicArray[z]+" ");
    }
    z++;
}
tf.append(") AND (File.DrawingSizeID=DrawingSize.ID AND File.CADFormatID=CADFormat.ID AND
 File.PartID=Part.ID AND Part.RevisionID=Revision.ID AND
 File.ProjectsID=Projects.ID AND Projects.CustomerID=Customer.ID AND
 File.DrawingStatusID=DrawingStatus.ID AND File.LocationsID=Locations.ID AND
 File.DesignerID=Designer.ID AND Designer.Location=Locations.ID)) ORDER BY Part.Name ASC");
//====================================================================
//
//====================================================================
query = tf.getText();
System.out.println(query);
queryDB(query);
    }
    public int getRowCount() {
return resVector==null ? 0 : resVector.size();
    }
    public int getColumnCount() {
return m_columns.length;
    }
    public Object getValueAt(int nRow, int nCol) {
if (nRow < 0 || nRow >= getRowCount())
    return "";
TableData row = (TableData)resVector.elementAt(nRow);
switch (nCol) {
    case 0: return row.m_fileName;
    case 1: return row.m_drawingSize;
    case 2: return row.m_format;
    case 3: return row.m_drawingName;
    case 4: return row.m_revision;
    case 5: return row.m_projectNumber;
    case 6: return row.m_customerName;
    case 7: return row.m_drawingStatus;
    case 8: return row.m_fileLocation;
    case 9: return row.m_designerName;
    case 10: return row.m_archivingTime;
    case 11: return row.m_description;
    case 12: return new Integer(row.m_fileSize);
}
return "";
    }
}
class ColumnData {
    public String m_title;
    public int m_width;
    public int m_alignment;
    public ColumnData(String title, int width, int alignment) {
m_title = title;
m_width = width;
m_alignment = alignment;
    }
}

Hope that u can find what's wrong with it.
[ April 15, 2002: Message edited by: Peter Phung ]
[ April 15, 2002: Message edited by: Peter Phung ]
[ April 15, 2002: Message edited by: Peter Phung ]

[Peter Phung]

I have found that my table is querying the database and displaying results properly, but the column names are not appearing as i wanted. The column names appear as A, B, etc.. Can anyone tell me how to change this.
Also my table does not appear wide enough to show the values in the cells. Can someone point me in the right direction on this one too.
Thanks in advance for any help

[Renee Zhang]

Hi Peter,
If your table column names appear as A, B, etc, that's because you didn't override getColumnNames in your talbeModel.Please add public String getColumnName(int col) {
return m_columns[col];
} to your table model.
I have no idea why
for (int k = 0; k < ResultTableData.m_columns.length; k++) {
DefaultTableCellRenderer renderer = new DefaultTableCellRenderer();
renderer.setHorizontalAlignment(ResultTableData.m_columns[k].m_alignment);
TableColumn column = new TableColumn(k, ResultTableData.m_columns[k].m_width, renderer, null);
resTable.addColumn(column);
}
is not working. How about try another way which is working in my project.
for (int k = 0; k <
TableColumn column = resTable.getColumnModel().getColumn(k);
column.setPreferredWidth(ResultTableData.m_columns[k].m_width);
column.setMaxWidth(ResultTableData.m_columns[k].m_width);
column.setMinWidth(ResultTableData.m_columns[k].m_width);
}
resTable = new JTable() {
public TableCellRenderer getCellRenderer(int row, int col) {
DefaultTableCellRenderer renderer = new DefaultTableCellRenderer();
renderer.setHorizontalAlignment(ResultTableData.m_columns[col].m_alignment);
return renderer;
}
};
Good luck!
Renee

[Renee Zhang]

Sorry it should be
resTable = new JTable(t_data) {
public TableCellRenderer getCellRenderer(int row, int col) {
DefaultTableCellRenderer renderer = new DefaultTableCellRenderer();
renderer.setHorizontalAlignment(ResultTableData.m_columns[col].m_alignment);
return renderer;
}
};

[Peter Phung]

I've tried adding

 
    public String getColumnName(int col) {
return m_columns[col];
    }
 

like u suggested, but i get this compile error :

archivetool/resultsTable.java:650: incompatible types
found   : archivetool.ColumnData
required: java.lang.String
        return m_columns[col];
                        ^
1 error

The other part of code works fine. Thank you.
Any further help that u can offer would be appreciated.

[Peter Phung]

I've solved the problem now by adding .m_title to the code :

 
public String getColumnName(int column) {
return m_columns[column].m_title;
}
 

Thanks Renee for your help

[Peter Phung]

Does anyone know how to make a Table scrollable?
I've tried adding the table to a scrollpane but it doesn't work.
The code that i have so far is :

 resTable = new JTable(t_data)
sp = new JScrollPane(resTable);
sp.setPreferredSize(new Dimension(775,400)); 

I've also tried adding the table to the scrollpane using a seperate command after instantiating the scrollpane.
Please help because this is really confusing me

[Nathan Pruett]

What do you mean by "it doesn't work"?

-Nate

[Peter Phung]

I mean that looking at the display, the table is obviously bigger than the viewable area, but there are no scrollbars.
I've tried to use the line
sp.getViewport().add(resTable);
after calling the constructor, but i get the same result. I've had to change the preferred size of the columns to take account of this, but this causes the table to truncate the column names. If u have any suggestions, i would be grateful

[Nathan Pruett]

Not sure why you aren't getting the default behavior...

Here's some code that shows the usual way to use a table in a scroll pane... ( also, table.setPreferredScrollableViewportSize() is usually better than calling scrollpane.setPreferredSize()... ) Hopefully this will help you out some...

import java.awt.*;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
public class ScrollTableTest extends JFrame {
    
    private JTable table;
    
    public static void main( String[] arg ) {
        new ScrollTableTest();
    }
    
    public ScrollTableTest() {
        super( "Watch My Table SCROLL!!!!" );
        table = new JTable( new MyModel() );
        JScrollPane scroll = new JScrollPane( table );
        int colz = table.getColumnModel().getTotalColumnWidth(); 
        int rowz = 5 * table.getRowHeight( 1 );
        table.setPreferredScrollableViewportSize( new Dimension( colz, rowz ) );
        getContentPane().add( scroll );
        setDefaultCloseOperation( EXIT_ON_CLOSE );
        pack();
        show();
    }
    
    private class MyModel extends DefaultTableModel {
        
        private Object[][] data = {
            { "Superman",  Boolean.TRUE, Boolean.TRUE, Boolean.TRUE },
            { "Batman", Boolean.TRUE, Boolean.TRUE, Boolean.TRUE },
            { "Spider-man", Boolean.TRUE, Boolean.TRUE, Boolean.TRUE },
            { "The Tick", Boolean.TRUE, Boolean.FALSE, Boolean.TRUE },
            { "Aquaman", Boolean.TRUE, Boolean.FALSE, Boolean.TRUE },
            { "The Hulk", Boolean.TRUE, Boolean.TRUE, Boolean.TRUE },
            { "Wonder Woman", Boolean.TRUE, Boolean.FALSE, Boolean.FALSE },
            { "Iron Man", Boolean.TRUE, Boolean.FALSE, Boolean.TRUE }
        };
        private Object[] colNames = { "Superhero", "Comic", "Movie", "Cartoon" };
        
        public MyModel() {
            super();
            setDataVector( data, colNames );
        }
    }
}

-Nate

[Peter Phung]

Thanks for the help Nate, but i've come up with another problem.
I've got my code compiling and running now but i'm unsure of how to add my table to the rest of my gui.
THe code i have so far is :

 
public void init() {
//omitted code
resConstraints.gridx = 0;
resConstraints.gridy = 1;
resConstraints.gridheight = 1;
resConstraints.gridwidth = 5;
resLayout.setConstraints(getTableScrollPane(params), resConstraints);
resPanel.add(getTableScrollPane(params));
//omitted code
}
    private JScrollPane getTableScrollPane(String params) {
if (sp == null) {
    sp = new JScrollPane();
    sp.setVerticalScrollBarPolicy(JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED);
    sp.setHorizontalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
    Dimension dim = new Dimension(getTablePanel(params).getSize().width-10,
        getTablePanel(params).getSize().height-80);
    sp.getViewport().setPreferredSize(dim);
    sp.getViewport().add(getTablePanel(params));
}
return sp;
    }
    private JTable getTablePanel(String params) {
if (resTable == null) {
    t_data = new ResultTableData(params);
    resTable = new JTable(t_data);
    resTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
    resTable.setBorder(new EmptyBorder(5,5,5,5));
    for (int k = 0; k < ResultTableData.m_columns.length; k++) {
TableColumn column = resTable.getColumnModel().getColumn(k);
column.setPreferredWidth(ResultTableData.m_columns[k].m_width);
column.setMinWidth(ResultTableData.m_columns[k].m_width);
    }
    int colz = resTable.getColumnModel().getTotalColumnWidth(); 
    int rowz = 5 * resTable.getRowHeight( 1 );
    resTable.setPreferredScrollableViewportSize( new Dimension( colz, rowz ) );
}
return resTable;
    }
 

normally i would use a line like
container.add(component);
But i've been unsuccessful in my attempts so far.
Please could u suggest a way of adding the table to my container.

[Nathan Pruett]

For adding a component to a JScrollPane after it is constructed you would call scollPane.setViewportView( component )...

-Nate

[Peter Phung]

What i actually meant was,
my scrollpane is created using the method
getTableScrollPane(String params)
I don't know wether or not the table has been placed in the scrollpane because the scrollpane does not appear in my GUI.
All code relating to this was in my last post. Please can you help

[Doanh Nguyen]

Originally posted by Peter Phung:
the table is obviously bigger than the viewable area, but there are no scrollbars.

JScollPane = ViewPort + ScrollBars
If you use JScrollPane, the scrollbars are included. If you could parse the resultset into the arrays as required in the code example below, using JTable is quite convenient:

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
public class Java {
public static void main(String args[]) {
String tableName = "Coffee Price List";
Object[] columnNames =
{"Brand", "Supplier", "Price", "Origin"};
Object[][] tableData = {
{"Arabia", new Float(57910000), new Float(14.80), "south" },
{"Colombian", null, new Float(13.90), "north" },
{"Java", new Float(108200000), new Float(12.55), "east" },
{"Arabia", new Float(57910000), new Float(14.80), "south" },
{"Colombian", null, new Float(13.90), "north" },
{"Arabia", new Float(57910000), new Float(14.80), "south" },
{"Colombian", null, new Float(13.90), "north" },
{"Java", new Float(108200000), new Float(12.55), "east" },
{"Amaretto", new Float(149600000), new Float(12.73), "east" },
{"MoonLight", new Float(384400), new Float(13.46), "west"},
{"Almond", new Float(227940000), new Float(16.94), "midwest" },
{"Amaretto", new Float(149600000), new Float(12.73), "east" },
{"Java", new Float(108200000), new Float(12.55), "east" },
{"Amaretto", new Float(149600000), new Float(12.73), "east" },
{"MoonLight", new Float(384400), new Float(13.46), "west"},
{"Almond", new Float(227940000), new Float(16.94), "midwest" },
{"Mint", new Float(9378), new Float(12.52), "southeast" },
{"Chocolate", new Float(23459), new Float(12.6), "northwest" },
{"MoonLight", new Float(384400), new Float(13.46), "west"},
{"Almond", new Float(227940000), new Float(16.94), "midwest" },
{"Mint", new Float(9378), new Float(12.52), "southeast" },
{"Chocolate", new Float(23459), new Float(12.6), "northwest" },
{"Mint", new Float(9378), new Float(12.52), "southeast" },
{"Chocolate", new Float(23459), new Float(12.6), "northwest" },
};
new Display(tableName, columnNames, tableData );
}
}

class Display {
JFrame window = new JFrame();
String title;
String text = "";

public Display(String tableName, Object[] columnNames, Object[][] tableData) {
JTable table = new JTable(tableData, columnNames);
JScrollPane scrollableTable = new JScrollPane(table);
JFrame mainWindow = new JFrame(tableName);
mainWindow.setContentPane(scrollableTable);
mainWindow.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent evt) {
System.exit(0);
}
});
mainWindow.pack();
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = mainWindow.getSize();
if (frameSize.height > screenSize.height)
frameSize.height = screenSize.height;
if (frameSize.width > screenSize.width)
frameSize.width = screenSize.width;
frameSize.height = 35 * tableData.length;
if (frameSize.height > 300) frameSize.height = 300;
mainWindow.setSize(frameSize.width, frameSize.height);
mainWindow.setLocation((screenSize.width - frameSize.width) / 2, (screenSize.height - frameSize.height) / 2);
mainWindow.setVisible(true);
}

}
[ April 19, 2002: Message edited by: Doanh Nguyen ]
[ April 19, 2002: Message edited by: Doanh Nguyen ]

[Peter Phung]

Doanh,
How do i parse the data into arrays like you suggested?
All of my data is in a vector populated by objects of type TableData.