记录SpringBoot使用Druid和Mybatis配置

1.Druid介绍也不专业，百度自查

主要几个配置：

先配置文件application.properties中：

server.port=8081#MVC配置spring.mvc.view.prefix = classpath:/templates/spring.mvc.view.suffix = .html#静态资源配置在conf/WebMvcConfig#使用Mysqlspring.datasource.type = com.alibaba.druid.pool.DruidDataSourcespring.datasource.url=jdbc:mysql://localhost:3307/websitespring.datasource.username=rootspring.datasource.password=spring.datasource.driverClassName=com.mysql.jdbc.Driver#连接池的配置信息  spring.datasource.initialSize=5  spring.datasource.minIdle=5  spring.datasource.maxActive=20  spring.datasource.maxWait=60000  spring.datasource.timeBetweenEvictionRunsMillis=60000  spring.datasource.minEvictableIdleTimeMillis=300000  spring.datasource.validationQuery=SELECT 1 FROM DUAL  spring.datasource.testWhileIdle=true  spring.datasource.testOnBorrow=false  spring.datasource.testOnReturn=false  spring.datasource.poolPreparedStatements=true  spring.datasource.maxPoolPreparedStatementPerConnectionSize=20  spring.datasource.filters=stat,wall,log4j  spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  #Mybatismybatis.config-locations=classpath:mybatis/mybatis-config.xmlmybatis.mapper-locations=classpath:mybatis/mapper/*.xmlmybatis.type-aliases-package=com.damionew.website.model

然后几个类

DruidDBConfig

import java.sql.SQLException;import javax.sql.DataSource;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import org.springframework.beans.factory.annotation.Value;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import org.springframework.context.annotation.Primary;import com.alibaba.druid.pool.DruidDataSource;  import com.alibaba.druid.support.http.StatViewServlet;  import com.alibaba.druid.support.http.WebStatFilter; @Configuration  public class DruidDBConfig {      private Logger logger = LoggerFactory.getLogger(DruidDBConfig.class);            @Value("${spring.datasource.url}")      private String dbUrl;            @Value("${spring.datasource.username}")      private String username;            @Value("${spring.datasource.password}")      private String password;            @Value("${spring.datasource.driverClassName}")      private String driverClassName;            @Value("${spring.datasource.initialSize}")      private int initialSize;            @Value("${spring.datasource.minIdle}")      private int minIdle;            @Value("${spring.datasource.maxActive}")      private int maxActive;            @Value("${spring.datasource.maxWait}")      private int maxWait;            @Value("${spring.datasource.timeBetweenEvictionRunsMillis}")      private int timeBetweenEvictionRunsMillis;            @Value("${spring.datasource.minEvictableIdleTimeMillis}")      private int minEvictableIdleTimeMillis;            @Value("${spring.datasource.validationQuery}")      private String validationQuery;            @Value("${spring.datasource.testWhileIdle}")      private boolean testWhileIdle;            @Value("${spring.datasource.testOnBorrow}")      private boolean testOnBorrow;            @Value("${spring.datasource.testOnReturn}")      private boolean testOnReturn;            @Value("${spring.datasource.poolPreparedStatements}")      private boolean poolPreparedStatements;            @Value("${spring.datasource.maxPoolPreparedStatementPerConnectionSize}")      private int maxPoolPreparedStatementPerConnectionSize;            @Value("${spring.datasource.filters}")      private String filters;            @Value("{spring.datasource.connectionProperties}")      private String connectionProperties;            @Bean     //声明其为Bean实例      @Primary  //在同样的DataSource中，首先使用被标注的DataSource      public DataSource dataSource(){          DruidDataSource datasource = new DruidDataSource();                    datasource.setUrl(this.dbUrl);          datasource.setUsername(username);          datasource.setPassword(password);          datasource.setDriverClassName(driverClassName);                    //configuration          datasource.setInitialSize(initialSize);          datasource.setMinIdle(minIdle);          datasource.setMaxActive(maxActive);          datasource.setMaxWait(maxWait);          datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);          datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);          datasource.setValidationQuery(validationQuery);          datasource.setTestWhileIdle(testWhileIdle);          datasource.setTestOnBorrow(testOnBorrow);          datasource.setTestOnReturn(testOnReturn);          datasource.setPoolPreparedStatements(poolPreparedStatements);          datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);          try {              datasource.setFilters(filters);          } catch (SQLException e) {              logger.error("druid configuration initialization filter", e);          }          datasource.setConnectionProperties(connectionProperties);                    return datasource;      }  }

DruidStatFilter

import javax.servlet.annotation.WebFilter;  import javax.servlet.annotation.WebInitParam;    import com.alibaba.druid.support.http.WebStatFilter;    @WebFilter(filterName="druidWebStatFilter",urlPatterns="/*",      initParams={          @WebInitParam(name="exclusions",value="*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*")//忽略资源     }  )  public class DruidStatFilter extends WebStatFilter {    }  

DruidStatViewServlet

@WebServlet(urlPatterns="/druid/*",      initParams={           @WebInitParam(name="allow",value=""),// IP白名单(没有配置或者为空，则允许所有访问)           @WebInitParam(name="deny",value=""),// IP黑名单 (存在共同时，deny优先于allow)           @WebInitParam(name="loginUsername",value="root"),// 用户名           @WebInitParam(name="loginPassword",value="123"),// 密码           @WebInitParam(name="resetEnable",value="false")// 禁用HTML页面上的“Reset All”功能  })  public class DruidStatViewServlet extends StatViewServlet {      private static final long serialVersionUID = -2688872071445249539L;    }  

这样，等下http://localhost:8081/druid/login.html登录时账号密码就是root，123

还有一个就是，在Application类中加上@ServletComponentScan

@ServletComponentScan@EnableWebMvc@SpringBootApplication@MapperScan("com.damionew.website.dao")public class Application extends WebMvcConfigurerAdapter{public static void main(String[] args) {SpringApplication.run(Application.class, args);}}

这样就可以显示数据库监控页面，页面是Druid生成的

然后Mybatis配置，心痛，当出现

Invalid bound statement (not found): com.damionew.website.dao.UserDao.insert

时，查了很久，在xml配置文件终于找到，mybatis.mapper-locations

手写的，手残少了s。。

详情还是这个http://blog.csdn.net/gebitan505/article/details/54929287自带demo的，使用xml配置

感觉只要配置文件路径正确，命名空间正确，就没啥毛病了