创建一个springboot web工程

1、创建meve## 标题n项目

File- > New -> Project -> Maven -> 。。。下一步 -> 等待Maven创建结束。

2、创建项目结构

3、更改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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>springbootdemo</groupId>
    <artifactId>Springbootdemo</artifactId>
    <version>1.0-SNAPSHOT</version>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.6.8</version>
    </parent>

    <dependencies>
        <dependency>
        	<!-- 这里只用这个依赖就可以使用springMVC -->
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
        <!-- mybatis相关依赖 -->
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>

        <dependency>
        <!-- mysql数据库依赖 -->
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.28</version>
        </dependency>


    </dependencies>

</project>

4、创建相应文件

UserController.java

package com.strex.controller;

import com.strex.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
public class UserController {

    @Autowired
    private UserService userService;

    @GetMapping("/strex")
    public void test() {
        userService.test();
    }

}

UserMapper.java

package com.strex.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserMapper {

    @Insert("INSERT INTO allwords.words (word,phoneticSymbol,Definitions) VALUES ('aaa','[ˈteilə]','n. 裁缝师'), ('bbb','[ʌnˈkɔnʃəs]','adj. 不省人事的；失去知觉的')")
    void insertOne();

}

UserService.java

package com.strex.service;

import com.strex.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;

@Component
public class UserService {

    @Autowired
    private UserMapper userMapper;

    @Transactional
    public void test() {
        System.out.println("调用service成功");
        userMapper.insertOne();
    }

}

MyApplication.java

package com.strex;

import com.strex.service.UserService;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.ConfigurableApplicationContext;

@SpringBootApplication
public class MyApplication {

    public static void main(String[] args) {
        //这里就只需要让工程运行起来就行了
        SpringApplication.run(MyApplication.class);
    }

}

application.properties

#这个可以不配
#spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://11.22.33.44:3306/database?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=false
spring.datasource.username='***'
spring.datasource.password=***

5、运行

点击main左边的启动按钮运行

这里可以看到请求已经成功了

5、查看数据库是否插入成功