Latest Activity In Study Groups

Join Your Study Groups

VU Past Papers, MCQs and More

We non-commercial site working hard since 2009 to facilitate learning Read More. We can't keep up without your support. Donate.

CS506 - Web Design and Development Assignment No. 02 Solution and Discussion Spring 2014(Graded) Due Date May 23, 2014

Assignment No.2

Dear Students,

Please note that Assignment  No.2(Graded) of CS506 Will be uploaded on LMS at 16th May, 2014 (16/05/2014). Deadline of this assignment is May 23, 2014 (23/05/2014).

Assignment No.1 will include Lectures No. 09 to 14

 

In case of any query, you can send email at cs506@vu.edu.pk

 

Views: 17019

Replies to This Discussion

the 'view' button in Student Profile tab will contain the class object of StudentProfileData, and the Class StudentProfileData will contain a method to get the data from database and display it in the given format, i did all the coding to save the data and get the data from database but i didn't get the display and back functionality, i have searched many many websites and tutorials but i didn't get the back button functionality

Yes same here, i also do alot of search about that but result is 0.

can you plz share the function to get data from database?

try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String url = "Jdbc:Odbc:gradeBookDSN";
            Connection con = DriverManager.getConnection(url);
            Statement st = con.createStatement();
            String query = "Select * from StudentProfile";
            ResultSet rs = st.executeQuery(query);
                     
            while(rs.next())
            {
                student_id = rs.getString("StudentID");
                student_name = rs.getString("StudentName");
                study_program = rs.getString("StudyProgram");
                student_email = rs.getString("Email");
                
               }
            
            
        }
        catch(Exception ex)
        {
            JOptionPane.showMessageDialog(null, ex);
        }

this is the coding to GET the data from database, but to display it, you have to use JTable and then display the Columns and rows in that table...

Khalid Afzal what you didn't get?

package mainconnectivity;

import java.sql.*;
import javax.swing.*;
public class MyDbConnectivity {

    Connection conn=null;
    public static Connection DatabaseConnectivity(){

    try{

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             String url="jdbc:odbc:GradeBook";
             Connection conn =DriverManager.getConnection(url);
             return conn;
            System.out.println("Connection ABC Successful established");
    } catch (Exception e)
    {
        JOptionPane.showMessageDialg(null,e);
        return null;
    }
    }

}

Same Error

Khalid Afzal ap nay 2 Classes Bnani han SGB Form k ilawa, or un dono Classes 'StudenProfileData' and 'GradeBookData' in dono Classes me main method nahi hoga, ap nay in dono classes ko run nahi karna, balkay in dono classes ko SGB me call kar k SGB ko run karna hay...

Salam 

Dear Can any one please upload viedo tutorial of this assignment 

that how to  create a jtabedpane and how to write the code 

i mean all steps or snap shots from a to z/

thanks if someone upload.

any one can upload 1st assignment solution

student make java class in asignment project... and paste this code in... change the database name as u used in your file box... it will connect data base

import java.sql.*;
import javax.swing.*;

public class Connect {
Connection con=null;
public static Connection ConnectDB(){
String DataSourceName="GradeBook";
String dbURL="jdbc:odbc:" + DataSourceName;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(dbURL,"","");
return con;

}catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
return null;
}
}

Walaikum Salam, me ap k liye video tutorial bana raha tha but jb video complete hoi to wo 3.44GB ki video bani is liye us ko me upload nai kar sakta, me subah ap k liye snapshots ka tutorial bana donga...

to aap usay kahe or upload kar day or link day day yaha

Uzma Kanwal: 3.44 GB ko upload karnay me shayad kai ghantay lag jayen ya may be pora din lag jaye...

@ Khalid Afzal added

RSS

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

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