Transcript Slide 1

Data Access Layer (Con’t)
(Overview)
Custom View Class (i.e. AccountAddressView)
Class specific to database table or SQL view. Mapped to CRUD + TXNID
(i.e READ_ACCOUNT_ADDRESS)
DBViewBean Class
Class exposes JDBC-like methods to query and manipulate data
Data Access Layer
1.
Provides common methods to perform READ, DELETE, UPDATE,
INSERT, NEXTVAL JDBC calls. Performs single and batch
processing. Governs rollbacks and auto-commits.
2.
Provides DB connection pooling
3.
Provides SQL query mapping from SQL XML maps via CRUD +
TXNID (i.e. READ_ACCOUNT_ADDRESS)
Data Base