vue mysql添加 删除_Vue+Spring Data JPA+MySQL 增查改删

视频讲解:

工程概述:

前后端分离，进行简单增查改删(CRUD)

前端使用VUE

后端使用Spring Data JPA

数据库使用MySQL

EmployeeController.java

package com.deepincoding.springdatajpamysqlcrud.controller;

import com.deepincoding.springdatajpamysqlcrud.entity.Employee;

import com.deepincoding.springdatajpamysqlcrud.model.BaseResponse;

import com.deepincoding.springdatajpamysqlcrud.service.EmployeeService;

import lombok.extern.log4j.Log4j2;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.data.domain.Page;

import org.springframework.data.domain.Pageable;

import org.springframework.data.domain.Sort;

import org.springframework.data.web.PageableDefault;

import org.springframework.web.bind.annotation.*;

import java.util.Optional;

@RestController

@RequestMapping("/api/employee")

@Log4j2

public class EmployeeController extends BaseController {

@Autowired

private EmployeeService employeeService;

@PostMapping

public BaseResponse save(@RequestBody Employee employee){

employeeService.save(employee);

return new BaseResponse<>(SUCCESS,"保存成功");

}

@GetMapping("/{id}")

public BaseResponse> findById(@PathVariable Long id){

Optional employee = employeeService.findById(id);

return new BaseResponse<>(SUCCESS,"获取成功",employee);

}

@GetMapping

public BaseResponse> findAll(@PageableDefault(sort = {"id"},direction = Sort.Direction.DESC ,size = 3) Pageable pageable){

log.info("pageable:{}",pageable.getPageNumber());

Page employees = employeeService.findAll(pageable);

return new BaseResponse<>(SUCCESS,"获取成功",employees);

}

@PutMapping

public BaseResponse update(@RequestBody Employee employee){

employeeService.save(employee);

return new BaseResponse<>(SUCCESS,"修改成功");

}

@DeleteMapping("/{id}")

public BaseResponse delete(@PathVariable Long id){

employeeService.delete(id);

return new BaseResponse<>(SUCCESS,"删除成功");

}

}

CorsConfig.java

package com.deepincoding.springdatajpamysqlcrud.config;

import org.springframework.context.annotation.Configuration;

import org.springframework.web.servlet.config.annotation.CorsRegistry;

import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;

@Configuration

public class CorsConfig implements WebMvcConfigurer {

/**

* 跨域配置

* @param registry

*/

@Override

public void addCorsMappings(CorsRegistry registry) {

registry.addMapping("/**")

.allowedOrigins("*")

.allowedMethods("*");

}

}

Employee.java

package com.deepincoding.springdatajpamysqlcrud.entity;

import com.deepincoding.springdatajpamysqlcrud.enums.Gender;

import lombok.AllArgsConstructor;

import lombok.Data;

import lombok.NoArgsConstructor;

import javax.persistence.*;

@Entity

@Data

@NoArgsConstructor

@AllArgsConstructor

public class Employee {

@Id

@GeneratedValue(strategy= GenerationType.AUTO)

private long id;

private String name;

@Enumerated(EnumType.STRING)

private Gender gender;

private Integer age;

private String introduce;

}

EmployeeServiceImpl.java

package com.deepincoding.springdatajpamysqlcrud.service;

import com.deepincoding.springdatajpamysqlcrud.entity.Employee;

import com.deepincoding.springdatajpamysqlcrud.repositories.EmployeeRep;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.data.domain.Page;

import org.springframework.stereotype.Service;

import org.springframework.data.domain.Pageable;

import java.util.Optional;

@Service

public class EmployeeServiceImpl implements EmployeeService{

@Autowired

private EmployeeRep employeeRep;

@Override

public void save(Employee employee) {

employeeRep.save(employee);

}

@Override

public Optional findById(Long id) {

return employeeRep.findById(id);

}

@Override

public void update(Employee employee) {

employeeRep.save(employee);

}

@Override

public void delete(Long id) { employeeRep.deleteById(id); }

@Override

public Page findAll(Pageable pageable) {

return employeeRep.findAll(pageable);

}

}

本文使用 mdnice 排版