Developing SQL Server based Java Apps using NetBeans IDE
This article introduces you to developing Java (or JFC) based applications with Microsoft SQL Server as the database, using NetBeans IDE. In this first article in a series, I will show you how to establish a connection from your Java programs to a Microsoft SQL Server database using JDBC.
Developing SQL Server based Java Apps using NetBeans IDE (Page 1 of 6 )
A downloadable file for this article is available here.
I already introduced about NetBeans IDE in my previous article “Developing Java Applications using Netbeans.” Even though that particular article is fairly introductory, the next two articles concentrated on the basics of JFC. You can find them here and here.
If you are new to NetBeans IDE, I strongly suggest you go through the existing articles first, before proceeding with this one.
The entire code for this article is freely available in the form of a zip file. That downloadable solution was developed using NetBeans 4.1 IDE and tested with Microsoft SQL Server 2000 database Enterprise Edition (with Service Pack 3). I didn’t really test it in any other version. If you are unable to connect to the respective database, please post in the discussion section, so that I may guide you.
Another issue is that this entire article focuses on the Microsoft platform only. The steps I discuss in this article would never help you for any other operating system (except the programming code). I used Microsoft Windows 2003 Standard Edition to work this sample. I request you to follow the steps according to the operating system installed on your computer. Most of them will be very similar to follow and very easy to understand.