springboot项目搭建web项目详细总结

太过爱你忘了你带给我的痛 2021-11-09 16:16 383阅读 0赞

1.用官网地址[https://start.spring.io/][https_start.spring.io]   快速搭建项目

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70][]

选择需要的包

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 2][]

生成原始项目代码，解压导入IDE

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 3][]

2.配置

package com.horse.red.controller;
    
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    @RestController
    public class HelloController {
    
        @RequestMapping("/sayHello")
        public String sayHello(){
            System.out.println("hello spring boot");
            return "hello spring boot";
        }
    }

在启动网站前，由于spring boot 是默认自动注册加载数据库相关的类文件的，所以为了不报错，我们需要打开数据库并在resource目录下的application.property中加入数据库配置相关文件，这里以mysql为例子，配置文件如下：
    application.properties中配置：
    spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false
    spring.datasource.username=root
    spring.datasource.password=root

3.运行项目：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 4][]

[http://localhost:8080/sayHello][http_localhost_8080_sayHello]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 5][]

4.传参数

/* url传参，访问的路径类似这样：localhost:8080/getParamDemo1/1
            * 方法体中的参数要在前面加注释，@PathVariable，代表url中的参数
     */
    
    @RequestMapping(path = {"/getParamDemo1/{id}"})
    public String getParamDemo1(@PathVariable("id") int userId){
        System.out.println("get param " + userId);
        return "success get param";
    }

[http://localhost:8080/getParamDemo1/1][http_localhost_8080_getParamDemo1_1]

/**
     * 当然，你也可以通过这种传参方式：localhost:8080/getParamDemo?param1=1或者直接表单提交参数
     * 当然，同时方法中参数声明的注释也要变成@RequestParam，代表请求参数，required属性说明了参数是否是必须的
     */
    @RequestMapping(path = {"/getParamDemo2"})
    public String getParamDemo2 (@RequestParam(value="param1",required = false) int param){
        System.out.println("get param " + param);
        return "success get param";
    }

[http://localhost:8080/getParamDemo2?param1=1][http_localhost_8080_getParamDemo2_param1_1]

5.**构建restful编程风格**

利用上面说的url中的值（类似这个：path="/member/\{userid\}"）进行资源定位，也非常符合resultful的风格要求，例如这path="/getParamDemo1/\{userid\}"的配置就是对应的就是对会员级别的某个用户（由userid定位）进行某些操作，如果要删除该用户，则对应http请求的delete请求即可。

@RequestMapping(path = {"/getParamDemo2"},method = RequestMethod.GET)
    public String getParamDemo2 (@RequestParam(value="param1",required = false) int param){
        System.out.println("get param " + param);
        return "success get param";
    }

6.**spring boot中配置数据库框架（以mybatis为例子）**

application.properties

\#下面这条配置声明了mybatis的配置文件路径，classpath对应的是和这个文件统计的resources mybatis.config-location=classpath:mybatis-config.xml

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    
        <settings>
            
            <setting name="cacheEnabled" value="true"/>
            
            <setting name="defaultStatementTimeout" value="3000"/>
            
            <setting name="mapUnderscoreToCamelCase" value="true"/>
            
            <setting name="useGeneratedKeys" value="true"/>
        </settings>
    
        
    
    </configuration>

package com.horse.red.dao;
    
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Select;
    
    import java.util.List;
    
    @Mapper
    public interface HelloDao {
    
        @Select({"select name from  user_info "})
        List<String> queryDemo();
    }

请求方法
     @Autowired
    private HelloDao helloDao;
    
     @RequestMapping("/sayHello")
     public String sayHello(){
         System.out.println("hello spring boot");
         List<String> names = helloDao.queryDemo();
         System.out.println(names.toString());
         return "hello spring boot";
     }

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 6][]

如果出现报错：

java.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

解决办法：

url后面增加：

jdbc.url=jdbc:mysql://localhost:3306/seckill?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC

试了很多次这个方法都不管用后来直接修改了时区。

修改数据库时区：

set global time\_zone = '+8:00'; \#\#修改mysql全局时区为北京时间，即我们所在的东8区  
  set time\_zone = '+8:00'; \#\#修改当前会话时区  
  flush privileges; \#立即生效

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 7][]

7.springboot跳转html页面

首先在pom文件中引入模板引擎jar包，即：

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

以及web支持
    <dependency>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

在application.properties中配置模板引擎

spring.thymeleaf.prefix=classpath:/templates/

是让controller层到templates文件夹寻找xx.html(src/main/resources/templates)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 8][]  
在templates下建立index.html文件

controller层

package com.horse.red.controller;
    
    
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    @Controller
    public class TestController {
    
        @RequestMapping("/test")
        public String test(){
            return "index";
        }
    
    }

在浏览器中地址栏输入：[http://localhost:8080/test][http_localhost_8080_test]

[https_start.spring.io]: https://start.spring.io/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70]: /images/20211109/b0fca9c342a9454ba14ad776b3e69505.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 1]: /images/20211109/7539ec2df52144669a0938ca1dee8a89.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 2]: /images/20211109/307d6b6435924023853f01e3454f1759.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 3]: /images/20211109/0dcd390198564abf807c9829706c604c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 4]: /images/20211109/be7bdbb8e8b34ddebc224926d8324d49.png
[http_localhost_8080_sayHello]: http://localhost:8080/sayHello
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 5]: /images/20211109/45bdc6bbecb145bd8b123a521862d837.png
[http_localhost_8080_getParamDemo1_1]: http://localhost:8080/getParamDemo1/1
[http_localhost_8080_getParamDemo2_param1_1]: http://localhost:8080/getParamDemo2?param1=1
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 6]: /images/20211109/1c7038e77c1d451dad55c3c65c4bcdff.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 7]: /images/20211109/0126c8b428e840fda5415e1c89ff1a1e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMxODQzMDc_size_16_color_FFFFFF_t_70 8]: /images/20211109/f0436a7ea49b4b50804b41b5bee81a23.png
[http_localhost_8080_test]: http://localhost:8080/test