Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JSP-Servlet "virtual classroom" is not working. databases are in netbeans
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


sheetal
"virtual classroom" is not working. databases are in netbeans
0 Answer(s)      2 years and 7 months ago
Posted in : JSP-Servlet


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

Advertisement
View Answers

Related Tutorials/Questions & Answers:
problem in inserting data in databases created in netbeans using jsp..
problem in inserting data in databases created in netbeans using jsp..  i am trying to make a virtual classroom website in jsp using netbeans.i created table inside netbeans through sql editor.and tried to make a login page whose
JOptionPane.showMessageDialog is not working on tomcat however it is working on netbeans on same machine
JOptionPane.showMessageDialog is not working on tomcat however it is working on netbeans on same machine  the following code is not running on apacheTomcat 7.0.30 version but the same code is working on netebans 7.0, how to make
Advertisements
NetBeans
NetBeans  why Netbeans IDE is not commonly used Today by most of the companies
NetBeans
NetBeans  Hi, I am Kundan I have made a project on NetBeans. And now I want to know that how can i run my project without NetBeans IDE,on other PC. Please help me it's important
NetBeans
NetBeans  Hi, I am Kundan I have made a project on NetBeans. And now I want to know that how can i run my project without NetBeans IDE,on other PC. Please help me it's important
netbeans
netbeans  In netbeans, there are choices of books with their price. you check the book you wanted then click the purchase.the output should be the book with the price then you will get the total price of the book you purchase.how
netbeans
netbeans  guysss m nt able to opemn ma netbeans ide.. no error msg s coming... wn i installed yesterday one msg came stating about some run time error... sm one plzzzzzz hlp me
Switch databases
Switch databases  How do you inter-change between relational databases without code changes
connecting databases
application is created in netbeans
conflicting databases
conflicting databases  i recently installed xampp including apache and mysql. i need to study php in dreamweaver. bt i already installed mysql for jsp project in netbeans. now mysql in xampp showing this result. 1:10:05 PM
conflicting databases
conflicting databases  i recently installed xampp including apache and mysql. i need to study php in dreamweaver. bt i already installed mysql for jsp project in netbeans. now mysql in xampp showing this result. 1:10:05 PM
Databases supported by Jdeveloper?
Databases supported by Jdeveloper?  I want to know what databases are supported by jdeveloper ?and any light database for jdeveloper
codes for banking databases
codes for banking databases  sir plz give me codes for creating a banking database using netbeans as back end and java as front end
mysqldump all databases
mysqldump all databases  How to take the backup of complete data including all the databases in the MySQL Server? Is there one command to take...-databases > all_databases.sql Thanks
Datagrid not working
Datagrid not working  The code here is working fine, apart from the fact that that I'm using netbeans 6.5 and the servlet v2.5 and struts 1.1.... working. please help me out
Merge databases in SQL SErver 2005
Merge databases in SQL SErver 2005  Please help me to merge databases in SQL server 2005
java netbeans
java netbeans  i am making project in core java using Netbeans. Regarding my project i want to know that How to fetch the data from ms-access... using netbeans
RMI and netbeans
RMI and netbeans  how to use Rmi in netbeans? i want to connect to a server machine which is holding my application and need to identify the systems connected in LAN with it and get the IP address from it i wnt to use netbeans
java netbeans
java netbeans  i am making project in core java using Netbeans. Regarding my project i want to know that How to fetch the data from ms-access... using netbeans
UITapgesturerecognizer not working
UITapgesturerecognizer not working  uitapgesturerecognizer not working
netbeans library
netbeans library  Hi could someone build a program in netbeans for a book library please.The program should provide a menu of options to work with the library, including: 1) Adding a new item to the library 2) Viewing all stock
netbeans library
netbeans library  Hi could someone build a program in netbeans for a book library please.The program should provide a menu of options to work with the library, including: 1) Adding a new item to the library 2) Viewing all stock
need help....how to connect and disconnect multiple databases(databases created in mysql) using java and my sql
need help....how to connect and disconnect multiple databases(databases created in mysql) using java and my sql  i am working on a project... to know that how to query multiple databases(databases created in my mysql) so
webservice in Netbeans
.. im using netbeans version 6.9.1 .. pls help me out... regards-- Harish Kumar
Netbeans program
Netbeans program  I need to write a program that does the following... The TicTacToe class contains a 3x3 two-dimensional array of integers... a two human player game of Tic-Tac-Toe. Using the NetBeans design tool also create
Advertisements
 

 

 

DMCA.com