CS506 Assignment No.3 Solution Spring 2013
Page 1 of 1 • Share
CS506 Assignment No.3 Solution Spring 2013
Assignment No. 03
SEMESTER Spring 2013
CS506- Web Design and Development
Total Marks: 20
Due Date: 20/05/2013
Instructions
Please read the following instructions carefully before solving & submitting assignment:
It should be clear that your assignment will not get any credit if:
The assignment is submitted after due date.
The submitted assignment does not open or file corrupt.
The assignment is fully or partially copied from (other student or ditto copy from handouts or internet).
Student ID is not mentioned in the assignment File or name of file is other than student ID.
The assignment is not submitted .java format.
Uploading instructions
Your submission must include:
Submit the complete working project in zip format and other if necessary files (database) to compile and run your program.
Objective
The objective of this assignment is
To give you some practice exercise of event handling and Database connectivity and perform different queries on database in Java
Important Requirements and Instructions:
You are allowed to use Netbeans IDE for this assignment.
Assignment due date is May 20, 2013.
We will not accept assignment through email in any case. Be Careful
Deadline: Your assignment must be uploaded/submitted at or before 20/05/2013.
For any query about the assignment, contact at cs506@vu dot edu dot pk
GOOD LUCK
Question:
HRM is the management of employees within an organization. At present stage all the Human Resource (HR) work for JS Group of Industries is managing manually. Each time to change employee information, the manager needs to update the record manually in different locations/ places, which is a tedious job for the HR manager and prone to errors.
As in the second assignment we had designed different GUIs for HR Manager of JS Group of Industries. So in this assignment we are going to connect the GUI’s with database and perform different event handling.
Solution Guidelines:
First you have to create a database in MS Access named as “Employee”.
There should be a table in “Employee” database named as “Personal Information”
Set Data source name (DSN) for your database.
You can also get help from the 2nd assignment solution for GUI’s creation.
Note:
Submit the complete working project in zip format
Event handling and database connection must be work; otherwise you will get zero marks.
Your code must be enough for 20 marks
Sample Output:
When you run the program:
User fill the form and click on “Save” button, then all the information will be saved in “Personal Information” table of “Employee” database
When User click “Search Personal Information” tab, then:
User provides the ID that he/she wants to search. As a result all the data that is stored in the database will be display.
When user click “Delete Personal Information” tab, then:
The user provides ID and all the records of that ID will be deleted from the database “Personal Information” table.
SEMESTER Spring 2013
CS506- Web Design and Development
Total Marks: 20
Due Date: 20/05/2013
Instructions
Please read the following instructions carefully before solving & submitting assignment:
It should be clear that your assignment will not get any credit if:
The assignment is submitted after due date.
The submitted assignment does not open or file corrupt.
The assignment is fully or partially copied from (other student or ditto copy from handouts or internet).
Student ID is not mentioned in the assignment File or name of file is other than student ID.
The assignment is not submitted .java format.
Uploading instructions
Your submission must include:
Submit the complete working project in zip format and other if necessary files (database) to compile and run your program.
Objective
The objective of this assignment is
To give you some practice exercise of event handling and Database connectivity and perform different queries on database in Java
Important Requirements and Instructions:
You are allowed to use Netbeans IDE for this assignment.
Assignment due date is May 20, 2013.
We will not accept assignment through email in any case. Be Careful
Deadline: Your assignment must be uploaded/submitted at or before 20/05/2013.
For any query about the assignment, contact at cs506@vu dot edu dot pk
GOOD LUCK
Question:
HRM is the management of employees within an organization. At present stage all the Human Resource (HR) work for JS Group of Industries is managing manually. Each time to change employee information, the manager needs to update the record manually in different locations/ places, which is a tedious job for the HR manager and prone to errors.
As in the second assignment we had designed different GUIs for HR Manager of JS Group of Industries. So in this assignment we are going to connect the GUI’s with database and perform different event handling.
Solution Guidelines:
First you have to create a database in MS Access named as “Employee”.
There should be a table in “Employee” database named as “Personal Information”
Set Data source name (DSN) for your database.
You can also get help from the 2nd assignment solution for GUI’s creation.
Note:
Submit the complete working project in zip format
Event handling and database connection must be work; otherwise you will get zero marks.
Your code must be enough for 20 marks
Sample Output:
When you run the program:
User fill the form and click on “Save” button, then all the information will be saved in “Personal Information” table of “Employee” database
When User click “Search Personal Information” tab, then:
User provides the ID that he/she wants to search. As a result all the data that is stored in the database will be display.
When user click “Delete Personal Information” tab, then:
The user provides ID and all the records of that ID will be deleted from the database “Personal Information” table.
Victoria333- Monstars
-
Posts : 267
Join date : 2013-05-12
Age : 34
Location : Victoria
Re: CS506 Assignment No.3 Solution Spring 2013
This assignment is tough one...this is how you can do it:-
Required Softwares:- NetBeans IDE & MS Access-2007
1. Make GUI as shown in Assignment (Same Tabbed panes as in Assign-2 using NetBeans)
2. Make Database Employee in MS Access with field names as shown in GIF file given in assignment.
3. Create Database DSN using Control Panel>>Administrative Tools>>System DSN, Follow the procedure explained in lecture.
4. On first tab (Personal Information) of GUI there is 'SAVE' button, we have to add code to this button, when 'SAVE' button is pressed then database connection with MS Access should be established and then create Statement, Connection and ResultSet objects as explained in Lec-16.
5. Then use rs.updateString(1,"SomeString") command to update the value from GUI to MS Access Database, Same procedure for other fields.
6. Close the connection, as already explained in lec-16
7. Similarly, when "Cancel" button is pressed we have to edit CancelButton ActionListener method to reset all the text fields.
8. To search ID we can use same ResultSet object along with for loop to scan all the records in MS access database and display the record when found.
9. To delete record, first we search the record and then use rs.deleteRow(); command to delete it.
and thats all...Complete solution of assignment is given above, now all have to understand and do it...Wish you all best of luck...
Required Softwares:- NetBeans IDE & MS Access-2007
1. Make GUI as shown in Assignment (Same Tabbed panes as in Assign-2 using NetBeans)
2. Make Database Employee in MS Access with field names as shown in GIF file given in assignment.
3. Create Database DSN using Control Panel>>Administrative Tools>>System DSN, Follow the procedure explained in lecture.
4. On first tab (Personal Information) of GUI there is 'SAVE' button, we have to add code to this button, when 'SAVE' button is pressed then database connection with MS Access should be established and then create Statement, Connection and ResultSet objects as explained in Lec-16.
5. Then use rs.updateString(1,"SomeString") command to update the value from GUI to MS Access Database, Same procedure for other fields.
6. Close the connection, as already explained in lec-16
7. Similarly, when "Cancel" button is pressed we have to edit CancelButton ActionListener method to reset all the text fields.
8. To search ID we can use same ResultSet object along with for loop to scan all the records in MS access database and display the record when found.
9. To delete record, first we search the record and then use rs.deleteRow(); command to delete it.
and thats all...Complete solution of assignment is given above, now all have to understand and do it...Wish you all best of luck...
Victoria333- Monstars
-
Posts : 267
Join date : 2013-05-12
Age : 34
Location : Victoria
Re: CS506 Assignment No.3 Solution Spring 2013
[You must be registered and logged in to see this image.]1 aur assignment aa gae
ChIntoo- Monstars
- Posts : 92
Join date : 2011-02-13
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|
Sat May 04, 2024 11:49 am by ali001
» house disrepair claims
Thu May 02, 2024 4:29 pm by Ibad Khan Buledi
» Bounce n Bang: Physics puzzler
Thu May 02, 2024 11:39 am by ali001
» AIChatSY - AIChatbot Assistant
Wed May 01, 2024 10:48 am by ali001
» Storybook Magic App
Tue Apr 30, 2024 7:06 pm by ali001
» Flower Book Match3 Puzzle Game
Tue Apr 30, 2024 12:17 pm by ali001
» Avian Influenza Symptom in Chickens "Bird Flu H5N1 Virus" Vet learning materials, Poultry Farming
Sat Apr 27, 2024 9:57 am by Ibad Khan Buledi
» Aloha Planner - Note-Taker
Thu Apr 11, 2024 4:52 pm by ali001
» Streaming Guide Film TV Series
Tue Apr 09, 2024 9:39 pm by ali001