hey...actually this code of "virtual classroom" is not working.Can u help?plz...i am running it in netbeans and the databases are in netbeans only...plz...

The structure of all tables included in the project is as under:-

1.  STUDENT
+--------+-------------+------+-----+---------+-------+

| Field  | Type | Null | Key | Default | Extra |

+--------+-------------+------+-----+---------+-------+

| user   | varchar(25) | YES  | UNI | NULL  |   |

| pass   | varchar(25) | YES  | | NULL  |   |

| name   | varchar(25) | YES  | | NULL  |   |

| ph_no  | varchar(25) | YES  | | NULL  |   |

| year   | varchar(2)  | YES  | | NULL  |   |

| branch | varchar(4)  | YES  | | NULL  |   |

+--------+-------------+------+-----+---------+-------+

2.  FACULTY
+---------+-------------+------+-----+---------+-------+
| Field   | Type    | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| user  | varchar(25) | YES  |  | NULL  |   |
| pass  | varchar(25) | YES  |  | NULL  |   |
| name  | varchar(25) | YES  |  | NULL  |   |
| ph_no   | varchar(10) | YES  |    | NULL  |   |
| subject | varchar(25) | YES  |    | NULL  |   |
| branch  | varchar(4)  | YES  |    | NULL  |   |

5

Virtual Classroom


+---------+-------------+------+-----+---------+-------+

3.  STUDENTSIGNUP
+--------+-------------+------+-----+---------+-------+
| Field  | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| user   | varchar(25) | YES  | UNI | NULL  |   |
| pass   | varchar(25) | YES  | | NULL  |   |
| name   | varchar(25) | YES  | | NULL  |   |
| ph_no  | varchar(25) | YES  | | NULL  |   |
| year   | varchar(2)  | YES  | | NULL  |   |
| branch | varchar(4)  | YES  | | NULL  |   |
+--------+-------------+------+-----+---------+-------+
4.  FACULTYSIGNUP
+---------+-------------+------+-----+---------+-------+
| Field   | Type    | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| user  | varchar(25) | YES  |  | NULL  |   |
| pass  | varchar(25) | YES  |  | NULL  |   |
| name  | varchar(25) | YES  |  | NULL  |   |
| ph_no   | varchar(10) | YES  |    | NULL  |   |
| subject | varchar(25) | YES  |    | NULL  |   |
| branch  | varchar(4)  | YES  |    | NULL  |   |
+---------+-------------+------+-----+---------+-------+
5.  ADMIN
+-------+------------+------+-----+---------+-------+
| Field | Type  | Null | Key | Default | Extra |
+-------+------------+------+-----+---------+-------+
| pass  | varchar(5) | YES  |   | NULL  |   |
+-------+------------+------+-----+---------+-------+
6.  PPT
+---------+-------------+------+-----+---------+-------+
| Field   | Type    | Null | Key | Default | Extra |

6
Virtual Classroom


+---------+-------------+------+-----+---------+-------+
| subject | varchar(10) | YES  |    | NULL  |   |
| ppt   | varchar(50) | YES  |  | NULL  |   |
+---------+-------------+------+-----+---------+-------+

7.  VIDEO
+---------+-------------+------+-----+---------+-------+
| Field   | Type    | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| subject | varchar(10) | YES  |    | NULL  |   |
| video   | varchar(70) | YES  |    | NULL  |   |
+---------+-------------+------+-----+---------+-------+
8.  QUESTION
+---------+--------------+------+-----+---------+-------+
| Field   | Type    | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| que   | varchar(200) | YES  | | NULL  |   |
| askedby | varchar(25)  | YES  |   | NULL  |   |
| subject | varchar(10)  | YES  |   | NULL  |   |
| qid   | int(11)   | YES  | UNI | NULL |   |
+---------+--------------+------+-----+---------+-------+
9.  ANSWER

+----------+--------------+------+-----+---------+-------+

| Field | Type  | Null | Key | Default | Extra |

+----------+--------------+------+-----+---------+-------+

| qid   | int(11)   | YES  | UNI | NULL |   |

| answer   | varchar(200) | YES  |  | NULL  |   |

| answerby | varchar(25)  | YES  |  | NULL  |   |

+----------+--------------+------+-----+---------+-------+


Virtual Classroom
![alt text][1]

CODE

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>
<!DOCTYPE   html    PUBLIC  "-//W3C//DTD    HTML    4.01    Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>profile</title>
</head>
<SCRIPT type="text/javascript">
window.history.forward();
function noBack() { window.history.forward(); }
</SCRIPT>
<body background="G:\Classroom1.jpg" bgcolor="red" >


<form action="main.jsp" method="post" >

<table  width="960" border="0"  cellpadding="0" cellspacing="4" bgcolor="grey">
<tr>
<td>
<center><img src="D:\New folder\Web Page Header.gif" width="960"height="100"
></center>
</td>
</tr>
<tr>
<td align="left"    style="word-spacing:6px;font-size:120%;padding- right:30px;color:#888888;white-space:nowrap;">
<a href="studlogin.jsp" title="student">Student login </a>  |
<a href="faclogin.jsp" title="faculty"> Faculty login </a>  |


</td></tr>
</table>

8

Virtual Classroom


<table>
<tr><td>
<tr><td>Admin Login
<tr><td><input type="password" value="" name="pass" >
<tr><td><input type="submit" value="Login" onclick="fu(this.form)" >
</td></tr>
</table>
<%

String pass1=request.getParameter("pass");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection  c=  DriverManager.getConnection("jdbc:odbc:akb",    "root", "root");
Statement s= c.createStatement(); String sql="select pass from admin"; ResultSet rs= s.executeQuery(sql); rs.next();
if( pass1.equalsIgnoreCase(rs.getString(1)) )
{
%>
<jsp:forward page="admin.jsp"></jsp:forward>
<%
}
rs.close(); s.close(); c.close();
}
catch(Exception e) {}
%>
</form>
</body>
</html>





<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>
<!DOCTYPE   html    PUBLIC  "-//W3C//DTD    HTML    4.01    Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>MAIN</title>
</head>
<SCRIPT type="text/javascript">
window.history.forward();
function noBack() { window.history.forward(); }
</SCRIPT>


