简单搭建一个springBoot项目

简单搭建一个springBoot项目

构建maven项目

新增pom配置

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.ydzx</groupId>
    <artifactId>myBoot</artifactId>
    <version>1.0-SNAPSHOT</version>


    <dependencyManagement>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-dependencies</artifactId>
                <version>2.6.3</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
        </dependencies>
    </dependencyManagement>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <version>3.2.4</version>
        </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>
            <version>8.0.33</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>2.0.12</version>
            <exclusions>
                <exclusion>
                    <groupId>org.slf4j</groupId>
                    <artifactId>slf4j-simple</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
    </dependencies>
</project>

配置数据库相关

application文件

server:
  port: 9999 ##端口号
  servlet:
    context-path: /spring01  ##路径
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/mydemo?useSSL=false&serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8  ## 数据库
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 密码
mybatis:
  type-aliases-package: com.demo.pojo   ## 类的别名
  mapper-locations: classpath:mybatis/*.xml  ## 配置解析xml

**

项目分层；连接数据库层

**
mapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.demo.mapper.BookMapper">
    <select id="selectAllbooks" resultType="book">
        SELECT * FROM my_book
    </select>
    <insert id="insertBook">
        INSERT INTO my_book (name,author,price) VALUES (#{name},#{author},#{price});
    </insert>
    <update id="updateBook">
        UPDATE my_book SET price=#{price},name=#{name} WHERE id=#{id}
    </update>
    <delete id="deleteBook">
        DELETE FROM my_book WHERE id=#{id}
    </delete>
</mapper>

mapper接口

package com.demo.mapper;

import com.demo.pojo.Book;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface BookMapper {
    List<Book> selectAllbooks();
    int insertBook(Book book);
    int updateBook(Book book);
    int deleteBook(Book id);
}

业务层

package com.demo.service;

import com.demo.pojo.Book;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface BookService {
    List<Book> findAll();
    int addBook(Book book);
    int updateBook(Book book);
    int deleteBook(Book book);
}

package com.demo.service.imp;

import com.demo.mapper.BookMapper;
import com.demo.pojo.Book;
import com.demo.service.BookService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Service
public class BookServiceImp implements BookService {
    @Autowired
    private BookMapper bookMapper;
    public List<Book> findAll() {
        return bookMapper.selectAllbooks();
    }
    public int addBook(Book book) {
        return bookMapper.insertBook(book);
    }
    public int updateBook(Book book) {
        return bookMapper.updateBook(book);
    }
    public int deleteBook(Book book) {
        return bookMapper.deleteBook(book);
    }
}

Controller层

package com.demo.controller;

import com.demo.pojo.Book;
import com.demo.service.BookService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Controller
public class BookController {
    @Autowired
    private BookService bookService;
    @RequestMapping("/findAll")
    @ResponseBody
    public Map<String, Object> findBook() {
        List<Book> book= bookService.findAll();
        Map<String, Object> response = new HashMap<>();
        response.put("code", 0);
        response.put("status", "success");
        response.put("result", book);
        response.put("msg", "");
        return response;
    }
    @PostMapping("/add")
    public ResponseEntity<Map<String, Object>> addBook(@RequestBody Book book) {
        // 在这里执行添加书籍的逻辑，并返回相应的结果
        System.out.println(book.getName());
        int res=bookService.addBook(book);
        // 假设书籍添加成功，构造响应对象
        Map<String, Object> response = new HashMap<>();

        if(res>0){
            response.put("code", 0);
            response.put("status", "success");
            response.put("msg", "Book added successfully");
        }else{
            response.put("code", 400);
            response.put("status", "fail");
            response.put("msg", "Book added fail");
        }
        return ResponseEntity.status(HttpStatus.OK).body(response);
    }
    @PostMapping("/update")
    public ResponseEntity<Map<String, Object>> updateBook(@RequestBody Book book) {
        int res=bookService.updateBook(book);
        Map<String, Object> response = new HashMap<>();
        if(res>0){
            response.put("code", 0);
            response.put("status", "success");
            response.put("msg", "Book update successfully");
        }else{
            response.put("code", 400);
            response.put("status", "fail");
            response.put("msg", "Book update fail");
        }
        return ResponseEntity.status(HttpStatus.OK).body(response);
    }
    @PostMapping("/del")
    public ResponseEntity<Map<String, Object>> delBook(@RequestBody Book book) {
        int res=bookService.deleteBook(book);
        Map<String, Object> response = new HashMap<>();
        if(res>0){
            response.put("code", 0);
            response.put("status", "success");
            response.put("msg", "Book del successfully");
        }else{
            response.put("code", 400);
            response.put("status", "fail");
            response.put("msg", "Book del fail");
        }
        return ResponseEntity.status(HttpStatus.OK).body(response);
    }

}