import javax.servlet.http.*;
import java.sql.*;
import javax.servlet.*;
import java.io.*;
public class UserLogin 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 StudentRegForm where name=? and pass=?");
}
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 name=request.getParameter("name");
String pass=request.getParameter("pass");
if(name==null||name.equals("")||pass==null||pass.equals(""))
{
out.println("<html><body>");
out.println("<li><i>user name and pass word cnt be empty</i></li><br/>");
out.println("</body></html>");
}
ps.setString(1,name);
ps.setString(2,pass);
}
catch(Exception e)
{
out.println("<h2>un ble</h2>");
}
}
public void destroy()
{
try{
con.close();
}
catch(Exception e)
{
}
}
}
Next Link Program
