A Java EE Data Persistence Layer Model Based on Design Pattern and DbUtils

Aiming at the shortcomings of low development efficiency and high code redundancy of traditional JDBC and improved JDBC in the development of data persistence layer, a new Java EE data persistence layer development model is proposed. The model uses factory design pattern to separate the creation and use of DAO, uses single instance pattern to encapsulate the database connection pool, uses dynamic proxy and reflection to create the implementation class object of DAO interface, uses annotation to mark the mapping relationship between entity class and data table, and uses DbUtils tool class to complete the interaction with database. The design idea and components of the model are described in detail. Taking the data persistence layer of the target assessment system as an application case, the implementation process of the model is described in detail. The test results show that this model can improve the development efficiency and reduce the redundancy of code, and its performance is almost the same as that of traditional JDBC.