Spring框架

SpringAll开源教程

github开源教程：https://github.com/wuyouzhuguli/SpringAll

Spring Boot

开启Spring Boot

在https://start.spring.io/页面可以填写一个表格，来生成maven文件包，然后下载，在eclipse中选择import maven项目时将该包添加到maven项目中。这个一个简单的spring boot helloworld程序。

image-20210801183208332

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
// DemoApplication.java
package com.springboot.demo;

import org.springframework.boot.Banner;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
@SpringBootApplication
public class DemoApplication {

    @RequestMapping("/")
    String index() {
        return "hello spring boot";
    }
    
    /*public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }*/
    public static void main(String[] args) {
    	SpringApplication app = new SpringApplication(DemoApplication.class);
    	app.setBannerMode(Banner.Mode.OFF);
    	app.run(args);
    }
}

Spring Boot基础配置

全局配置文件

在src/main/resources目录下，Spring Boot提供了一个名为application.properties的全局配置文件，可对一些默认配置的配置值进行修改。

自定义属性值

image-20210801230001623

Spring Boot允许我们在application.properties下自定义一些属性，比如：

1
2
mrbird.blog.name=mrbird's blog
mrbird.blog.title=Spring Boot

定义一个BlogProperties Bean，通过@Value("${属性名}")来加载配置文件中的属性值：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
package com.springboot.demo;

import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Component;

@Component
public class BlogProperties {
    public String getName() {
		return this.name;
	}
	public String getTitle() {
		return this.title;
	}
	
    @Value("${mrbird.blog.name}")
    private String name;
    
    @Value("${mrbird.blog.title}")
    private String title;
}

编写IndexController，注入该Bean：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
package com.springboot.demo;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
public class IndexController {
    @Autowired
    private BlogProperties blogProperties;
    
    @RequestMapping("/")
    String index() {
        return blogProperties.getName()+"——"+blogProperties.getTitle();
    }
}

@Autowired标注会帮助我们的变量与配置文件中的内容进行自动匹配。

修改DemoApplication.java： 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
package com.springboot.demo;

import org.springframework.boot.Banner;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@SpringBootApplication
public class DemoApplication {
    
    /*public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }*/
    public static void main(String[] args) {
    	SpringApplication app = new SpringApplication(DemoApplication.class);
    	//app.setBannerMode(Banner.Mode.OFF);
    	app.run(args);
    }
}

在属性非常多的情况下，可以这样

1
2
3
4
5
6
7
8
9
10
11
12
// BlogProperties.java
package com.springboot.demo;

import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.context.properties.ConfigurationProperties;

@ConfigurationProperties(prefix="mrbird.blog")
public class BlogProperties {
	// get, set略
	private String name;
	private String title;
}

通过注解@ConfigurationProperties(prefix="mrbird.blog")指明了属性的通用前缀，通用前缀加属性名和配置文件的属性名一一对应。

除此之外还需在Spring Boot入口类加上注解@EnableConfigurationProperties({ConfigBean.class})来启用该配置：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
package com.springboot.demo;

import org.springframework.boot.Banner;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.context.properties.EnableConfigurationProperties;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@SpringBootApplication
@EnableConfigurationProperties({BlogProperties.class})
public class DemoApplication {
    
    /*public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }*/
    public static void main(String[] args) {
    	SpringApplication app = new SpringApplication(DemoApplication.class);
    	//app.setBannerMode(Banner.Mode.OFF);
    	app.run(args);
    }
}
属性间的引用
1
2
3
mrbird.blog.name=mrbird's blog
mrbird.blog.title=Spring Boot
mrbird.blog.wholeTitle=${mrbird.blog.name}--${mrbird.blog.title}

自定义配置文件

可以在/src/main/resources目录下新建一个自定义配置文件test.properties

1
2
test.name=zhou
test.age=22

定义一个对应该配置文件的Bean:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
package com.springboot.demo;

import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import org.springframework.stereotype.Component;

@Configuration
@ConfigurationProperties(prefix="test")
@PropertySource("classpath:test.properties")
@Component
public class TestConfigBean{
    private String name;
    private int age;
    
