QuestionAsk Questions?
Karen
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.
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
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
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
