Idea搭建spring boot环境

小咪咪 2022-03-31 09:48 504阅读 0赞

**目录**

Idea搭建spring boot环境

一、创建项目

二、等待加载完成

三、添加数据源application.yml

四、添加test.css

五、添加test.html

六、添加controller

七、启动

八、访问http://localhost:8888/index

九、添加MyBatis-Plus依赖

十、添加User

十一、添加UserMapper

十二、添加UserMapperTest

十三、执行sql

十四、测试运行

--------------------

# Idea搭建spring boot环境 #

## **一、创建项目** ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 5][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 6][]

## **二、等待加载完成** ##

![20190102235929601.png][]

## **三、添加数据源application.yml** ##

server:
      port: 8888
      address: localhost
    # DataSource Config
    spring:
      http:
        encoding.charset: UTF-8
        encoding.enable: true
        encoding.force: true
      datasource:
        driver-class-name: com.mysql.cj.jdbc.Driver
        schema: classpath:db/schema-mysql.sql
        data: classpath:db/data-mysql.sql
        url: jdbc:mysql:///test?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false
        username: root
        password: 123456
    
    # Logger Config
    logging:
      level:
        com.baomidou.mybatisplus.samples.quickstart: debug

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 7][]

如果是application.pro则使用如下配置

spring.datasource.url = jdbc:mysql://localhost:3306/test
    spring.datasource.username = root
    spring.datasource.password =  123456
    spring.datasource.driverClassName = com.mysql.jdbc.Driver
    #页面热加载
    spring.thymeleaf.cache = false
    #端口
    server.port=8888

## **四、添加test.css** ##

body\{

color: red;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 8][]

## **五、添加test.html** ##

<!DOCTYPE html>

<head>

<title>Title</title>

</head>

<body>

王者归来

</body>

</html>

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 9][]

## **六、添加controller** ##

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

\*\*\*\*\*\*\*\*\* K\*I\*N\*G \*\*\*\*\*\*\*\*\*\* B\*A\*C\*K \*\*\*\*\*\*\*/

package com.ibm.mosesboot.controller;

/\*\*

\* @author Moses \*

\* @Date 2019/1/2 23:34

\*/

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

@Controller

public class IndexController \{

@RequestMapping("/index")

public String index()\{

return "test";

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 10][]

## **七、启动** ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 11][]

## **八、访问[http://localhost:8888/index][http_localhost_8888_index]** ##

![20190103000028799.png][]

## **九、添加**[MyBatis-Plus][]依赖 ##

<dependency>  
    <groupId>org.projectlombok</groupId>  
    <artifactId>lombok</artifactId>  
    <optional>true</optional>  
</dependency>  
<dependency>  
    <groupId>com.baomidou</groupId>  
    <artifactId>mybatis-plus-boot-starter</artifactId>  
    <version>3.0.7.1</version>  
</dependency>

## **十、添加**User ##

package com.ibm.mosesboot.entity;

import lombok.Data;

/\*\*  
 \* @author Moses \*  
 \* @Date 2019/1/21 15:35  
 \*/  
@Data  
public class User \{  
    private Long id;  
    private String name;  
    private Integer age;  
    private String email;  
\}

## **十一、添加UserMapper** ##

package com.ibm.mosesboot.mapper;
    
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    import com.ibm.mosesboot.entity.User;
    
    /**
     * @author Moses *
     * @Date 2019/1/21 15:40
     */
    public interface UserMapper extends BaseMapper<User> {
    
    }

## **十二、添加UserMapperTest** ##

import com.ibm.mosesboot.entity.User;
    import org.junit.Assert;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.test.context.junit4.SpringRunner;
    
    import java.util.List;
    
    /**
     * @author Moses *
     * @Date 2019/1/21 15:42
     */
    @RunWith(SpringRunner.class)
    @MapperScan("com.ibm.mosesboot.mapper")
    @SpringBootTest
    public class UserMapperTest {
    
        @Autowired
        private UserMapper userMapper;
    
        @Test
        public void testSelect() {
            System.out.println(("----- selectAll method test ------"));
            List<User> userList = userMapper.selectList(null);
            Assert.assertEquals(5, userList.size());
            userList.forEach(System.out::println);
        }
    
    }

## **十三、执行sql** ##

DROP TABLE IF EXISTS user;
    
    CREATE TABLE user
    (
       id BIGINT(20) NOT NULL COMMENT '主键ID',
       name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名',
       age INT(11) NULL DEFAULT NULL COMMENT '年龄',
       email VARCHAR(50) NULL DEFAULT NULL COMMENT '邮箱',
       PRIMARY KEY (id)
    );

DELETE FROM user;
    
    INSERT INTO user (id, name, age, email) VALUES
    (1, 'Jone', 18, 'test1@baomidou.com'),
    (2, 'Jack', 20, 'test2@baomidou.com'),
    (3, 'Tom', 28, 'test3@baomidou.com'),
    (4, 'Sandy', 21, 'test4@baomidou.com'),
    (5, 'Billie', 24, 'test5@baomidou.com');

## **十四、测试运行** ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 12][]

----- selectAll method test ------
    User(id=1, name=Jone, age=18, email=test1@baomidou.com)
    User(id=2, name=Jack, age=20, email=test2@baomidou.com)
    User(id=3, name=Tom, age=28, email=test3@baomidou.com)
    User(id=4, name=Sandy, age=21, email=test4@baomidou.com)
    User(id=5, name=Billie, age=24, email=test5@baomidou.com)

附：java.lang.IllegalArgumentException: URL must start with 'jdbc'

spring.datasource.hikari.jdbc-url=jdbc:mysql://localhost:3306/springbootbase?useUnicode=true&characterEncoding=utf8
    spring.datasource.hikari.username=root
    spring.datasource.hikari.password=123456
    spring.datasource.hikari.driver-class-name=com.mysql.jdbc.Driver

代码地址：[https://github.com/glory2018/moses-boot.git][https_github.com_glory2018_moses-boot.git]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70]: /images/20220331/8ab72450ae5f43afa36cab7ac4c68934.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 1]: /images/20220331/29edf23da4644b47965638a3da12392d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 2]: /images/20220331/25ce0f9fe1d14054860feaf319559575.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 3]: /images/20220331/c1af082ce86047babd36b11fa597f463.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 4]: /images/20220331/20ec51de648345c3b66f49983544dbc6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 5]: /images/20220331/7193dfb50e50439da15c0c76054ff25a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 6]: /images/20220331/3e2f509b07764ce6b9fd9b5db1cb2be5.png
[20190102235929601.png]: /images/20220331/72893e15faef4815b80358d7658c5112.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 7]: /images/20220331/183831a0f6ef4c44bfb4d1bed54651d1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 8]: /images/20220331/05ee22f4bcf3422e9ef6edd0d357b008.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 9]: /images/20220331/a0a668d34df547789f8a48c2e52d05a3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 10]: /images/20220331/6ebaebb137b44fbcbdcd41b5343054a3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 11]: /images/20220331/3acc6dc0551242f9b97f1f689642f6b3.png
[http_localhost_8888_index]: http://localhost:8888/index
[20190103000028799.png]: /images/20220331/8fd6f8ce888a4d01ab829bc61464697a.png
[MyBatis-Plus]: https://mp.baomidou.com/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 12]: /images/20220331/4c450b638b3840e2943b2c508571b433.png
[https_github.com_glory2018_moses-boot.git]: https://github.com/glory2018/moses-boot.git