springboot搭建web（整合mybatis）（四）

1、application.properties

###datasource
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:oracatt
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver

###mybatis
mybatis.mapperLocations=classpath:com/arrome/mapping/*.xml

2、写Controller、mapper、service即可，通过mybatis持久化数据

3、整合数据源druid
application.properties中添加

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.filters=stat,wall
spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

同时java配置

import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;

@Configuration
public class DruidConfiguration {
        @Bean 
        public ServletRegistrationBean druidServlet() {
            return new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
        }

        @Bean 
        public FilterRegistrationBean filterRegistrationBean() {
            FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();
            filterRegistrationBean.setFilter(new WebStatFilter());
            filterRegistrationBean.addUrlPatterns("/*");
            filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
            return filterRegistrationBean;
        }
}

这样就添加了数据源druid，可以通过路径http://localhost:8081/demo_boot/druid/index.html访问druid内置监控页面