wap to validate the user id and password

/*

* ser_reqs.java

*

* Created on March 18, 2009, 9:47 AM

*/

package com;

import java.io.*;

import java.net.*;

import java.sql.*;

import javax.servlet.*;

import javax.servlet.http.*;

/**

*

* @author Administrator

* @version

*/

public class ser_reqs extends HttpServlet {

/** Initializes the servlet.

*/

String userid;

String password;

Connection dbconnection;

ResultSet resultset;

public void init() throws ServletException {

ServletConfig config = getServletConfig();

String driverClassName = config.getInitParameter("driverclassname");

String dbURL = config.getInitParameter("dburl");

String username = config.getInitParameter("username");

String dbpassword = config.getInitParameter("dbpassword");

try

{

Class.forName(driverClassName);

}

catch(ClassNotFoundException cnfe)

{

System.err.println("Error loading driver: " + cnfe);

}

try

{

dbconnection = DriverManager.getConnection(dbURL, username, dbpassword);

}

catch(SQLException sqle)

{

System.err.println("Connection error: " + sqle);

}

}

/** Destroys the servlet.

*/

public void destroy() {

}

/** Processes requests for both HTTP GET and POST methods.

* @param request servlet request

* @param response servlet response

*/

protected void processRequest(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

response.setContentType("text/html");

PrintWriter out = response.getWriter();

// String s1=request.getParameter("t1");

// String ps=request.getParameter("p1");

try

{

Statement statement = dbconnection.createStatement();

String sqlString = "SELECT * FROM st_record WHERE name='"+request.getParameter("t1")+"'AND password='"+request.getParameter("p1")+"'";

resultset=statement.executeQuery(sqlString);

while(resultset.next())

{

userid = resultset.getString("name");

password = resultset.getString("password");

}

}

catch(SQLException sqle)

{

System.err.println("Connection error: " + sqle);

}

if(password.equals(request.getParameter("p1")) && userid.equals(request.getParameter("t1")))

{

response.sendRedirect("/ser_req/corret.html");

}

else

{

response.sendRedirect("/ser_req/incorret.html");

}

//TODO output your page here

out.println("");

out.println("");

out.println("");

out.println("");

out.println("");

// out.println(s1);

// out.println(ps);

out.println("");

out.println("");

out.close();

}

/** Handles the HTTP GET method.

* @param request servlet request

* @param response servlet response

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

processRequest(request, response);

}

/** Handles the HTTP POST method.

* @param request servlet request

* @param response servlet response

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

processRequest(request, response);

}

/** Returns a short description of the servlet.

*/

public String getServletInfo() {

return "Short description";

}

Rest of program do urself....