JpaRepository: interface boladona do Spring
Trechos de código spring.datasource.url=jdbc:h2:mem:testdb spring.datasource.username=sa spring.datasource.password=
spring.h2.console.enabled=true spring.h2.console.path=/h2-console
spring.jpa.show-sql=true spring.jpa.properties.hibernate.format_sql=true INSERT INTO tb_users(name,email,salary) VALUES ('Maria','maria@gmail.com',1348.74); INSERT INTO tb_users(name,email,salary) VALUES ('Joao Silva','joao@gmail.com',9276.62); INSERT INTO tb_users(name,email,salary) VALUES ('Carlos Silva','carlos@gmail.com',7318.75); INSERT INTO tb_users(name,email,salary) VALUES ('Adriana','adriana@gmail.com',10688.93); INSERT INTO tb_users(name,email,salary) VALUES ('Karina','karina@gmail.com',7251.28); INSERT INTO tb_users(name,email,salary) VALUES ('Carlos Marques','carlos@gmail.com',5485.79); INSERT INTO tb_users(name,email,salary) VALUES ('Carlos Pereira','carlos@gmail.com',3519.41); INSERT INTO tb_users(name,email,salary) VALUES ('Ana Maria','ana@gmail.com',2569.20); INSERT INTO tb_users(name,email,salary) VALUES ('Beatriz','beatriz@gmail.com',3853.33); INSERT INTO tb_users(name,email,salary) VALUES ('Joana','joana@gmail.com',4222.91); INSERT INTO tb_users(name,email,salary) VALUES ('Tulio Augusto','tulio@gmail.com',9453.69); INSERT INTO tb_users(name,email,salary) VALUES ('Augusto','augusto@gmail.com',4119.91); INSERT INTO tb_users(name,email,salary) VALUES ('Marta','marta@gmail.com',4519.15); INSERT INTO tb_users(name,email,salary) VALUES ('Silvio','silvio@gmail.com',5285.68); INSERT INTO tb_users(name,email,salary) VALUES ('Washington','washington@gmail.com',6439.99); INSERT INTO tb_users(name,email,salary) VALUES ('Teresa','teresa@gmail.com',8929.78); INSERT INTO tb_users(name,email,salary) VALUES ('Luciano','luciano@gmail.com',3360.72); INSERT INTO tb_users(name,email,salary) VALUES ('Fabiana','fabiana@gmail.com',2532.83); INSERT INTO tb_users(name,email,salary) VALUES ('Fabio','fabio@gmail.com',5912.88); INSERT INTO tb_users(name,email,salary) VALUES ('Gisele','gisele@gmail.com',7558.26); INSERT INTO tb_users(name,email,salary) VALUES ('Larissa','larissa@gmail.com',2362.04); INSERT INTO tb_users(name,email,salary) VALUES ('Natanael','natanael@gmail.com',6860.63); INSERT INTO tb_users(name,email,salary) VALUES ('Meire','meire@gmail.com',3553.40); INSERT INTO tb_users(name,email,salary) VALUES ('Ana Carolina','ana@gmail.com',1404.28); INSERT INTO tb_users(name,email,salary) VALUES ('Filipe','filipe@gmail.com',3388.73); @Autowired private UserRepository repository;
@GetMapping public ResponseEntity<List> findAll() { List result = repository.findAll(); return ResponseEntity.ok(result); }
@GetMapping(value = "/page") public ResponseEntity<Page> findAll(Pageable pageable) { Page result = repository.findAll(pageable); return ResponseEntity.ok(result); }
@GetMapping(value = "/search-salary") public ResponseEntity<Page> searchBySalary(@RequestParam(defaultValue = "0") Double minSalary, @RequestParam(defaultValue = "1000000000000") Double maxSalary, Pageable pageable) { Page result = repository.findBySalaryBetween(minSalary, maxSalary, pageable); return ResponseEntity.ok(result); }
@GetMapping(value = "/search-name") public ResponseEntity<Page> searchByName(@RequestParam(defaultValue = "") String name, Pageable pageable) { Page result = repository.findByNameContainingIgnoreCase(name, pageable); return ResponseEntity.ok(result); } @Query("SELECT obj FROM User obj WHERE obj.salary >= :minSalary AND obj.salary <= :maxSalary") Page searchBySalary(Double minSalary, Double maxSalary, Pageable pageable);
@Query("SELECT obj FROM User obj WHERE LOWER(obj.name) LIKE LOWER(CONCAT('%',:name,'%'))") Page searchByName(String name, Pageable pageable);
Page findBySalaryBetween(Double minSalary, Double maxSalary, Pageable pageable);
Page findByNameContainingIgnoreCase(String name, Pageable pageable);