Spring事务之三（DriverManagerDataSource）

来源：互联网发布：网络研修中的困惑编辑：程序博客网时间：2024/05/21 15:43

更多文章请访问：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>

0 0