-
Notifications
You must be signed in to change notification settings - Fork 1
kowsercse/GovForms
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
########################################## Answer 1 ########################################## It simplifies the use of JDBC and helps to avoid common errors. It executes core JDBC workflow, leaving application code to provide SQL and extract results. This class executes SQL queries or updates, initiating iteration over ResultSets and catching JDBC exceptions and translating them to the generic, more informative exception hierarchy defined in the org.springframework.dao package. Following classes use JDBCDaoTemplate. Actually they are the implementation for DAO used in the application. bd.gov.forms.dao.FormDaoImpl bd.gov.forms.dao.ListDaoImpl bd.gov.forms.dao.UserDaoImpl Its pitfalls 1. We need to write SQL queries which is considered as "Boiler Plate Code" 2. It will be hard to write database vendor independent SQL queries 3. Sometimes it is needed to build sql query, which can be erroneous So we will use JPA which is a standard for JavaEE application leaving those responsibility to underlying layer. ########################################## Answer 2 ########################################## Hibernate is an ORM. Advantages: it will generate database vendor independent SQL queries. Connection pooling & transaction management is possible to be done automatically. We can prefer using hibernate as persistance provider. Additionally JPA has support from JavaEE standard for injecting EntityManager & handle transaction automatically. From the perspective of this application it is not possible to create beans for the dynamic tables. We can consider using reflection to do that, but these are extreme cases. ########################################## Answer 3 ########################################## Uses of Hibernate can be decided on 2 cases. Data Read Data Write Generally it is not preferable to use hibernate(any ORM) for data read. It is better to use SQL statment or JDBCTemplate for this application. If Data Write is much more than Data read or about to be same I would prefer using Hibernate instead of JDBCTemplate. According to uses of this applicatoin we can think that it will have much data read compare to data write. So it should be preferable to have JDBC template. However we propose create seperating two different application. One for Form creation. Another for public uses & data entry or form download. Optionally third applicatoin can be created for analyzing data. All of them can be packages as an ear project. ########################################## Answer 4 ########################################## Following are the example uses @ModelAttribute("<something>") @Repository("formDao") @Controller @RequestMapping("<something>") @Service //these could be used @Qualifier //these could be used ########################################## Answer 5 ########################################## DAOs follow the principal Controllers follow the principal
About
No description, website, or topics provided.
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published