web第五次课后练习

PeotController

package com.study.controller;

import com.study.pojo.Peot;
import com.study.pojo.Result;
import com.study.service.PeotService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;


@RestController
public class PeotController {

    @Autowired
    private PeotService peotService;
    //    对数据进行查询操作
    @GetMapping
    public Result findAll(){
        List<Peot> peotList=peotService.findAll();
        return Result.success(peotList);
    }


    //对数据进行删除
    @DeleteMapping
    public Result deleteById(Integer id){
        peotService.deleteById(id);
        return Result.success();
    }


    //对数据根据ID查询
    @GetMapping
    public Result findById(@PathVariable Integer id){
        List<Peot> peotList=peotService.findById(id);
        return Result.success(peotList);
    }


    //增加数据
    @PostMapping
    public Result add(@RequestBody Peot peot){
        peotService.add(peot);
        return Result.success();
    }


    //更新数据
    @PutMapping
    public Result update(@RequestBody Peot peot){
        peotService.update(peot);
        return Result.success();
    }











}

Peot

package com.study.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.time.LocalDateTime;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Peot {
    private Integer id;
    private String name;
    private Short gender;
    private String dynasty;
    private String titile;
    private String style;
    private LocalDateTime createTime;
    private LocalDateTime updateTime;
}

Result

package com.study.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Result {
    private Integer code;
    private String msg;
    private Object data;

    //增删改 成功响应
    public static Result success(){
        return new Result(1,"success",null);
    }

    //查询 成功响应
    public static Result success(Object data){
        return new Result(1,"success",data);
    }

    //失败响应
    public static Result error(String msg){
        return new Result(0,msg,null);
    }

}

PeotMapper

package com.study.mapper;

import com.study.pojo.Peot;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface PeotMapper {

    //查询全部
    @Select("select * from peot")
    List<Peot> findAll();


    //删除全部
    @Delete("delete from peot where id=#{id}")
    void deleteById(Integer id);

    //根据ID查询
    @Select("select * from peot where id=#{id}")
    List<Peot> findById(Integer id);

    //增加数据
    @Insert("insert into peot(name, gender, dynasty, title, style) " +
            "values (#{name},#{gender},#{dynasty},#{title},#{style})")
    void add(Peot peot);

    //更新数据
    @Update(value = "update peot set name=#{name},gender=#{gender}," +
            "dynasty=#{dynasty},title=#{title},style=#{style} where id=#{id} ")
    void update(Peot peot);
}

PeotService

package com.study.service;

import com.study.pojo.Peot;

import java.util.List;

public interface PeotService {

    //全部查询
    List<Peot> findAll();

    //删除数据
    void deleteById(Integer id);

    //根据ID查询
    List<Peot> findById(Integer id);

    //增加数据
    void add(Peot peot);

    //更新数据
    void update(Peot peot);
}

PeotServiceImpl

package com.study.service.impl;

import com.study.mapper.PeotMapper;
import com.study.pojo.Peot;
import com.study.service.PeotService;
import lombok.AllArgsConstructor;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.time.LocalDateTime;
import java.util.List;


@Service
public class PeotServiceImpl implements PeotService {

    @Autowired
    private PeotMapper peotMapper;

    //全部查询
    @Override
    public List<Peot> findAll() {
        return peotMapper.findAll();
    }


    //删除数据
    @Override
    public void deleteById(Integer id) {
        peotMapper.deleteById(id);
    }


    //根据ID查询
    @Override
    public List<Peot> findById(Integer id) {
        return peotMapper.findById(id);
    }


    //增加数据
    @Override
    public void add(Peot peot) {
        peot.setCreateTime(LocalDateTime.now());
        peot.setUpdateTime(LocalDateTime.now());
        peotMapper.add(peot);
    }


    //更新数据
    @Override
    public void update(Peot peot) {
        peot.setUpdateTime(LocalDateTime.now());
        peotMapper.update(peot);
    }
}