Linglom's blog

Introduction

Here comes again, a tutorial about accessing database on NetBeans. In 2007, I wrote two tutorials which are accessing SQL Server on NetBeans using JDBC and accessing MySQL on NetBeans using JDBC. Both tutorials are useful to many people so I decide to write a new one, Accessing MS Microsoft Access 2007 on NetBeans.

This series shows how to use NetBeans 6.5 to connect to a Microsoft Access 2007′s database using JDBC. After the connection is established, you see how to perform basic SQL operations such as SELECT, INSERT, UPDATE and DELETE on a table and get result (if any) to display on console window.

I divide this series into 4 parts:

1. Accessing MS Access 2007 on NetBeans 6.5 using JDBC, Part 1: Introduction
   The post that you are reading.
2. Accessing MS Access 2007 on NetBeans 6.5 using JDBC, Part 2: Prepare Northwind Database
   This post shows you how to prepare Northwind database of Microsoft Access 2007.
3. Accessing MS Access 2007 on NetBeans 6.5 using JDBC, Part 3: Create a Connection
   This post shows how to establish a connection to the Northwind database on NetBeans 6.5.
4. Accessing MS Access 2007 on NetBeans 6.5 using JDBC, Part 4: Perform SQL Operations
   This post shows how to perform basic SQL operations such as SELECT, INSERT, UPDATE and DELETE on Customer table on Northwind database.

Requirements

Here are the software requirements which I use on this series.

• NetBeans 6.5.1
• Northwind sample database for Microsoft Access 2007