AlanLau的专栏

@Configuration@EnableJpaRepositories@EnableTransactionManagementclass ApplicationConfig { @Bean public DataSource dataSource() { EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuil

spring data jpa中named query中关键字与方法名以及jpql语句一一对应，总结出来，以便用到的时候查阅。更多spring data jpa请参考：http://docs.spring.io/spring-data/jpa/docs/1.6.4.RELEASE/reference/html/jpa.repositories.html

spring data jpa:Spring Data JPA, part of the larger Spring Data family, makes it easy to easily implement JPA based repositories. This module deals with enhanced support for JPA based data access layers. It makes it easier to build Spring-powered applicati

在用jpa nativequery语句中，用spring junit测试发现报错：JPA-style positional param was not an integral ordinal。。。。。。经过百度与自己代码调试发现：多是sql之间的空格问题，或者sql拼接问题，还有可能是sql语句后面不能有分号。

参考文章：http://www.tuicool.com/articles/jQJBNv 1. 一个使用@Query注解的简单例子@Query(value = "select name,author,price from Book b where b.price>?1 and b.price)List findByPriceRange(long price1, long p