1.编写存放数据库连接信息的属性文件jdbc.properties
jdbc.driverClassName=com.mysql.jdbc.Driver jdbc.url=jdbc/:mysql/://localhost/:3306/cdl jdbc.username=root jdbc.password=root
2.编写Spring的配置文件applicationContext.xml
<!-- 使用属性文件配置数据源 --> <bean id="propertyPlaceholderConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location" value="jdbc.properties"/> </bean> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" destroy-method="close"> <property name="driverClassName" value="${jdbc.driverClassName}"/> <property name="url" value="${jdbc.url}"/> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> </bean>
3.编写测试类
package cdl; import javax.sql.DataSource; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; public class Test2 { public static void main(String[] args) throws Exception{ ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml"); // 测试数据源 DataSource dataSource=(DataSource)ctx.getBean("dataSource"); System.out.println(dataSource.getConnection()); } }
