DaniWeb Forum Index > Web Development > JSP

Login page. JSP/Servlet

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jan 2006

Posts: 18

Reputation: nisrin is an unknown quantity at this point

Solved Threads: 0

nisrin

Offline

Newbie Poster

Login page. JSP/Servlet

Apr 20th, 2007

im creating a website that deals with the monthly reminders (extracted from Oracle) for my members for a school project. Should I create a login page using JSP or servlets? I am unfamiliar in both the languages.
Will I need to establish my connection for each page if I use JSP instead of servlets?

Im confused, please advice.

•

Join Date: Jul 2004

Posts: 28

Reputation: saurav is an unknown quantity at this point

Solved Threads: 2

saurav

Offline

Light Poster

Re: Login page. JSP/Servlet

Apr 20th, 2007

Hi...you can JSP and Servlets or simple Java Classes as normal easy way.
But i would sugeest you to have it done by using Struts......thats the best way out.
You need require to establish connection each time in any of the above cases.
Just have one Java class which will do that for you and let the other classes call the method of that class.

cheers

•

Join Date: Jan 2006

Posts: 18

Reputation: nisrin is an unknown quantity at this point

Solved Threads: 0

nisrin

Offline

Newbie Poster

Re: Login page. JSP/Servlet

Apr 20th, 2007

Hello. Thanks for the reply. Programing in Java would have been easier for me. But, Im required to script in either JSP or Servlets.
I suppose I should script in JSP then..How should I retain and extract member details after login, by using sessions??

•

Join Date: Jul 2004

Posts: 28

Reputation: saurav is an unknown quantity at this point

Solved Threads: 2

saurav

Offline

Light Poster

Re: Login page. JSP/Servlet

Apr 20th, 2007

jsp s r actually servlets........they r compiled into servlets........member details u can keep in a db and then do the validation in your java/servlet .....

•

Join Date: Jan 2006

Posts: 18

Reputation: nisrin is an unknown quantity at this point

Solved Threads: 0

nisrin

Offline

Newbie Poster

Re: Login page. JSP/Servlet

Apr 20th, 2007

I understand jsp codes get compiled into servlets at the backend. But, for the purpose of my project, I would either script in JSP or manually create Servlets..

Member details will be housed in my db. This is what Im not sure about: The login page takes the user's info and see if it exists in the db. After that the next few pages should use the same user info and track down his set reminders. For that information to be retained in the front-end for JSP usage, should I use sessions??

Thank you very much.

•

Join Date: Jul 2004

Posts: 28

Reputation: saurav is an unknown quantity at this point

Solved Threads: 2

saurav

Offline

Light Poster

Re: Login page. JSP/Servlet

Apr 20th, 2007

yes you are right......u have to use sessions.......
retrieve the details wherever u like

•

Join Date: Jan 2006

Posts: 18

Reputation: nisrin is an unknown quantity at this point

Solved Threads: 0

nisrin

Offline

Newbie Poster

Re: Login page. JSP/Servlet

Apr 20th, 2007

Thank you. Now that the theory is clear, hope I can code well.

•

Join Date: Jul 2004

Posts: 28

Reputation: saurav is an unknown quantity at this point

Solved Threads: 2

saurav

Offline

Light Poster

Re: Login page. JSP/Servlet

Apr 20th, 2007

best of the luck..cheers

•

Join Date: Dec 2007

Posts: 8

Reputation: kemarS is an unknown quantity at this point

Solved Threads: 0

kemarS

Offline

Newbie Poster

Re: Login page. JSP/Servlet

Dec 27th, 2007

Hi. I don't mean to be a sponger, but I think his project is similar to mine. I am creating a Movie Theatre site for my Web Apps project. I have almost everything done, but I cant figure out how to create a login page. I was told to try a SELECT query and compare them with the data entered, but that isn't working. Here's the code:

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
 
 
<!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>JSP Page</title>
    </head>
    <body>
        <%
String url = "jdbc:odbc:userDSN";
String username="";
String password="";
Connection conn=null;
String classPath = "sun.jdbc.odbc.JdbcOdbcDriver";
String usernm = username;
String passwrd = password;
 
try{
    Class.forName(classPath);
    conn = DriverManager.getConnection(url,username,password);
    }catch(Exception exc){
        out.println(exc.toString());
    }
%>
<%
    Statement stm=null;
    ResultSet rst=null;
 
    stm= conn.createStatement();
    String query= "SELECT userID, password FROM user WHERE userID =" +usernm;
 
    rst = stm.executeQuery(query);
%>
 
<%= rst.getString("userID") %>
<%= rst.getString("password") %>
 
 
 
<% 
if (usernm.equals(userID) && passwrd.equals(password)) { %>
 
<jsp:forward page = "index.jsp"></jsp:forward>
 
<% } else { %>
 
<jsp:forward page = "login_handle.jsp"></jsp:forward>
 
 
<% }
            rst.close();
            stm.close();
            conn.close();
%> 
    </body>
</html>
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>


<!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>JSP Page</title>
    </head>
    <body>
        <%
String url = "jdbc:odbc:userDSN";
String username="";
String password="";
Connection conn=null;
String classPath = "sun.jdbc.odbc.JdbcOdbcDriver";
String usernm = username;
String passwrd = password;
    
try{
    Class.forName(classPath);
    conn = DriverManager.getConnection(url,username,password);
    }catch(Exception exc){
        out.println(exc.toString());
    }
%>
<%
    Statement stm=null;
    ResultSet rst=null;
    
    stm= conn.createStatement();
    String query= "SELECT userID, password FROM user WHERE userID =" +usernm;
    
    rst = stm.executeQuery(query);
%>

<%= rst.getString("userID") %>
<%= rst.getString("password") %>



<% 
if (usernm.equals(userID) && passwrd.equals(password)) { %>

<jsp:forward page = "index.jsp"></jsp:forward>

<% } else { %>

<jsp:forward page = "login_handle.jsp"></jsp:forward>


<% }
            rst.close();
            stm.close();
            conn.close();
%> 
    </body>
</html>

When i run it, Tomcat says :

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
org.apache.jasper.JasperException: Unable to compile class for JSP
 
An error occurred at line: 46 in the jsp file: /login_handle.jsp
Generated servlet error:
C:\Documents and Settings\Kemar\.netbeans\5.5.1\apache-tomcat-5.5.17_base\work\Catalina\localhost\Web_Project\org\apache\jsp\login_005fhandle_jsp.java:94: cannot find symbol
symbol  : variable userID
location: class org.apache.jsp.login_005fhandle_jsp
if (usernm.equals(userID) && passwrd.equals(password)) { 
                  ^
org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 46 in the jsp file: /login_handle.jsp
Generated servlet error:
C:\Documents and Settings\Kemar\.netbeans\5.5.1\apache-tomcat-5.5.17_base\work\Catalina\localhost\Web_Project\org\apache\jsp\login_005fhandle_jsp.java:94: cannot find symbol
symbol  : variable userID
location: class org.apache.jsp.login_005fhandle_jsp
if (usernm.equals(userID) && passwrd.equals(password)) { 
                  ^