<body background="G:\Classroom1.jpg" bgcolor="red" >





Virtual Classroom


<SCRIPT type="text/javascript">
window.history.forward();
function noBack() { window.history.forward(); }
</SCRIPT>
<form action="studlogin.jsp"    method="post" >

<marquee        ONMOUSEOVER="this.stop();"  ONMOUSEOUT="this.start();" scrollamount="20"    bgcolor="white" >
<H3> Virtual Class room </H3>
</MARQUEE>





<TABLE border=0 cellspacing=2 cellpadding=2 width="100%">
<TR>
<TD width="34%">
<TABLE border=0 cellspacing=2 cellpadding=2 width="100%">
<TR>
<TD>
<marquee bgcolor="red"  style="position: relative;" behavior="scroll" "
direction="up"  scrollamount="8"    scrolldelay="2" onmouseover="this.stop()"
onmouseout="this.start()"width="350" height="200"><br>

<img src="D:\New folder\3d_virtual_classroom.jpg" width=250 height=250 title="ad " style="position: relative;" border="0"><br>
<img src="D:\New folder\education1.jpg" width=250 height=250    title="ad
" style="position: relative;" border="0"><br>
<img src="D:\New folder\virtual.jpg" width=250 height=250   title="ad   "
style="position: relative;" border="0"><br>
<img    src="D:\New folder\virtual_class_room.jpg"  width=250   height=250
title="ad   " style="position: relative;" border="0"><br>

</marquee>
</TD>
</TR>
</TABLE>
</TD>
<TD>
<table cellpadding=2 cellspacing=0 border=0>

<tr>    <td bgcolor="red"><table     cellpadding=0   cellspacing=0  border=1 width=100%>            <tr>    <td     bgcolor="green"     align=center style="padding:2;padding-bottom:4">        <b><font    size=-1 color="white" face="verdana,arial"> LOG IN</font></b></tr>
<tr><td bgcolor="white" style="padding:5"><br>
<TABLE  border=0    cellspacing=5   cellpadding=2   width="60%"
bgcolor="white">
<TR>
<TD>
<tr><td>    <font   face="verdana,arial"    size=-1>
Login_Type:</font></td> <td><select name="type"><option
value="Student">Student</option></select></td></tr>

10



Virtual Classroom


<tr><td>    <font face="verdana,arial" size=-1> Login:</font></td>
<td><input type="text" name="login" value=""></td></tr>
<tr><td>    <font   face="verdana,arial"    size=-1> Password:</font></td>      <td><input  type="password" name="password1"></td></tr>
<tr><td>    <font face="verdana,arial" size=-1>� </font></td>
<td><font   face="verdana,arial"    size=-1><input  type="submit"
value="Enter"></font></td></tr>
<tr><td colspan=2><font face="verdana,arial"    size=-
1>� </font></td>  </tr>
<tr><td colspan=2><font face="verdana,arial"    size=-1>Lost    your
username    or  password?   Find    it  <a
href="G:\study\seminar\ppt\ppt_for_05].ppt">here</a>!</font></td></tr>
<tr><td colspan=2><font face="verdana,arial"    size=-1>Not member
yet? Click      <button style="width:160;height:24; background-color:#97cfc3" onclick=  "   location.href='signup.jsp'" >here</button>  to register.</font></td></tr>


</TABLE>
</TD>
<TD>
</table>


</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>





<%

String str1=request.getParameter("login"); String str2=request.getParameter("password1"); if(str1!=null && str2!= null)
{
int flag=0;


try{


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection  c=  DriverManager.getConnection("jdbc:odbc:akb",

"root", "root");
Statement s= c.createStatement();
out.println("user="+str1+" and pass= "+str2);
String sql="select user from student where user='"+str1+"' and pass='"+str2+"'";
ResultSet rs= s.executeQuery(sql);
if(rs.next())

11



Virtual Classroom




else

flag=1;

flag=0;



if(flag==1)
{





}
else

rs.close(); s.close(); c.close();



session.setAttribute("user",str1);
%>
<jsp:forward page="profile.jsp" />
<%


out.println("UserName/Password Not Valid");


}







%>
</form>
</body>
</html>

}catch(Exception e) {   out.println(e);}




<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>
<!DOCTYPE   html    PUBLIC  "-//W3C//DTD    HTML    4.01    Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<SCRIPT type="text/javascript">
window.history.forward();
function noBack() { window.history.forward(); }
</SCRIPT>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>student</title>
</head>
<body background="G:\Classroom1.jpg" bgcolor="red" >

<form action="studentsignup.jsp"    method="post" >

<table  width="960" border="0"  cellpadding="0" cellspacing="4" bgcolor="black">
<tr>
<td>


12



Virtual Classroom


<center><img    src="D:\New folder\Web  Page    Header.gif" width="1150" height="100" ></center>
</td>
</tr>
<tr>
<td align="left"    style="word-spacing:6px;font-size:120%;padding-
right:30px;color:#888888;white-space:nowrap;">
<a href="student.jsp" title="student">Student </a>  |
<a href="studentsignup.jsp" title="studensignupt">Student req </a>  |
<a href="faculty.jsp" title="faculty"> Faculty </a> |
<a href="facultysignup.jsp" title="faculty signup requests">Faculty req </a>
|
<a href="pptup.jsp" title="faculty"> PPT(upload) </a>   |
<a href="pptdel.jsp" title="faculty"> PPT(del) </a> |
<a href="videoup.jsp" title="faculty"> Video(up) </a>   |
<a href="videodel.jsp" title="faculty"> Video(del) </a> |
<a href="que1.jsp" title="faculty"> Question </a>   |
<a href="ans1.jsp" title="faculty"> Ans </a>    |
<td>    <a href="main.jsp" title="faculty"> Logout </a>

</td></tr>
</table>
<br>
<br>
<b>User Name    :   </b><input type="text" value="" name="user"> ââ?¬Æ? ââ?¬Æ?
<input type="submit" value="DELETE" >
<br>
<br>
<table  width="960" border="0"  cellpadding="0" cellspacing="4" border=2
background="G:\Classroom1.jpg">
<tr>
<td>


