AIM:
To develop the student webpage information using java servlet and JDBC.
ALGORITHM :
Start the program
Create main HTML page for student database maintenance Select option to do the following operation
Insertion, search ,delete and modify or update the student recode
Main.Html
<html>
<body bgcolor=yellow text=red>
<div align=center>
<label><h2>Student database maintenance</h2> </label>
<TABLE>
<TR><TD><a href="http://localhost:7001/student/viewall">VIEW ALL
</a></TD></TR>
Register.HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> registration </TITLE>
</HEAD>
<BODY bgcolor=teak text=red>
<form action="http://localhost:7001/student/register1" method=post>
<pre>
Enter Id : <input type=text name="id" size=4 ><br>
Enter Name : <input type=text name="name" size=20 ><br>
Enter Age : <input type=text name="age" size=4 ><br>
Enter Branch: <input type=text name="branch" size=10 ><br>
Enter Mark1 : <input type=text name="m1" size=4 ><br>
Enter Mark2 : <input type=text name="m2" size=4 ><br>
Enter Mark3 : <input type=text name="m3" size=4 ><br>
Enter Grade : <input type=text name="grade" size=20 ><br>
Click : <input type="submit" name="submit" value=register>
</pre></form></BODY></HTML>
Insert.Html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> registration </TITLE>
</HEAD>
<BODY bgcolor=teak text=red>
<form action="http://localhost:7001/student/insert" method=post>
<pre>
<div align=center>
Enter Id : <input type=text name="id" size=4 ><br>
Enter Name : <input type=text name="name" size=20 ><br>
Enter Age : <input type=text name="age" size=4 ><br>
Enter Branch: <input type=text name="branch" size=10 ><br>
Enter Mark1 : <input type=text name="m1" size=4 ><br>
Enter Mark2 : <input type=text name="m2" size=4 ><br>
Enter Mark3 : <input type=text name="m3" size=4 ><br>
Enter Grade : <input type=text name="grade" size=4 ><br>
<input type="submit" name="submit" value=register>
</div></pre></form></BODY></HTML>
Delete.Html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> DELETE STUDENT RECORD </TITLE></HEAD>
<BODY bgcolor=yellow text=cyan>
<form action="http://localhost:7001/student/delete2" method=post>
<pre>
Enter the ID :<input type=text name="idno" size=4 ><br>
Click :<input type="submit" name=submit value=delete>
</pre>
public class second extends HttpServlet {
public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
loginform(res,false);
}//goGet()
private void loginform(HttpServletResponse res,boolean error)throws ServletException,IOException
{
res.setContentType("text/html");
PrintWriter pr=res.getWriter();
pr.println("<html><body bgcolor=blue text=red>");
pr.println("<div align=center>");
if(error) {
pr.println("<H2>LOGIN FAILED, PLEASE TRY AGAIN!!!</H2>");
}
pr.println("<form method=post NAME=FORM>");
pr.println("<table><TR><TD><label> please enter your name and password</label></TR></TD>");
pr.println("<TR><TD>Username:<input type=text name=username> ");
pr.println("<TR><TD>Password:<input type=password name=password><br></TR></TD><hr width=100%></TR></TD>");
pr.println("<TR><TD>Press:<input type=submit name=submit value=Continue></TR></TD>");
pr.println("<TR><TD>clear:<input type=reset name =reset value=Clear></TR></TD></TABLE>");
pr.println("</form></div></body></html>");
}//loginform()
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
boolean logindb(String name, String pass) {
String sql="select * from stu where username= '" + name + "' AND password= '" + pass + "' ";
ResultSet rs=s.executeQuery(sql);
public class register1 extends HttpServlet {
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
int m2=Integer.parseInt(req.getParameter("m2"));
int m3=Integer.parseInt(req.getParameter("m3"));
String grade=req.getParameter("grade");
pr.println("<html><body bgcolor=yellow text=red><div align=center>");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:ss");
//pr.println("student information are successfully registered");
//pr.println("<a
href=http://localhost:7001/student/main.html>goto main page</a>");
PreparedStatement pst=con.prepareStatement("Insert into studata values(?,?,?,?,?,?,?,?) ");
pst.setInt(1,id);
pr.println("student information are successfully registered");
pr.println("<a
href=http://localhost:7001/student/main.html>goto main page</a>");
pr.println("</html></body>");
Insert.java
public class register extends HttpServlet {
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
pr.println("<html><body bgcolor=yellow text=red><div align=center>");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:ss");
// pr.println("Get connection");
PreparedStatement pst=con.prepareStatement("Insert into studata values(?,?,?,?,?,?,?,?) ");
pst.setInt(1,id);
con.commit();
pr.println("student information are successfully registered");
pr.println("<a
href=http://localhost:7001/student/main.html>goto main page</a>");
pr.println("</html></body>");
/* SEARCH THE PARTICULAR RECORD */
import javax.servlet.*;
public class find3 extends HttpServlet {
public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
res.setContentType("Text/html");
PrintWriter pr=res.getWriter();
pr.println("<html><body bgcolor=black text=green><div align=center>");
pr.println("<form action=http://localhost:7001/student/find3 method=post name=form1>");
pr.println("<h4>Enter the student ID:</h4><input type=text name=id
>");
pr.println("<h4>click:</h4><input type=submit name=submit value=search>");
pr.println("</form></div></body></html>");
}
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{ try {
res.setContentType("Text/html");
PrintWriter pr=res.getWriter();
String id =req.getParameter("id");
int idno=Integer.parseInt(id);
pr.println("<html><body bgcolor=black text=green><div align=center>");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:ss");
//PreparedStatement pst=con.prepareStatement("select * from studata where ID= '" + idno + "' ");
PreparedStatement pst=con.prepareStatement("select * from studata where ID= ? ");
pr.println("<a href=http://localhost:7001/student/main.html>goto main page</a>");
}
public class delete2 extends HttpServlet {
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{ try {
res.setContentType("Text/html");
PrintWriter pr=res.getWriter();
pr.println("<html><body bgcolor=black text=yellow>");
String idno=req.getParameter("idno");
int id=Integer.parseInt(idno);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:ss");
pr.println("get connected");
//PreparedStatement pst=con.prepareStatement("Delete from studata where ID= '" + id + "' ");
PreparedStatement pst=con.prepareStatement("Delete from studata where ID= ? ");
pst.setInt(1,id);
pst.executeUpdate();
pr.println("<h2>student record is successfully deleted");
pr.println("<a href=http://localhost:7001/student/main.html>goto main page</a>");
}
catch(Exception e) {
e.printStackTrace();
} }
};
Output:
Studenttable.
RESULT :
Thus student information java script program is successfully completed.