spring 框架jdbc连接数据库
2017-01-17 09:58 甘雨路 阅读(359) 评论(0) 编辑 收藏 举报user=LF password=LF url=jdbc:oracle:thin:@localhost:1521:orcl driver=oracle.jdbc.driver.OracleDriver
<?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:p="http://www.springframework.org/schema/p" 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 http://www.springframework.org/schema/context/spring-context.xsd"> <context:property-placeholder location="classpath:jdbc.properties"/> <bean id="connection" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="username" value="${user}"></property> <property name="password" value="${password}"></property> <property name="driverClassName" value="${driver}"></property> <property name="url" value="${url}"></property> </bean> </beans>
public class Utils_jdbc {
public static void main(String[] args) {
ApplicationContext ctc = new ClassPathXmlApplicationContext("applicationContext.xml");
DriverManagerDataSource dSource = (DriverManagerDataSource) ctc.getBean("connection");
try {
System.out.println(dSource.getConnection());
} catch (SQLException e) {
e.printStackTrace();
}
}
}