spring boot 1.4 整合 mybatis盛末，使用 druid 數(shù)據(jù)庫(kù)連接池

項(xiàng)目結(jié)構(gòu)目錄 ##

結(jié)構(gòu)

maven 引入 spring boot 開(kāi)發(fā)依賴

  <parent>  
    <groupId>org.springframework.boot</groupId> 
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>1.4.0.RELEASE</version>
  </parent>
  <properties>  
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  </properties>
  <dependencies>  
    <dependency>
     <groupId>org.springframework.boot</groupId>   
     <artifactId>spring-boot-starter-thymeleaf</artifactId>    
    </dependency>  
    <dependency>    
      <groupId>org.springframework.boot</groupId>    
      <artifactId>spring-boot-starter-test</artifactId>     
    </dependency>  
    <!--    devtools可以實(shí)現(xiàn)頁(yè)面熱部署（即頁(yè)面修改后會(huì)立即生效弹惦，這個(gè)可以直接在application.properties文件中配置spring.thymeleaf.cache=false來(lái)實(shí)現(xiàn)），   
     實(shí)現(xiàn)類文件熱部署（類文件修改后不會(huì)立即生效）悄但，實(shí)現(xiàn)對(duì)屬性文件的熱部署棠隐。    即devtools會(huì)監(jiān)聽(tīng)classpath下的文件變動(dòng)，并且會(huì)立即重啟應(yīng)用（發(fā)生在保存時(shí)機(jī)）檐嚣，注意：因?yàn)槠洳捎玫奶摂M機(jī)機(jī)制助泽，該項(xiàng)重啟是很快的  -->  
    <dependency>    
      <groupId>org.springframework.boot</groupId>    
      <artifactId>spring-boot-devtools</artifactId>    
      <optional>true</optional>  
    </dependency>  
    <!-- mybatis -->  
    <dependency>    
      <groupId>org.mybatis.spring.boot</groupId>    
      <artifactId>mybatis-spring-boot-starter</artifactId>    
      <version>1.1.1</version>  
    </dependency>  
    <!-- mybatis 分頁(yè)插件 -->  
    <dependency>    
      <groupId>com.github.pagehelper</groupId>    
      <artifactId>pagehelper</artifactId>    
      <version>4.1.6</version>  
    </dependency>  
    <!--mysql-->  
    <dependency>    
      <groupId>mysql</groupId>    
      <artifactId>mysql-connector-java</artifactId>  
    </dependency>  
    <!--druid-->  
    <dependency>    
      <groupId>com.alibaba</groupId>    
      <artifactId>druid</artifactId>    
      <version>1.0.20</version>  
    </dependency>
  </dependencies>

  <build>  
    <finalName>spring-boot-druid</finalName>  
    <plugins>    
      <plugin>      
        <groupId>org.springframework.boot</groupId>      
        <artifactId>spring-boot-maven-plugin</artifactId>    
      </plugin>  
    </plugins>  
    <resources>    
      <resource>      
        <directory>src/main/java</directory>      
        <includes>        
          <!-- 我習(xí)慣將mybatis的配置xml放在java目錄下 -->        
          <include>**/*.xml</include>      
        </includes>      
        <filtering>true</filtering>    
      </resource>    
      <resource>      
        <directory>src/main/resources</directory>      
        <includes>        
          <include>**/*</include>      
        </includes>      
        <filtering>true</filtering>    
      </resource>  
    </resources>
  </build>

application.properties

數(shù)據(jù)庫(kù)連接信息與 druid 的連接池配置信息
thymeleaf 模板的配置

