Assignment No. 02
Semester: Fall 2017
Semester: Fall 2017
CS506 – Web Design and Development
Uploading instructions:
Your assignment should be in .zip /.rar format.
Save your assignment with your ID (e.g. bc000000000.rar).
No assignment will be accepted through email.
Rules for Marking:
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, execute or file is
corrupted.
Your assignment is copied from internet, handouts or from any
other student (Strict disciplinary action will be taken in this case).
Do not put any query
on MDB about this assignment, if you have any query then email at cs506@vu.edu.pk.
Note: Furthermore, if any student found cheating from any other
student or from online forums then he/she will be awarded ZERO right away and
strict disciplinary action will be taken against the student.
Deadline: Your assignment must be uploaded/submitted on or before 24th
November 2017.
Important Regarding Submission:
After completing your code, execute your java file(s) and take the
screenshot of the output/result. Now, compress your code, database file and
screenshot of the output using winzip or winrar and upload it on VULMS.
Question No: 01
Create a new
database in MS Access and add a table in the database. The name of database
should be same as your own VU ID (like BC0000000) and the name of table should
be Student. Student table will have four attributes i.e. ID, NAME, ADDRESS and
PROGRAM.
Now, design a graphical user
interface in java as given below (You
must have to mention your own VU ID in title as shown in screenshot).
Your program should perform
following tasks:
1. Add new record in database
Whenever user enters some new
data in text fields and clicks “Add Record in Database” button, all the text
fields’ data should be stored in Student Table.
2. Search a record from database on the basis of ID and display it on
screen
Whenever user enters any ID in
text field and clicks “Search Record from Database” button, your program should
fetch this record from database. If this ID is available in database then
display the record of this ID in the mentioned text fields otherwise show an
error message that no such record is available.
Important Regarding Development:
If you are using JDK1.8 or above
then you’ll have to use ucanaccess
driver to connect to MS Access database. In this case, I'll suggest you to
view the following tutorial.
Following links will be helpful
in creating new database in MS Access.
Comments
Post a Comment