Spring Data JPA（含自定义Repository）

package com.wisely; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.data.domain.Page; import org.springframework.data.domain.PageRequest; import org.springframework.data.domain.Sort; import org.springframework.data.domain.Sort.Direction; import org.springframework.data.jpa.repository.config.EnableJpaRepositories; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import com.wisely.dao.PersonRepository; import com.wisely.domain.Person; import com.wisely.support02.CustomRepositoryFactoryBean; import com.wisely.util.UUIDUtils; /** * spring Data JPA * */ @RestController @SpringBootApplication /** * 在配置类上配置@EnableJpaRepositories并指定repositoryFactoryBeanClass,让自定义的Repository起效 * 如果不需要自定义Repository实现，则在Spring Data JPA无需添加@EnableJpaRepositories，因为@SpringBootApplication * 包含的@EnableAutoConfiguration注解已经开启了对Spring Data JPA的支持 */ @EnableJpaRepositories(repositoryFactoryBeanClass = CustomRepositoryFactoryBean.class) public class Ch823Application { @Autowired PersonRepository personRepository; public static void main(String[] args) { SpringApplication.run(Ch823Application.class, args); } /** * 通过名字相等查询 * @param address * @return */ @RequestMapping("/findByName") public List<Person> findByName(String name) { List<Person> people = personRepository.findByName(name); return people; } /** * 通过名字like查询，两边不加% * @param name * @return */ @RequestMapping("/findByNameLike") public List<Person> findByNameLike(String name) { List<Person> people = personRepository.findByNameLike(name); return people; } /** * 通过名字like查询，两边加% * @param name * @return */ @RequestMapping("/findByNameContaining") public List<Person> findByNameContaining(String name) { List<Person> people = personRepository.findByNameContaining(name); return people; } /** * 获得符合查询条件的前10条数据 * @param name * @return */ @RequestMapping("/findFirst10ByName") public List<Person> findFirst10ByName(String name) { List<Person> people = personRepository.findFirst10ByName(name); return people; } /** * 更新地址 * @param address * @return */ @RequestMapping("/updateAddress") public int updateAddress(String address) { return personRepository.updateAddress(address); } /** * 排序 * @param address * @return */ @RequestMapping("/findByAddressSort") public List<Person> findByAddressSort(String address) { List<Person> people = personRepository.findByAddress(address, new Sort(Direction.ASC, "age")); return people; } /** * 分页 * @param address * @return */ @RequestMapping("/findByAddressPage") public Page<Person> findByAddressPage(String address) { Page<Person> people = personRepository.findByAddress(address, new PageRequest(0, 10)); return people; } /**************************************实战**********************************************/ /** * 保存 * @param name * @param age * @param address * @return */ @RequestMapping("/save") public Person save(String name, Integer age, String address) { Person p = personRepository.save(new Person(UUIDUtils.getUUIDLong(), name, age, address)); return p; } /** * 测试findByAddress */ @RequestMapping("/q1") public List<Person> q1(String address){ List<Person> people = personRepository.findByAddress(address); return people; } /** * 测试findByNameAndAddress */ @RequestMapping("/q2") public Person q2(String name,String address){ Person people = personRepository.findByNameAndAddress(name, address); return people; } /** * 测试withNameAndAddressQuery */ @RequestMapping("/q3") public Person q3(String name,String address){ Person p = personRepository.withNameAndAddressQuery(name, address); return p; } /** * 测试withNameAndAddressNamedQuery */ @RequestMapping("/q4") public Person q4(String name,String address){ Person p = personRepository.withNameAndAddressNamedQuery(name, address); return p; } /** * 测试排序 */ @RequestMapping("/sort") public List<Person> sort(){ List<Person> people = personRepository.findAll(new Sort(Direction.ASC,"age")); return people; } /** * 测试分页 */ @RequestMapping("/page") public Page<Person> page(){ Page<Person> pagePeople = personRepository.findAll(new PageRequest(1, 2)); return pagePeople; } /**************************************实战**********************************************/ //support01 // @RequestMapping("/home") // public List<Object[]> home() { // String sql = "select * from person where id = '9'"; // return personRepository.listBySQL(sql); // } //support02 /** * 控制器中接受一个person对象，当person的name有值时，会自动对name进行like查询； * 当age有值时，会进行等于查询; * 当person中有多个值不为空的时候，会自动构造多个查询条件; * 当person所有值为空的时候，默认查询出所有记录 * * 需要特别指出的是，在实体类中定义的数据类型要用包装类型(Long,Integer) * 而不能使用原始数据类型(long,int) * 应为在Spring MVC中，使用原始数据类型会自动初始化为0，而不是空，导致我们构造条件失败 * @param person * @return */ @RequestMapping("/home") public Page<Person> home(Person person) { Page<Person> pagePeople = personRepository.findByAuto(person,new PageRequest(0, 10)); return pagePeople; } //support02 // @RequestMapping("/findAll") // public List<Person> findAll() { // List<Person> people = personRepository.findAll(CustomeSpecs.personFromHangZhou()); // return people; // } //support03 // @RequestMapping("/home") // public String home() { // System.out.println("hello"); // // String hql = "select e from Person e"; // Page<Person> page = new Page<Person>(); // Page<Person> findPage = personRepository.findPage(page, hql, null); // for(Person person : findPage.getResult()) { // System.out.println(person.getName()); // } // // return "hello"; // } }