記錄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配置

感覺只要設定檔路徑正確，命名空間正確，就沒啥毛病了