Re: struts using jdbc

From:

Lew <lew@nospam.lewscanon.com>

Newsgroups:

comp.lang.java.programmer

Date:

Thu, 05 Apr 2007 09:36:11 -0400

Message-ID:

<fOGdnU6Vx5zRZonbnZ2dnUVZ_uygnZ2d@comcast.com>

ros wrote:

Hello,

I am new to Struts. Have worked on a few tutorials and have attempted
a few simple exercises. Currently I am working on an exercise where I
have to access a MySQL database from the main jsp page ( which asks
the user for name) and display the data related to the user.

I would be really thankful if somebody pointed me to some online
resource where I could study more about this stuff and attempt the
exercise. Tutorial etc.

Write a class, or package of classes, that contain the JDBC calls that create
the connection, prepare the SQL statement, execute the statement and retrieve
the results. That layer or class will translate the ResultSet or other return
values into objects that the rest of the application can use. (This is what
frameworks like Hibernate do.)

In your Action class create a data access object (DAO) of this class or one of
the package types, (Interfaces are best for the compile-time type.) Use that
instance to execute your data operations.

There are JDBC tutorials and other documentation amply available on the web.
GIYF.

--
Lew