import javax.servlet.http.*;
import java.sql.*;
import javax.servlet.*;
import java.io.*;
public class AddBook 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 bookname=request.getParameter("bookname");
String auther=request.getParameter("auther");
String bookno=request.getParameter("bookno");
String desc=request.getParameter("desc");
ps.setString(1,bookname);
ps.setString(2,auther);
ps.setString(3,bookno);
ps.setString(4,desc);
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
