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

Assignment No. 2

 Spring 2016
CS506- Web Design and Development

Total Marks: 20

Due Date: 04/07/2016

 

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).
  • The assignment is not submitted in .java format.

 

Uploading instructions

Your submission must include:

 

  1. You have to make a zip file which contains three java files, one database file and upload it on VULMS.

 

Note: Use Notepad or Notepad++ for coding and JDK package for java source code compilation and running (A guideline document on JDK installation and configuration is given in course download section). You can also use IDE such as Eclipse or NetBeans.

Objective                                                                                                                                             

 

The objective of this assignment is to

  • Give you some practice exercise of Classes and Objects.  
  • Develop GUI (Graphical User Interface) in java
  • Event handling on GUI
  • Understand the concept of java database connectivity

 

 

 

 

 

 

 

Problem Statement:                                                        

You are required to write a java program which contains three classes named as Main, employeeDB, GUI and one database file named employeeDB.

employeeDB class must have the following member methods:

  • getConnection()
  • Default constructor
  • employeeRecords()
  • averageSalary()
  • empSalary()

 

getConnection(): It should have functionality to connect to database and return an object of type Connection.

Default Constructor: It should call the getConnection() method.

employeeRecords(): It should display all employee records from the database table named Employee.

averageSalary(): It should return a value of type integer which is the average salary of all employees from Employee table.

empSalary(): It should display all employee records having salary greater than 10,000.

 

GUI class must have the following member methods:

  • Default constructor
  • Event handling function

Default constructor: It should have the functionality to develop GUI as shown in the following figure. It should have three buttons and one label.

 

Event handling function: All three buttons should have event handling mechanism. 

  • When user clicks button1 then it should retrieve all employee records from the database table named Employee and display it on Command prompt.
  • When user clicks button2 then it should retrieve all employee records having salary greater than 10,000 from Employee table and display it on Command prompt.
  • When user clicks button3 then it should calculate the average salary of employees from Employee table and display it on Command prompt.

  

Main is a public driver class that contains the main() method. Within main() method,  you will create an object of GUI class.

 

Database file contains the Employee data which has four properties Id, Name, Age and Salary.

 

 

 

Sample Output:

 

 

 

 

 

 

Output on Command prompt

 

All Employee records

1          Ali          25     12000

2          Ahmad               30     15000

3          Hassaan  35     11000

4          Fatima    27     9000

5          Ayesha               29     8000

 

Employees having Salary > 10K

1          Ali           25    12000

2          Ahmad                30    15000

3          Hassaan   35    11000

 

Average Salary

11000

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Note:

 

JDBC-ODBC bridge does not work for Java 8 so you have to download another driver and add its library. A detailed guideline document has been uploaded in the Downloads section of VULMS. You can read the guideline document from the following link:


http://vulms.vu.edu.pk/Courses/CS506/Downloads/UCanAccess.docx

You can take help from the following audio tutorial that will help you in better way.
http://vulms.vu.edu.pk/Courses/CS506/Downloads/UCanAccess.mp4

You can view all files from the following folder:
http://vulms.vu.edu.pk/Courses/CS506/Downloads/UCanAccess.zip

 

See the attached guideline document as how to add jar files to your NetBeans project and then connecting with database.

http://vulms.vu.edu.pk/Courses/CS506/Downloads/Adding%20JAR%20files...

 

 

Deadline

Your assignment must be uploaded/submitted at or before 4th July, 2016.

 

 

For any query about the assignment, contact at cs506@vu.edu.pk

GOOD LUCK

 

 

 

 

+ Click Here To Join also Our facebook study Group.

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


See Your Saved Posts Timeline

Views: 10062

.

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

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

Attachments:

Replies to This Discussion

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.

Extension in assignment No.2 due date Dated: Jul 01, 16
Dear Students, 
Updated due date of Assignment No. 2 is Monday July 11, 2016
Note: Assignment will not be accepted via email at all. Submit your assignment on VU-LMS with in due date. 

Thanks for sharing information........

kamal hy is ko assignment ka name nahi is ko project kehna chahiay

Right..........

20 lines of code ko project kaho gy to project main to wesy he hart attack ho jaey ga.

Asslam Allekum friends.

ye assignment easy hy lekin bohat bari hy means time bohat lagy ga isko banany main means is main kafi chezen hen like GUI (Graphical User Interface) and Database bhi hy ap SQL ya Access use kar skty hain aro is main Database connection bhi hota java main etc ap youtube ko follow karen.

aor jo assignment main requirements hen wo sub ap follow karen mtlb sary softwares jo use hongy wo ap install kar len us ki details assignment file main last page par hy ap apny system main kar len

step wise software krna houn ge

any one can guide which software n links ?

Netbeans 8 download karna ho ga or MS Access ma Sql write karni ho gi

Assignment ki requirement ma java ko 3 file NOTEPAD ma ho gi or MS Access ki file or sat ma UcanAccess ki file bi hai

Abrar Ahmed (BSSE) email, cell no sharing is not allowed at the site.next time be care.thanks four understanding 




XalMan HaidEr


guys database kese connect krte hen? plzzzz help.....

RSS

Today Top Members 

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

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