Reading multple columns in 1 query.

[Sam Smoot]

I'm attaching to an Access 2000 database on a shared mapped drive and can pull 1 column in at a time through my SQL statement. I have to execute a separate SQL call for each column, which seems to be a waste. I want to be able to pull in and show all the fields in each row.
What do I do to show both / all of the columns in each row?

import java.net.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
public class dbconnect extends JFrame
{
    Choice fName;
    Choice lName;
  //  Connection conn;
  //  Statement stmt;
    public dbconnect(){
       Container cp = getContentPane();
       fName = new Choice();
       lName = new Choice();
       cp.setLayout(new FlowLayout());
       try{
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       String dsn = "jdbc :o dbc :D river={Microsoft Access Driver (*.mdb)};" +
                    "DBQ=Q:\\Group Information\\Team.mdb";
            String user = " ";
            String pswd = "TeamInfo";
            Connection con = DriverManager.getConnection( dsn, user, pswd);
            Statement stmt = con.createStatement();
            //  input sql stmts.
            String SQL="SELECT FirstName LastName FROM TeamInfo";
            ResultSet rset = stmt.executeQuery(SQL);
            String fn = "";
            String ln = "";
            while (rset.next()){
       //  I think this is where things get muddled, but I'm not sure...
                  fn = rset.getString(1);
                  ln = rset.getString(2);
                  fName.addItem(fn);
                  lName.addItem(ln);
            }
            }
            catch(Exception e){
                System.out.println("Ain't working hoss...");
            }
            cp.add(fName);
 }
    public static void main(String args[]){
        JFrame jf = new dbconnect();
        jf.setSize(250, 250);
        jf.addWindowListener(new WindowAdapter(){
             public void windowClosing(WindowEvent e)
                    {System.exit(0);}});
        jf.setVisible(true);
   }
}

(I'm just trying to get a handle on this, so I know this application doesn't make sense yet....)
Thanks in Advance!
[ February 18, 2004: Message edited by: Sam Smoot ]

[Sonny Gill]

This could be your problem, unless SQL Server allows this!
String SQL="SELECT FirstName LastName FROM TeamInfo";
the missing comma between FirstName and LastName.
Try changing it to
String SQL="SELECT FirstName, LastName FROM TeamInfo";

[Sam Smoot]

DUHHHHHHHH!!!
That fixed it...
I gotta quit running in mixed mode and stick to one thing...
Thanks!

[Sonny Gill]

no worries, mate.
cases like this, sometimes you can debug by trying to use PreparedStatement instead of Statement. cheers

[Bear Bibeault]

And if you want all the columns you can just use SELECT * FROM ...