Skip to main content

Assignment No 2 CS506 - Web Design and Development, Due Date: 04-07-2016

Image
By

Follow us on Facebook





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

Solution :


Click To Download CS506 Assigment Solution 2

Labels:

Comments

Post a Comment

Popular posts from this blog

cs302 Solved Quiz

By
estion # 1 of 10 ( Start time: 03:03:55 PM )  Total Marks: 1    Divide-by-32 counter can be acheived by using   Select correct option:   Flip-Flop and DIV 10  Flip-Flop and DIV 16   Flip-Flop and DIV 32  DIV 16 and DIV 32 Question # 2 of 10 ( Start time: 03:05:20 PM )  Total Marks: 1   The counter states or the range of numbers of a counter is determined by the formula. (“n” represents the total number of flip-flops)   Select correct option:   (n raise to power 2)  (n raise to power 2 and then minus 1)  (2 raise to power n) (2 raise to power n and then minus 1) Question # 3 of 10 ( Start time: 03:06:36 PM )  Total Marks: 1   A 4- bit UP/DOWN counter is in DOWN mode and in the 1010 state. on the next clock pulse, to what state does the counter go?   Select correct option:   1001  1011  0011  1100 Question # 4 of 10 ( Start time: 03:07:37 PM )  Total Marks: 1   A 4-bit binary UP/DOWN counter is in the binary state zero. the next state in the DOWN mode is
Post a Comment
Read more

Mth621 Final term paper sept 2020

By
  Mth 621 paper Practise queation ma sa 80% aya : 3nu quizes ma sa sary mcqs ay Objective bi 30 aur subjective bi 30 k tha total 60 marks k paper tha Subjective total chap3 aur chap 4 ma say tha Subjective almost practise question ma sa tha Mcqs 80% quizes ma sa thay G therorem bi aik 2 to zehn ma ni a rhy 621 theorem on bounded set theorem on reman integral mean value theirem limit chain rule integaration 621 k saare mcq old quizes m se aye #Mth621 Mcqs were based on concepts and 6,7 was from mcqs file of quizz. 1-Define Removeavle continuity? 2 marks 2-Deifine chain rule for composition of functions? 2 marks 3-Define Second mean theorem of Integration? 4- Find uniform continuity of 2x? 5- A theorem was from Monotonic Function? 5 marks 6-evaluate lim->0 ln sinx/ln x?? 7- and Rest two was from the last 5th chp of about integration on closed interval. Mcqs zyada quiz mai sy thy evaluate lim->0 ln sinx/ln x?? Find uniform continuity of 2x? generalized mean value the
2 comments
Read more

UniVERSITY VIRTUAL CAMPUSES & Contact #

By
UniVERSITY VIRTUAL CAMPUSES VU OWN CAMPUSES Sr # Province City Code Details 1    BALOCHISTAN PISHIN VPSN01 Virtual University Campus, Pishin Killi Malik Abdul Razzaq, Pishin Phone:   0826-442275 Fax:   - Email:   vpsn01@vu.edu.pk ,   vpsn01@vu.edu.pk   2    CAPITAL ISLAMABAD VIBD01 Virtual University Campus, Islamabad 9-E, Rizwan Plaza, Blue Area, Islamabad. Phone:   051-9213476 Fax:   NA Email:   vibd01@vu.edu.pk ,   vibd01@vu.edu.pk   3    KHYBER-PAKHTUNKHWA PESHAWAR VPSW01 Virtual University Campus, Peshawar 8-Jamrud Road, P.O. Tehkal Bala, Adjacent Toyota Froniter Motors, Peshawar. Phone:   091-5701071, 5705994 Fax:   091-5711381 Email:   vpsw01@vu.edu.pk ,   vpsw01@vu.edu.pk   4    PUNJAB D.G. KHAN VDGK01 Virtual University Campus, D.G. khan Sakhi Sarwar Road, Old D.D.A. Building, Near Pul Dat, D.G. Khan. Phone:   064-2000919, 2472813 Fax:   - Email:   vdgk01@vu.edu.pk ,   vdgk01@vu.edu.pk
1 comment
Read more