We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

CS506 Web Design And Development Assignment No.3 Spring 2013 Total Marks: 20 Due Date: 20/05/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:

 

  1. 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:

  1. You are allowed to use Netbeans IDE for this assignment.
  2. Assignment due date is May 20, 2013.
  3. 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.edu.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.

 

 

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 17034

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

Plz koi ye bataye ga k ye assignment Access me kerni he ya Netbeans me? jaise pichli assignment ki thi GUI's ki

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions.

+(((§קάяƙℓє Ŧάɨяẙ)))+ PLz come n join the discussion

uffff ... web ky  sir assign py assign bhej rahy hn... abi to lcturz prhne ka soch ri thi ek r assign...

kia ye assign java m coding ky zarie bn skti hai?

Use Netbeans 7.2, by using MS access connectivity driver you can access Database Table from access to netbeans

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....

Airborne

I dont know how to use Access 2007 plz can u help me... n how to create databas DSN please calrify

3. Create Database DSN using Control Panel>>Administrative Tools>>System DSN,

when i open this sequence in my PC i didnt find System DSN... where is it?

See the screenshot below for guidance...if still not clear, kindly go through video lectures it is explained clearly by the instructor, in video lectures.....

1.   Create New MS Access file as shown below:-

2.  Create New table, As shown in above screenshot, From View choose "Design View" also see screenshot below:-

3.  Create Fields in the table as shown below:-

4. Save the table....

RSS

Latest Activity

Sheraz Ali posted a discussion
13 minutes ago
Imran Khan replied to +¢αяєℓєѕѕ gιяℓ's discussion CS506 - Web Design and Development Assignment No.1 Due Date Nov 15, 2019 in the group CS506 Web Design and Development
1 hour ago
Imran Khan joined + M.Tariq Malik's group
1 hour ago
+ ! ! ! ! Mehαr Mαh꧂ liked + M.Tariq Malik's discussion PSC401 Final Term Papers Spring 2019 (24 August ~ 04 September 2019) & All Solved Past Papers, Solved MCQs & Helping Material
1 hour ago
Hamza Hameed replied to + M.Tariq Malik's discussion CS611 Software Quality Engineering Assignment No 01 Fall 2019 Solution & Discussion Due Date: 15-11-2019 in the group CS611 Software Quality Engineering
2 hours ago
+Umar Amin+ replied to + M.Tariq Malik's discussion Criteria Required for Award Badges, Featured Members & Moderators
2 hours ago
+ !! SARAH replied to MIT's discussion Operating Systems(CS604) Assignment # 01 Deadline Date 16-11-2019 in the group CS604 Operating Systems
2 hours ago
+ !! SARAH joined + M.Tariq Malik's group
2 hours ago
November 2019 replied to + M.Tariq Malik's discussion CS401 Assignment No 01 Fall 2019 Solution & Discussion in the group CS401 Computer Architecture and Assembly Language Programming
3 hours ago
Hamza Hameed updated their profile
3 hours ago
Profile IconHamza Hameed, +.Ãŋɠɜʆḁ.+ and Aijaz khan joined + M.Tariq Malik's group
3 hours ago
Profile IconHamza Hameed and Purple Work joined + M.Tariq Malik's group
3 hours ago
Hamza Hameed joined + M.Tariq Malik's group
3 hours ago
Hamza Hameed joined + M.Tariq Malik's group
3 hours ago
Arham Shah replied to + M.Tariq Malik's discussion CS401 Assignment No 01 Fall 2019 Solution & Discussion in the group CS401 Computer Architecture and Assembly Language Programming
3 hours ago
Arham Shah joined + M.Tariq Malik's group
3 hours ago
khurram us salam replied to + M.Tariq Malik's discussion MGT402 Cost & Management Accounting Online Quiz No 01 Fall 2019 Solution Discussion in the group MGT402 Cost & Management Accounting
3 hours ago
khurram us salam joined + M.Tariq Malik's group
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked + ! ! ! ! ! MySterIouS's blog post + Beginning +
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked Mani Siddiqui BS VIII's discussion Kash Main Doure Payamber
3 hours ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service