    public String getName(){
        return this.name;
    }
    public int getAge(){
        return this.age;
    }
    public void setName(String name) {
    	this.name = name;
    }
    public void setAge(int age) {
    	this.age = age;
    }
}

在入口类中使用注解@EnableConfigurationProperties({TestConfigBean.class})；同样地，也要改一下IndexController.java文件；TestConfigBean.java文件中没有import相应的包，eclipse会有提示应该import什么包。

通过命令行设置属性值

运行Spring Boot jar文件时，可以使用命令java -jar xxx.jar --server.port=8081来改变端口的值。这条命令等价于我们手动到application.properties中修改（如果没有这条属性的话就添加）server.port属性的值为8081。

Spring Boot中使用Mybatis

引入mybatis-spring-boot-starter和数据库连接驱动（这里使用关系型数据库Oracle 11g）

mybatis-spring-boot-starter

在pom中引入

1
2
3
4
5
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.2.0</version>
</dependency>

注意：version不能写2.2，否则会报：missing artifact

不同版本的Spring Boot和MyBatis版本对应不一样，具体可查看官方文档：http://www.mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/。

通过点击Dependency Hierarchy来查看依赖关系：

image-20210803194816092

引入ojdbc6

我们需要使用mvn命令将ojdbc6.jar依赖安装到本地maven仓库，然后才可以在pom中配置。

ojdbc6.jar的直接下载地址：https://files.cnblogs.com/files/luohaonan/ojdbc6.zip

解压到D盘根目录中后，执行：

1
mvn install:install-file -Dfile=D:/ojdbc6.jar -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=6.0 -Dpackaging=jar -DgeneratePom=true

输出为：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
[INFO] Scanning for projects...
Downloading from central: https://repo.maven.apache.org/maven2/org/apache/maven/plugins/maven-clean-plugin/2.5/maven-clean-plugin-2.5.pom
Downloaded from central: https://repo.maven.apache.org/maven2/org/apache/maven/plugins/maven-clean-plugin/2.5/maven-clean-plugin-2.5.pom (3.9 kB at 2.2 kB/s)
Downloading from central: https://repo.maven.apache.org/maven2/org/apache/maven/plugins/maven-plugins/22/maven-plugins-22.pom
Downloaded from central: https://repo.maven.apache.org/maven2/org/apache/maven/plugins/maven-plugins/22/maven-plugins-22.pom (13 kB at 26 kB/s)
Downloading from central: https://repo.maven.apache.org/maven2/org/apache/maven/plugins/maven-install-plugin/2.4/maven-install-plugin-2.4.pom
Downloaded from central: https://repo.maven.apache.org/maven2/org/apache/maven/plugins/maven-install-plugin/2.4/maven-install-plugin-2.4.pom (6.4 kB at 13 kB/s)
[INFO]
[INFO] ------------------< org.apache.maven:standalone-pom >-------------------
[INFO] Building Maven Stub Project (No POM) 1
[INFO] --------------------------------[ pom ]---------------------------------
[INFO]
[INFO] --- maven-install-plugin:2.4:install-file (default-cli) @ standalone-pom ---
Downloading from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus-utils/3.0.5/plexus-utils-3.0.5.pom
Downloaded from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus-utils/3.0.5/plexus-utils-3.0.5.pom (2.5 kB at 5.2 kB/s)
Downloading from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus/3.1/plexus-3.1.pom
Downloaded from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus/3.1/plexus-3.1.pom (19 kB at 37 kB/s)
Downloading from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus-digest/1.0/plexus-digest-1.0.pom
Downloaded from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus-digest/1.0/plexus-digest-1.0.pom (1.1 kB at 2.3 kB/s)
Downloading from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus-components/1.1.7/plexus-components-1.1.7.pom
Downloaded from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus-components/1.1.7/plexus-components-1.1.7.pom (5.0 kB at 4.6 kB/s)
Downloading from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus/1.0.8/plexus-1.0.8.pom
Downloaded from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus/1.0.8/plexus-1.0.8.pom (7.2 kB at 15 kB/s)
Downloading from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus-container-default/1.0-alpha-8/plexus-container-default-1.0-alpha-8.pom
Downloaded from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus-container-default/1.0-alpha-8/plexus-container-default-1.0-alpha-8.pom (7.3 kB at 15 kB/s)
Downloading from central: https://repo.maven.apache.org/maven2/classworlds/classworlds/1.1-alpha-2/classworlds-1.1-alpha-2.jar
Downloading from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus-digest/1.0/plexus-digest-1.0.jar
Downloading from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus-utils/3.0.5/plexus-utils-3.0.5.jar
Downloaded from central: https://repo.maven.apache.org/maven2/classworlds/classworlds/1.1-alpha-2/classworlds-1.1-alpha-2.jar (38 kB at 66 kB/s)
Downloaded from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus-digest/1.0/plexus-digest-1.0.jar (12 kB at 12 kB/s)
Downloaded from central: https://repo.maven.apache.org/maven2/org/codehaus/plexus/plexus-utils/3.0.5/plexus-utils-3.0.5.jar (230 kB at 152 kB/s)
[INFO] Installing D:\ojdbc6.jar to C:\Users\zhou2\.m2\repository\com\oracle\ojdbc6\6.0\ojdbc6-6.0.jar
[INFO] Installing C:\Users\zhou2\AppData\Local\Temp\mvninstall6943467979654797617.pom to C:\Users\zhou2\.m2\repository\com\oracle\ojdbc6\6.0\ojdbc6-6.0.pom
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time:  10.649 s
[INFO] Finished at: 2021-08-03T20:16:12+08:00
[INFO] ------------------------------------------------------------------------

