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 Fall spring 2015 CS506- Web Design and Development Total Marks: 25 Due Date: 8 june, 2015

Dear Students,

Assignment No. 2 has been uploaded last date for submission of Assignment No. 2 is Monday, June 08, 2015.
 
Note: No Assignment will be accepted through e-mail. 
See attach file

Assignment No. 02

 Spring 2015

CS506- Web Design and Development

Total Marks: 25

Due Date: 08/06/15

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.

Uploading instructions

You are required to submit your solution in Power Point File (.ppt or .pptx) with audio narration. Assignment submitted in any other format will get zero marks. Assignment sent through email will not be accepted in any case. 

Note: Use JDK for compiling/running of java program (A video tutorial of installation and configuration of JDK is given in course download section). 

Visit the following link for installing and configuring of JDK.

Tutorial for installing JDK for windows 7

Tutorial for installing JDK for Windows XP

Guidelines for installing JDK

Following is link for downloading JDK 7

http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downlo...

Objective

The objective of this assignment is

  • Understanding the Java Database Connectivity (JDBC)
  • Compiling/running of java program

 

Problem Statement:

You are required to write a java program which display Student information from a database. For that, you will require to perform three steps.

Step 1: firstly perform the following steps for creation of database and table in MS Access.

  • Create a database in MS Access with any name
  • Create a table named as “StudentInfo”, having three fields (VUID, Studentname, Coursename).
  • Insert one row in table StudentInfo i.e. containing your own VUID, your name and course name. 

( procedure to create a database in MS Access is given in handouts)

Following is screen shot of sample MS Access Database

You have to create the table and insert one record in table Studentinfo contains your own VUID, name and course code as explained in above screen shot.

Step 2: write a java program in notepad that will perform Java Data base Connectivity with MS Access database, (show all database connectivity steps).

(A tutorial to create a DSN connection is given in course download section)

http://vulms.vu.edu.pk/Courses/CS506/Downloads/How%20to%20create%20...

 Tutorial for creating DSN for windows 7

Step3: Compile and run the program in JDK (on command prompt) and display Student Information from database on command prompt

Note:  You are required to compile/run the java program in JDK. Don’t use NetBeans, Eclipse or any other IDE for creating Assignment No. 2 .

You can download the JDK 7 from the following link.

http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downlo...

Sample Output:

Insert the one record in table Studentinfo, contains your VUID, name and course code.  Compile and run your program as described above

Submission:

You are required to submit your solution as a presentation in PowerPoint File (.ppt or .pptx) with audio narration through LMS. Assignment submitted in any other format will get zero marks.

Prepare presentation slides in following way.

a)      In first slide give a brief introduction of your program and show a snapshot of MS Access database table “Student Info” and very briefly describe it.

b)      In second slide show your solution (java code) and record audio narration which will explain all database connectivity steps. You need to give very brief explanation for each line of code. While recording audio narration, don’t forget to speak your name and VU-ID in the beginning. 

c)      Take screen shot of compiling/running of your java program in command prompt and paste that screen shot in third slide. In this slide you have to explain the procedure of compiling and running of your program with audio narration.

Steps for Recording the Presentation

Recording of Presentation (PowerPoint 2010/13)

  1. Record a narration before or during a slide show.
  2. When you record a narration, you run through the presentation and record each slide. You can pause and resume recording any time.
  3. Ensure your microphone is set up and working properly prior to recording your slide show.
  4. On the Slide Show tab, in the Set Up group, click Record Slide Show .
  5. Select one of the following:In the Record Slide Show dialog box, select the Narrations and laser pointer check box, and if appropriate, select or deselect the Slide and animation timings check box.
    • Start Recording from Beginning
    • Start Recording from Current Slide
  6. Click Start Recording.
  7. To end your slide show recording, right click the slide, and then click End Show.
  8. The recorded slide show timings are automatically saved and the slide show appears in Slide Sorter view with timings beneath each slide.
  1. A sound icon  appears on the slide.

Preview the Recorded Presentation

  1. In Normal view, on the slide, click the sound icon .
    1. a.      OR
    2. On the ribbon, under Audio Tools, on the Playback tab, in the Preview group, click Play.

To record a sound for a PowerPoint 2003/2007 presentation, you can follow the steps below:

  1. Open the PowerPoint presentation you are going to record a sound in, and go to Insert -> Movies and Sounds -> Record Sound
  2. In the Record Sound dialog, Name field, enter a name for the recording.
  3. Next, at the bottom of the dialog, click the red dot (the Record button) to start recording a sound.
  4. When finished, click the blue square (the Stop button) on the left of the Record button.
  5. To test the recorded sound, click the blue triangle (the Play button).
  6. Record another sound if the existing one is not satisfying. To confirm the recorded sound, click OK. The sound icon is displayed on the current slide.

Deadline: Your assignment must be uploaded/submitted at or before.08/06/15. No assignment would be accepted through email. For any query about the assignment, contact at cs506@vu.edu.pk

 

+ Click Here To Join also Our facebook study Group.

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


See Your Saved Posts Timeline

Views: 17936

.

+ 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

Khizra and black pochyn ap ny kya pocha.... kya help chaheay ap ko

Command prompt me java program kesay run krty hain plz guide kren

 Khizra

MS access k driver ko kesay connect krna hai plz guide

 Khizra Here iz tutorials fr making DSN.

Attachments:

Thanx a lot sis

welcome 

congrats for your assignment.
can you please tell that what versions of
window
jdk
ms access
you are using on what bits..??

Help me

import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;


public class JavaApplication2 {


public static void main(String[] args) {

System.out.println("hello");
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:student";
Connection con = DriverManager.getConnection(url);
Statement st = con.createStatement();
String sql = "SELECT * FROM StudentInfo";
ResultSet rs = st.executeQuery(sql);
while(rs.next()){
String vuid = rs.getString("VUID");
String name = rs.getString("Name");
String courseName = rs.getString("CourseName");
System.out.println(vuid + "" + name + "" + courseName);
}
con.close();
} catch (ClassNotFoundException ex) {
Logger.getLogger(JavaApplication2.class.getName()).log(Level.SEVERE, null, ex);
} catch (Exception sqlEx) {
System.out.println(sqlEx);
}
}
}

A.O.A

please ye bta dain k is code ko kis sftware main run krna ha

sunaina

Ye code JDK mn run krna hy,

RSS

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

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