Jsp_login
aysha
I want to help me in login_Action.jsp. I mean I want the user enter
the username, userId and password and
after that, the page will send the user to seller page or buyer page
depend on these attributes (username, userid and pass) only.
This is my servlet code:-
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import javax.servlet.RequestDispatcher;
/**
*
* @author 200610776
*/
public class checkLogin extends HttpServlet {
/**
* Processes requests for both HTTP <code>GET</code> and
<code>POST</code> methods.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
//Get User Inputs
String UserID = request.getParameter("UserID");
String UserName = request.getParameter("UserName");
String Password = request.getParameter("Password");
//Connect to Database
Connection con = null;
Statement stmt = null;
ResultSet rst = null;
String databaseURL = "jdbc:mysql://localhost:3306/aysha";
String driverName = "com.mysql.jdbc.Driver";
String username = "root";
String password = "root";
try {
Class.forName(driverName).newInstance();
con = DriverManager.getConnection(databaseURL, username,
password);
stmt = (Statement) con.createStatement();
} catch (Exception e) {
System.out.println("ERROR Connecting to DB: " + e);
return;
}
//Check data
String selectStmt = "select count(*) C from user where
UserID='" + UserID + "' and Password='" + Password + "' and
UserName='" + UserName + "'";
try {
rst = stmt.executeQuery(selectStmt);
if (rst.next()) {
//int i = Integer.parseInt(rst.getString("C"));
String v = rst.getObject("v").toString();
if (v.equals("buyer")) {
RequestDispatcher dispatcher =
getServletContext().getRequestDispatcher("/buyer.jsp");
dispatcher.forward(request, response);
return;
} else if (v.equals("seller")) {
RequestDispatcher dispatcher =
getServletContext().getRequestDispatcher("/seller.jsp");
dispatcher.forward(request, response);
return;
} else {
RequestDispatcher dispatcher =
getServletContext().getRequestDispatcher("/error.jsp");
dispatcher.forward(request, response);
return;
}
}
} catch (Exception e) {
System.out.println("ERROR: Wrong User or Password: " + e);
return;
}
//Close database
try {
rst.close();
stmt.close();
con.close();
} catch (SQLException e) {
System.out.println("Workshop Register: ERROR: closing DB
connection: " + e);
}
}
.......
}
------------------------------------------------------------------------------------------------
and This is the jsp code:-
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>Login</title>
</head>
<body>
<h1>Login</h1>
<form name="userDetails" method="POST" action="checkLogin">
User ID <input type="text" name="UserID">
Username <input type="text" name="UserName">
Password <input type="password" name="Password">
<input type="submit" value="Submit">
</form>
<TABLE>
<form name="userDetails" method="POST" action="Homepage.jsp">
<br>
<input type="submit" value="Back to Homepage">
</form>
</TABLE>
</body>
</html>
Thank you..
Aysha.