Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

connecting to a database directly through your jsp page

  • 27-01-2006 10:54PM
    #1
    [Deleted User]
    Posts: 24,286 ✭✭✭✭


    hi.

    Is it better to connect directly to a database via a jsp page or would it be better to implement servlets and java classes in-between. at the moment i am trying to create a registration form in jsp for a site i am working on. I have created
    1. a 'User' class file to accomodate the user been registered
    2. a data source file to connect to the database
    3. a java interface which has an insert new user method in it
    4. a record new user file which has the 'insert' statement in it

    basically i am wondering would it be better to link it to a registration page via a servlet or just skip all that and connect directly fro the 'registration.jsp' page


Comments

  • #2
    bpmurray
    Registered Users, Registered Users 2 Posts: 1,275 ✭✭✭bpmurray


    Is this a single-page app? Is it going to be enhanced in the future? If so, using beans to get at your data is probably a good way to go.

    On the other hand, if it's simple and an independent page, you could use the JSTL sql tags, or even put some JDBC code directly into your page.

    Remember that a JSP *is* a servlet, although it's HTML with Java mixed in, while a traditional servlet is Java which spits out markup, so doing this in a servlet isn't really doing anything different.

    Have you considered using the various frameworks: JSF provides a pretty good way to link backend data with the UI.


  • #3
    [Deleted User]
    Posts: 24,286 ✭✭✭✭ [Deleted User]


    bpmurray wrote:
    Is this a single-page app? Is it going to be enhanced in the future? If so, using beans to get at your data is probably a good way to go.

    On the other hand, if it's simple and an independent page, you could use the JSTL sql tags, or even put some JDBC code directly into your page.

    Remember that a JSP *is* a servlet, although it's HTML with Java mixed in, while a traditional servlet is Java which spits out markup, so doing this in a servlet isn't really doing anything different.

    Have you considered using the various frameworks: JSF provides a pretty good way to link backend data with the UI.

    hi sorry for the tardy reply. i just connected from a servlet in my source package in the end. Was aiming to use a DAO pattern. its a relatively small application so i just couldnt be ars*d creating class after class.

    doing a project where i have to create a fantasy football website. its for my 3rd year in college.

    wish me luck, im gonna need it


Advertisement