Spring事务之三（DriverManagerDataSource）

最新推荐文章于 2024-04-24 11:15:12 发布

bboyzqh

最新推荐文章于 2024-04-24 11:15:12 发布

阅读量4k

点赞数

文章标签： spring 事务 jdbc

本文链接：https://blog.csdn.net/zhuqiuhui/article/details/70307052

版权

更多文章请访问：http://zhuqiuhui.space/

org.springframework.jdbc.datasource.DriverManagerDataSource （实现了javax.sql.DataSource接口，Spring框架自带的数据源，不常用）：每个连接请求时都新建一个连接，DriverManagerDataSource提供的连接没有进行池管理，当连接数到达一定的大小会出现异常。参见DriverManagerDataSource源码：

public class DriverManagerDataSource extends AbstractDriverBasedDataSource {
    public DriverManagerDataSource() {
    }
 
    public DriverManagerDataSource(String url) {
        this.setUrl(url);
    }
 
    public DriverManagerDataSource(String url, String username, String password) {
        this.setUrl(url);
        this.setUsername(username);
        this.setPassword(password);
    }
 
    public DriverManagerDataSource(String url, Properties conProps) {
        this.setUrl(url);
        this.setConnectionProperties(conProps);
    }
 
    public void setDriverClassName(String driverClassName) {
        String driverClassNameToUse = driverClassName.trim();
 
        try {
            Class.forName(driverClassNameToUse, true, ClassUtils.getDefaultClassLoader());
        } catch (ClassNotFoundException var4) {
            throw new IllegalStateException("Could not load JDBC driver class [" + driverClassNameToUse + "]", var4);
        }
 
        if(this.logger.isInfoEnabled()) {
            this.logger.info("Loaded JDBC driver: " + driverClassNameToUse);
        }
 
    }
 
    protected Connection getConnectionFromDriver(Properties props) throws SQLException {
        String url = this.getUrl();
        if(this.logger.isDebugEnabled()) {
            this.logger.debug("Creating new JDBC DriverManager Connection to [" + url + "]");
        }
 
        return this.getConnectionFromDriverManager(url, props);
    }
 
    protected Connection getConnectionFromDriverManager(String url, Properties props) throws SQLException {
        return DriverManager.getConnection(url, props);  // 重要
    }
}

下面是Spring中实现DataSource接口的类图：

在Spring中的配置：

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/mybatisTest" />
        <property name="username" value="root" />
        <property name="password" value="123456" />
</bean>