# springdata-new

**Repository Path**: qed/springdata-new

## Basic Information

- **Project Name**: springdata-new
- **Description**: springdata 入门总结
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2016-04-23
- **Last Updated**: 2020-12-18

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#springdata-new
begin to learn springdata

## develop environment
IDE: IntelliJ IDEA 14.1

JDK: jdk1.8.0_65

## Use open source project:

Spring IO platform

Spring Framework

Spring Data

JPA

Hibernate

Slf4j

use apache maven to do project management and comprehension tool

## annotation
@NoRepositoryBean

@Query

@Async

@Modifying

@RepositoryDefinition


## Supported keywords inside method names
| Keyword                   | Sample                                               | JPQL snippet                                  |
| ------------------------- |:----------------------------------------------------:| ---------------------------------------------:|
| And                       | findByLastnameAndFirstname                           |  … where x.lastname = ?1 and x.firstname = ?2 |
| Or                        | findByLastnameOrFirstname                            |… where x.lastname = ?1 or x.firstname = ?2    |
| Is,Equals                 | findByFirstname,findByFirstnameIs,findByFirstnameEquals | … where x.firstname = ?1                   |
| Between                   | findByStartDateBetween                               | … where x.startDate between ?1 and ?2         |
| LessThan                  | findByAgeLessThan                                    | … where x.age < ?1                            |
| LessThanEqual             | findByAgeLessThanEqual                               | … where x.age <= ?1                           |
| GreaterThan               | findByAgeGreaterThan                                 | … where x.age > ?1                            |
| GreaterThanEqual          | findByAgeGreaterThanEqual                            | … where x.age >= ?1                           |
| After                     | findByStartDateAfter                                 | … where x.startDate > ?1                      |
| Before                    | findByStartDateBefore                                | … where x.startDate < ?1                      |
| IsNull                    | findByAgeIsNull                                      | … where x.age is null                         |
| IsNotNull,NotNull         | findByAge(Is)NotNull                                 | … where x.age not null                        |
| Like                      | findByFirstnameLike                                  | … where x.firstname like ?1                   |
| NotLike                   | findByFirstnameNotLike                               | … where x.firstname not like ?1               |
| StartingWith              | findByFirstnameStartingWith          | … where x.firstname like ?1 (parameter bound with appended %) |
| EndingWith                | findByFirstnameEndingWith            | … where x.firstname like ?1 (parameter bound with prepended %)|
| Containing                | findByFirstnameContaining            | … where x.firstname like ?1 (parameter bound wrapped in %)    |
| OrderBy                   | findByAgeOrderByLastnameDesc         | … where x.age = ?1 order by x.lastname desc                   |
| Not                       | findByLastnameNot                                    | … where x.lastname <> ?1                      |
| In                        | findByAgeIn(Collection<Age> ages)                    | … where x.age in ?1                           |
| NotIn                     | findByAgeNotIn(Collection<Age> age)                  | … where x.age not in ?1                       |
| True                      | findByActiveTrue()                                   | … where x.active = true                       |
| False                     | findByActiveFalse()                                  | … where x.active = false                      |
| IgnoreCase                | findByFirstnameIgnoreCase                            | … where UPPER(x.firstame) = UPPER(?1)         |

[Spring Data JPA - Reference Documentation](http://docs.spring.io/spring-data/jpa/docs/1.10.1.RELEASE/reference/html/)