Home arrow Java arrow Traversing To and Fro with SQL Server Based Java Applications using NetBeans IDE
JAVA

Traversing To and Fro with SQL Server Based Java Applications using NetBeans IDE


This series introduces you to a step-by-step process for developing Java (or JFC) based applications with Microsoft SQL Server as the database, using NetBeans IDE. In this article (which is the last in this series), I shall introduce you to traversing through a set of rows more efficiently. This will be a bit different from any of the articles in this series.

Author Info:
By: Jagadish Chaterjee
Rating: 5 stars5 stars5 stars5 stars5 stars / 5
June 28, 2006
TABLE OF CONTENTS:
  1. · Traversing To and Fro with SQL Server Based Java Applications using NetBeans IDE
  2. · How to connect to the database during form load
  3. · The Java code from IDE
  4. · The source code for buttons
  5. · How to handle the clear memory resources when the form is closed

print this article
SEARCH DEVARTICLES

Traversing To and Fro with SQL Server Based Java Applications using NetBeans IDE
(Page 1 of 5 )


A downloadable file for this article is available here.

I already introduced the NetBeans IDE in my previous article "Developing Java Applications using NetBeans."  Even though that article is fairly introductory, the next two articles concentrate on the basics of JFC.  You can find the next two articles 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. If you are new to developing Microsoft SQL Server based Java applications, I request that you go through another article of mine here.

Creating a Java application using NetBeans IDE

We shall develop a small application with four labels, four text boxes and four buttons. The buttons will be identical to the usage of FIRST, PREVIOUS, NEXT and LAST. The "Northwind" database, by default doesn't have an "emp" table.  I just created it for simplicity; you can find its structure along with the rows of that table in my previous article.

Currently, I named the project "SampleJavaApplication1" and the form (or JFrame) "DBSample06" in the package "MyDBPack."

Before dropping all controls onto the form, set the layout to "null layout" (fig 01) to ease our development for this article. When you complete your form design, it should look something like Fig 1 and the "inspector" view should look something like Fig 2.


Fig 1


Fig 2

For the convenience of writing understandable code, I named those controls as follows:

txtEmpno
txtEname
txtSal
txtDeptno
btnFirst, btnPrevious, btnNext, btnLast
lblMsg
jLabel1, jLabel2, jLabel4, jLabel5 (default names)

I also gave a value to the Frame property "title" (using the property window) of "Traversing Java."

You are also required to import necessary packages as shown below:

import java.sql.*;


blog comments powered by Disqus
JAVA ARTICLES

- Java Too Insecure, Says Microsoft Researcher
- Google Beats Oracle in Java Ruling
- Deploying Multiple Java Applets as One
- Deploying Java Applets
- Understanding Deployment Frameworks
- Database Programming in Java Using JDBC
- Extension Interfaces and SAX
- Entities, Handlers and SAX
- Advanced SAX
- Conversions and Java Print Streams
- Formatters and Java Print Streams
- Java Print Streams
- Wildcards, Arrays, and Generics in Java
- Wildcards and Generic Methods in Java
- Finishing the Project: Java Web Development ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials