import javax.servlet.http.*;
import java.sql.*;
import javax.servlet.*;
import java.io.*;
public class Fee extends HttpServlet
{
private Connection con;
private PreparedStatement ps=null;
public void init()throws ServletException
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","sysrem","system");
ps=con.prepareStatement("select *from AddBook where bookname=?");
}
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 fee=request.getParameter("fee");
if(fee==null||fee.equals(""))
{
out.println("<html><body>");
out.println("<li><i>enter the course</i></li><br/>");
out.println("</body></html>");
}
ps.setString(1,fee);
ResultSet rs=ps.executeQuery();
while(rs.next())
{
out.println("<html><body>");
out.println("<table border=1>");
out.println("<tr><td>rs.getString(1)<td>");
out.println("<td>rs.getString(2)</td>");
out.println("<td>rs.getString(3)</td>");
out.println("<td>rs.getString(4)</td>");
out.println("<tr><td>rs.getString(5)<td>");
out.println("<td>rs.getString(6)</td>");
out.println("<td>rs.getString(7)</td>");
out.println("<td>rs.getString(8)</td>");
out.println("</tr></table>");
out.println("</body></html>");
}
}
catch(Exception e)
{
}
}
public void destroy()
{
try{
con.close();
}
catch(Exception e)
{
}
}
}
Next Link Programe
