Springboot配置

一、定制默认启动图案Banner
在src/main/resources下新建一个banner.txt 并输入想要的图案
通过http://patorjk.com/software/taag 生成想要的字符

 

二、热部署

1、引入依赖

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-devtools</artifactId>
    <!-- optional=true,依赖不会传递，该项目依赖devtools；之后依赖myboot项目的项目如果想要使用devtools，需要重新引入 -->
    <optional>true</optional>
</dependency>

2、修改IDEA配置
<1>File-Settings-Compiler-Build project automatically
<2>ctrl + shift + alt + /,选择Registry,勾上 Compiler autoMake allow when app running

 

三、springboot返回页面
@Controller必须配合模板，这里使用thymeleaf
先导入依赖：

<dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>

在templates目录下新建一个test.html

<!DOCTYPE html>

<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
aaaaaa
</body>
</html>

HelloController.java

package com.example.demo;

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

@Controller
public class HelloController {

    @RequestMapping("hello")
    public String hello(){
        return "test";
    }
}

访问http://localhost:8080/hello即可

 

四、JDBC数据库访问

加入依赖

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>

配置application.properties

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

访问数据库

package com.example.demo;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Controller;
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;
import java.util.Map;

//@RestController //RestController = Controller + ResponseBody
@Controller
public class HelloController {

    private final static Logger logger= LoggerFactory.getLogger(HelloController.class);

    @Autowired
    JdbcTemplate jdbcTemplate;

    //这里返回页面
    @RequestMapping("hello")
    public String hello() {
        logger.info("----------hello()-------");
        return "ss";  //这里返回的是ss.html页面
    }

    //加上ResponseBody注解后返回的是json
    @RequestMapping("world")
    @ResponseBody  //意味着返回json数据
    public String world() {
        logger.info("----------world()-------");
        return "ss"; //这里返回的是ss字符串
    }

    @RequestMapping("query")
    @ResponseBody
    public List<Map<String, Object>> query() {
        logger.info("----------queryUsers()-------");
        List<Map<String, Object>> list = jdbcTemplate.queryForList("select * from user");
        return list; //返回json, 页面上显示[{"id":1,"name":"mutian","age":21},{"id":1,"name":"muhe","age":11}]
    }
}

访问http://localhost:8080/query 显示json数据库内容

Q：The server time zone value 'xxxxxx' is unrecognized or represents more than one time zone.
在数据库后面加上?serverTimezone=UTC
比如 spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?serverTimezone=UTC
con = DriverManager.getConnection("jdbc:mysql:"+"//localhost:3306/world","root","1234");

 

posted @ 2019-09-24 17:32  牧 天  阅读(94)  评论(0)    收藏  举报