接着在pom中引入:

1
2
3
4
5
<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>6.0</version>
</dependency>

Druid数据源

Druid是一个关系型数据库连接池，是阿里巴巴的一个开源项目，地址：https://github.com/alibaba/druid。Druid不但提供连接池的功能，还提供监控功能，可以实时查看数据库连接池和SQL查询的工作情况。

加入pom依赖

1
2
3
4
5
<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>druid-spring-boot-starter</artifactId>
	<version>1.2.6</version>
</dependency>

引入mysql驱动

加入pom依赖

1
2
3
4
<dependency>
	<groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
<version>8.0.26</version>

代码架构

image-20210810202601126

application.java

1
2
3
4
5
6
7
8
package com.springboot;

@SpringBootApplication
public class Application {
	public static void main(String[] args) {
		SpringApplication.run(Application.class, args);
	}
}

TestController.java

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
package com.springboot.controller;

import com.springboot.bean.Student;
import com.springboot.service.StudentService;

@RestController
public class TestController {
	@Autowired
	private StudentService studentService;
	
	@RequestMapping(value="/querystudent", method=RequestMethod.GET)
	public Student queryStudentBySno(String sno) {
		return this.studentService.queryStudentBySno(sno);
	}
}

Student.java

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
package com.springboot.bean;

import java.io.Serializable;

public class Student implements Serializable{
    private static final long serialVersionUID = -339516038496531943L;
    private String sno;
    private String sname;
    private String ssex;
    // get,set略
    public String getSno() {
		return sno;
	}
	public void setSno(String sno) {
		this.sno = sno;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String name) {
		this.sname = name;
	}
	public String getSsex() {
		return ssex;
	}
	public void setSsex(String sex) {
		this.ssex = sex;
	}
}

StudentMapper.java

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
package com.springboot.mapper;

import com.springboot.bean.Student;

@Component
@Mapper
public interface StudentMapper {
	@Insert("insert into student(sno,sname,ssex) values(#{sno},#{sname},#{ssex})")
    int add(Student student);
    
    @Update("update student set sname=#{sname},ssex=#{ssex} where sno=#{sno}")
    int update(Student student);
    
    @Delete("delete from student where sno=#{sno}")
    int deleteBysno(String sno);
    
    @Select("select * from student where sno=#{sno}")
    @Results(id = "student",value= {
        @Result(property = "sno", column = "sno", javaType = String.class),
        @Result(property = "sname", column = "sname", javaType = String.class),
        @Result(property = "ssex", column = "ssex", javaType = String.class)
    })
    Student queryStudentBySno(String sno);
}

StudentService.java

1
2
3
4
5
6
7
8
9
10
11
package com.springboot.service;

