当前位置: 首页 > Web前端 > vue.js

Kotlin+Vue+SpringDataJPA+MySQL添加查询修改删除

时间:2023-03-31 18:56:07 vue.js

概述:Kotlin是后端开发语言,持久层是SpringDataJPA,前后端分离,进行简单的CRUD。前端使用VUE数据库,使用MySQLVue前端代码,不再赘述。下面是Kotlin后台代码EmployeeController.ktpackagecom.example.kotlinjpacrud.controllerimportcom.example.kotlinjpacrud.entity.Employeeimportcom.example.kotlinjpacrud.repositories.EmployeeRepositoryimportorg.springframework.data.domain.Pageimportmain.springframework.dataPageableimportorg.springframework.data.domain.Sortimportorg.springframework.data.web.PageableDefaultimportorg.springframework.http.HttpStatusimportorg.springframework.http.ResponseEntityimportorg.springframework.web.bind.annotation.*importjavax.validation.Valid@RestController@RequestMapping("/api/employee")classEmployeeController(privatevalemployeeRepository:EmployeeRepository){/***获取所有员工分页*按字段Id降序排列*没有3条记录*/@GetMappingfungetAllEmployees(@PageableDefault(sort=["id"],direction=Sort.Direction.DESC,size=3)pageable:Pageable):Page{returnemployeeRepository.findAll(pageable)}/***新取增量工*/@PostMappingfuncreateEmployee(@Valid@RequestBodyemployee:Employee):Employee{returnemployeeRepository.save(employee)}/***根据ID获得员工*/@GetMapping("/{id}")fungetEmployeeById(@PathVariable(value="id")employeeId:Long):ResponseEntity{returnemployeeRepository.findById(employeeId).map{employee->ResponseEntity.ok(employee)}.orElse(ResponseEntity.notFound().build())}/***修改人员*/@PutMappingfunupdateEmployeeById(@Valid@RequestBodynewEmployee:Employee):ResponseEntity{returnemployeeRepository.findById(newEmployee.id).map{existingArticle->valupdatedArticle:Employee=existingArticle.copy(name=newEmployee.name,性别=newEmployee.gender,age=newEmployee.age,introduce=newEmployee.introduce)ResponseEntity.ok().body(employeeRepository.save(updatedArticle))}.orElse(ResponseEntity.notFound().build())}/***根据ID删除*/@DeleteMapping("/{id}")fundeleteEmployeeById(@PathVariable(value="id")employeeId:Long):ResponseEntity{returnemployeeRepository.findById(employeeId).map{deleteEmployee->employeeRepository.delete(deleteEmployee)ResponseEntity(HttpStatus.OK)}.orElse(ResponseEntity.notFound().build())}}Employee.ktpackagecom.example.kotlinjpacrud.entityimportcom.example.kotlinjpacrud.enums复制代码.Genderimportjavax.persistence.Entityimportjavax.persistence.GeneratedValueimportjavax.persistence.Id@Entity数据类Employee(@Id@GeneratedValuevarid:Long=0,varname:String="",vargender:Gender=Gender.MALE,varage:Int=0,varintroduce:String="")EmployeeRepository.tkpackagecom.example.kotlinjpacrud.repositoriesimportcom.example.kotlinjpacrud.entity.Employeeimportorg.springframework.data.jpa.repository.JpaRepositoryimportorg.springframework.stereotype.Repository@RepositoryinterfaceEmployeeRepository:JpaRepository{}