web第七次作业

Re对peot表实现基础的增删改查操作

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("/peots")
    public Result findAll(){
        List<Peot> peotList=peotService.findAll();
        return Result.success(peotList);
    }


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


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


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


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











}

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);
}

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;

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;
}

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);
    }
}

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);
}

application.properties

# 应用服务 WEB 访问端口
server.port=8080
#下面这些内容是为了让MyBatis映射
#指定Mybatis的Mapper文件
mybatis.mapper-locations=classpath:mappers/*xml
#指定Mybatis的实体目录
mybatis.type-aliases-package=com.study.mybatis.entity

#驱动类名称
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#数据库连接的url
spring.datasource.url=jdbc:mysql://localhost:3306/mystudy
#连接数据库的用户名
spring.datasource.username=root
#连接数据库的密码
spring.datasource.password=1234

#配置mybatis的日志, 指定输出到控制台
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

#开启mybatis的驼峰命名自动映射开关 a_column ------> aCloumn
mybatis.configuration.map-underscore-to-camel-case=true