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>