<%
try{



Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection  c=  DriverManager.getConnection("jdbc:odbc:akb",

"root", "root");
Statement s= c.createStatement();
String sql="select * from studentsignup "; ResultSet rs= s.executeQuery(sql);
%>
<tr><td><b>USERNAME</b><td><b>PASSWORD</b><td><b>NAME</b><td><b>PHONE NO</b><td><b>YEAR</b><td><b>BRANCH</b>
<%
while( rs.next() )
{
%>


<%

%>
<td>

<tr><td>

out.println(rs.getString(1));



13




Virtual Classroom



<%

%>
<td>
<%


out.println(rs.getString(2));




%>
<td>
<%

out.println(rs.getString(3));




%>
<td>
<%

out.println(rs.getString(4));




%>
<td>
<%

out.println(rs.getString(5));


out.println(rs.getString(6));


}
rs.close();

String user=request.getParameter("user"); String sql1;
if(user!=null)
{
sql1="select * from studentsignup where user='"+user+"' "; ResultSet rs1= s.executeQuery(sql1);
rs1.next();
out.println("user : "+user);
sql1="insert    into    student
values('"+rs1.getString(1)+"','"+rs1.getString(2)+"','"+rs1.getString(3)+"','
"+rs1.getString(4)+"','"+rs1.getString(5)+"','"+rs1.getString(6)+"' )";
s.execute(sql1);

sql="delete from studentsignup where user='"+user+"'";
s.execute(sql);
rs1.close();
}







%>
</td>
</tr>
</table>

s.close();
c.close();
}catch(Exception e) {   out.println(e);}





14




Virtual Classroom



</form>

</body>
</html>



<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>
<!DOCTYPE   html    PUBLIC  "-//W3C//DTD    HTML    4.01    Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>profile</title>
</head>
<SCRIPT type="text/javascript">
window.history.forward();
function noBack() { window.history.forward(); }
</SCRIPT>
<body background="G:\Classroom1.jpg" bgcolor="red" >

<form action="profile.jsp"  method="post" >

<table  width="960" border="0"  cellpadding="0" cellspacing="4" bgcolor="grey">
<tr>
<td>
<center><img src="D:\New folder\Web Page Header.gif" width="960"height="100"
></center>
</td>
</tr>
<tr>
<td align="left"    style="word-spacing:6px;font-size:120%;padding- right:30px;color:#888888;white-space:nowrap;">
<a href="profile.jsp" title="Home">Home </a>    |
<a href="update.jsp" title="update"> Edit Profile </a>  |
<a href="study.jsp" title="study">Study material</a>    |
<a href="video.jsp" title="video">Video Lectures</a>    |
<a href="question.jsp" title="ask">Ask doubts</a>   |
<a href="ans.jsp" title="tell">Answers</a>

</td>

<td align="right"   style="word-spacing:6px;font-size:120%;padding- right:10px;color:#888888;white-space:nowrap;">
|<a href="main.jsp" title="tell">Logout</a>
</td>
</tr>
</table>



15



Virtual Classroom







<%
String user =(String)session.getAttribute("user");




try{


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection  c=  DriverManager.getConnection("jdbc:odbc:akb",

"root", "root");
Statement s= c.createStatement();
String sql="select * from student where user='"+user+"'";


ResultSet rs= s.executeQuery(sql);
rs.next();


%>



<br>
<br>
<br>
<table border=0 cellspacing=2 cellpadding=2 width="100%">
<tr>    <td bgcolor="red"><table    cellpadding=0   cellspacing=0   border=1 width=100%>        <tr>        <td     bgcolor="green"     align=center style="padding:2;padding-bottom:4">            <font    size=-1    color="white" face="verdana,arial"> <b>Profile</b></font></tr>
<TR>
<TD width="50%">
<TABLE  cellspacing=2 cellpadding=2 width="100%">
<TR>
<td>



> </center>



</td>
</TR>

<center> <img src="G:\Classroom1.jpg" width=100 height= 100



<tr><td>Logged  in  as  <input  type="text" name="user"

value="<% out.println(rs.getString(1)); %>"></td></tr>


</TABLE>
</TD>
<TD>
<TABLE border=0 cellspacing=2 cellpadding=2 width="100%">
<TR>
<TD>

16


Virtual Classroom


<tr><td>    <font face="verdana,arial" size=-1> Name: </font></td>  <td>
<input type="text" name="name" value="<% out.println(rs.getString(3)); %>">
</td>   </tr>


<tr><td>    <font   face="verdana,arial"    size=-1>    Branch:</font></td>
<td>    <input  type="text" name="branch"   value="<%
out.println(rs.getString(6)); %>">  </td>   </tr>

<tr><td>    <font   face="verdana,arial"    size=-1>    Year.:</font></td>
<td>    <input type="text" name="year" value="<% out.println(rs.getString(5));
%>">    </td>   </tr>

<tr><td>    <font   face="verdana,arial"    size=-1>        Contact No..:</font></td>    <td>       <input  type="text" name="phno" value="<% out.println(rs.getString(4)); %>">    </td>       </tr>



</TD>
<TD>

</TABLE>

</td>
</tr>
</table>

<%

</TABLE>


String branch=rs.getString(6); String year=rs.getString(5); session.setAttribute("branch",branch); session.setAttribute("year",year); out.println("branch = "+branch+" and year = "+year); rs.close();
s.close();
c.close();
}
catch(Exception e) { out.println(e);    }








%>


</form>
</body>
</html>


17



Virtual Classroom




<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>
<!DOCTYPE   html    PUBLIC  "-//W3C//DTD    HTML    4.01    Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>update</title>
</head>

<SCRIPT type="text/javascript">
window.history.forward();
function noBack() { window.history.forward(); }
</SCRIPT>
<body background="G:\Classroom1.jpg" bgcolor="red" >
<form   action="update.jsp" method="post" >
<table  width="960" border="0"  cellpadding="0" cellspacing="4"
bgcolor="grey">
<tr>
<td>
<center><img src="D:\New folder\Web Page Header.gif" width="960"height="100"
></center>
</td>
</tr>
<tr>
<td align="left"    style="word-spacing:6px;font-size:120%;padding-
right:30px;color:#888888;white-space:nowrap;">
<a href="profile.jsp" title="Home">Home </a>    |
<a href="update.jsp" title="update"> Edit Profile </a>  |
<a href="study.jsp" title="study">Study material</a>    |
<a href="videos.jsp" title="video">Video Lectures</a>   |
<a href="question.jsp" title="ask">Ask doubts</a>   |
<a href="ans.jsp" title="tell">Answers</a>

</td>

<td align="right"   style="word-spacing:6px;font-size:120%;padding- right:10px;color:#888888;white-space:nowrap;">
|<a href="main.jsp" title="tell">Logout</a>
</td>
</tr>
</table>



<%
String name=request.getParameter("name");
String username=request.getParameter("username"); String pas=request.getParameter("pass");

String branch=request.getParameter("branch");

18



Virtual Classroom


String year=request.getParameter("year"); String phno=request.getParameter("ph_no"); out.println("branch = "+branch+" and year = "+year); String user =(String)session.getAttribute("user"); try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection  c=  DriverManager.getConnection("jdbc:odbc:akb",
"root", "root");
Statement s= c.createStatement();
String sql="select * from student where user='"+user+"'"; ResultSet rs= s.executeQuery(sql);
rs.next();


%>


<center><table cellpadding=2 cellspacing=0 border=0>


<tr>    <td bgcolor="red"><table    cellpadding=0   cellspacing=0   border=1 width=100%>        <tr>        <td     bgcolor="green"     align=center style="padding:2;padding-bottom:4">            <b><font     size=-1    color="white" face="verdana,arial"> Edit Profile</font></b></tr>
<tr><td bgcolor="white" style="padding:5"><br>
<TABLE border=0 cellspacing=2 cellpadding=2 width="100%">

<tr>    <td bgcolor="red"><table        cellpadding=0   cellspacing=0   border=1 width=100%>            <tr>            <td     bgcolor="green"         align=center style="padding:2;padding-bottom:4">                <b><font     size=-1        color="white" face="verdana,arial">     Profile picture</font></b><td   bgcolor="green" align=center        style="padding:2;padding-bottom:4">     <b><font            size=-1 color="white" face="verdana,arial">Personal info</font></b>

<TR>
<TD width="50%">
<TABLE  cellspacing=2 cellpadding=2 width="100%">
<TR>
<TD>
<center><img src="G:\Classroom1.jpg" width=150 height=150   ></center>
<center>
<div class="mybutton">
<a href="main.html">
<button style="width:160;height:24; background-
color:#97cfc3">change picture
</button></a><br>
</div>
</center>
</TD>
</TR>
</TABLE>
</TD>
<TD>

19



Virtual Classroom


<center><table>
<tr><td>    <font face="verdana,arial" size=-1> Name:</font></td>   <td>
<input type="text" name="name" value="<% out.println(rs.getString(3)); %>">
</td>   </tr>

<tr><td>    <font face="verdana,arial" size=-1> User_name:</font></td>
<td>    <input  type="text" name="username" value="<%
out.println(rs.getString(1)); %>">  </td>   </tr>

<tr><td>    <font face="verdana,arial" size=-1> Password:</font></td>
<td>    <input type="text" name="pass" value="<% out.println(rs.getString(2));
%>">    </td>   </tr>


<tr><td>    <font   face="verdana,arial"    size=-1>    Branch:</font></td>
<td><select name="branch">


value="it">IT</option> value="mech">MECH</option> value="comp">Comp</option> value="entc">Entc</option>

<option

<option

<option

<option

</select></td></tr>


<tr><td>    <font   face="verdana,arial"    size=-1>    Year:</font></td>
<td><select name="year">


value="fe">FE</option> value="se">SE</option> value="te">TE</option> value="be">BE</option>

<option

<option

<option

<option

</select></td></tr>


<tr><td>    <font   face="verdana,arial"    size=-1>        Contact No..:</font></td>    <td>       <input  type="text"         name="ph_no"    value="<% out.println(rs.getString(4)); %>">    </td>       </tr>

<tr><td><font   face="verdana,arial"    size=-1>� </font></td><td><font face="verdana,arial" size=-1><input type="submit" value="Update"  ></font>
</table></center>
</table>
</td>
<%

String  sql1="update    student set user='"+username+"',pass='"+pas+"',name='"+name+"',ph_no='"+phno+"',year='"+y ear+"',branch='"+branch+"' where user='"+user+"'";


20



Virtual Classroom


s.execute(sql1);
%>
<jsp:forward page="profile.jsp" />
<%



s.close();
c.close();
}
catch(Exception e) {    }


