It's not a secret anymore!
The moose likes Servlets and the fly likes DB Utility Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "DB Utility" Watch "DB Utility" New topic

DB Utility

Himanshu Jhamb
Ranch Hand

Joined: Aug 01, 2001
Posts: 134
This is my first time here & I have a basic question.
My requirement is to make a simple DB lookup utility which queries the DB & posts the information on the user's browser. Being new to the Java scenario, I am a bit overwhelmed by all the options that are available.
I have access to the weblogic server & would like to make use of it (even though, I may have simpler avenues) since this might turn out to be a good learning experience in weblogic, as well.
I have thought of approaching the problem as follows...
1) Have a login page(html) which validates the users by POSTing the login info to a servlet, the servlet validates it against the DB & returns. If validation fails, the user gets prompted to enter info again. If successful, the user is directed to another page (invoking another html page?) which contains fields for the actual query.
From what I know, I feel I have two options from here on...
1) Give the user his/her own Session handler (using Session EJBs). The EJB contains the DB Query code & returns result to a JSP... OR
2) Just use beans (not EJBs) coupled with JSPs, where the beans contain the actual query handling code & JSPs deal with reporting back the result of the query to the client.
Using the first option appears more lucrative right now since it touches the area of EJBs as well.. and might be more flexible for future enhancements... when, lets say, we have a lot of users querying from their web clients...
Any recommendations/advice is welcome...
thx in advance.
- Himanshu

Himanshu Jhamb<br />SCJP2 v1.2 (April 2002)<br />SCJP2 v1.4 (May 2002)
I agree. Here's the link:
subject: DB Utility
It's not a secret anymore!