This section describes how to run SELECT queries through the JDBC driver.
After inserting data into my Access database, I want to get it back with a SELECT query.
Here is my sample program to get all rows back from the table HY_Address:
/**
* DerbyQuery.java
* Copyright (c) 2007 by Dr. Herong Yang. All rights reserved.
*/
import java.sql.*;
public class DerbyQuery {
public static void main(String [] args) {
Connection con = null;
try {
con = DriverManager.getConnection(
"jdbc:derby://localhost/TestDB");
Statement sta = con.createStatement();
// getting the data back
ResultSet res = sta.executeQuery(
"SELECT * FROM HY_Address");
System.out.println("List of Addresses: ");
while (res.next()) {
System.out.println(
" "+res.getInt("ID")
+ ", "+res.getString("StreetName")
+ ", "+res.getString("City"));
}
res.close();
sta.close();
con.close();
} catch (Exception e) {
System.err.println("Exception: "+e.getMessage());
}
}
}
The output looked correct to me:
C:\>java -cp .;\local\javadb\lib\derbyclient.jar DerbyQuery
List of Addresses:
1, 5 Baker Road, Bellevue
2, 25 Bay St., Hull
3, 251 Main St., W. York
