Students
Courses
Faculty
Fee details
etc..,
Adding Student details using jsp:
<html>
<head>
<title>Add Student Details</title>
<script>
function selectall()
{
if(document.myform.privilage[0].checked==true)
{
document.myform.privilage[1].disabled=true;
document.myform.privilage[2].disabled=true;
document.myform.privilage[3].disabled=true;
document.myform.privilage[4].disabled=true;
}
else
{
document.myform.privilage[1].disabled=false;
document.myform.privilage[2].disabled=false;
document.myform.privilage[3].disabled=false;
document.myform.privilage[4].disabled=false;
}
}
function check(ch)
{
if(ch.checked==true)
{
document.myform.privilage[0].disabled=true;
}
else
{
document.myform.privilage[0].disabled=false;
}
}
</script>
</head>
<body bgcolor="pink">
<form action="student1.jsp" name="myform">
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ include file="connect.jsp"%>
<%! String id;%>
<div align="center"><font color=black size=8>
<u><b>Enter Student Details</b></u>
</font>
</div>
<center>
<table cellpadding=6 border=10;>
<tr>
<th><font size=4>StudentNo:</font></th><td><input type="text" name="sid"></td></tr>
<tr><th><font size=4>StudentName:</font></th><td><input type="text" name="sname"></td></tr><br>
<tr><th><font size=4>Gender:</font></th><td><input type="radio" name="m1" value="m">Male
<input type="radio" name="m1" value="f">Female
<tr><th>
<tr><th><font size=4>StudentPhNo:</font></th><td><input type="text" name="sphno"></td></tr>
<tr><th><font size=4>StudentAddr:</font></th><td><textarea cols=20 rows=5 name="saddr"></textarea></td></tr>
<tr><th><font size=4>StudentDob:</font></th><td><input type="text" name="sdob"></td></tr>
<tr><th><font size=4>Email:</font></th><td><input type="text" name="semail"></td></tr>
<tr><th><font size=4>Course</font></th><td>
ALL<input type="checkbox" name="privilage" value="all" onClick="selectall()"/><br>
Java<input type="checkbox" name="privilage" value="insert" onClick="check(document.myform.privilage[1])"/><br>
C<input type="checkbox" name="privilage" value="update" onClick="check(document.myform.privilage[2])"/><br>
C++<input type="checkbox" name="privilage" value="view" onClick="check(document.myform.privilage[3])"/><br>
Oracle<input type="checkbox" name="privilage" value="del" onClick="check(document.myform.privilage[4])"/>
<tr><th><font size=4>Fees:</font></th><td><input type="text" name="fee"></td></tr>
<tr><th><font size=4>Duration:</font></th><td><input type="text" name="dur"></td></tr>
<tr><th><font size=4>Faculty:</font></th><td><input type="text" name="fac"></td></tr>
</select>
</td>
</tr>
</table>
<br>
<input type="submit" value="Submit">
<input type="Reset" value="cancel">
</center>
</form>
</body>
</html>
<html>
<body>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ include file="connect.jsp"%>
<%! String sid;
String sname;
String course;
String gender;
String sphno;
String saddr;
String sdob;
String sfee;
String dur;
String fac
String email
PreparedStatement st1;
%>
<%
sid=request.getParameter("sid");
sname=request.getParameter("sname");
gender=request.getParameter("m1");
sphno=request.getParameter("sphno");
saddr=request.getParameter("saddr");
sdob=request.getParameter("sdob");
email=request.getParameter("semail");
String[] privilage=request.getParameterValues("course");
String str="";
for(int i=0;i<privilage.length;i++)
{
str=str+privilage[i];
}
sfee=request.getParameter("sfee");
dur=request.getParameter("dur");
fac=request.getParameter("fac");
%>
<%=sid%>
<%=sname%>
<%=gender%>
<%=sphno%>
<%=saddr%>
<%=sdob%>
<%=email%>
<%=str%>
<%=sfee%>
<%=dur%>
<%=fac%>
<%
st1=con.prepareStatement("insert into student(sid,sname,gender,sphno,saddr,sdob,semail,course,sfee,dur,fac) values(?,?,?,?,?,?,?,?,?,?,?)");
st1.setString(1,sid);
st1.setString(2,sname);
st1.setString(3,gender);
st1.setString(4,sphno);
st1.setString(5,saddr);
st1.setString(6,sdob);
st1.setString(7,email);
st1.setString(8,course);
st1.setString(9,sfee);
st1.setString(10,dur);
st1.setString(11,fac);
st1.executeUpdate();
out.println("Student details are inserted");
%>
</body>
</html>
View Student Details:
<html>
<head>
<title>View Student Page</title>
</head>
<body bgcolor="#B93B8F">
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ include file="privilage.jsp"%>
<%! String sid,st1,rs1;
String sname;
String course;
String gender;
String sphno;
String saddr;
String sdob;
String sfee;
String dur;
String fac
String email
%>
<%
Statement st1=con.createStatement();
ResultSet rs1=st.executeQuery("select * from student");
%>
<center>
<u><h1>Student Details</h1></u>
<form>
<table border="1">
<th style="background-color:thistle">StudentNo</th>
<th style="background-color:thistle">StudentName</th>
<th style="background-color:thistle">Gender</th>
<th style="background-color:thistle">StudentPhNO</th>
<th style="background-color:thistle">StudentAddr</th>
<th style="background-color:thistle">StudentDOB</th>
<th style="background-color:thistle">EmailId</th>
<th style="background-color:thistle">Course</th>
<th style="background-color:thistle">Fees</th>
<th style="background-color:thistle">Duration</th>
<th style="background-color:thistle">Faculty</th>
<%
while(rs1.next())
{
sno=rs1.getString(1);
sname=rs1.getString(2);
gender=rs1.getString(3);
sphno=rs1.getString(4);
saddr=rs1.getString(5);
sdob=rs1.getString(6);
email=rs1.getString(7);
course=rs1.getstring(8);
fees=rs1.getString(9);
dur=rs1.getString(10);
fac=rs1.getString(11);
%>
<tr>
<td><i><%=sid%></a></td>
<td><i><%=sname%></td>
<td><i><%=gender%></td>
<td><i><%=sphno%></td>
<td><i><%=saddr%></td>
<td><i><%=sdob%></td>
<td><i><%=semail%></td>
<td><i><%=course%></td>
<td><i><%=fees%></td>
<td><i><%=dur%></td>
<td><i><%=fac%></td>
<%
}
%>
</table>
</form></center>
</body>
</html>
Adding Student details using jsp:
<html>
<head>
<title>Add Student Details</title>
<script>
function selectall()
{
if(document.myform.privilage[0].checked==true)
{
document.myform.privilage[1].disabled=true;
document.myform.privilage[2].disabled=true;
document.myform.privilage[3].disabled=true;
document.myform.privilage[4].disabled=true;
}
else
{
document.myform.privilage[1].disabled=false;
document.myform.privilage[2].disabled=false;
document.myform.privilage[3].disabled=false;
document.myform.privilage[4].disabled=false;
}
}
function check(ch)
{
if(ch.checked==true)
{
document.myform.privilage[0].disabled=true;
}
else
{
document.myform.privilage[0].disabled=false;
}
}
</script>
</head>
<body bgcolor="pink">
<form action="student1.jsp" name="myform">
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ include file="connect.jsp"%>
<%! String id;%>
<div align="center"><font color=black size=8>
<u><b>Enter Student Details</b></u>
</font>
</div>
<center>
<table cellpadding=6 border=10;>
<tr>
<th><font size=4>StudentNo:</font></th><td><input type="text" name="sid"></td></tr>
<tr><th><font size=4>StudentName:</font></th><td><input type="text" name="sname"></td></tr><br>
<tr><th><font size=4>Gender:</font></th><td><input type="radio" name="m1" value="m">Male
<input type="radio" name="m1" value="f">Female
<tr><th>
<tr><th><font size=4>StudentPhNo:</font></th><td><input type="text" name="sphno"></td></tr>
<tr><th><font size=4>StudentAddr:</font></th><td><textarea cols=20 rows=5 name="saddr"></textarea></td></tr>
<tr><th><font size=4>StudentDob:</font></th><td><input type="text" name="sdob"></td></tr>
<tr><th><font size=4>Email:</font></th><td><input type="text" name="semail"></td></tr>
<tr><th><font size=4>Course</font></th><td>
ALL<input type="checkbox" name="privilage" value="all" onClick="selectall()"/><br>
Java<input type="checkbox" name="privilage" value="insert" onClick="check(document.myform.privilage[1])"/><br>
C<input type="checkbox" name="privilage" value="update" onClick="check(document.myform.privilage[2])"/><br>
C++<input type="checkbox" name="privilage" value="view" onClick="check(document.myform.privilage[3])"/><br>
Oracle<input type="checkbox" name="privilage" value="del" onClick="check(document.myform.privilage[4])"/>
<tr><th><font size=4>Fees:</font></th><td><input type="text" name="fee"></td></tr>
<tr><th><font size=4>Duration:</font></th><td><input type="text" name="dur"></td></tr>
<tr><th><font size=4>Faculty:</font></th><td><input type="text" name="fac"></td></tr>
</select>
</td>
</tr>
</table>
<br>
<input type="submit" value="Submit">
<input type="Reset" value="cancel">
</center>
</form>
</body>
</html>
<html>
<body>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ include file="connect.jsp"%>
<%! String sid;
String sname;
String course;
String gender;
String sphno;
String saddr;
String sdob;
String sfee;
String dur;
String fac
String email
PreparedStatement st1;
%>
<%
sid=request.getParameter("sid");
sname=request.getParameter("sname");
gender=request.getParameter("m1");
sphno=request.getParameter("sphno");
saddr=request.getParameter("saddr");
sdob=request.getParameter("sdob");
email=request.getParameter("semail");
String[] privilage=request.getParameterValues("course");
String str="";
for(int i=0;i<privilage.length;i++)
{
str=str+privilage[i];
}
sfee=request.getParameter("sfee");
dur=request.getParameter("dur");
fac=request.getParameter("fac");
%>
<%=sid%>
<%=sname%>
<%=gender%>
<%=sphno%>
<%=saddr%>
<%=sdob%>
<%=email%>
<%=str%>
<%=sfee%>
<%=dur%>
<%=fac%>
<%
st1=con.prepareStatement("insert into student(sid,sname,gender,sphno,saddr,sdob,semail,course,sfee,dur,fac) values(?,?,?,?,?,?,?,?,?,?,?)");
st1.setString(1,sid);
st1.setString(2,sname);
st1.setString(3,gender);
st1.setString(4,sphno);
st1.setString(5,saddr);
st1.setString(6,sdob);
st1.setString(7,email);
st1.setString(8,course);
st1.setString(9,sfee);
st1.setString(10,dur);
st1.setString(11,fac);
st1.executeUpdate();
out.println("Student details are inserted");
%>
</body>
</html>
View Student Details:
<html>
<head>
<title>View Student Page</title>
</head>
<body bgcolor="#B93B8F">
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ include file="privilage.jsp"%>
<%! String sid,st1,rs1;
String sname;
String course;
String gender;
String sphno;
String saddr;
String sdob;
String sfee;
String dur;
String fac
String email
%>
<%
Statement st1=con.createStatement();
ResultSet rs1=st.executeQuery("select * from student");
%>
<center>
<u><h1>Student Details</h1></u>
<form>
<table border="1">
<th style="background-color:thistle">StudentNo</th>
<th style="background-color:thistle">StudentName</th>
<th style="background-color:thistle">Gender</th>
<th style="background-color:thistle">StudentPhNO</th>
<th style="background-color:thistle">StudentAddr</th>
<th style="background-color:thistle">StudentDOB</th>
<th style="background-color:thistle">EmailId</th>
<th style="background-color:thistle">Course</th>
<th style="background-color:thistle">Fees</th>
<th style="background-color:thistle">Duration</th>
<th style="background-color:thistle">Faculty</th>
<%
while(rs1.next())
{
sno=rs1.getString(1);
sname=rs1.getString(2);
gender=rs1.getString(3);
sphno=rs1.getString(4);
saddr=rs1.getString(5);
sdob=rs1.getString(6);
email=rs1.getString(7);
course=rs1.getstring(8);
fees=rs1.getString(9);
dur=rs1.getString(10);
fac=rs1.getString(11);
%>
<tr>
<td><i><%=sid%></a></td>
<td><i><%=sname%></td>
<td><i><%=gender%></td>
<td><i><%=sphno%></td>
<td><i><%=saddr%></td>
<td><i><%=sdob%></td>
<td><i><%=semail%></td>
<td><i><%=course%></td>
<td><i><%=fees%></td>
<td><i><%=dur%></td>
<td><i><%=fac%></td>
<%
}
%>
</table>
</form></center>
</body>
</html>
Adding Student details using jsp:
<html>
<head>
<title>Add Student Details</title>
<script>
function selectall()
{
if(document.myform.privilage[0].checked==true)
{
document.myform.privilage[1].disabled=true;
document.myform.privilage[2].disabled=true;
document.myform.privilage[3].disabled=true;
document.myform.privilage[4].disabled=true;
}
else
{
document.myform.privilage[1].disabled=false;
document.myform.privilage[2].disabled=false;
document.myform.privilage[3].disabled=false;
document.myform.privilage[4].disabled=false;
}
}
function check(ch)
{
if(ch.checked==true)
{
document.myform.privilage[0].disabled=true;
}
else
{
document.myform.privilage[0].disabled=false;
}
}
</script>
</head>
<body bgcolor="pink">
<form action="student1.jsp" name="myform">
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ include file="connect.jsp"%>
<%! String id;%>
<div align="center"><font color=black size=8>
<u><b>Enter Student Details</b></u>
</font>
</div>
<center>
<table cellpadding=6 border=10;>
<tr>
<th><font size=4>StudentNo:</font></th><td><input type="text" name="sid"></td></tr>
<tr><th><font size=4>StudentName:</font></th><td><input type="text" name="sname"></td></tr><br>
<tr><th><font size=4>Gender:</font></th><td><input type="radio" name="m1" value="m">Male
<input type="radio" name="m1" value="f">Female
<tr><th>
<tr><th><font size=4>StudentPhNo:</font></th><td><input type="text" name="sphno"></td></tr>
<tr><th><font size=4>StudentAddr:</font></th><td><textarea cols=20 rows=5 name="saddr"></textarea></td></tr>
<tr><th><font size=4>StudentDob:</font></th><td><input type="text" name="sdob"></td></tr>
<tr><th><font size=4>Email:</font></th><td><input type="text" name="semail"></td></tr>
<tr><th><font size=4>Course</font></th><td>
ALL<input type="checkbox" name="privilage" value="all" onClick="selectall()"/><br>
Java<input type="checkbox" name="privilage" value="insert" onClick="check(document.myform.privilage[1])"/><br>
C<input type="checkbox" name="privilage" value="update" onClick="check(document.myform.privilage[2])"/><br>
C++<input type="checkbox" name="privilage" value="view" onClick="check(document.myform.privilage[3])"/><br>
Oracle<input type="checkbox" name="privilage" value="del" onClick="check(document.myform.privilage[4])"/>
<tr><th><font size=4>Fees:</font></th><td><input type="text" name="fee"></td></tr>
<tr><th><font size=4>Duration:</font></th><td><input type="text" name="dur"></td></tr>
<tr><th><font size=4>Faculty:</font></th><td><input type="text" name="fac"></td></tr>
</select>
</td>
</tr>
</table>
<br>
<input type="submit" value="Submit">
<input type="Reset" value="cancel">
</center>
</form>
</body>
</html>
<html>
<body>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ include file="connect.jsp"%>
<%! String sid;
String sname;
String course;
String gender;
String sphno;
String saddr;
String sdob;
String sfee;
String dur;
String fac
String email
PreparedStatement st1;
%>
<%
sid=request.getParameter("sid");
sname=request.getParameter("sname");
gender=request.getParameter("m1");
sphno=request.getParameter("sphno");
saddr=request.getParameter("saddr");
sdob=request.getParameter("sdob");
email=request.getParameter("semail");
String[] privilage=request.getParameterValues("course");
String str="";
for(int i=0;i<privilage.length;i++)
{
str=str+privilage[i];
}
sfee=request.getParameter("sfee");
dur=request.getParameter("dur");
fac=request.getParameter("fac");
%>
<%=sid%>
<%=sname%>
<%=gender%>
<%=sphno%>
<%=saddr%>
<%=sdob%>
<%=email%>
<%=str%>
<%=sfee%>
<%=dur%>
<%=fac%>
<%
st1=con.prepareStatement("insert into student(sid,sname,gender,sphno,saddr,sdob,semail,course,sfee,dur,fac) values(?,?,?,?,?,?,?,?,?,?,?)");
st1.setString(1,sid);
st1.setString(2,sname);
st1.setString(3,gender);
st1.setString(4,sphno);
st1.setString(5,saddr);
st1.setString(6,sdob);
st1.setString(7,email);
st1.setString(8,course);
st1.setString(9,sfee);
st1.setString(10,dur);
st1.setString(11,fac);
st1.executeUpdate();
out.println("Student details are inserted");
%>
</body>
</html>
View Student Details:
<html>
<head>
<title>View Student Page</title>
</head>
<body bgcolor="#B93B8F">
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ include file="privilage.jsp"%>
<%! String sid,st1,rs1;
String sname;
String course;
String gender;
String sphno;
String saddr;
String sdob;
String sfee;
String dur;
String fac
String email
%>
<%
Statement st1=con.createStatement();
ResultSet rs1=st.executeQuery("select * from student");
%>
<center>
<u><h1>Student Details</h1></u>
<form>
<table border="1">
<th style="background-color:thistle">StudentNo</th>
<th style="background-color:thistle">StudentName</th>
<th style="background-color:thistle">Gender</th>
<th style="background-color:thistle">StudentPhNO</th>
<th style="background-color:thistle">StudentAddr</th>
<th style="background-color:thistle">StudentDOB</th>
<th style="background-color:thistle">EmailId</th>
<th style="background-color:thistle">Course</th>
<th style="background-color:thistle">Fees</th>
<th style="background-color:thistle">Duration</th>
<th style="background-color:thistle">Faculty</th>
<%
while(rs1.next())
{
sno=rs1.getString(1);
sname=rs1.getString(2);
gender=rs1.getString(3);
sphno=rs1.getString(4);
saddr=rs1.getString(5);
sdob=rs1.getString(6);
email=rs1.getString(7);
course=rs1.getstring(8);
fees=rs1.getString(9);
dur=rs1.getString(10);
fac=rs1.getString(11);
%>
<tr>
<td><i><%=sid%></a></td>
<td><i><%=sname%></td>
<td><i><%=gender%></td>
<td><i><%=sphno%></td>
<td><i><%=saddr%></td>
<td><i><%=sdob%></td>
<td><i><%=semail%></td>
<td><i><%=course%></td>
<td><i><%=fees%></td>
<td><i><%=dur%></td>
<td><i><%=fac%></td>
<%
}
%>
</table>
</form></center>
</body>
</html>