Java Database Connectivity with MS Access --- Part 2

After the creation of the table (in MS Access) and DSN, we should now write a program in Java which connects to this database.

• As we use SQL statements in the program we have to import the package java.sql.* by the  statement: import java.sql.*; 

• In any JDBC program, first the driver has to be loaded which is done  by: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 

• Now the driver manager gets connection to the database by the following statement:           Connection con=DriverManager.getConnection ("jdbc:odbc:StudentInfo") ;       Here, "StudentInfo" is the Data Source Name and we are connecting through JDBC-ODBC Bridge Driver. So, the database URL is "jdbc:odbc:StudentInfo". There is no username and password given in this function. Only the database URL is given.

•  Make sure that the entire program has good Exception handling as the code throws "SQLException".