application.yml<\/code><\/li>\n<\/ul>\nspring:\n datasource:\n order:\n type: com.alibaba.druid.pool.DruidDataSource\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: ${spring.datasource.order.url}\n username: ${spring.datasource.order.username}\n password: ${spring.datasource.order.password}\n payment:\n type: com.alibaba.druid.pool.DruidDataSource\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: ${spring.datasource.payment.url}\n username: ${spring.datasource.payment.username}\n password: ${spring.datasource.payment.password}<\/code><\/pre>\n\napplication-env.yml<\/code><\/li>\n<\/ul>\nspring:\n datasource:\n order:\n url: jdbc:mysql:\/\/192.168.1.10:3306\/order?useUnicode=true&autoReconnect=true&characterEncoding=utf-8\n username: order\n password: ******\n filters: config\n connectionProperties: config.decrypt=true;config.decrypt.key=******\n payment:\n url: jdbc:mysql:\/\/192.168.1.10:3306\/payment?useUnicode=true&autoReconnect=true&characterEncoding=utf-8\n username: payment\n password: ******\n filters: config\n connectionProperties: config.decrypt=true;config.decrypt.key=******<\/code><\/pre>\n\u521b\u5efa\u6570\u636e\u6e90<\/h3>\n@Configuration\n@MapperScan(basePackages = "cn.appblog.mall.mapper.order", sqlSessionTemplateRef = "orderSqlSessionTemplate")\npublic class OrderDataSourceConfig {\n\n @Bean(name = "orderDataSource")\n @ConfigurationProperties(prefix = "spring.datasource.order")\n public DataSource orderDataSource() {\n \/\/return DruidDataSourceBuilder.create().build();\n return new MyDruidDataSource();\n }\n\n @Bean(name = "orderSqlSessionFactory")\n public SqlSessionFactory orderSqlSessionFactory(@Qualifier("orderDataSource") DataSource dataSource) throws Exception {\n SqlSessionFactoryBean bean = new SqlSessionFactoryBean();\n bean.setDataSource(dataSource);\n bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper\/order\/*.xml"));\n return bean.getObject();\n }\n\n @Bean(name = "orderTransactionManager")\n public DataSourceTransactionManager orderTransactionManager(@Qualifier("orderDataSource") DataSource dataSource) {\n return new DataSourceTransactionManager(dataSource);\n }\n\n @Bean(name = "orderSqlSessionTemplate")\n public SqlSessionTemplate orderSqlSessionTemplate(@Qualifier("orderSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {\n return new SqlSessionTemplate(sqlSessionFactory);\n }\n\n}<\/code><\/pre>\n@Configuration\n@MapperScan(basePackages = "cn.appblog.mall.mapper.payment", sqlSessionTemplateRef = "paymentSqlSessionTemplate")\npublic class OrderDataSourceConfig {\n ...\n}<\/code><\/pre>\n\u5982\u4f55\u914d\u7f6e Filter<\/h2>\n
\u53ef\u4ee5\u901a\u8fc7 spring.datasource.druid.filters=stat,wall,log4j ...<\/code> \u7684\u65b9\u5f0f\u6765\u542f\u7528\u76f8\u5e94\u7684\u5185\u7f6eFilter\uff0c\u4e0d\u8fc7\u8fd9\u4e9bFilter\u90fd\u662f\u9ed8\u8ba4\u914d\u7f6e\u3002\u5982\u679c\u9ed8\u8ba4\u914d\u7f6e\u4e0d\u80fd\u6ee1\u8db3\u9700\u6c42\uff0c\u53ef\u4ee5\u653e\u5f03\u8fd9\u79cd\u65b9\u5f0f\uff0c\u901a\u8fc7\u914d\u7f6e\u6587\u4ef6\u6765\u914d\u7f6eFilter\uff0c\u4e0b\u9762\u662f\u4f8b\u5b50\u3002<\/p>\n# \u914d\u7f6eStatFilter \nspring.datasource.druid.filter.stat.enabled=true\nspring.datasource.druid.filter.stat.db-type=h2\nspring.datasource.druid.filter.stat.log-slow-sql=true\nspring.datasource.druid.filter.stat.slow-sql-millis=2000\n\n# \u914d\u7f6eWallFilter \nspring.datasource.druid.filter.wall.enabled=true\nspring.datasource.druid.filter.wall.db-type=h2\nspring.datasource.druid.filter.wall.config.delete-allow=false\nspring.datasource.druid.filter.wall.config.drop-table-allow=false\n\n# \u5176\u4ed6 Filter \u914d\u7f6e\u4e0d\u518d\u6f14\u793a<\/code><\/pre>\n\u76ee\u524d\u4e3a\u4ee5\u4e0b Filter \u63d0\u4f9b\u4e86\u914d\u7f6e\u652f\u6301\uff0c\u8bf7\u53c2\u8003\u6587\u6863\u6216\u8005\u6839\u636eIDE\u63d0\u793a\uff08spring.datasource.druid.filter.*<\/code>\uff09\u8fdb\u884c\u914d\u7f6e\u3002<\/p>\n\n- StatFilter<\/li>\n
- WallFilter<\/li>\n
- ConfigFilter<\/li>\n
- EncodingConvertFilter<\/li>\n
- Slf4jLogFilter<\/li>\n
- Log4jFilter<\/li>\n
- Log4j2Filter<\/li>\n
- CommonsLogFilter<\/li>\n<\/ul>\n
\u8981\u60f3\u4f7f\u81ea\u5b9a\u4e49 Filter \u914d\u7f6e\u751f\u6548\u9700\u8981\u5c06\u5bf9\u5e94Filter\u7684enabled<\/code>\u8bbe\u7f6e\u4e3atrue<\/code>\uff0cDruid Spring Boot Starter \u9ed8\u8ba4\u7981\u7528StatFilter<\/code>\uff0c\u53ef\u4ee5\u5c06\u5176enabled<\/code>\u8bbe\u7f6e\u4e3atrue<\/code>\u6765\u542f\u7528\u5b83\u3002<\/p>\n\u5982\u4f55\u83b7\u53d6 Druid \u7684\u76d1\u63a7\u6570\u636e<\/h2>\n
Druid \u7684\u76d1\u63a7\u6570\u636e\u53ef\u4ee5\u5728\u5f00\u542fStatFilter<\/code>\u540e\u901a\u8fc7DruidStatManagerFacade<\/code>\u8fdb\u884c\u83b7\u53d6\uff0c\u83b7\u53d6\u5230\u76d1\u63a7\u6570\u636e\u4e4b\u540e\u53ef\u4ee5\u5c06\u5176\u66b4\u9732\u7ed9\u4f60\u7684\u76d1\u63a7\u7cfb\u7edf\u8fdb\u884c\u4f7f\u7528\u3002Druid \u9ed8\u8ba4\u7684\u76d1\u63a7\u7cfb\u7edf\u6570\u636e\u4e5f\u6765\u6e90\u4e8e\u6b64\u3002\u4e0b\u9762\u7ed9\u505a\u4e00\u4e2a\u7b80\u5355\u7684\u6f14\u793a\uff0c\u5728 Spring Boot \u4e2d\u5982\u4f55\u901a\u8fc7 HTTP \u63a5\u53e3\u5c06 Druid \u76d1\u63a7\u6570\u636e\u4ee5 JSON \u7684\u5f62\u5f0f\u66b4\u9732\u51fa\u53bb\uff0c\u5b9e\u9645\u4f7f\u7528\u4e2d\u53ef\u4ee5\u6839\u636e\u9700\u8981\u81ea\u7531\u5730\u5bf9\u76d1\u63a7\u6570\u636e\u3001\u66b4\u9732\u65b9\u5f0f\u8fdb\u884c\u6269\u5c55\u3002<\/p>\n@RestController\npublic class DruidStatController {\n @GetMapping("\/druid\/stat")\n public Object druidStat(){\n \/\/ DruidStatManagerFacade#getDataSourceStatDataList \u8be5\u65b9\u6cd5\u53ef\u4ee5\u83b7\u53d6\u6240\u6709\u6570\u636e\u6e90\u7684\u76d1\u63a7\u6570\u636e\uff0c\u9664\u6b64\u4e4b\u5916 DruidStatManagerFacade \u8fd8\u63d0\u4f9b\u4e86\u4e00\u4e9b\u5176\u4ed6\u65b9\u6cd5\uff0c\u53ef\u4ee5\u6309\u9700\u9009\u62e9\u4f7f\u7528\u3002\n return DruidStatManagerFacade.getInstance().getDataSourceStatDataList();\n }\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"Druid Spring Boot Starter Druid Spring Boot Starter \u7528\u4e8e\u5e2e […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[110],"class_list":["post-1919","post","type-post","status-publish","format-standard","hentry","category-spring-boot","tag-druid"],"_links":{"self":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1919","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/comments?post=1919"}],"version-history":[{"count":0,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1919\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/media?parent=1919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/categories?post=1919"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/tags?post=1919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}