Populate a JTable from a ResultSet

Hello,
I’ll try to summarize the code in steps:

1- in your method you declare objects in which you return the records from the database (one object for each field) e.g.:
Col1 = new String[100];
Col2 = new String[100];
....

2- you declare an object data of type Object as follows:
data = new Object[200][N]; // N being the number of columns of your JTable 200 rows

3- you open your connection to the database ... (Class.forName.. and the accompanying chatter)

4- the query

5- you retrieve the query result into a ResultSet

// stmt being the preparedStatement
ResultSet rs=stmt.executeQuery();

while (rs.next()) {

Col1 [j] = rs.getString("Champ1");
Col2[j] = rs.getString("Champ2");
... // for as many columns as you want to return

data[j][i]= Col1 [j];
data[j][i+1]= Col2[j];
....
j++;
}
// the column headers :
String title[] = {"La colonne 1", "La colonne 2",....};
JTable table = new JTable(data, title);

JPanel tableau = new JPanel (new BorderLayout ());
// add the headers to the north of the container
tableau.add (table.getTableHeader (), BorderLayout.NORTH);
tableau.add (table, BorderLayout.CENTER);
JSplitPane split3 = new JSplitPane (JSplitPane.VERTICAL_SPLIT, true, tableau, new JTextArea (" Avec entête "));
TableColumn column = null;
for(int i=0;i<4 ; i++){
column= table.getColumnModel().getColumn(i);
column.setPreferredWidth(180);
}
P.add(tableau); // P being the panel of the window
// a scrollPane if needed
JScrollPane scrollpane = new JScrollPane(P,JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
this.getContentPane().add(scrollpane);
6- you finish with a catch ....

There isn’t anything simpler :-)

Hi :) I followed what you wrote but it shows the following error!!
java:219: error: cannot find symbol
TableColumn column = null;
^
could someone help :) thank you