基于注解的spring boot整合Druid

最新推荐文章于 2021-07-10 12:48:09 发布

zwjatjx

最新推荐文章于 2021-07-10 12:48:09 发布

阅读量369

点赞数 1

文章标签： spring druid

本文链接：https://blog.csdn.net/zwjatjx/article/details/72764867

版权

spring boot整合Druid很简单，参考Druid官方github文档可解决大部分问题

pom文件里加入jpa和Druid的依赖

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <scope>runtime</scope>
    </dependency>
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.0.28</version>
    </dependency>
</dependencies>

在配置文件里加入数据库相关的配置

spring.druid.dataSource.url=jdbc:mysql://10.211.55.8:3306/spring
spring.druid.dataSource.username=spring
#加密的密码
spring.druid.dataSource.password=aFdYuoFF6kTrgAU57N1eUVWax44rIWHI90oHIU01wQNOf5E56mx0y3IPVdOfsinWlGG2AGLzCBPeSyTqlogU0A==
spring.druid.dataSource.driver-class-name=com.mysql.jdbc.Driver
spring.druid.dataSource.initial-size=10
spring.druid.dataSource.max-active=30
druid.config.decrypt=true
#解密用到的public key
druid.config.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAIpmVDXMmG4TuhXGWBqjYwI1aTCAape7lVEK/MIvnnZIW+G54sAQe3llSwiMYkqs4EYpwu7rtgcU2f3yK51O7a8CAwEAAQ==

spring.jpa.properties.hibernate.hbm2ddl.auto=create-drop

编写Druid配置类DruidConfig

@Configuration
public class DruidConfig {
    @Autowired
    private Environment env;
    @Bean(name = "dataSource",initMethod = "init",destroyMethod = "close")
    @ConfigurationProperties(prefix = "spring.druid.dataSource")
    public DruidDataSource readDataSource(){
        DruidDataSource dataSource = new DruidDataSource();
        try {
            dataSource.setFilters("config");
            Properties properties = new Properties();
            properties.put("config.decrypt",env.getProperty("druid.config.decrypt"));
            properties.put("config.decrypt.key",env.getProperty("druid.config.decrypt.key"));
            dataSource.setConnectProperties(properties);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return dataSource;
    }
}

密码明文写在配置文件里是不安全的行为，所以这里对数据库连接密码进行了加密处理。Druid提供了ConfigFilter为数据库密码加密。
可以用Druid的ConfigTools生成加密后的数据库密码

public class Test {
    public static void main(String[] args) throws Exception{
        String password = "spring";
        String[] arr = ConfigTools.genKeyPair(512);
        System.out.println("privateKey:" + arr[0]);
        System.out.println("publicKey:" + arr[1]);
        System.out.println("password:" +ConfigTools.encrypt(arr[0], password));
    }
}

至此Druid的简单整合已经完成，可以在classpath里写个sql文件，里面写一个插入的sql语句，然后启动spring boot程序，看能否成功往数据库里插入数据
源码：https://github.com/Wenkiam/spring-boot-learning/tree/master/spring-boot-druid-demo