#數(shù)據(jù)庫(kù)配置
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://192.168.1.28:3306/chidu
spring.datasource.username=root
spring.datasource.password=1qaz2WSX
# 下面為連接池的補(bǔ)充設(shè)置，應(yīng)用到上面所有數(shù)據(jù)源中# 初始化大小嚎京，最小嗡贺，最大
spring.datasource.initialSize=5
spring.datasource.minIdle=5
spring.datasource.maxActive=20
# 配置獲取連接等待超時(shí)的時(shí)間
spring.datasource.maxWait=60000
# 配置間隔多久才進(jìn)行一次檢測(cè)，檢測(cè)需要關(guān)閉的空閑連接鞍帝，單位是毫秒
spring.datasource.timeBetweenEvictionRunsMillis=60000
# 配置一個(gè)連接在池中最小生存的時(shí)間诫睬，單位是毫秒
spring.datasource.minEvictableIdleTimeMillis=300000
spring.datasource.validationQuery=SELECT 1 FROM DUAL
spring.datasource.testWhileIdle=true
spring.datasource.testOnBorrow=false
spring.datasource.testOnReturn=false
# 打開(kāi)PSCache，并且指定每個(gè)連接上PSCache的大小
spring.datasource.poolPreparedStatements=true
spring.datasource.maxPoolPreparedStatementPerConnectionSize=20
# 配置監(jiān)控統(tǒng)計(jì)攔截的filters帕涌，去掉后監(jiān)控界面sql無(wú)法統(tǒng)計(jì)摄凡，'wall'用于防火墻
spring.datasource.filters=stat,wall,log4j
# 通過(guò)connectProperties屬性來(lái)打開(kāi)mergeSql功能；慢SQL記錄
spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
# 合并多個(gè)DruidDataSource的監(jiān)控?cái)?shù)據(jù)
#spring.datasource.useGlobalDataSourceStat=true

#視圖模型
spring.thymeleaf.prefix=classpath:/templates/
spring.thymeleaf.suffix=.html
spring.thymeleaf.cache=false
spring.thymeleaf.mode=HTML5
spring.thymeleaf.encoding=UTF-8
spring.thymeleaf.content-type=text/html
spring.thymeleaf.check-template-location=true

main 方法入口

package liangchong998;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
/** * 程序入口 * */
@SpringBootApplication
public class App {    
    public static void main( String[] args ) {   
       SpringApplication.run(App.class, args);    
    }
}

注冊(cè)數(shù)據(jù)庫(kù)

package liangchong998.base;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.util.StringUtils;
import com.github.pagehelper.PageHelper;
import org.apache.ibatis.plugin.Interceptor;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.bind.RelaxedPropertyResolver;
import org.springframework.context.ApplicationContextException;
import org.springframework.context.EnvironmentAware;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.env.Environment;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import java.io.IOException;
import java.sql.SQLException;
import java.util.Arrays;
import java.util.Properties;
/** 
 * Created by liangchong998 on 2016/8/18. 
 */
@Configuration
@EnableTransactionManagement
@MapperScan(value = "liangchong998.mapper")
public class DatabaseConfiguration implements EnvironmentAware { 
    private Environment environment; 
    private RelaxedPropertyResolver propertyResolver; 
    @Override 
    public void setEnvironment(Environment environment) { 
      this.environment = environment; 
      this.propertyResolver = new RelaxedPropertyResolver(environment,"spring.datasource."); 
    } 
    //注冊(cè)dataSource 
    @Bean(initMethod = "init", destroyMethod = "close") 
    public DruidDataSource dataSource() throws SQLException { 
      if (StringUtils.isEmpty(propertyResolver.getProperty("url"))) { 
        System.out.println("Your database connection pool configuration is incorrect!" 
            + " Please check your Spring profile, current profiles are:"
            + Arrays.toString(environment.getActiveProfiles())); 
         throw new ApplicationContextException( 
            "Database connection pool is not configured correctly"); 
      } 
      DruidDataSource druidDataSource = new DruidDataSource(); 
      druidDataSource.setDriverClassName(propertyResolver.getProperty("driver-class-name")); 
      druidDataSource.setUrl(propertyResolver.getProperty("url")); 
      druidDataSource.setUsername(propertyResolver.getProperty("username")); 
      druidDataSource.setPassword(propertyResolver.getProperty("password")); 
      druidDataSource.setInitialSize(Integer.parseInt(propertyResolver.getProperty("initialSize"))); 
      druidDataSource.setMinIdle(Integer.parseInt(propertyResolver.getProperty("minIdle"))); 
      druidDataSource.setMaxActive(Integer.parseInt(propertyResolver.getProperty("maxActive"))); 
      druidDataSource.setMaxWait(Integer.parseInt(propertyResolver.getProperty("maxWait"))); 
      druidDataSource.setTimeBetweenEvictionRunsMillis(Long.parseLong(propertyResolver.getProperty("timeBetweenEvictionRunsMillis"))); 
      druidDataSource.setMinEvictableIdleTimeMillis(Long.parseLong(propertyResolver.getProperty("minEvictableIdleTimeMillis"))); 
      druidDataSource.setValidationQuery(propertyResolver.getProperty("validationQuery")); 
      druidDataSource.setTestWhileIdle(Boolean.parseBoolean(propertyResolver.getProperty("testWhileIdle"))); 
      druidDataSource.setTestOnBorrow(Boolean.parseBoolean(propertyResolver.getProperty("testOnBorrow"))); 
      druidDataSource.setTestOnReturn(Boolean.parseBoolean(propertyResolver.getProperty("testOnReturn"))); 
      druidDataSource.setPoolPreparedStatements(Boolean.parseBoolean(propertyResolver.getProperty("poolPreparedStatements"))); 
      druidDataSource.setMaxPoolPreparedStatementPerConnectionSize(Integer.parseInt(propertyResolver.getProperty("maxPoolPreparedStatementPerConnectionSize"))); 
      druidDataSource.setFilters(propertyResolver.getProperty("filters")); 
      return druidDataSource; 
    } 

