java spring jdbc_Spring配置JDBC连接DataSource

方式一：

jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driver

jdbc.url=jdbc\:mysql\://127.0.0.1\:3306/test?useUnicode\=true&characterEncoding\=utf-8

jdbc.username=root

jdbc.password=123124

datasource.xml

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:context="http://www.springframework.org/schema/context"

xsi:schemaLocation="http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.0.xsd

http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">

destroy-method="close">

SpringJDBC.java

package com.what21.spring.jdbc;

import java.sql.SQLException;

import org.apache.commons.dbcp.BasicDataSource;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

public class SpringJDBC {

/**

* @param args

* @throws SQLException

*/

public static void main(String[] args) throws SQLException {

String path = "com/what21/spring/jdbc/datasource.xml";

ApplicationContext ac = new ClassPathXmlApplicationContext(path);

BasicDataSource dataSource = (BasicDataSource)ac.getBean("dataSource");

System.out.println(dataSource);

System.out.println(dataSource.getConnection());

}

}

方式二：

jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driver

jdbc.url=jdbc\:mysql\://127.0.0.1\:3306/test?useUnicode\=true&characterEncoding\=utf-8

jdbc.username=root

jdbc.password=123124

datasource.xml

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:context="http://www.springframework.org/schema/context"

xsi:schemaLocation="http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.0.xsd

http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">

destroy-method="close">

SpringJDBC.java

package com.what21.spring.jdbc2;

import java.sql.SQLException;

import org.apache.commons.dbcp.BasicDataSource;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

public class SpringJDBC {

/**

* @param args

* @throws SQLException

*/

public static void main(String[] args) throws SQLException {

String path = "com/what21/spring/jdbc2/datasource.xml";

ApplicationContext ac = new ClassPathXmlApplicationContext(path);

BasicDataSource dataSource = (BasicDataSource)ac.getBean("dataSource");

System.out.println(dataSource);

System.out.println(dataSource.getConnection());

}

}