1、导入坐标
< dependencies>
< dependency>
< groupId> org.springframework</ groupId>
< artifactId> spring-context</ artifactId>
< version> 5.2.4.RELEASE</ version>
</ dependency>
< dependency>
< groupId> org.springframework</ groupId>
< artifactId> spring-test</ artifactId>
< version> 5.2.3.RELEASE</ version>
</ dependency>
< dependency>
< groupId> org.springframework</ groupId>
< artifactId> spring-jdbc</ artifactId>
< version> 5.2.3.RELEASE</ version>
</ dependency>
< dependency>
< groupId> org.aspectj</ groupId>
< artifactId> aspectjweaver</ artifactId>
< version> 1.9.5</ version>
</ dependency>
< dependency>
< groupId> org.springframework</ groupId>
< artifactId> spring-tx</ artifactId>
< version> 5.2.3.RELEASE</ version>
</ dependency>
< dependency>
< groupId> mysql</ groupId>
< artifactId> mysql-connector-java</ artifactId>
< version> 8.0.22</ version>
</ dependency>
< dependency>
< groupId> junit</ groupId>
< artifactId> junit</ artifactId>
< version> 4.11</ version>
< scope> test</ scope>
</ dependency>
< dependency>
< groupId> c3p0</ groupId>
< artifactId> c3p0</ artifactId>
< version> 0.9.1.1</ version>
</ dependency>
< dependency>
< groupId> com.alibaba</ groupId>
< artifactId> druid</ artifactId>
< version> 1.0.9</ version>
</ dependency>
< dependency>
< groupId> org.junit.jupiter</ groupId>
< artifactId> junit-jupiter</ artifactId>
< version> RELEASE</ version>
< scope> compile</ scope>
</ dependency>
</ dependencies>
2、配置连接数据库jdbc.properties
#驱动名
jdbc.driver=com.mysql.cj.jdbc.Driver
#数据库连接
jdbc.url=jdbc:mysql://localhost:3306/test?seUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
#账户名称
jdbc.user=root
#账户密码
jdbc.password=123456789
3、配置spring.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: 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: component-scan base-package = " com.xiaoyi" />
< context: property-placeholder location = " classpath:jdbc.properties" />
< bean id = " datasource" class = " com.mchange.v2.c3p0.ComboPooledDataSource" >
< property name = " driverClass" value = " ${jdbc.driver}" />
< property name = " jdbcUrl" value = " ${jdbc.url}" />
< property name = " user" value = " ${jdbc.user}" />
< property name = " password" value = " ${jdbc.password}" />
</ bean>
< bean id = " jdbcTemplate" class = " org.springframework.jdbc.core.JdbcTemplate" >
< property name = " dataSource" ref = " datasource" />
</ bean>
</ beans>
4、测试类
public class DataSourceTest {
@Test
public void jdbcTest ( ) {
ApplicationContext ac = new ClassPathXmlApplicationContext ( "spring.xml" ) ;
JdbcTemplate jt = ( JdbcTemplate ) ac. getBean ( "jdbcTemplate" ) ;
String sql = "select count(*) from money" ;
Integer ii = jt. queryForObject ( sql, Integer . class ) ;
System . out. println ( ii) ;
}
}