Idea搭建spring boot环境

目录

Idea搭建spring boot环境

一、创建项目

二、等待加载完成

三、添加数据源application.yml

四、添加test.css

五、添加test.html

六、添加controller

七、启动

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

九、添加MyBatis-Plus依赖

十、添加User

十一、添加UserMapper

十二、添加UserMapperTest

十三、执行sql

十四、测试运行


Idea搭建spring boot环境

一、创建项目

二、等待加载完成

三、添加数据源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

如果是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;

}

五、添加test.html

<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <title>Title</title>

    <link rel="stylesheet" href="test.css" type="text/css" />

</head>

<body>

王者归来

</body>

</html>

六、添加controller

/*********************************************

 *

 * Copyright (C) 2019 IBM All rights reserved.

 *

 ********* 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";

    }

}

七、启动

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

九、添加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');

十四、测试运行

----- 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

  • 1
    点赞
  • 8
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值