springboot写增删查改接口

1，搭建好一个spring boot项目

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.6.4</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.example</groupId>
    <artifactId>demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>demo</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

2，连接数据库

application.properties

server.port=8082

spring.datasource.url=jdbc:mysql://localhost:3306/ssm_db?serverTimezone=GMT%2B8&characterEncoding-utf-8&useSSL=false
spring.datasource.username=root  //mysql用户名
spring.datasource.password=root  //mysql密码
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver


spring.jpa.show-sql=true
spring.jpa.properties.hibernate.format_sql=true

3，编写实体类

创建entity.user

package com.example.demo.entity;


//实体类
public class user {
    private Integer commodity_Id;
    private String name;
    private Double price;
    private String creation_Time;
    private String picture;
    private Integer id;
    private Integer commodityType;
    private Integer commoditySate;

    public Integer getCommodity_Id() {
        return commodity_Id;
    }

    public void setCommodity_Id(Integer commodity_Id) {
        this.commodity_Id = commodity_Id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Double getPrice() {
        return price;
    }

    public void setPrice(Double price) {
        this.price = price;
    }

    public String getCreation_Time() {
        return creation_Time;
    }

    public void setCreation_Time(String creation_Time) {
        this.creation_Time = creation_Time;
    }

    public String getPicture() {
        return picture;
    }

    public void setPicture(String picture) {
        this.picture = picture;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public Integer getCommodityType() {
        return commodityType;
    }

    public void setCommodityType(Integer commodityType) {
        this.commodityType = commodityType;
    }

    public Integer getCommoditySate() {
        return commoditySate;
    }

    public void setCommoditySate(Integer commoditySate) {
        this.commoditySate = commoditySate;
    }
}

4，编写控制层

创建controller.UserController

package com.example.demo.controller;


import com.example.demo.entity.user;
import com.example.demo.mapper.userMapper;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.util.List;
//解决跨域问题
@CrossOrigin(origins = {"*", "null"})
@RestController
@RequestMapping("/phone")
public class UserController {

    @Resource
    userMapper userMapper;

    @GetMapping
    public List<user> getUser(){
        return userMapper.findAll();
    }
    @PostMapping
    public String addUser(@RequestBody user phone){
        userMapper.save(phone);
        return "添加成功";
    }
    @PutMapping
    public String updateUser(@RequestBody user phone) {
        userMapper.updateById(phone);
        return "更新成功";
    }

}

5，编写持久层

创建mapper.userMapper

package com.example.demo.mapper;


import com.example.demo.entity.user;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.transaction.annotation.Transactional;


import java.util.List;

public interface userMapper {

    @Select("Select * from phone")
    List<user> findAll();
//INSERT INTO `phone`(`commodity_Id`, `name`, `price`, `creation_Time`, `picture`, `id`, `commodityType`, `commoditySate`) VALUES (10, '手机01', 2000.00, '2022-03-13 22:20:51', 'https://s3.bmp.ovh/imgs/2022/03/cb452b6f8d9bef72.jpg', 1, NULL, NULL);
    @Update("INSERT INTO `phone`( `name`, `price`, `creation_Time`, `picture`, `id`, `commodityType`, `commoditySate`) VALUES (#{name},#{price},#{creation_Time},#{picture},#{id},#{commodityType},#{commoditySate});")
    @Transactional
//    事物注解
    void save(user phone);

//UPDATE `ssm_db`.`phone` SET `name` = '手机01', `price` = 2000.00, `creation_Time` = '2022-03-13 22:20:51', `picture` = 'https://s3.bmp.ovh/imgs/2022/03/cb452b6f8d9bef72.jpg', `id` = 1, `commodityType` = NULL, `commoditySate` = NULL WHERE `commodity_Id` = 10;
    @Update("Update phone SET name = #{name},price = #{price},creation_Time = #{creation_Time}, picture= #{picture},id=#{id},commodityType=#{commodityType},commoditySate = #{commoditySate} WHERE commodity_Id = #{commodity_Id}")
    @Transactional
    void updateById(user phone);
}