Spring之jdbc连接数据库配置

1) xml文件:

<?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:aop="http://www.springframework.org/schema/aop" 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
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd">

<bean id="datasource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />   //mysql驱动
<property name="url" value="jdbc:mysql://localhost:3306/spring" />    //mysql数据库名
<property name="username" value="root" />     //登录名
<property name="password" value="Ok25897758" />    //密码
</bean>

</beans>

2) 新建与数据库对应的类, 必须有变量和get/set方法

3)测试类:

ApplicationContext applicationContext = new ClassPathXmlApplicationContext("jdbc/bean.xml");
DataSource dataSource = applicationContext.getBean("datasource",DataSource.class);
Connection connection;
try {
connection = dataSource.getConnection();
System.out.println(connection);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

注:控制台打印成功说明配置正确.