基于注解的spring boot整合Druid

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值