基于注解的spring boot整合Druid

来源：互联网发布：java进程间通信编辑：程序博客网时间：2024/05/31 05:27

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/springspring.druid.dataSource.username=spring#加密的密码spring.druid.dataSource.password=aFdYuoFF6kTrgAU57N1eUVWax44rIWHI90oHIU01wQNOf5E56mx0y3IPVdOfsinWlGG2AGLzCBPeSyTqlogU0A==spring.druid.dataSource.driver-class-name=com.mysql.jdbc.Driverspring.druid.dataSource.initial-size=10spring.druid.dataSource.max-active=30druid.config.decrypt=true#解密用到的public keydruid.config.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAIpmVDXMmG4TuhXGWBqjYwI1aTCAape7lVEK/MIvnnZIW+G54sAQe3llSwiMYkqs4EYpwu7rtgcU2f3yK51O7a8CAwEAAQ==spring.jpa.properties.hibernate.hbm2ddl.auto=create-drop

编写Druid配置类DruidConfig

@Configurationpublic 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

阅读全文

0 0