build gui for existing oracle database tables with webdynpro java?

[JK]

hi

i want to build a GUI to maintain existing oracle tables

so far we used oracleFORMS to do so

is there a good approach for webdynpro java? or do you recommend other sap tools?

can we generate the gui with a wizard based on the fields in the table?

do we have to generate sql statements or type in manually?

regards

joerg

[Former Member]

Hi Joerg,

generally that is possible, but you'll have to implement the data access by yourself, by means of EJB or another Java persistance framework such as JDO, SQLMaps, Hibernate, whatever...

Web Dynpro allows to build a GUI based upon a model - in this case this could be some POJOs (DTOs) representing your database tables, which are communicated to the GUI by your data access layer. Consider a model as a simple Java bean representing database data.

This approach would require to build a data access layer which incorporates manually generated sql statements, so you'll have to have expert database and java knowledge.

There might be other approaches, this is just to demonstrate one working possibility.

regards,

Christian