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