1<\/div>\n<\/td>\n
\n\n List<Student> findByFirstNameAndLastNameOrderByFirstnameAsc(String firstName,String lastName);<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\nIn such cases we can use @query annotation provided by Spring Data. <\/p>\n \n \n \n\n\n\n1<\/div>\n 2<\/div>\n<\/td>\n \n\n @Query(<\/code>\"SELECT s FROM Student s WHERE s.firstName =?1 or s.lastName =?2 order by firstName asc)\"<\/code>)<\/code><\/div>\nList<Student> findByName(String firstName,String lastName);<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\nUsing position based parameter (?paramPosition) could be difficult to understand and refactor. This can be avoided by using named-parameters in query. We can use \u201c:paramName<\/em>\u201d and \u201c@Param<\/em>\u201d annotation for parameter binding. <\/div> <\/div><\/p>\n \n \n \n\n\n\n1<\/div>\n 2<\/div>\n<\/td>\n \n\n @Query(<\/code>\"SELECT s FROM Student s WHERE s.firstName = :firstName or s.lastName = :lastName order by firstName asc)\"<\/code>)<\/code><\/div>\nList<Student> findByName(@Param(<\/code>\"firstName\"<\/code>)String firstName, @Param(<\/code>\"lastName\"<\/code>)String lastName);<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n3) Configuration for spring data JPA<\/h3>\nSpring Data JPA can be used in basic spring or spring-boot project. Also the configuration can be done using xml or java classes. For configuration using java class, we need to use @Configuration annotation.<\/p>\n 3.1 Spring data JPA configuration in spring boot:<\/h2>\nSpring boot is another very famous framework, which make application creation and management very fast and easy. It has auto configuration feature which provides all required dependencies and configuration. We just need to add correct dependencies.<\/p>\n It also auto configures Spring data and hibernate as default JPA. Also it provides all necessary configuration required for spring data according to database used. We just need to add correct database connector dependency and provide data source.<\/p>\n We don\u2019t need to do other configuration unless, we need to customize it.<\/p>\n Spring boot configuration using application.properties<\/h2>\n\n \n \n\n\n\n1<\/div>\n 2<\/div>\n 3<\/div>\n<\/td>\n \n\n spring.datasource.url=jdbc:mysql:<\/code>\/\/localhost:3306\/database_name<\/code><\/div>\nspring.datasource.username=root <\/code><\/div>\nspring.datasource.password=root<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n3.2 Spring data JPA configuration in non-spring boot:<\/h2>\nTo use spring data we need to configure following objects:<\/p>\n \n- DataSource<\/strong>: Database configuration- URL, username, password, driver, etc<\/li>\n
- EntityManager<\/strong>: Most important object which binds all objects, like entity package, datasource, etc\n
\n- we can configure entityManager using LocalEntityManagerFactoryBean<\/li>\n
- we can also configure additional properties using setJpaProperties(properties)<\/li>\n<\/ol>\n<\/li>\n
- TransactionManager<\/strong>: Configuration for database transaction<\/li>\n<\/ol>\n
Configuration using java code:<\/h2>\n\n \n \n\n\n\n01<\/div>\n 02<\/div>\n 03<\/div>\n 04<\/div>\n 05<\/div>\n 06<\/div>\n 07<\/div>\n 08<\/div>\n 09<\/div>\n 10<\/div>\n 11<\/div>\n 12<\/div>\n 13<\/div>\n 14<\/div>\n 15<\/div>\n 16<\/div>\n 17<\/div>\n 18<\/div>\n 19<\/div>\n 20<\/div>\n 21<\/div>\n 22<\/div>\n 23<\/div>\n 24<\/div>\n 25<\/div>\n 26<\/div>\n 27<\/div>\n 28<\/div>\n 29<\/div>\n 30<\/div>\n 31<\/div>\n 32<\/div>\n<\/td>\n \n\n @Configuration<\/code><\/div>\n@EnableJpaRepositories<\/code><\/div>\n@EnableTransactionManagement<\/code><\/div>\nclass<\/code> ApplicationConfig {<\/code><\/div>\n <\/div>\n <\/code>@Bean<\/code><\/div>\n <\/code>public<\/code> DataSource dataSource(){<\/code><\/div>\n <\/code>DriverManagerDataSource dataSource = <\/code>new<\/code> DriverManagerDataSource();<\/code><\/div>\n <\/code>dataSource.setUrl(<\/code>\"jdbc:mysql:\/\/localhost:3306\/database_name\"<\/code>);<\/code><\/div>\n <\/code>dataSource.setUsername( <\/code>\"root\"<\/code> );<\/code><\/div>\n <\/code>dataSource.setPassword( <\/code>\"root\"<\/code> );<\/code><\/div>\n | | | | | | | | |