    @Bean public SqlSessionFactory sqlSessionFactory() throws Exception { 
      SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean(); 
      sqlSessionFactoryBean.setDataSource(dataSource()); 
      //mybatis分頁(yè) 
      PageHelper pageHelper = new PageHelper(); 
      Properties props = new Properties(); 
      props.setProperty("dialect", "mysql"); 
      props.setProperty("reasonable", "true"); 
      props.setProperty("supportMethodsArguments", "true"); 
      props.setProperty("returnPageInfo", "check"); 
      props.setProperty("params", "count=countSql"); 
      pageHelper.setProperties(props); //添加插件 
      sqlSessionFactoryBean.setPlugins(new Interceptor[]{pageHelper}); 
      PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver(); 
      sqlSessionFactoryBean.setMapperLocations(resolver.getResources("classpath:/liangchong998/mybatis/*.xml")); 
      return sqlSessionFactoryBean.getObject(); 
    } 
    @Bean public PlatformTransactionManager transactionManager() throws SQLException { 
      return new DataSourceTransactionManager(dataSource()); 
    }
}

druid 開(kāi)啟監(jiān)控

package liangchong998.base;

import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
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;
/** 
 * Created by liangchong998 on 2016/8/18. 
 */
@Configuration
public class DruidConfig { 
  @Bean 
  public ServletRegistrationBean druidServlet() { 
    ServletRegistrationBean reg = new ServletRegistrationBean(); 
    reg.setServlet(new StatViewServlet()); 
    reg.addUrlMappings("/druid/*"); 
    //reg.addInitParameter("allow", "127.0.0.1"); //白名單 
    //reg.addInitParameter("deny",""); //黑名單 
    reg.addInitParameter("loginUsername", "admin"); 
    reg.addInitParameter("loginPassword", "admin"); 
    return reg; 
  } 

  @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; 
   }
}

controller###

返回index視圖蚓曼，并傳遞參數(shù)

package liangchong998.controller;
import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import liangchong998.mapper.UserInfoMapper;
import liangchong998.model.UserInfo;
import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import java.util.List;
/** 
 * Created by liangchong998 on 2016/8/18. 
 */
@Controllerpublic class HomeController { 

    private Logger logger = Logger.getLogger(HomeController.class); 

    @Autowired private UserInfoMapper userInfoMapper; 

    @RequestMapping(value = "/", method = RequestMethod.GET) 
    public String index(Model Model){ 
      Model.addAttribute("name","liangchong998"); 
      return "index"; 
    }
}

index.html

在 resources 中新建文件夾 templates
新建 index.html此處注意頭文件亲澡，這地方是個(gè)坑
IDEA 中 ${name} 下一直有個(gè)紅線報(bào)錯(cuò)，不過(guò)不影響程序辟躏，也不知道是什么原因谷扣。

<!DOCTYPE html SYSTEM "http://www.thymeleaf.org/dtd/xhtml1-strict-thymeleaf-spring4-4.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:th="http://www.thymeleaf.org">
<head> 
    <meta charset="UTF-8" /> 
    <title>Title</title>
</head>
<body>
  <h2>hello <span th:text="${name}">word</span></h2>
</body>
</html>

運(yùn)行 main 方法
輸入 localhost:8080/

瀏覽器

項(xiàng)目 Github ：Github 地址