%>

</table>
</table>

</td>
</tr>
</table>
</center>

</form>


</body>
</html>



<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>
<!DOCTYPE   html    PUBLIC  "-//W3C//DTD    HTML    4.01    Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>study material</title>
</head>
<body background="G:\Classroom1.jpg" bgcolor="red" >
<SCRIPT type="text/javascript">
window.history.forward();
function noBack() { window.history.forward(); }
</SCRIPT>
<form action="study.jsp" method="post" >
<%
String branch =(String)session.getAttribute("branch");
String year =(String)session.getAttribute("year");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection  c1= DriverManager.getConnection("jdbc:odbc:akb", "root", "root");

21



Virtual Classroom


Statement s1= c1.createStatement();
out.println("branch= "+branch+" and year= "+year);
String sql="select subject from subject where branch='"+branch+"' and year='"+year+"' ";
String temp=null;
ResultSet rs= s1.executeQuery(sql);

rs.next();
temp=rs.getString(1);

%>

<table  width="960" border="0"  cellpadding="0" cellspacing="4" bgcolor="black">
<tr>
<td>
<center><img src="D:\New folder\Web Page Header.gif" width="960"height="100"
></center>
</td>
</tr>
<tr>
<td align="left"    style="word-spacing:6px;font-size:120%;padding-
right:30px;color:#888888;white-space:nowrap;">
<a href="sub1.jsp" title="<% out.println(temp); %>"><% out.println(temp); %>
</a>    |
<%  rs.next();
temp=rs.getString(1);
%>
<a href="sub2.jsp" title="<% out.println(temp); %>"><% out.println(temp); %>
</a>    |
<%  rs.next();
temp=rs.getString(1);
%>
<a href="sub3.jsp" title="<% out.println(temp); %>"><% out.println(temp); %>
</a>    |
<%  rs.next();
temp=rs.getString(1);
%>
<a href="sub4.jsp" title="<% out.println(temp); %>"><% out.println(temp); %>
</a>    |
<%  rs.next();
temp=rs.getString(1);
%>
<a href="sub5.jsp" title="<% out.println(temp); %>"><% out.println(temp); %>
</a>    |
<%rs.close(); %>
<a href="profile.jsp" title="home">home</a>

