{"id":1918,"date":"2023-04-01T09:30:21","date_gmt":"2023-04-01T01:30:21","guid":{"rendered":"https:\/\/www.appblog.cn\/?p=1918"},"modified":"2023-04-22T08:52:43","modified_gmt":"2023-04-22T00:52:43","slug":"druid-custom-filter-implementation","status":"publish","type":"post","link":"https:\/\/www.appblog.cn\/index.php\/2023\/04\/01\/druid-custom-filter-implementation\/","title":{"rendered":"Druid\u81ea\u5b9a\u4e49Filter\u5b9e\u73b0"},"content":{"rendered":"<p>\u53c2\u8003\uff1a<a target=\"_blank\" rel=\"noopener\" href=\"https:\/\/github.com\/alibaba\/druid\/blob\/master\/src\/main\/java\/com\/alibaba\/druid\/filter\/config\/ConfigFilter.java\">https:\/\/github.com\/alibaba\/druid\/blob\/master\/src\/main\/java\/com\/alibaba\/druid\/filter\/config\/ConfigFilter.java<\/a><\/p>\n<p>\u65b0\u5efa\u914d\u7f6e\u6587\u4ef6\uff1a<code>META-INF\/druid-filter.properties<\/code><\/p>\n<pre><code>druid.filters.myfilter=cn.appblog.mall.dao.filter.FilterAdapter<\/code><\/pre>\n<p><!-- more --><\/p>\n<pre><code class=\"language-yml\">spring:\n  datasource:\n    appblog:\n      type: com.alibaba.druid.pool.DruidDataSource\n      driver-class-name: com.mysql.cj.jdbc.Driver\n      url: jdbc:mysql:\/\/192.168.1.10:3306\/appblog?useUnicode=true&amp;autoReconnect=true&amp;characterEncoding=utf-8\n      username: appblog\n      password: Up58k0xJr7C2kcVFTGrnxRlyPBsj7DPeKjMYUAHxWQfjighJLheMrDIlp7Xj8r5Ad1I8Q+qh5WwnCv5kFyWlTQ==\n      filters: config,myfilter\n      connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=3000;config.decrypt=true;config.decrypt.key=MFwwDQYJKoZIhvcNa5EBkQADSwAwSAJ6ALYHjdmAVAm79Ao3MbruNxsWM76Ifz+qaN8sOZesMKvYCJdpxLFLtmo6bNkpYkzk+OAYhXf7U8r0+dZngOy0RnMCAwEAAQ==<\/code><\/pre>\n<pre><code class=\"language-java\">@Slf4j\n@Component\npublic class MyDruidFilter extends FilterAdapter {\n\n    @Override\n    public void init(DataSourceProxy dataSourceProxy) {\n        if (!(dataSourceProxy instanceof DruidDataSource)) {\n            log.error(&quot;ConfigLoader only support DruidDataSource&quot;);\n        }\n        DruidDataSource dataSource = (DruidDataSource) dataSourceProxy;\n        log.info(&quot;db configuration: url=&quot; + dataSource.getUrl());\n\n        Properties properties = dataSource.getConnectProperties();\n        String password = dataSource.getPassword();\n        log.info(&quot;password: {}&quot;, password);\n        try {\n            PublicKey publicKey = getPublicKey(properties);\n            password = ConfigTools.decrypt(publicKey, password);\n            log.info(&quot;password: {}&quot;, password);\n        } catch (Exception e) {\n            log.warn(&quot;DataSource password decrypt error.&quot;, e);\n        }\n        \/\/dataSource.setPassword(password);\n        try {\n            \/\/ \u5c06\u4fe1\u606f\u914d\u7f6e\u8fdbDruid\n            DruidDataSourceFactory.config(dataSource, properties);\n        } catch (Exception e) {\n            log.error(&quot;DataSource config error.&quot;, e);\n        }\n    }\n\n    @Override\n    public ConnectionProxy connection_connect(FilterChain chain, Properties info) throws SQLException {\n        DruidDataSource dataSource = (DruidDataSource) chain.getDataSource();\n        if (dataSource.isInited()) {\n\n        }\n        return super.connection_connect(chain, info);\n    }\n\n    public PublicKey getPublicKey(Properties connectionProperties) {\n        String key = connectionProperties.getProperty(&quot;config.decrypt.key&quot;);\n        log.info(&quot;config.decrypt.key: {}&quot;, key);\n\n        if (StringUtils.isEmpty(key)) {\n            key = System.getProperty(&quot;druid.config.decrypt.key&quot;);\n            log.info(&quot;druid.config.decrypt.key: {}&quot;, key);\n        }\n\n        return ConfigTools.getPublicKey(key);\n    }\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u53c2\u8003\uff1ahttps:\/\/github.com\/alibaba\/druid\/blob\/master\/src\/mai [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[110],"class_list":["post-1918","post","type-post","status-publish","format-standard","hentry","category-database","tag-druid"],"_links":{"self":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1918","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=1918"}],"version-history":[{"count":0,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1918\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/media?parent=1918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/categories?post=1918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/tags?post=1918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}