Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.86 KB | None | 0 0
  1. DevConfig*****************************************
  2. @Configuration
  3. public class DevConfig {
  4.  
  5. @Autowired
  6. private DbService dbService;
  7.  
  8. @Value("${spring.jpa.hibernate.ddl-auto}")
  9. private String strategy;
  10.  
  11. @Bean
  12. public boolean inicializaBancoDeDados() throws ParseException {
  13. if (!"create".equals(strategy)) {
  14. return false;
  15. }
  16. dbService.inicializaBancoDeDados();
  17. return true;
  18. }
  19.  
  20. }
  21.  
  22. DbService****************************************
  23. @Service
  24. public class DbService {
  25.  
  26. @Autowired
  27. private CategoriaRepository categoriaRepository;
  28.  
  29. @Autowired
  30. private EstadoRepository estadoRepository;
  31.  
  32. public void inicializaBancoDeDados() throws ParseException {
  33.  
  34. Categoria cat1 = new Categoria(null, "Informática");
  35. Categoria cat2 = new Categoria(null, "Escritório");
  36. Categoria cat3 = new Categoria(null, "Cama mesa e banho");
  37. Categoria cat4 = new Categoria(null, "Eletrônicos");
  38. Categoria cat5 = new Categoria(null, "Jardinagem");
  39. Categoria cat6 = new Categoria(null, "Decoração");
  40. Categoria cat7 = new Categoria(null, "Perfumaria");
  41. categoriaRepository.saveAll(Arrays.asList(cat1, cat2, cat3, cat4, cat5, cat6, cat7));
  42.  
  43. }
  44.  
  45. }
  46.  
  47.  
  48. CATEGORIA RESOURCE***********************
  49.  
  50. @RestController
  51. @RequestMapping(value="/categorias")
  52. public class CategoriaResource {
  53.  
  54. @Autowired
  55. private CategoriaService service;
  56.  
  57. //BUSCAR POR ID
  58. @RequestMapping(value="/{id}",method=RequestMethod.GET)
  59. public ResponseEntity<Categoria> find(@PathVariable Integer id){
  60. Categoria obj = service.find(id);
  61. return ResponseEntity.ok().body(obj);
  62. }
  63.  
  64. //INSERIR
  65. @RequestMapping(method=RequestMethod.POST)
  66. public ResponseEntity<Void>insert(@RequestBody Categoria obj){
  67. obj = service.insert(obj);
  68. URI uri = ServletUriComponentsBuilder.fromCurrentRequest().
  69. path("/{id}").buildAndExpand(obj.getId()).toUri();
  70. return ResponseEntity.created(uri).build();
  71. }
  72.  
  73. //ATUALIZAR
  74. @RequestMapping(value="/{id}", method=RequestMethod.PUT)
  75. public ResponseEntity<Void> update(@RequestBody Categoria obj, @PathVariable Integer id){
  76. obj.setId(id);
  77. obj = service.update(obj);
  78. return ResponseEntity.noContent().build();
  79. }
  80.  
  81.  
  82. //EXCLUIR
  83. @RequestMapping(value="/{id}", method=RequestMethod.DELETE)
  84. public ResponseEntity<Void> delete(@PathVariable Integer id) {
  85. service.delete(id);
  86. return ResponseEntity.noContent().build();
  87. }
  88.  
  89. //LISTAR TODAS
  90. @RequestMapping(method=RequestMethod.GET)
  91. public ResponseEntity<List<CategoriaDTO>> findAll() {
  92. List<Categoria> lista = service.findAll();
  93. //ou for para percorrer a lista
  94. List<CategoriaDTO> listaDTO = lista.stream().map(obj -> new CategoriaDTO(obj)).collect(Collectors.toList());
  95. return ResponseEntity.ok().body(listaDTO);
  96. }
  97.  
  98. }
  99.  
  100. CATEGORIA SERVICE********************
  101. @Service
  102. public class CategoriaService {
  103.  
  104. @Autowired
  105. private CategoriaRepository rep;
  106.  
  107. //BUSCAR POR ID
  108. public Categoria find (Integer id) {
  109. Optional<Categoria> obj = rep.findById(id);
  110. return obj.orElse(null);
  111. }
  112.  
  113. //INSERIR
  114. public Categoria insert (Categoria obj) {
  115. obj.setId(null);
  116. return rep.save(obj);
  117. }
  118.  
  119. //ATUALIZAR
  120. public Categoria update (Categoria obj) {
  121. find(obj.getId());
  122. return rep.save(obj);
  123. }
  124.  
  125. //DELETAR
  126. public void delete (Integer id) {
  127. find(id);
  128. rep.deleteById(id);
  129. }
  130.  
  131. //LISTAR TODAS
  132. public List<Categoria> findAll(){
  133. return rep.findAll();
  134. }
  135.  
  136.  
  137. POM.XML*****************************
  138.  
  139. <dependency>
  140. <groupId>org.springframework.boot</groupId>
  141. <artifactId>spring-boot-starter-data-jpa</artifactId>
  142. </dependency>
  143.  
  144. <dependency>
  145. <groupId>org.springframework.boot</groupId>
  146. <artifactId>spring-boot-devtools</artifactId>
  147. </dependency>
  148.  
  149. application.properties**********************************
  150.  
  151. spring.datasource.url=jdbc:mysql://localhost:3306/pweb_quarta?useTimezone=true&serverTimezone=UTC
  152. spring.datasource.username=root
  153. spring.datasource.password=root
  154. spring.jpa.hibernate.ddl-auto=create
  155. spring.jpa.show-sql=true
  156. spring.jpa.properties.hibernate.format_sql=true
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement