Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Eclipse, Java, Mysql,tomcat Im trying to use this example on mysql database : http://met.guc.edu.eg/OnlineTutorials/JSP%20-%20Servlets/Full%20Login%20Example.aspx but Im getting this error when I run it on the

Eclipse, Java, Mysql,tomcat

Im trying to use this example on mysql database : http://met.guc.edu.eg/OnlineTutorials/JSP%20-%20Servlets/Full%20Login%20Example.aspx

but Im getting this error when I run it on the server, can someone tell me what could be wrong?

Type Status Report

Message /LoginExample/

Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.

LoginExample is the name of my java application.

HERE ARE THE FILES:

LoginServlet.java

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

/**

* Servlet implementation class LoginServlet

*/

public class LoginServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, java.io.IOException {

try

{

UserBean user = new UserBean();

user.setUserName(request.getParameter("un"));

user.setPassword(request.getParameter("pw"));

user = UserDAO.login(user);

if (user.isValid())

{

HttpSession session = request.getSession(true);

session.setAttribute("currentSessionUser",user);

response.sendRedirect("userLogged.jsp"); //logged-in page

}

else

response.sendRedirect("invalidLogin.jsp"); //error page

}

catch (Throwable theException)

{

System.out.println(theException);

}

}

}

UserBean.java

public class UserBean {

private String username;

private String password;

private String firstName;

private String lastName;

public boolean valid;

public String getFirstName() {

return firstName;

}

public void setFirstName(String newFirstName) {

firstName = newFirstName;

}

public String getLastName() {

return lastName;

}

public void setLastName(String newLastName) {

lastName = newLastName;

}

public String getPassword() {

return password;

}

public void setPassword(String newPassword) {

password = newPassword;

}

public String getUsername() {

return username;

}

public void setUserName(String newUsername) {

username = newUsername;

}

public boolean isValid() {

return valid;

}

public void setValid(boolean newValid) {

valid = newValid;

}

}

UserDAO.java

import java.text.*;

import java.util.*;

import java.sql.*;

public class UserDAO

{

static Connection currentCon = null;

static ResultSet rs = null;

public static UserBean login(UserBean bean) {

//preparing some objects for connection

Statement stmt = null;

String username = bean.getUsername();

String password = bean.getPassword();

String searchQuery =

"select * from users where username='"

+ username

+ "' AND password='"

+ password

+ "'";

// "System.out.println" prints in the console; Normally used to trace the process

System.out.println("Your user name is " + username);

System.out.println("Your password is " + password);

System.out.println("Query: "+searchQuery);

try

{

//connect to DB

currentCon = ConnectionManager.getConnection();

stmt=currentCon.createStatement();

rs = stmt.executeQuery(searchQuery);

boolean more = rs.next();

// if user does not exist set the isValid variable to false

if (!more)

{

System.out.println("Sorry, you are not a registered user! Please sign up first");

bean.setValid(false);

}

//if user exists set the isValid variable to true

else if (more)

{

String firstName = rs.getString("FirstName");

String lastName = rs.getString("LastName");

System.out.println("Welcome " + firstName);

bean.setFirstName(firstName);

bean.setLastName(lastName);

bean.setValid(true);

}

}

catch (Exception ex)

{

System.out.println("Log In failed: An Exception has occurred! " + ex);

}

//some exception handling

finally

{

if (rs != null) {

try {

rs.close();

} catch (Exception e) {}

rs = null;

}

if (stmt != null) {

try {

stmt.close();

} catch (Exception e) {}

stmt = null;

}

if (currentCon != null) {

try {

currentCon.close();

} catch (Exception e) {

}

currentCon = null;

}

}

return bean;

}

}

ConnectionManager.java

import java.sql.*;

import java.util.*;

public class ConnectionManager {

static Connection con;

static String url;

public static Connection getConnection()

{

try

{

String url = "jdbc:odbc:" + "DataSource";

// assuming "DataSource" is your DataSource name

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

try

{

con = DriverManager.getConnection(url,"username","password");

// assuming your SQL Server's username is "username"

// and password is "password"

}

catch (SQLException ex)

{

ex.printStackTrace();

}

}

catch(ClassNotFoundException e)

{

System.out.println(e);

}

return con;

}

}

userLogged.java

import java.sql.*;

import java.util.*;

public class ConnectionManager {

static Connection con;

static String url;

public static Connection getConnection()

{

try

{

String url = "jdbc:odbc:" + "DataSource";

// assuming "DataSource" is your DataSource name

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

try

{

con = DriverManager.getConnection(url,"username","password");

// assuming your SQL Server's username is "username"

// and password is "password"

}

catch (SQLException ex)

{

ex.printStackTrace();

}

}

catch(ClassNotFoundException e)

{

System.out.println(e);

}

return con;

}

}

inavalidLogin.jsp

<%@ page language="java"

contentType="text/html; charset=windows-1256"

pageEncoding="windows-1256"

%>

"http://www.w3.org/TR/html4/loose.dtd">

content="text/html; charset=windows-1256">

Invalid Login

Sorry, you are not a registered user! Please sign up first

web.xml

xmlns="http://java.sun.com/xml/ns/javaee"

xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"

id="WebApp_ID" version="2.5">

LoginExample

LoginServlet

LoginServlet

LoginServlet

LoginServlet

/LoginServlet

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sams Teach Yourself Beginning Databases In 24 Hours

Authors: Ryan Stephens, Ron Plew

1st Edition

067232492X, 978-0672324925

More Books

Students also viewed these Databases questions

Question

Provide examples of KPIs in Human Capital Management.

Answered: 1 week ago

Question

What are OLAP Cubes?

Answered: 1 week ago