Reading the columns, JDBC

but43r

So i have this peace of java code

try {
Dao d = new Dao();
Connection con = d.getConnection();
Statement s = con.createStatement();
s.execute("select ID from VEHICLES"); // select the data from the table

ResultSet rs = s.getResultSet(); // get any ResultSet that came from our quer
if (rs != null) // if rs == null, then there is no ResultSet to view
{
while (rs.next()) // this will step through our data row-by-row
{
/* the next line will get the first column in our current row's ResultSet
as a String ( getString( columnNumber) ) and output it to the screen */
result.add(rs.getString(1));
}
}

s.close(); // close the Statement to let the database know we're done with it
con.close(); // close the Connection to let the database know we're done with it

} catch (Exception ex) {
System.out.println("Message " + ex.getMessage());
}

It reads all rows in a database. I would be searcing some particular Vehicle lets say. What I want to know is, how would I extract the corresponding columns to the row I find.

Thanks.

but43r

Ok firgured this one out.
Instead of having s.execute("select ID from VEHICLES"); i had to have s.execute("select * from VEHICLES"); and just change result.add(rs.getString(1)) whichever column I want

Malached

SELECT id FROM vehicles where <vehicle_type> = <vehicle type> basic ANSI SQL. Any language.