Linglom's blog

This article is one of the series of Accessing MS Access 2007 on NetBeans 6.5 using JDBC. You can see the index of this series at Accessing Access 2007 on NetBeans 6.5 using JDBC, Part 1: Introduction

Create a Connection

From Part 2: Prepare Sample Database, I show how to setup Northwind database for Microsoft Access 2007. Now let’s start programming. On this post, you see how to create a connection from NetBeans 6.5 to the Northwind database of Microsoft Access 2007 which located at “c:\database\Northwind 2007.accdb”.

Step-by-step

1. Create a new Java Application project on NetBeans. Open NetBeans 6.5.1 and select File -> New Project.
   
2. On New Project, select Java -> Java Application. Click Next.
   
3. On New Java Application, type the project name “NorthwindSample” and click Finish.
   
4. The project “NorthwindSample” is created.
   
5. Let’s begin the programming part. First, I need to import some libraries.

   import java.sql.*;

   

6. Type the code below to the main method.

   1 2 3 4 5 6 7 8 9 10 11 12 13

   try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url = "jdbc:odbc:Driver={Microsoft Access Driver " + "(*.mdb, *.accdb)};DBQ=C:\\Database\\Northwind 2007.accdb"; Connection con = DriverManager.getConnection(url); System.out.println("Connected!"); con.close(); } catch (SQLException e) { System.out.println("SQL Exception: "+ e.toString()); } catch (ClassNotFoundException cE) { System.out.println("Class Not Found Exception: "+ cE.toString()); }

   Code Explanation:

   • Line 2: Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”); means load the JDBC-ODBC driver.
   • Line 3-4: String url = “jdbc:odbc:Driver={Microsoft Access Driver ” + “(*.mdb, *.accdb)};DBQ=C:\\Database\\Northwind 2007.accdb”; declare a variable which store a string of the driver name for Microsoft Access 2007 and the location of the Northwind database.
   • Line 5: Make a connection using information on the variable which was created before.
   • Line 6: Display “Connected!” on console window.
   • Line 7: Close the connection.

   

7. Compile and run the project. You see the text “Connected!” on the output window. Otherwise, you should see an exception message.
   

What’s Next?

Now you have connected to the Northwind database of Microsoft Access 2007. Next, I will show how to perform some basic SQL operations such as SELECT, INSERT, UPDATE and DELETE to the Northwind database. See Part 4: Perform SQL Operations.