7.3. Database Access¶
Provides the function to connect to database and execute SQL.
Nablarch provides the following two types of database access functions:
Although SQL can be executed by using either of the above functions, use of universal DAO is recommended for the following reasons.
- SQL statement of CRUD can be automatically generated from Entity, and the SQL can be executed.
- Since the search results can be obtained as a Bean object, complementary functions of IDE can be effectively used and development efficiency is good.
Important
Even if universal DAO is used, JDBC wrapper function is used to connect to the database and execute SQL. Therefore, configuration for using JDBC wrapper function are required.
Tip
For comparison of functions between Universal DAO and JSR317 (JPA2.0), refer to Functional Comparison Between Universal DAO and JSR317 (JPA2.0) .