Implementation of DAO and DTO in webdynpro

[Former Member]

Hi,

I need to implement DAO and DTO in webdynpro.... I am fetching details from SQL table.

Please help me with step-by-step process of using DAO and DTO in webdynpro.

Thanks and Regards,

Sayan Ghosh

[Former Member]

Hi Sayan,

check out the NWDI tutorial, even if you don't have NWDI, it explains the best practice:

[Component-based Development from Database Table to Web Dynpro using NWDI|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/c0b53558-6df6-2910-cfbf-a63316bb0fad]

kind regards

Stefanie

[siddharth_jain]

Hi,

i would not suggest directly Using DAO Design pattern in Webdynpro because it is not a Good Practice.

You Should Follow the J2EE Layered Architecture for this.

First you Should Define Your Business Logic Layer Which can be Stateless ,or Entity beans.This Layer will Act As Facade.

This Business Logic Layer Will Access Business Object layer this Layer will Comprise Java Classes with the Logic to Access DAO Layer and the Result will be in the Form of Transfer Object Returned to WD Application.

All the DTO should be Serializable this is a Standard Practice in case if your Business Logic is Deployed on other server.

Ejbs Should have Remote and Local Interfaces Declared.

And you should not use any datatype in the DTO which is not serializable.

DTO Layer Classes will be bundled as jar with WD Application.

Hope This Help

Regards,

Siddharth