Ad:

JSP Discussion Thread
Marked Solved
Views: 3073

You are currently viewing page 3 of this multi-page discussion thread; Jump to the first page

Aug 4th, 2008

-1

Re: error while forwarding page

I finally had look on what you done so far. Many of the JSP pages with DB connectivity can be combine into one servlet and that will reduce size of the whole project. For example login process with retrieving user info you do (assuming we have correct username and password)

index.jsp=>as.jsp(to check username&password)=>try.jsp(to retrieve user group data and display events)=>Questionforvote/fillquestion.jsp

simplified version should be

index.jsp
loginServlet.class
- setup db connection
- check if user exist
  1. user doesn't exist
    - set error message
    - set session attributes
    - return back to index.jsp that will display error message from session
  2. user does exist
    - get events available for user
    - store events in the session
    - redirect to next page
events.jsp

Any questions?

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 873

Code tags enforcer

Offline

6,656 posts
since Dec 2004

Permalink

Aug 5th, 2008

Re: error while forwarding page

Hi peter_budo,
Thank you very much for your cooperation.
I have some doubt like in loginServlet.class
Whether I have to connect database for table user and event and retrieving the neccessary field and store in session attributes?

Quote ...

index.jsp
loginServlet.class
setup db connection
check if user exist
user doesn't exist
set error message
set session attributes
return back to index.jsp that will display error message from session
user does exist
get events available for user
store events in the session
redirect to next page

I could not understand about: set session attributes
THis is for normal user.
Now if the user is administrative then it has to add,modyfy and delete the user,group,question,event like.
So I required seprate connection for that?
Can you give me some demo of my updated code view.for above mentioned page.
just give me atlest loginservlet logic.
Thanks and Regards
Haresh

guravharsha

Reputation Points: 8

Solved Threads: 0

Light Poster

Offline

42 posts
since Jun 2008

Permalink

Aug 5th, 2008

-1

Re: error while forwarding page

How you gone distinguish between users groups that is what I asked you to answer in Database design section when I provided few suggestions. Unfortunately so far I did not get answer to that...

Check second post of this thread there is already partial implementation. After validation of submitted data, connect to database to retrieve info on user. The query will either return user details if username and passwords are correct or NULL if one of them fail. If null close DB connection and jump to redirect and go back to login screen. However if query return user details do not close connection but run another query this time on events related to userID and groupID. Exact queries are up to you.
Passing user details from servlet to JSP in session is very simple something like this

java Syntax (Toggle Plain Text)
// what is structure of User bean doesn't matter in this example
// data retrived from the database and stored in a instance of User bean "user"
HttpSession session = request.getSession();
if(BOOLEAN_DATA_SUCCESSFULLY_RETRIEVED)
{
	session.setAttribute( "user", user);
	RequestDispatcher dispatcher = getServletContext().getRequestDispatcher("/event_page.jsp");
	dispatcher.forward( request, response);
}
else
{
        String strError = "Wrong username or password!";
	session.setAttribute( "error", strError);
	RequestDispatcher dispatcher = getServletContext().getRequestDispatcher("/index.jsp");
	dispatcher.forward( request, response);
}
// what is structure of User bean doesn't matter in this example
// data retrived from the database and stored in a instance of User bean "user"
HttpSession session = request.getSession();
if(BOOLEAN_DATA_SUCCESSFULLY_RETRIEVED)
{
	session.setAttribute( "user", user);
	RequestDispatcher dispatcher = getServletContext().getRequestDispatcher("/event_page.jsp");
	dispatcher.forward( request, response);
}
else
{
        String strError = "Wrong username or password!";
	session.setAttribute( "error", strError);
	RequestDispatcher dispatcher = getServletContext().getRequestDispatcher("/index.jsp");
	dispatcher.forward( request, response);
}

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 873

Code tags enforcer

Offline

6,656 posts
since Dec 2004

Permalink

Aug 8th, 2008

Re: error while forwarding page

Hi Peter_buto,
I want to really appreciates for your help.
Now i am going to Forward with you suggested project Structure. If i require any Help ,
I will come here again and call to you for help. As i completed 70% of my project work with older fashion,it will take some time to modulate into new form.
Thanks again
Regards
Haresh

guravharsha

Reputation Points: 8

Solved Threads: 0

Light Poster

Offline

42 posts
since Jun 2008

Permalink

Aug 8th, 2008

-1

Re: error while forwarding page

That is OK.
Are you gone do anything with database structure? It is very inefficient...

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 873

Code tags enforcer

Offline

6,656 posts
since Dec 2004

Previous
1
2
Page 3

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in JSP Forum Timeline: general questions about jsp

Next Thread in JSP Forum Timeline: Open Office document in IE browser

DaniWeb Message

Cancel Changes

User Name
Password