Getting 404 errors

Dear experts,

I have embedded a login page inside my landing page - home.jsp.

So, at the right-hand column of my page,
I use the below codes:-

<ul class="list-one">
<li><div id="fig2_8">
<h4>Login</h4>
<form action="login" method="POST">
<p style="padding-right:15px">ID: <input type="text" name="userid"/></p>
<br/>
<p>Password:<input type="password" name="password" size="15"/></p>
<br/>
</div>
<p><input type="submit" value="Submit" name="submit" />
<input type="reset" value="Reset" name="reset" /></p>
</form>
</ul>

And my servlet codes:-

import java.io.*;
import java.io.PrintWriter;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class login extends HttpServlet {

protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String userid = request.getParameter("userid");
String password = request.getParameter("password");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/xxx", "xxx", "xxx");

String query = "SELECT count( * ) FROM admin WHERE userid = ? AND password = ?";
PreparedStatement stmt = conn.prepareStatement(query);
stmt.setString(1, userid);
stmt.setString(2, password);
ResultSet resultSet = stmt.executeQuery();
resultSet.next();
int columnCount = resultSet.getInt(1);
if (columnCount == 1) {
out.println("<html>");
out.println("<head><title>Login Success</title></head>");
out.println("<body>");
out.println("<p>Login Success! Welcome " + userid);
out.println("</body></html>");
out.println("<a href=\"search.jsp\">Click here to search tutors</a>");
//response.sendRedirect("AddMember.jsp");
} else {
out.println("<html>");
out.println("<head><title>No Such User</title></head>");
out.println("<body>");
out.println("<p>Login Failed! " + userid);
out.println("<p>No such user exists, " + userid);
out.println("</body></html>");
out.println("<a href=\"index.jsp\">Click here to login</a>");
out.close();
conn.close();
}} catch (Exception e) {
System.out.println("Error" + e.getMessage());
}
// response.sendRedirect("home.html");
try {
/* TODO output your page here
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet Servlet1</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1>Servlet Servlet1 at " + request.getContextPath () + "</h1>");
out.println("</body>");
out.println("</html>");
*/
} finally {
out.close();
}}}

my database is 3 fields :-

userid
password
access

I received a 404 errors and I identified that the servlet doesn't appear in the xml mapping inside my netbean IDE.

However, even when I tried manually add in the xml, it's still not working.

I wonder is it because the login portion can't be embedded inside and I have to create a class for the login page? I'm not sure and I'm hoping you experts will advise me. I have only done something in which the login page is on its own and so may be there's something that I need to do but I don't know what is it....Kindly advise me again. Thank you so much.

View Answers

August 6, 2010 at 12:13 PM

Hi Friend,

We have modified your code, try the following:

1)jsp

<ul class="list-one">
<li><div id="fig2_8">
<h4>Login</h4>
<form action="../login" method="POST">
<p style="padding-right:15px">ID: <input type="text" name="userid"/></p>
<br/>
<p>Password:<input type="password" name="password" size="15"/></p>
<br/>
</div>
<p><input type="submit" value="Submit" name="submit" />
<input type="reset" value="Reset" name="reset" /></p>
</form>
</ul>

2)login.java

import java.io.*;
import java.io.PrintWriter;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class login extends HttpServlet {

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String userid = request.getParameter("userid");
String password = request.getParameter("password");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/test";, "root", "root");

String query = "SELECT count( * ) FROM user_details WHERE username = ? AND password = ?";
PreparedStatement stmt = conn.prepareStatement(query);
stmt.setString(1, userid);
stmt.setString(2, password);
ResultSet resultSet = stmt.executeQuery();
resultSet.next();
int columnCount = resultSet.getInt(1);
if (columnCount == 1) {
out.println("<html>");
out.println("<head><title>Login Success</title></head>");
out.println("<body>");
out.println("<p>Login Success! Welcome " + userid);
out.println("</body></html>");
out.println("<a href=\"search.jsp\">Click here to search tutors</a>");
//response.sendRedirect("AddMember.jsp");
} else {
out.println("<html>");
out.println("<head><title>No Such User</title></head>");
out.println("<body>");
out.println("<p>Login Failed! " + userid);
out.println("<p>No such user exists, " + userid);
out.println("</body></html>");
out.println("<a href=\"index.jsp\">Click here to login</a>");
out.close();
conn.close();
}} catch (Exception e) {
System.out.println("Error" + e.getMessage());
}

out.close();
}}

Thanks