<p class="shortdesc">pafa-cloud-support-jdbc支持tomcat、hikarCP等连接池，默认使用hikarCP连接池，druid可自行整合。</p> <section class="section" id="Single_data_source__section_hzg_pjg_bsb"><h2 class="doc-tairway">适用场景</h2> <p class="p">单个服务进程只有一个数据库的场景、微服务场景。</p> </section> <section class="section" id="Single_data_source__section_czx_qjg_bsb"><h2 class="doc-tairway">准备工作</h2> <p class="p">完成开发环境搭建。</p> </section> <section class="section" id="Single_data_source__section_pbh_tjg_bsb"><h2 class="doc-tairway">接入指南</h2> <ol class="ol" id="Single_data_source__ol_bjh_5jg_bsb"> <li class="li"><strong class="ph b">pom.xml引入pafa-cloud-support-jdbc依赖</strong>。<div class="p"> <pre class="pre codeblock" id="Single_data_source__codeblock_cjb_vjg_bsb"><code><dependencyManagement> <dependencies> <dependency> <groupId>com.pingan.pafa.cloud</groupId> <artifactId>pafa-cloud-dependencies</artifactId> <version>{版本参考核心框架简介}</version> <type>pom</type> <scope>import</scope> </dependency> </dependencies> </dependencyManagement> <dependencies> <dependency> <groupId>com.pingan.pafa.cloud</groupId> <artifactId>pafa-cloud-service-starter</artifactId> </dependency> <dependency> <groupId>com.pingan.pafa.cloud</groupId> <artifactId>pafa-cloud-support-jdbc</artifactId> </dependency> <!-- 按照实际从下面选择合适的数据库驱动 --> <dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifactId> <version>42.2.2</version> </dependency> <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc6</artifactId> <version>11.2.0.4.0</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.11</version> </dependency> </dependencies></code></pre> </div><p class="p">注：spring boot默认使用的连接池为tomcat的实现的连接池，pafa-cloud-support-jdbc默认使用hikariCP连接池，性能更佳更稳定。</p><p class="p">参考文章：<a class="xref" href="http://www.cnblogs.com/xingzc/p/6073730.html" target="_blank" rel="external noopener">http://www.cnblogs.com/xingzc/p/6073730.html</a></p></li> <li class="li"><strong class="ph b">配置说明</strong><p class="p">spring.datasource前缀的为数据库公用配置。</p><p class="p">spring.datasource.hikari为HikariCP对应配置。</p><p class="p">按照上述的配置写法，spring boot会默认加载hikariCP数据库连接池配置以及数据库连接、用户、密码、驱动类配置。</p><p class="p">请参考“<a class="xref" href="https://github.com/brettwooldridge/HikariCP" target="_blank" rel="external noopener">hikariCP</a>”文档。</p><div class="p"> <pre class="pre codeblock" id="Single_data_source__codeblock_ik5_ckg_bsb"><code>spring.datasource.url=jdbc:postgresql://1.1.1.1:5432/test spring.datasource.username=**** spring.datasource.password=**** spring.datasource.driver-class-name=org.postgresql.Driver spring.datasource.hikari.max-wait=10000 spring.datasource.hikari.maximum-pool-size=200 spring.datasource.hikari.test-on-borrow=true spring.datasource.hikari.initial-size=10 spring.datasource.hikari.idleTimeout=30000 spring.datasource.hikari.connectionTimeout=60000 spring.datasource.hikari.autoCommit=false</code></pre> </div></li> <li class="li"><strong class="ph b">设置mybaties的Mapper扫描</strong><div class="p"> <pre class="pre codeblock" id="Single_data_source__codeblock_pnb_fkg_bsb"><code>mybatis.mapper-locations=classpath:mapper/*.xml mybatis.type-aliases-package=com.pingan.pafa.cloud.mybatis.mybatisdemo.mapper</code></pre> </div><p class="p">注：参考UserInfoMapper类。</p></li> <li class="li"><strong class="ph b">事务开启，启动类需添加<a class="xref" href="https://github.com/EnableTransactionManagement" target="_blank" rel="external noopener">@EnableTransactionManagement</a>注解即可</strong><table class="table" id="Single_data_source__table_lql_hkg_bsb"><caption></caption><colgroup><col><col><col><col></colgroup><thead class="thead"> <tr class="row"> <th class="entry" id="Single_data_source__table_lql_hkg_bsb__entry__1">名称</th> <th class="entry" id="Single_data_source__table_lql_hkg_bsb__entry__2">是否必填</th> <th class="entry" id="Single_data_source__table_lql_hkg_bsb__entry__3">说明</th> <th class="entry" id="Single_data_source__table_lql_hkg_bsb__entry__4">默认值</th> </tr> </thead><tbody class="tbody"> <tr class="row"> <td class="entry" headers="Single_data_source__table_lql_hkg_bsb__entry__1 "> <p class="p">pafa.cloud.mybatis.row-interceptor.maxRows</p> </td> <td class="entry" headers="Single_data_source__table_lql_hkg_bsb__entry__2 "> <p class="p">否</p> </td> <td class="entry" headers="Single_data_source__table_lql_hkg_bsb__entry__3 "> <p class="p">限制每次查询最大条数。适用PAFA CLOUD 2.x版本</p> </td> <td class="entry" headers="Single_data_source__table_lql_hkg_bsb__entry__4 "> <p class="p">10000</p> </td> </tr> <tr class="row"> <td class="entry" headers="Single_data_source__table_lql_hkg_bsb__entry__1 "> <p class="p">mybatis.custom.maxRows</p> </td> <td class="entry" headers="Single_data_source__table_lql_hkg_bsb__entry__2 "> <p class="p">否</p> </td> <td class="entry" headers="Single_data_source__table_lql_hkg_bsb__entry__3 "> <p class="p">限制每次查询最大条数。适用PAFA CLOUD 1.x版本</p> </td> <td class="entry" headers="Single_data_source__table_lql_hkg_bsb__entry__4 "> <p class="p">10000</p> </td> </tr> </tbody></table></li> </ol> </section>