import com.springboot.bean.Student;

public interface StudentService {
	int add(Student student);
	int update(Student student);
	int deleteBySno(String sno);
	Student queryStudentBySno(String sno);
}

StudentServiceImp.java

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
package com.springboot.service.impl;

import com.springboot.bean.Student;
import com.springboot.mapper.StudentMapper;
import com.springboot.service.StudentService;

@Service("studentService")
public class StudentServiceImp implements StudentService {
	@Autowired
    private StudentMapper studentMapper;
    
    @Override
    public int add(Student student) {
        return this.studentMapper.add(student);
    }
    
    @Override
    public int update(Student student) {
        return this.studentMapper.update(student);
    }
    
    @Override
    public int deleteBySno(String sno) {
        return this.studentMapper.deleteBysno(sno);
    }
    
    @Override
    public Student queryStudentBySno(String sno) {
        return this.studentMapper.queryStudentBySno(sno);
    }
}

在test数据库中写如下SQL

1
2
3
4
5
6
7
8
9
CREATE TABLE student(
    sno varchar(100) PRIMARY KEY,
    sname varchar(100) NOT NULL,
    ssex varchar(100) NOT NULL
);

INSERT INTO student VALUES ('001', 'KangKang', 'M ');
INSERT INTO student VALUES ('002', 'Mike', 'M ');
INSERT INTO student VALUES ('003', 'Jane', 'F ');

application.yml

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
server:
  servlet:
    context-path: /web

spring:
  datasource:
    druid:
      # 数据库访问配置, 使用druid数据源
      type: com.alibaba.druid.pool.DruidDataSource
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8
      username: root
      password: zhou19981209
      initial-size: 5
      min-idle: 5
      max-active: 20
      max-wait: 5000
      # 状态监控
      filter:
        stat:
          enabled: true
          db-type: mysql
          log-slow-sql: true
          slow-sql-millis: 2000
      # 监控过滤器
      web-stat-filter:
        enabled: true
        exclusions:
        - "*.js"
        - "*.gif"
        - "*.jpg"
        - "*.png"
        - "*.css"
        - "*.ico"
        - "/druid/*"
      # druid 监控页面
      stat-view-servlet:
        enabled: true
        url-pattern: /druid/*
        reset-enable: false
        login-username: root
        login-password: root

参考 https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter#%E5%A6%82%E4%BD%95%E9%85%8D%E7%BD%AE-filter

  1. mysql驱动，所以spring.datasource.druid.driver-class-name是com.mysql.cj.jdbc.Driver；
  2. mysql要启动在3306端口，并创建test数据库，spring.datasource.druid.url是jdbc:mysql://localhost:3306/test
  3. 通过server.servlet.context-path改变服务器网址的根路径，比如我这里改成了/web。

运行

运行http://localhost:8080/web/querystudent?sno=001

image-20210810203547441

这里也出现过白页，是因为这个网址是访问public Student queryStudentBySno(String sno)函数的，但是在定义Student类的时候没有设置set和get。

运行http://localhost:8080/web/druid

image-20210810203650441

刚开始运行这里出现白页，是因为application.yml中context-path的配置搞错了，它的键是server.servlet.context-path而不是server.context-path。

引用

Spring官网：https://spring.io/

Spring Initializer: https://start.spring.io/

github开源教程：https://github.com/wuyouzhuguli/SpringAll

不同版本的Spring Boot和MyBatis版本对应不一样，具体可查看官方文档：http://www.mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/

Druid: https://github.com/alibaba/druid

赏

谢谢你请我吃糖果

扫一扫，分享到微信

微信分享二维码

tag:

    缺失模块。
    1、请确保node版本大于6.2
    2、在博客根目录（注意不是yilia根目录）执行以下命令：
    npm i hexo-generator-json-content --save

    3、在根目录_config.yml里添加配置： 

      jsonContent:
    meta: false
    pages: false
    posts:
      title: true
      date: true
      path: true
      text: false
      raw: false
      content: false
      slug: false
      updated: false
      comments: false
      link: false
      permalink: false
      excerpt: false
      categories: false
      tags: true

很惭愧<br><br>只做了一点微小的工作<br>谢谢大家