WDJ application integrating with SQL

[Former Member]

I need to create a form with 10 check boxes. The user can select multiple check boxes, on clicking the submit button the check box entries should update a table in the SQL database.

How can i achieve the same through a WDJ application.

kindly provide useful documents and sample tutorial for the same.

[former_member218672]

Hi Saket,

Check this link - http://help.sap.com/saphelp_nw04s/helpdata/en/82/fdbf2085f65f43a71e755fc904478d/frameset.htm

Cheers,

Sen

[junwu]

create data source in your nw server

write your jdbc code as usual

there is no specific thing you have to do for wdj

[amolgupta]

you may consider using JPA - Java Persistence Architechture.

JPA is nothing but a layer built over JDBC, Java's answer to separate frameworks like Hibernate/Spring. Also, depends on version.... older versions support JDO.

Anyway, if you are confortable with JDBC, use JDBC. nothing wrong with that.