Struts sql query grouping

[sudhir pavan]

Hi

I am creating a web application in struts2, in which i used many sql queries in different java files.

but i like to group all sql queries of my project in single java file and like to call that java class for the desired query execution.

can you help out from here...............

[Joe Ess]

Struts is an implementation of the Front Controller Pattern. It has little or nothing to do with how you interact with a database. See the FAQ entry Accessing a Database for the recommended course of action.

[Lalit Mehra]

In case if you are using JDBC you can get the required output by creating a common DAO class for your queries ...

I would suggest you to use hibernate instead