方式一:
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());
}
}