BIRLA INSTITUTE OF TECHNOLOGY AND SCIENCE, PILANI – 333031
II Semester 2008-2009
IS C332 – Database Systems and Applications
LAB#3 (Using database - JAVA using NetBeans)
In lab, we have created table STUDENT_DETAIL, now we have to develop a program that
allow us to perform insert, update, delete and select operation from GUI.
1. Create NetBeans JAVA project.
File -> New Project..
Category – Java, Projects – Java Application then give next.
Give project name and click finish.
Your project is created and Main.java file is also created.
Now extend JFream class from this Main class and develop this to look as follows.
Exit button will exit program.
2. Insert Operation.
Select Insert andl click on Done… then screen as shown in fig 2 will appear.
By Clicking home you will reach to screen of fig1.
Here you will to fill detail as shown in fig 2. When you click insert data will be inserted in to
oracle database table that we have created. One alert message is displayed as shown in fig 3.
If record with this ID is already available then it should also show alert message that record
3. Select Operation.
Similarly when you select data it should take data from database table and display it as shown
in fig 4. Appropriate scrolling bar must be there
4. Update Operation.
When you select update operation it shows screen as in Fig 5.
Here Id’s are populated from database.
When you will select any id, its name and branch must be displayed into appropriate textbox.
By clicking update button you should update database record and show appropriate message
5. Delete Operation.
When you select delete operation it shows screen as in Fig 6.
When you will select any id, its name and branch must be displayed into appropriate label.
By clicking Delete button you should delete database record and show appropriate message
box. Also deleted record must be removed from list.