import javax.servlet.http.*;
import java.sql.*;
import javax.servlet.*;
import java.io.*;
public class StudentRegForm extends HttpServlet
{
private Connection con;
private PreparedStatement ps=null;
public void init()throws ServletException
{
try
{ //we get the information from the web.xml file
ServletContext ctxt=getServletContext();
String driverclassname=ctxt.getInitParameter("driverclassname");
String url=ctxt.getInitParameter("url");
String dbuser=ctxt.getInitParameter("dbuser");
String dbpass=ctxt.getInitParameter("dbpass");
String sqlstmt=ctxt.getInitParameter("sqlstatement");
con=DriverManager.getConnection(url,dbuser,dbpass);
ps=con.prepareStatement(sqlstmt);
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void service(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();
try{
String sname=request.getParameter("sname");
String sid=request.getParameter("sid");
String pwd=request.getParameter("pwd");
String course=request.getParameter("course");
String email=request.getParameter("email");
String phone=request.getParameter("phone");
String addr=request.getParameter("addr");
ps.setString(1,sname);
ps.setString(2,sid);
ps.setString(3,pwd);
ps.setString(4,course);
ps.setString(5,email);
ps.setString(6,phone);
ps.setString(7,addr);
int count=ps.executeUpdate();
if(count==1)
{
out.println("successfully added a book");
}
else
{
out.println("<html><body><h1> sorry try again</h1></body></html>");
}
}
catch(Exception e)
{
}
}
public void destroy()
{
try{
con.close();
}
catch(Exception e)
{
}
}
}
Next Link Program
