Resultset

[ben riches]

Hello all,
The code below pulls out the columnnames from a database and diplays them in a JList. How can I get the JList to display the data that is in a columnname called ben?
Thanks
Ben

import java.awt.Color;
import java.awt.Component;
import javax.swing.table.JTableHeader;
import javax.swing.table.TableModel;
import javax.swing.text.html.*;
import java.net.*;
import java.util.*;
import java.io.*;
import java.awt.*;
import javax.swing.table.*;
import java.util.List;
import javax.swing.*;
import javax.swing.filechooser.FileFilter;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.awt.event.*;
import java.lang.*;
import java.util.StringTokenizer.*;
import java.sql.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.DefaultTableCellRenderer;
import java.awt.*;
import javax.swing.*;
public class Ar extends JFrame {
DefaultListModel model = new DefaultListModel();
JList list = new JList();
String item;
static Connection conn2;
   static DatabaseMetaData DMD;
private JPanel ivjArPane = null;
private JPanel ivjJFrameContentPane = null;
private JScrollPane ivjJScrollPane1 = null;
private JList ivjJList1 = null;
public Ar() {
super();
initialize();
}
public Ar(String title) {
super(title);
}
private javax.swing.JPanel getArPane() {
if (ivjArPane == null) {
try {
ivjArPane = new javax.swing.JPanel();
ivjArPane.setName("ArPane");
ivjArPane.setLayout(null);
getArPane().add(getJScrollPane1(), getJScrollPane1().getName());

} catch (java.lang.Throwable ivjExc) {

handleException(ivjExc);
}
}
return ivjArPane;
}
private javax.swing.JPanel getJFrameContentPane() {
if (ivjJFrameContentPane == null) {
try {
ivjJFrameContentPane = new javax.swing.JPanel();
ivjJFrameContentPane.setName("JFrameContentPane");
ivjJFrameContentPane.setLayout(new java.awt.BorderLayout());
getJFrameContentPane().add(getArPane(), "Center");

} catch (java.lang.Throwable ivjExc) {

handleException(ivjExc);
}
}
return ivjJFrameContentPane;
}

private javax.swing.JList getJList1() {
if (ivjJList1 == null) {
try {
try {

 Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
    conn2 = DriverManager.getConnection( "jdbc :-o	 dbc:myProject") ;
      Statement st=conn2.createStatement();
    st.execute("SELECT * FROM ben ");
    ResultSet rs=st.getResultSet();
    ResultSetMetaData md=rs.getMetaData();
 
   for (int i=1;i<=md.getColumnCount();i++) {
 model.addElement(md.getColumnName(i));


    }
   st.close() ;
   

 } catch (SQLException se1 ) {

   System.out.println( "SQL Exception: " + se1 ) ;
 } catch (Exception ex ) {
   //System.out.println( ex ) ;
 }
 
ivjJList1 = new javax.swing.JList(model);
ivjJList1.setName("JList1");
ivjJList1.setBounds(0, 0, 160, 120);

} catch (java.lang.Throwable ivjExc) {

handleException(ivjExc);
}
}
return ivjJList1;
}
private javax.swing.JScrollPane getJScrollPane1() {
if (ivjJScrollPane1 == null) {
try {
ivjJScrollPane1 = new javax.swing.JScrollPane();
ivjJScrollPane1.setName("JScrollPane1");
ivjJScrollPane1.setBounds(132, 126, 160, 120);
getJScrollPane1().setViewportView(getJList1());

} catch (java.lang.Throwable ivjExc) {

handleException(ivjExc);
}
}
return ivjJScrollPane1;
}
private void handleException(java.lang.Throwable exception) {

}
private void initialize() {
try {
setName("Ar");
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setSize(460, 300);
setTitle("Ar");
setContentPane(getJFrameContentPane());
} catch (java.lang.Throwable ivjExc) {
handleException(ivjExc);
}

}
public static void main(java.lang.String[] args) {


try {

UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());

Ar aAr = new Ar();
aAr.addWindowListener(new java.awt.event.WindowAdapter() {
public void windowClosed(java.awt.event.WindowEvent e) {
System.exit(0);
};
});
aAr.setVisible(true);
} catch (Throwable exception) {
System.err.println("Exception occurred in main() of Ar");
exception.printStackTrace(System.out);
}
}
}

[Bear Bibeault]

Since this is more about the Swing than the JDBC, moving to the Swing forum.

[ben riches]

Sorry if I sound rude, but is there anyone who can help me with this please?
Thanks
Ben

[Stefan Wagner]

Bear Bibeault: It's really a jdbc/sql question (and you should probably fit to the naming conventions here ... har, har, har).

// Your tablename seems to be 'ben', columnname shall be 'ben' too?
// I cannot support this, so changing it ... 
st.execute("SELECT name FROM person");
ResultSet rs=st.getResultSet();
while (rs.next () 
{
model.addElement (rs.getString (1));
}

Note: You may not learn sql entirely from asking in a forum.
Get a tutorial, a book, a teacher.
And: shouting! don't catch Exceptions with silent ignore!
Don't!
Who silently catches Exceptions will be silently get cought by Exceptions.
And a minor question: From how many examples did you patchwork the code?
I would say: 5
And a last question:
Where did you find that 'ParanoidGetUntilItWorksButOnlyOnce_SmellPattern':

 
private JPanel getArPane () 
{
if (ivjArPane == null) 
{
try 
{
ivjArPane = new JPanel ();
ivjArPane.setName ("ArPane");
ivjArPane.setLayout (null);
getArPane().add (getJScrollPane1 (), getJScrollPane1 ().getName ());
} 
catch (java.lang.Throwable ivjExc) 
{
handleException (ivjExc);
}
}
return ivjArPane;
}

I would suggest: Get rid of it!
The best termin for that is: Today.

[ben riches]

I did not patchwork my code as I used Visual Age for Java.

[Stefan Wagner]

sorting your imports, you find something like that:

import java.awt.*;
import java.awt.*;
import java.awt.Color;
import java.awt.Component;

and a lot more...

public Ar() {
super();
initialize();
//...
public Ar(String title) {
super(title);
//...
private void initialize() {
// ...
setTitle("Ar");
public static void main(java.lang.String[] args) {
// ...
Ar aAr = new Ar();
/* may be reduced to: */
public static void main(java.lang.String[] args) {
// ...
Ar aAr = new Ar("Ar");
//...
public Ar(String title) {
super(title);
initialize();

import javax.swing.*;
// ...
private javax.swing.JPanel ...
// why not: 
private JPanel ...

And look at 'getArPane ()'.
Which exception do you want to catch?
'Throwable'.
Every exception.
But which exception may occour?
Nearly no one!
Perhaps an OutOfMemoryException.
And what will happen then?
Tell me!
And tell me, which other exception you want to catch!
(edited for typo)
[ April 03, 2004: Message edited by: Stefan Wagner ]