
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>
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.