Error

1. login.java

/*
* login.java
*
* Created on September 14, 2010, 11:47 AM
*/

import java.io.*;
import java.net.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.servlet.*;
import javax.servlet.http.*;

/**
*
* @author Nicodemus
* @version
*/
public class login extends HttpServlet {

/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String a=new String("");
String b=new String("");
String query="select UserName,Passwords from users";

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:nico;integrated security=true");
Statement stmt=con.createStatement();
stmt.executeQuery(query);
ResultSet rs=null;
rs=stmt.getResultSet();
while(rs.next())
{
a=rs.getString(1);
b=rs.getString(2);
}
rs.close();
stmt.close();
}
catch(Exception e)
{
out.println("Exception is..."+e);
}
if(a.equals(request.getParameter("user")) && b.equals(request.getParameter("password")))

{
out.println("User is Valid..<a href='Admin.jsp'>Admin Page</a>");
}
else{
out.println("Please enter correct username and password....<a href='index.jsp'>Try Again</a>");
}

/* TODO output your page here
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet login</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1>Servlet login at " + request.getContextPath () + "</h1>");
out.println("</body>");
out.println("</html>");
*/
out.close();
}

// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/** Handles the HTTP <code>GET</code> 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 <code>POST</code> 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";
}
// </editor-fold>
}

2.index.jsp

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
--%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
<script>
function checkNull(field)
{
if(login.user.value == "")
{
alert("Enter the Login Name");
login.user.focus();
return false;
}
else if(login.pass.value == "" )
{
alert("Enter the Password");
login.pass.focus();
return false;
}
else
{
return true;
}
}

function focus()
{
login.user.focus();
}
</script>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Login Page</title>
</head>
<body>

<body>

<form action ="login" method="post" name="login">

<p> </p>

<a title="Press To Go Back" href="login.jsp" style="text-decoration: none">
<font color="#FFFFFF" face="Bauhaus 93" size="4"><-- BACK</font></a></p>
<div align="center">
<center>
<div align="center">
<center>
<table border="1" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#0099cc" width="51%" id="AutoNumber1" bgcolor="#0099CC" height="134">
<tr>
<td width="100%" colspan="3" height="19">
<p align="center">
<b><font face="Verdana" color="#00FF00">ADMIN LOGIN
</font></b></p>

</td>
</tr>
<tr>
<td width="30%" height="23"><font face="Verdana" size="2" color="#800080">
USER NAME</font></td>
<td width="72%" colspan="2" height="23"><font color="#800080"><input type="text" name="user" size="20" onload = 'T1.focus();'></font></td>
</tr>
<script>
focus();
</script>

<tr>
<td width="30%" height="23"><font face="Verdana" size="2" color="#800080">
PASSWORD</font></td>
<td width="72%" colspan="2" height="23"><font color="#800080"><input type="password" name="pass" size="20">
</font> </td>
</tr>

<tr>
<td width="30%" height="23"> </td>
<td width="72%" colspan="2" height="23"> </td>
</tr>
<tr>
<td width="30%" height="26"> </td>
<td width="18%" height="26">
<p align="left"><font color="#800080"><input type="submit" value="Login" name="B1" onclick = 'return checkNull();'></font></td>
<td width="54%" height="26"><font color="#800080"><input type="reset" value="Cancel" name="B2"></font></td>
</tr>
</table>

</center>
</div>
<p align="left"><font color="#008080"> </font></p>

<p align="left"><font color="#008080">
</font></p>

<p align="left"><font color="#008080">
</font></p>

</center>
</div>
</form>
</body>

<%--
This example uses JSTL, uncomment the taglib directive above.
To test, display the page like this: index.jsp?sayHello=true&name=Murphy
--%>
<%--
<c:if test="${param.sayHello}">

Hello ${param.name}!
</c:if>
--%>

</body>
</html>

3. create table users
(
UserNAme varchar(30) not null, Passwords varchar(30) not null primary key(UserName,Passwords)
)

I tried this code but its not helping me. What I want is to login but it always shows <Please enter correct username and password>. Please help I'm a student. Thanks

View Answers