1.pom.xml需要导入的项目依赖
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>joda-time</groupId>
<artifactId>joda-time</artifactId>
<version>2.10.13</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
</dependency>
<dependency>
<groupId>org.codehaus.jackson</groupId>
<artifactId>jackson-mapper-asl</artifactId>
<version>1.9.13</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.4</version>
</dependency>
</dependencies>
2.application.yml
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/数据库名?useUnicode=true&characterEncoding=utf8
username: 用户名
password: 密码
#spring boot 默认不注入这些属性值需要自己配置
#druid 数据源专有配置
initialSize: 5
minIdle: 5
maxActive: 20
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
mi nEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
#配置监控统计拦截的filters, stat:监控统计、Log4j:日志记录、waLl:防御sqL注入
#如果允许时报错java.Lang.CLassNotFoundException: org.apache.Log4j.Priority
#则导入log4j依赖即可,Maven地址: https://mvnrepository.com/artifact/Log4j/Log4j
filters: stat,wall,log4j
maxPoolPreparedStatementPerConnectionSize: 20
useGloba1DataSourcestat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlillis=500
mybatis:
type-aliases-package: com.example.pojo
mapper-locations: classpath:mapper
3.pojo
public class RainManage {
private Integer id ;
private String districtName;
@DateTimeFormat(pattern = "yyyy-MM-dd")
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone="GMT+8")
private Date monitorTime ;
private Integer rain ;
private String monitoringStation;
private String monitoringAddress;
public RainManage() {
}
public RainManage(String districtName, Date monitorTime, Integer rain, String monitoringStation, String monitoringAddress) {
this.districtName = districtName;
this.monitorTime = monitorTime;
this.rain = rain;
this.monitoringStation = monitoringStation;
this.monitoringAddress = monitoringAddress;
}
public RainManage(Integer id, String districtName, Date monitorTime, Integer rain, String monitoringStation, String monitoringAddress) {
this.id = id;
this.districtName = districtName;
this.monitorTime = monitorTime;
this.rain = rain;
this.monitoringStation = monitoringStation;
this.monitoringAddress = monitoringAddress;
}
public void setId(Integer id) {
this.id = id;
}
public void setDistrictName(String districtName) {
this.districtName = districtName;
}
public void setMonitorTime(Date monitorTime) {
this.monitorTime = monitorTime;
}
public void setRain(Integer rain) {