Spring数据源配置-druid

一、手动配置

1、导入数据源坐标和数据库的依赖坐标

 <!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.2.8</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.27</version>
</dependency>

2、method-1:创建数据源、设置数据源参数、获得数据源、归还数据源

//创建数据源对象
DruidDataSource dataSource = new DruidDataSource();
//设置属性
dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
dataSource.setUrl("jdbc:mysql://localhost:3306/malldb");
dataSource.setUsername("root");
dataSource.setPassword("root");
//获取连接对象
Connection connection = dataSource.getConnection();
System.out.println(connection);
//通过连接对象执行相关操作。。。。
//释放连接
connection.close()

method-2:

step1:将配置信息放在xxx.properties中，本文放在db.properties

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/malldb
username=root
password=root

step2:从配置文件中读取配置信息

//创建Properties对象
Properties properties = new Properties();
//加载流
InputStream inputStream = TestDataSource.class.getResourceAsStream("/db.properties");
properties.load(inputStream);
//根据工厂创建数据源对象
DruidDataSource dataSource =
    (DruidDataSource) DruidDataSourceFactory.createDataSource(properties);
//获取连接对象
Connection connection = dataSource.getConnection();
System.out.println(connection);
//通过连接对象执行相关操作。。。。
//释放连接
connection.close();

二、使用Spring容器创建数据源

1、导入数据源坐标和数据库坐标

 <!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.2.8</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.27</version>
</dependency>

2、创建属性文件，xxx.properties,本文是jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driver 
jdbc.url=jdbc:mysql://127.0.0.1:3306/testdruid
jdbc.username=root 
jdbc.password=root

注意：username和password是关键字，key键不能取名为：uesrname和password

3、配置数据源对象

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd"> 
     <!--使用bean加载属性文件-->
     <!--<bean class="org.springframework.context.support.PropertySourcesPlaceholderConfigurer">
     <property name="location" value="jdbc.properties" />
     </bean>-->
     <!--使用context加载属性文件-->
     <context:property-placeholder location="jdbc.properties" />
     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
</beans>

三、测试代码

DruidDataSource dataSource = (DruidDataSource)ac.getBean("dataSource");
DruidPooledConnection connection = dataSource.getConnection();
System.out.println(connection);

 测试结果