Java Database Connectivity with MS Access --- Part 3

Now lets see how the program goes: I have considered a simple Java program that lists all the students in the "StudentInfo" database. The program is given below:

import java.sql.*;
public class AccessData {
    public static void main(String args[])
    {
        try
        {
            // Load the driver
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            // Database Connectivity
            Connection con = DriverManager.getConnection("jdbc:odbc:StudentInfo");
            System.out.println("Connected to MS Access");

            // Running a query
            Statement st=con.createStatement();
            ResultSet rs=st.executeQuery("select StudentID,Name from StudentInfo");
            while(rs.next()){
                System.out.print(rs.getInt(1)+"::");
                System.out.println(rs.getString(2));
            }           
            rs.close(); // Close the ResultSet
            st.close(); // Close the statement
        }
        catch(Exception e)
        {
            System.out.print(e.getMessage());
        }
    }
}
The output would look like this: