1.建.java为定义数据源的类
2.在bean.xml中配置数据源(见前一篇,)配置1中类
3.在测试类中通过语句操作数据库
-------------------------
package Dao;
import javax.sql.DataSource;
public class JdbcTemplate {
private DataSource dataSource;
public DataSource getDataSource() {
return dataSource;
}
public void setDataSource(DataSource dataSource) {
this.dataSource = dataSource;
}
}
bean.xml:
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://www.springframework.org/schema/beans"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
<bean id="jdbc" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" >
<property name="locations" value="jdbc.properties"/>
</bean>
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>${jdbc.driverClassName}</value>
</property>
<property name="url">
<value>${jdbc.url}</value>
</property>
<property name="username">
<value>${jdbc.username}</value>
</property>
<property name="password">
<value>${jdbc.password}</value>
</property>
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource">
<ref local="dataSource"/>
</property>
</bean>
Main.java:
package test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
import com.mchange.v2.c3p0.DriverManagerDataSource;
public class Main {
public static void main(String[] args) {
DriverManagerDataSource ds=null;
JdbcTemplate jtl=null;
ApplicationContext ac=new ClassPathXmlApplicationContext("bean.xml");
jtl=(JdbcTemplate) ac.getBean("jdbcTemplate");
String sql="insert into user(name,password) values('happy','1111')";
jtl.update(sql);
System.out.println("插入数据成功!");
}
}
Main.java