SpringDataJpa @query注解查询

EmployeeRepository接口中写方法：

@Query("select o from Employee o where username like ?1")
List<Employee> query01(String username);

@Query("select o from Employee o where username like ?1 and age > ?2")
List<Employee> query02(String username, Integer age);

@Query(value = "select * from employee where username like ?1",nativeQuery = true)
List<Employee> query03(String username);

 

测试

public void testFindByUsername(){
    List<Employee> employees = employeeRepository.query01("%1%");
    employees.forEach(e -> System.out.println(e));
}

@Test
public void testFindByUsernameAndAge(){
    List<Employee> employees = employeeRepository.query02("%1%",20);
    employees.forEach(e -> System.out.println(e));
}

@Test
public void testQuery03(){
    List<Employee> employees = employeeRepository.query03("%1%");
    employees.forEach(employee -> System.out.println(employee));
}

转载于:https://my.oschina.net/u/4107179/blog/3030075