import java.sql.*;public class odbc_test2
{
public static void main(String args[])
{
try
{
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
String url = "jdbc:odbc:TOY"; Connection db = DriverManager.getConnection(url,"username","password");
Statement  stmt = db.createStatement();
String stmt_str = "SELECT * FROM MyTestTable";
ResultSet rs = stmt.executeQuery(stmt_str); while (rs.next())
{
... ...
}
rs.close();
stmt.close();
db.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
e.printStackTrace();
}
} //end main
}