</td>

<td align="right"   style="word-spacing:6px;font-size:120%;padding- right:10px;color:#888888;white-space:nowrap;">
|<a href="main.jsp" title="tell">Logout</a>

22



Virtual Classroom


</td>
</tr>
</table>

<%


s1.close();
c1.close();
}
catch(Exception e) {out.println(e); }








%>

</form>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>
<!DOCTYPE   html    PUBLIC  "-//W3C//DTD    HTML    4.01    Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>sub1</title>
</head>
<body background="G:\Classroom1.jpg" bgcolor="red" >
<SCRIPT type="text/javascript">
window.history.forward();
function noBack() { window.history.forward(); }
</SCRIPT>
<form action="sub1.jsp" method="post" >
<%
String branch =(String)session.getAttribute("branch");
String year =(String)session.getAttribute("year");


try{


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection  c1= DriverManager.getConnection("jdbc:odbc:akb",

"root", "root");
Statement s1= c1.createStatement();
out.println("branch= "+branch+" and year= "+year);
String  sql1="select    subject from    subject where branch='"+branch+"' and year='"+year+"' ";
ResultSet rs= s1.executeQuery(sql1);
rs.next();

23



Virtual Classroom


String subject=rs.getString(1); rs= s1.executeQuery(sql1); rs.next();

%>

<table  width="960" border="0"  cellpadding="0" cellspacing="4" bgcolor="black">
<tr>
<td>
<center><img src="D:\New folder\Web Page Header.gif" width="960"height="100"
></center>
</td>
</tr>
<tr>
<td align="left"    style="word-spacing:6px;font-size:120%;padding-
right:30px;color:#888888;white-space:nowrap;">
<a href="sub1.jsp" title="<% out.println(rs.getString(1)); %>">sub1 </a>    |
<%  rs.next(); %>
<a href="sub2.jsp" title="<% out.println(rs.getString(1)); %>"> sub2 </a>   |
<%  rs.next(); %>
<a href="sub3.jsp" title="<% out.println(rs.getString(1)); %>">sub3</a> |
<%  rs.next(); %>
<a href="sub4.jsp" title="<% out.println(rs.getString(1)); %>">sub4</a> |
<%  rs.next(); %>
<a href="sub5.jsp" title="<% out.println(rs.getString(1)); %>">sub5</a> |
<%rs.close(); %>
<a href="profile.jsp" title="home">home</a>

</td>

<td align="right"   style="word-spacing:6px;font-size:120%;padding- right:10px;color:#888888;white-space:nowrap;">
|<a href="main.jsp" title="tell">Logout</a>
</td>
</tr>
</table>

<%

String sql2="select ppt from ppt where subject='"+subject+"'"; ResultSet rs1= s1.executeQuery(sql2);
rs1.next();
String ppt=rs1.getString(1);

%><br><br>
<a  href="<%    out.println(ppt);%>"    title="<%   out.println(ppt);%>">ppt1   </a>
<br><br>
<%
if(!rs1.next())
{
ppt=rs1.getString(1);
rs1.close();

24
Virtual Classroom
%>
</form>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>
<!DOCTYPE   html    PUBLIC  "-//W3C//DTD    HTML    4.01    Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>video</title>
</head>
<SCRIPT type="text/javascript">
window.history.forward();
function noBack() { window.history.forward(); }
</SCRIPT>
<body background="G:\Classroom1.jpg" bgcolor="red" >
<form action="video.jsp" method="post" >
<%
String branch =(String)session.getAttribute("branch");
String year =(String)session.getAttribute("year");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection  c1= DriverManager.getConnection("jdbc:odbc:akb", "root", "root");
Statement s1= c1.createStatement();
out.println("branch= "+branch+" and year= "+year);
String sql="select subject from subject where branch='"+branch+"'
and year='"+year+"' ";
ResultSet rs= s1.executeQuery(sql);

rs.next();
%>

<table  width="960" border="0"  cellpadding="0" cellspacing="4" bgcolor="black">
<tr>
<td>
<center><img src="D:\New folder\Web Page Header.gif" width="960"height="100"
></center>
</td>
</tr>
<tr>
<td align="left"    style="word-spacing:6px;font-size:120%;padding- right:30px;color:#888888;white-space:nowrap;">

26
Virtual Classroom
<a href="sub11.jsp" title="<% out.println(rs.getString(1)); %>">sub1 </a>   |
<%  rs.next(); %>
<a href="sub22.jsp" title="<% out.println(rs.getString(1)); %>"> sub2 </a>  |
<%  rs.next(); %>
<a href="sub23.jsp" title="<% out.println(rs.getString(1)); %>">sub3</a>    |
<%  rs.next(); %>
<a href="sub44.jsp" title="<% out.println(rs.getString(1)); %>">sub4</a>    |
<%  rs.next(); %>
<a href="sub55.jsp" title="<% out.println(rs.getString(1)); %>">sub5</a>    |
<% rs.close(); %>
<a href="profile.jsp" title="home">home</a>

</td>

<td align="right"   style="word-spacing:6px;font-size:120%;padding- right:10px;color:#888888;white-space:nowrap;">
|<a href="main.jsp" title="tell">Logout</a>
</td>
</tr>
</table>

<%


s1.close();
c1.close();
}
catch(Exception e) {out.println(e); }








%>

</form>
</body>
</html>



<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>
<!DOCTYPE   html    PUBLIC  "-//W3C//DTD    HTML    4.01    Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>MAIN</title>
</head>


27



Virtual Classroom



<body background="G:\Classroom1.jpg" bgcolor="red" >
<form action="faclogin.jsp" method="post" >

<marquee        ONMOUSEOVER="this.stop();"  ONMOUSEOUT="this.start();" scrollamount="20"    bgcolor="white" >
<H3> Virtual Class room </H3>
</MARQUEE>





<TABLE border=0 cellspacing=2 cellpadding=2 width="100%">
<TR>
<TD width="34%">
<TABLE border=0 cellspacing=2 cellpadding=2 width="100%">
<TR>
<TD>
<marquee bgcolor="red"  style="position: relative;" behavior="scroll" "
direction="up"  scrollamount="8"    scrolldelay="2" onmouseover="this.stop()" onmouseout="this.start()"width="350" height="200"><br>

<img src="D:\New folder\3d_virtual_classroom.jpg" width=250 height=250 title="ad " style="position: relative;" border="0"><br>
<img src="D:\New folder\education1.jpg" width=250 height=250    title="ad
" style="position: relative;" border="0"><br>
<img src="D:\New folder\virtual.jpg" width=250 height=250   title="ad   "
style="position: relative;" border="0"><br>
<img    src="D:\New folder\virtual_class_room.jpg"  width=250   height=250
title="ad   " style="position: relative;" border="0"><br>

</marquee>
</TD>
</TR>
</TABLE>
</TD>
<TD>
<table cellpadding=2 cellspacing=0 border=0>

<tr>    <td bgcolor="red"><table     cellpadding=0   cellspacing=0  border=1 width=100%>            <tr>    <td     bgcolor="green"     align=center style="padding:2;padding-bottom:4">        <b><font    size=-1 color="white" face="verdana,arial"> LOG IN</font></b></tr>
<tr><td bgcolor="white" style="padding:5"><br>
<TABLE  border=0    cellspacing=5   cellpadding=2   width="60%" bgcolor="white">
<TR>
<TD>
<tr><td>    <font   face="verdana,arial"    size=-1>
Login_Type:</font></td> <td><select name="type"><option value="Faculty">Faculty</option></select></td></tr>
<tr><td>    <font face="verdana,arial" size=-1> Login:</font></td>
<td><input type="text" name="login" value=""></td></tr>

28



Virtual Classroom


<tr><td>    <font   face="verdana,arial"    size=-1> Password:</font></td>      <td><input  type="password" name="password1"></td></tr>
<tr><td>    <font face="verdana,arial" size=-1>� </font></td>
<td><font   face="verdana,arial"    size=-1><input  type="submit" value="Enter"></font></td></tr>
<tr><td colspan=2><font face="verdana,arial"    size=-
1>� </font></td>  </tr>
<tr><td colspan=2><font face="verdana,arial"    size=-1>Lost    your
username    or  password?   Find    it  <a href="G:\study\seminar\ppt\ppt_for_05].ppt">here</a>!</font></td></tr>
<tr><td colspan=2><font face="verdana,arial"    size=-1>Not member
yet? Click          <button style="width:160;height:24; background-color:#97cfc3" onclick=  "   location.href='facsignup.jsp'"  >here</button>  to register.</font></td></tr>


</TABLE>
</TD>
<TD>
</table>


</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>





<%

String str1=request.getParameter("login"); String str2=request.getParameter("password1"); if(str1!=null && str2!= null)
{
int flag=0;


try{


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection  c=  DriverManager.getConnection("jdbc:odbc:akb",

"root", "root");
Statement s= c.createStatement();
out.println("user="+str1+" and pass= "+str2);
String sql="select user from faculty where user='"+str1+"' and pass='"+str2+"'";
ResultSet rs= s.executeQuery(sql);
if(rs.next())
flag=1;
else

29



Virtual Classroom


flag=0;


if(flag==1)
{





}
else

rs.close(); s.close(); c.close();



session.setAttribute("fuser",str1);
%>
<jsp:forward page="fac_profile.jsp" />
<%


out.println("UserName/Password Not Valid");


}







%>
</form>
</body>
</html>

}catch(Exception e) {   out.println(e);}




<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*" buffer="100kb"%>
<!DOCTYPE   html    PUBLIC  "-//W3C//DTD    HTML    4.01    Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>faculty signup</title>
</head>
<body background="G:\Classroom1.jpg" bgcolor="red" >


<script language="javascript">
function fu(form)
{
alert('A request is sent to the admin to approve your signup ');
}
function fun1(form)
{

var l=form.pass.value.length;

for(var i=0; i < l ; i++)
{

30



Virtual Classroom


if(form.pass1.value.substr(i,1) != form.pass.value.substr(i,1) )
{
form.pass.value=""; form.pass1.value=""; alert('passwords Not Equal'); break;
}

}
}

function fun2(form)
{

var l=form.phno.value.length;
for(var i=0; i < l ; i++)
{
if( (form.phno.value.substr(i,1)>=  'a' && form.phno.value.substr(i,1)>= 'z'        ) ||(form.phno.value.substr(i,1)>= 'A' && form.phno.value.substr(i,1)>= 'Z' ) )
{
form.pass.value=""; form.pass1.value=""; alert('invalid phone no.'); break;
}

}
}


</script>
<form action="facsignup.jsp" method="post" >

<marquee    ONMOUSEOVER="this.stop();"  ONMOUSEOUT="this.start();" bgcolor="white" scrollamount=15 >
<h2>    <font face="verdana,arial" size=-1 > <a href="main.jsp">Click here</a>
to return to home page .</font>
</h2>
</MARQUEE>


<table cellpadding=2 cellspacing=0 border=0>


<tr>    <td bgcolor="red"><table    cellpadding=0   cellspacing=0   border=1 width=100%>        <tr>        <td     bgcolor="green"     align=center style="padding:2;padding-bottom:4">            <font    size=-1    color="white" face="verdana,arial"> <b>Sign Up</b></font></tr>
<tr><td bgcolor="white" style="padding:5"><br>
<center><table>
<tr><td>    <font face="verdana,arial" size=-1> Name:</font></td>   <td>
<input type="text" name="name" value="">    </td>   </tr>

31



Virtual Classroom



<tr><td>    <font face="verdana,arial" size=-1> User_name:</font></td>
<td>    <input type="text" name="username" value="" > </td> </tr>

<tr><td>    <font face="verdana,arial" size=-1> Password:</font></td>
<td>    <input type="password" name="pass" value="">    </td>   </tr>

<tr><td>    <font   face="verdana,arial"    size=-1>    Conform
Password:</font></td>   <td>    <input type="password" name="pass1" value="">
</td>   </tr>
<tr><td>    <font face="verdana,arial" size=-1> Phone NO.:</font></td>
<td>    <input  type="text" name="phno" value=""    onblur="fun1(this.form)">
</td>   </tr>

<tr><td>    <font   face="verdana,arial"    size=-1>    Subject:</font></td>
<td>    <input type="text" name="subject" value="" onblur="fun2(this.form)">
</td>   </tr>

<tr><td>    <font   face="verdana,arial"    size=-1>    Branch:</font></td>
<td><select name="branch" >


value="it">IT</option> value="mech">Mech</option> value="entc">ENTC</option> value="comp">Comp</option>

<option

<option

<option

<option

</select></td></tr>





<tr><td><font   face="verdana,arial"    size=-1>� </font></td><td><font face="verdana,arial"      size=-1><input   type="submit"  value="Register" onclick="fu(this.form)" ></font></td></tr>

</table></center>



</td></tr></table></td></tr></table>


<%

String name=request.getParameter("name");
String username=request.getParameter("username"); String pas=request.getParameter("pass");
String pas1=request.getParameter("pass1"); String branch=request.getParameter("branch"); String subject=request.getParameter("subject"); String phno=request.getParameter("phno");

32
Virtual Classroom

try{ "root", "root");


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection  c=  DriverManager.getConnection("jdbc:odbc:akb",

Statement s= c.createStatement();
String  sql="insert into    facultysignup

values('"+username+"','"+pas+"','"+name+"','"+phno+"','"+subject+"','"+branch
+"' )";
out.println("name= : "+name);
if(name!=""&&name!=null)
{
s.execute(sql);
}
s.close();
c.close();
}
catch(Exception e) {}

%>


</form>

</body>
</html>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>
<!DOCTYPE   html    PUBLIC  "-//W3C//DTD    HTML    4.01    Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>update</title>
</head>

<SCRIPT type="text/javascript">
window.history.forward();
function noBack() { window.history.forward(); }
</SCRIPT>
<body background="G:\Classroom1.jpg" bgcolor="red" >
<form   action="facupdate.jsp" method="post" >
<table  width="960" border="0"  cellpadding="0" cellspacing="4"
bgcolor="grey">
<tr>
<td>


33
Virtual Classroom
<center><img src="D:\New folder\Web Page Header.gif" width="960"height="100"
></center>
</td>
</tr>
<tr>
<td align="left"    style="word-spacing:6px;font-size:120%;padding-
right:30px;color:#888888;white-space:nowrap;">
<a href="fac_profile.jsp" title="Home">Home </a>    |
<a href="facupdate.jsp" title="update"> Edit Profile </a>   |
<a href="fstudy.jsp" title="study">Study material</a>   |
<a href="fvideos.jsp" title="video">Video Lectures</a>  |
<a href="fquestion.jsp" title="ask">Ask doubts</a>  |
</td>

<td align="right"   style="word-spacing:6px;font-size:120%;padding- right:10px;color:#888888;white-space:nowrap;">
|<a href="main.jsp" title="tell">Logout</a>
</td>
</tr>
</table>



<%
String user =(String)session.getAttribute("fuser");


try{


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection  c=  DriverManager.getConnection("jdbc:odbc:akb",

"root", "root");
Statement s= c.createStatement();
String sql="select * from faculty where user='"+user+"'";
out.println("select * from faculty where user='"+user+"'"); ResultSet rs= s.executeQuery(sql);
rs.next();
out.println("user= "+user);

%>

<center><table cellpadding=2 cellspacing=0 border=0>


<tr>    <td bgcolor="red"><table    cellpadding=0   cellspacing=0   border=1 width=100%>        <tr>        <td     bgcolor="green"     align=center style="padding:2;padding-bottom:4">            <b><font     size=-1    color="white" face="verdana,arial"> Edit Profile</font></b></tr>
<tr><td bgcolor="white" style="padding:5"><br>
<TABLE border=0 cellspacing=2 cellpadding=2 width="100%">
34
Virtual Classroom

<tr>    <td bgcolor="red"><table        cellpadding=0   cellspacing=0   border=1 width=100%>            <tr>            <td     bgcolor="green"         align=center style="padding:2;padding-bottom:4">                <b><font     size=-1        color="white" face="verdana,arial">     Profile picture</font></b><td   bgcolor="green" align=center        style="padding:2;padding-bottom:4">     <b><font            size=-1 color="white" face="verdana,arial">Personal info</font></b>

<TR>
<TD width="50%">
<TABLE  cellspacing=2 cellpadding=2 width="100%">
<TR>
<TD>
<center><img src="G:\Classroom1.jpg" width=150 height=150   ></center>
<center>
<div class="mybutton">
<a href="main.html">
<button style="width:160;height:24; background-
color:#97cfc3">change picture
</button></a><br>
</div>
</center>
</TD>
</TR>
</TABLE>
</TD>
<TD>
<center><table>
<tr><td>    <font face="verdana,arial" size=-1> Name:</font></td>   <td>
<input type="text" name="name" value="<% out.println(rs.getString(3)); %>">
</td>   </tr>

<tr><td>    <font face="verdana,arial" size=-1> User_name:</font></td>
<td>    <input  type="text" name="username" value="<%
out.println(rs.getString(1)); %>">  </td>   </tr>

<tr><td>    <font face="verdana,arial" size=-1> Password:</font></td>
<td>    <input  type="password" name="pass" value="<%
out.println(rs.getString(2)); %>">  </td>   </tr>

<tr><td>    <font   face="verdana,arial"    size=-1>    Conform
Password:</font></td>   <td>    <input type="password" name="pass1" >   </td>
</tr>

<tr><td>    <font   face="verdana,arial"    size=-1>    Branch:</font></td>
<td><select name="branch">


value="it">IT</option> value="mech">MECH</option> value="comp">Comp</option> value="entc">Entc</option>
35

<option

<option

<option

<option

Virtual Classroom


</select></td></tr>
<tr><td>    <font face="verdana,arial" size=-1> Subject:</font></td>
<td>    <input  type="text" name="subject"  value="<%
out.println(rs.getString(5)); %>" > </td>   </tr>


<tr><td>    <font   face="verdana,arial"    size=-1>        Contact No..:</font></td>    <td>       <input  type="text"         name="ph_no"    value="<% out.println(rs.getString(4)); %>">    </td>       </tr>

<tr><td><font   face="verdana,arial"    size=-1>� </font></td><td><font face="verdana,arial" size=-1><input type="submit" value="Update"  ></font>
</table></center>
</table>
</td>
<%
String name=request.getParameter("name");
String username=request.getParameter("username"); String pas=request.getParameter("pass");
String pas1=request.getParameter("pass1"); String branch=request.getParameter("branch"); String subject=request.getParameter("subject"); String phno=request.getParameter("ph_no");


if(name!=null && username!=null)
{
String  sql1="update    faculty set user='"+username+"',pass='"+pas+"',name='"+name+"',ph_no='"+phno+"',subject=' "+subject+"',branch='"+branch+"' where user='"+user+"'";

s.execute(sql1);
%>
<jsp:forward page="fac_profile.jsp" />
<%

}
else
 out.println("enter the fields");


s.close();
c.close();
}
catch(Exception e) {out.println(e); }


%>

</table>
</table>

</td>
</tr>

36
Virtual Classroom
</table>
</center>
</form>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" %>
<!DOCTYPE   html    PUBLIC  "-//W3C//DTD    HTML    4.01    Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Admin</title>
</head>
<SCRIPT type="text/javascript">
window.history.forward();
function noBack() { window.history.forward(); }
</SCRIPT>
<body background="G:\Classroom1.jpg" bgcolor="red" >

<form action="fac_profile.jsp"  method="post" >

<table  width="1150"    border="0"  cellpadding="0" cellspacing="4" bgcolor="black">
<tr>
<td>
<center><img    src="D:\New folder\Web  Page    Header.gif" width="1150"
height="100" ></center>
</td>
</tr>
<tr>
<td align="left"    style="word-spacing:6px;font-size:120%;padding-
right:30px;color:#888888;white-space:nowrap;">
<a href="student.jsp" title="student">Student </a>  |
<a href="studentsignup.jsp" title="studensignupt">Student req </a>  |
<a href="faculty.jsp" title="faculty"> Faculty </a> |
<a href="facultysignup.jsp" title="faculty signup requests">Faculty req </a>
|
<a href="pptup.jsp" title="faculty"> PPT(upload) </a>   |
<a href="pptdel.jsp" title="faculty"> PPT(del) </a> |
<a href="videoup.jsp" title="faculty"> Video(up) </a>   |
<a href="videodel.jsp" title="faculty"> Video(del) </a> |
<a href="que1.jsp" title="faculty"> Question </a>   |
<a href="ans1.jsp" title="faculty"> Ans </a>    |
<td>    <a href="main.jsp" title="faculty"> Logout </a>


</td></tr>
</table>

37
Virtual Classroom
</form>
</body>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>
<!DOCTYPE   html    PUBLIC  "-//W3C//DTD    HTML    4.01    Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Video delete</title>
</head>
<SCRIPT type="text/javascript">
window.history.forward();
function noBack() { window.history.forward(); }
</SCRIPT>
<body background="G:\Classroom1.jpg" bgcolor="red" >

<form action="videodel.jsp" method="post" >

<table  width="960" border="0"  cellpadding="0" cellspacing="4" bgcolor="black">
<tr>
<td>
<center><img    src="D:\New folder\Web  Page    Header.gif" width="1150" height="100" ></center>
</td>
</tr>
<tr>
<td align="left"    style="word-spacing:6px;font-size:120%;padding- right:30px;color:#888888;white-space:nowrap;">
<a href="student.jsp" title="student">Student </a>  |
<a href="studentsignup.jsp" title="studensignupt">Student req </a>  |
<a href="faculty.jsp" title="faculty"> Faculty </a> |
<a href="facultysignup.jsp" title="faculty signup requests">Faculty req </a>
|
<a href="pptup.jsp" title="faculty"> PPT(upload) </a>   |
<a href="pptdel.jsp" title="faculty"> PPT(del) </a> |
<a href="videoup.jsp" title="faculty"> Video(up) </a>   |
<a href="videodel.jsp" title="faculty"> Video(del) </a> |
<a href="que1.jsp" title="faculty"> Question </a>   |
<a href="ans1.jsp" title="faculty"> Ans </a>    |
<td>    <a href="main.jsp" title="faculty"> Logout </a>

</td></tr>
</table>
<br>
<br>
<b>Video Name   :   </b><input type="text" value="" name="ppt"> ââ?¬Æ? ââ?¬Æ?
<input type="submit" value="DELETE" >
<br>
<br>
38
Virtual Classroom
<center><table  width="960" border="0"  cellpadding="0" cellspacing="4" border=2 background="G:\Classroom1.jpg">
<tr>
<td>

<%
try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection  c=  DriverManager.getConnection("jdbc:odbc:akb",

"root", "root");
Statement s= c.createStatement();
String sql="select * from video ";
ResultSet rs= s.executeQuery(sql);
%>
<tr><td><b>SUBJECT</b><td><b>Video</b>
<%
while( rs.next() )
{
%>


<%

%>
<td>
<%

<tr><td>

out.println(rs.getString(1));



out.println(rs.getString(2));


}
rs.close();

String ppt=request.getParameter("ppt");
if(ppt!=null)
{   sql="delete from video where video='"+ppt+"'";
s.execute(sql);
}

%>
</td>
</tr>

s.close();
c.close();
}catch(Exception e) {   out.println(e);}

</table> </center>

</form>

</body>
</html>


  [1]: http://er