springboot简单搭建

file创建

点击file->new->project

项目名称及存放位置自定，点击next

可以选择一些会用到的依赖，勾选上点击finish

导入依赖

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId> (不必须)
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId> 
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.5</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.2.2</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId> （不必须）
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

## 数据库配置

创建testre数据库和user表

插入两条数据

配置文件

找到resource下的application.properties，修改配置如下：

#定义端口，不配置则默认为8080
server.port=8081

#数据库链接配置
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/testre?useUnicode=true&characterEncoding=UTF-8&useSSL=false
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

#扫描到xml路径
mybatis.mapper-locations=classpath:mapper/*.xml
#配置resultType的包路径前缀
mybatis.type-aliases-package=com.example.springdemo.entity

目录

创建目录及文件（注意数据库名称，这里我的数据库名是testre）

controller

@RequestMapping("/user")
public class UserController {

    @Autowired
    UserService userService;

    @GetMapping("/seluser")
    public List<User> selUsers() {
        List<User> userList = userService.selUserList();
        return userList;
    }


}

entity

@Data
public class User {

    private Integer userid;
    private String username;

}

mapper

@Mapper
public interface UserMapper {

    List<User> userList();
}

service

public interface UserService {

    List<User> selUserList();
}

ServiceImpl

@Service
public class ServiceImpl implements UserService {

    @Autowired
    UserMapper userMapper;

    @Override
    public List<User> selUserList() {
        List<User> userList = userMapper.userList();
        return userList;
    }
}

userMapper.xml

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTO Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.springdemo.mapper.UserMapper">

    <select id="userList" resultType="User">
        select * from user
    </select>
</mapper>

运行

在浏览器中输入访问的端口地址（localhost:8088/user/seluser）
user:是对应的usercontroller，seluser：对应usercontroller类下的seluser这个接口

写得不好，望大家多多指教！