Hi,
I have to implement a business application with the following
constraints:
- I wanna use Jsp to publish on the web the data stored in a MySql DB
.
- I don't wanna use EJB (I'm studying this technology, but I'm not
ready to implement a project based on it)
- How can I separate the logic layer (tipically access to the db)
from the presentation layer? Could the solution be the "Java Beans"?
Do U suggest to write one bean including all the database query, one
bean for the update, ecc OR a bean for each relation table? Or Maybe a
mixed solution?
Thanx in advance,
Remo
Roedy Green - 12 Jul 2004 23:36 GMT
>- How can I separate the logic layer (tipically access to the db)
>from the presentation layer?
you might consider a report generator. See
http://mindprod.com/jgloss/reportgenerator.html
Another approach would be to use a servlet that talk to JDBC, and it
hands over a bean/object to JSP to use to display.

Signature
Canadian Mind Products, Roedy Green.
Coaching, problem solving, economical contract programming.
See http://mindprod.com/jgloss/jgloss.html for The Java Glossary.
Alexandr Molochnikov - 13 Jul 2004 00:57 GMT
You can try Scribe.
www.gestalt.com/Scribe
User: guest
Password: star
Have a look at the video clips and the Web demo.
Alex Molochnikov
Gestalt Corporation
> Hi,
>
[quoted text clipped - 15 lines]
>
> Remo
hilz - 13 Jul 2004 06:43 GMT
> Do U suggest to write one bean including all the database query, one
> bean for the update, ecc OR a bean for each relation table? Or Maybe a
> mixed solution?
You might want to take a look at www.hibernate.org for object/relational
persistence.
I have not used it yet, but after reading so much about it, i became very
interested in learning this technology.
I think it is a neat solution for the very complex problem of mapping
objects to relational databases.
good luck.
hilz
hilz - 13 Jul 2004 06:49 GMT
> You might want to take a look at www.hibernate.org for object/relational
> persistence.
I forgot to add that it is free and opensource.
Damodar Periwal - 13 Jul 2004 20:18 GMT
JDX OR-Mapper from Software Tree can simplify your solution. You can
define and use your domain object model for business logic and
presentation avoiding the need to create data transfer objects (DTO).
JDX takes care of all the persistence related operations without you
having to write any JDBC/SQL code. JDX is flexible, non-intrusive,
and lightweight. JDX comes with comprehensive documentation and many
working examples including a JSP one.
JDX highlights:
http://www.softwaretree.com/products/jdx/JDXHighlights.htm
Free eval download is available from http://www.softwaretree.com
-- Damodar
============================
Software Tree, Inc.
Simplify Data Integration
http://www.softwaretree.com
> Hi,
>
[quoted text clipped - 15 lines]
>
> Remo
Fredrik Bertilsson - 30 Jul 2004 11:42 GMT
Try,
http://butler.sourceforge.net
/Fredtrik