Win a copy of Penetration Testing Basics this week in the Security forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB Utility

Himanshu Jhamb
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic