本文主要追踪某个测试的博客，进行个人复现 not_found (影) · 话题 · TesterHome

https://panjiachen.github.io/vue-element-admin-site/zh/guide/

https://github.com/macrozheng/mall

https://github.com/macrozheng/mall-admin-web

Mall电商实战项目专属学习路线，主流技术一网打尽！ (qq.com)

一、创建spring boot脚手架

本章内容如下:

创建mysql docker容器，并用dbeaver客户端连上，创建test库，并导入用户表

创建spring web项目，并引入mysql驱动和mybatis依赖，及lombok依赖（真清爽啊）

补充mvc的bean、dao、controller、service及impl（鼠标移动到接口上alt+enter自动生成，记得挂二级目录impl）

补充mapper.xml，设置application.properties（服务端、db设置及mapper扫描配置）

准备了MySQL，路径192.168.20.150，root，123456, 之前建设的脚本如下

docker pull  mysql:5.7.37
mkdir -p /tmp/mysql/{conf,data}

tee /tmp/mysql/conf/hmy.cnf <<-'EOF'
[mysqld]
skip-name-resolve
character_set_server=utf8
datadir=/var/lib/mysql
server-id=1000
EOF

docker run \
    --name mysql \
    -p 3306:3306 \
    -e MYSQL_ROOT_PASSWORD=123456 \
    -v /tmp/mysql/conf/hmy.cnf:/etc/mysql/conf.d/hmy.cnf \
    -v /tmp/mysql/data:/var/lib/mysql \
    -d mysql:5.7.37

1）、创建工程，springboot

创建spring initializr工程（企业版），如果是社区版可以先添加插件， Spring Assistant
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.7.0</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.eric</groupId>
    <artifactId>testplatform</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>testplatform</name>
    <description>testplatform</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.1.4</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>
        <!-- lombok 插件简化get/set等体力劳动，虽然最终交付的代码量并没有少，甚至更多 -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </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=8081
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://192.168.20.150:3306/test?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT
spring.datasource.username=root
spring.datasource.password=123456

mybatis.type-aliases-package=com.eric.testPlatform.bean
mybatis.mapper-locations=classpath:mapper/*Mapper.xml

3）、数据库初始化

create database test;
use test;
-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) DEFAULT NULL,
`password` varchar(50) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'zhangsan', '123', '张三');
INSERT INTO `user` VALUES ('2', 'lisi', '123', '李四');

4）、创建mvc

bean

package com.eric.testplatform.bean;

import lombok.Data;

/**
 * @className: User
 * @description: TODO 类描述
 * @author: eric 4575252@gmail.com
 * @date: 2022/5/27/0027 16:22:57
 **/
@Data
public class User {
    //主键
    private Long id;
    //用户名
    private String userName;
    //密码
    private String password;
    //姓名
    private String name;
}

mapper

<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.eric.testplatform.dao.UserDao">
    <select id="queryUserList" resultType="com.eric.testplatform.bean.User">
        select * from user
    </select>
</mapper>

dao

package com.eric.testplatform.dao;

import com.eric.testplatform.bean.User;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * @className: UserDao
 * @description: TODO 类描述
 * @author: eric 4575252@gmail.com
 * @date: 2022/5/27/0027 16:23:49
 **/
@Mapper
public interface UserDao {
    public List<User> queryUserList();
}

service ==小技巧：先创建接口，然后在接口名称上按alt+enter可以快速生成实现==

package com.eric.testplatform.service;

import com.eric.testplatform.bean.User;

import java.util.List;

/**
 * @className: UserService
 * @description: TODO 类描述
 * @author: eric 4575252@gmail.com
 * @date: 2022/5/27/0027 16:26:24
 **/
public interface UserService {
    List<User> queryUserList();
}

package com.eric.testplatform.service.impl;

import com.eric.testplatform.bean.User;
import com.eric.testplatform.dao.UserDao;
import com.eric.testplatform.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @className: UserServiceImpl
 * @description: TODO 类描述
 * @author: eric 4575252@gmail.com
 * @date: 2022/5/27/0027 16:28:31
 **/
@Service
public class UserServiceImpl implements UserService {

    @Autowired
    private UserDao userDao;

    @Override
    public List<User> queryUserList() {
        return userDao.queryUserList();
    }
}

controller

package com.eric.testplatform.controller;

import com.eric.testplatform.bean.User;
import com.eric.testplatform.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * @className: UserController
 * @description: TODO 类描述
 * @author: eric 4575252@gmail.com
 * @date: 2022/5/27/0027 16:29:32
 **/
@RestController
public class UserController {
    @Autowired
    private UserService userService;

    @RequestMapping("/queryUser")
    @ResponseBody
    public List<User> queryUser(){
        List<User> userList = userService.queryUserList();
        return userList;
    }
}

5）、测试

访问 localhost:8081/queryUser

分享技术，品味人生

springboot 一步一步来

一、创建spring boot脚手架

1）、创建工程，springboot

2）、工程配置数据库依赖和配置信息

3）、数据库初始化

4）、创建mvc

5）、测试