This section describes how to run queries on MS Access database through the JDBC-ODBC 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:
/**
* OdbcAccessQuery.java
* Copyright (c) 2007 by Dr. Herong Yang. All rights reserved.
*/
import java.sql.*;
public class OdbcAccessQuery {
public static void main(String [] args) {
Connection con = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:HY_ACCESS");
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:
List of Addresses:
1, 5 Baker Road, Bellevue
2, 25 Bay St., Hull
3, 251 Main St., W. York
