Java框架--资源文件配置

╰+攻爆jí腚メ 2022-07-12 23:20 162阅读 0赞

jdbc.properties  放在classptah目录下

datasource.type=mysql
    datasource.driverClassName=com.mysql.jdbc.Driver
    datasource.url=jdbc\:mysql\://127.0.0.1\:3306/tzexam?useUnicode\=true&characterEncoding\=UTF-8
    datasource.username=rw_all_db
    datasource.password=rw_all_db
    hibernate.dialect=org.hibernate.dialect.MySQLDialect
    
    
    #datasource.type=oracle
    #datasource.driverClassName=oracle.jdbc.driver.OracleDriver
    #datasource.url=jdbc\:oracle\:thin\:@192.168.1.88\:1521\:tzexam?useUnicode\=true&characterEncoding\=utf-8 
    #datasource.username=root
    #datasource.password=root
    #hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

applicationContext.xml

EL表达式方式取值

<context:property-placeholder location="classpath:jdbc.properties"/> 
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    	    <property name="driverClassName" value="${datasource.driverClassName}"></property>  
    	    <property name="url" value="${datasource.url}"></property>  
    	    <property name="username" value="${datasource.username}"></property>  
    	    <property name="password" value="${datasource.password}"></property>  
    	</bean>

测试类

package com.test;
    
    import java.sql.SQLException;
    
    import org.apache.commons.dbcp.BasicDataSource;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    import com.ioc.web.UserController;
    
    public class Test3 {
    
    	public static void main(String[] args) throws SQLException {
    		ApplicationContext context = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
    		
    		BasicDataSource dataSource = (BasicDataSource) context.getBean("dataSource");
    		System.out.println(dataSource.getConnection());
    		
    		
    	}
    }

结果：

org.apache.commons.dbcp.PoolableConnection@5d740a0f