Spring 数据源配置与应用

51cto博客

熔岩…

2008-5-5

保存本文

推荐给好友

收藏本页

欢迎进入Java社区论坛，与200万技术人员互动交流 >>进入

/**
* Created by IntelliJ IDEA. 
* User: leizhimin 
* Date: 2008-4-22 13:53:56 
* Note: 基类DAO，提供了数据源注入
*/
public class BaseDAO {
 private DataSource dataSource;

 public DataSource getDataSource() {
 return dataSource;
 }

 public void setDataSource(DataSource dataSource) {
 this.dataSource = dataSource;
 }

 public Connection getConnection() {
 Connection conn = null;
 try {
 conn = dataSource.getConnection();
 } catch (SQLException e) {
 e.printStackTrace();
 }
 return conn;
 }
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING/DTD BEAN/EN"
 "http://www.springframework.org/dtd/spring-beans.dtd">

<beans>
 <bean id="dataSource"
 class="org.springframework.jdbc.datasource.DriverManagerDataSource">
 <property name="driverClassName">
 <value>com.mysql.jdbc.Driver</value>
 </property>
 <property name="url">
 <value>jdbc:mysql://localhost:3306/springdb</value>
 </property>
 <property name="username">
 <value>root</value>
 </property>
 <property name="password">
 <value>leizhimin</value>
 </property>
 </bean>

 <bean id="baseDAO" class="com.lavasoft.springnote.ch05_jdbc02.BaseDAO" abstract="true">
 <property name="dataSource">
 <ref bean="dataSource"/>
 </property>
 </bean>

 <bean id="userDAO"
 class="com.lavasoft.springnote.ch05_jdbc02.UserDAO" parent="baseDAO">
 </bean>
</beans>

/**
* Created by IntelliJ IDEA. 
* User: leizhimin 
* Date: 2008-4-22 11:41:34 
* Note: 客户端测试
*/
public class SpringDAODemo {
 public static void main(String[] args) {
 ApplicationContext context = new FileSystemXmlApplicationContext("D:\\_spring\\src\\com\\lavasoft\\springnote\\ch05_jdbc02\\bean-jdbc.xml");
 User user = new User();
 user.setName("caterpillar");
 user.setAge(new Integer(30));
 IUserDAO userDAO = (IUserDAO) context.getBean("userDAO");
 userDAO.insert(user);
 user = userDAO.find(new Integer(1));
 System.out.println("name: " + user.getName());
 }
}

运行结果

log4j:WARN No appenders could be found for logger (org.springframework.core.CollectionFactory).
log4j:WARN Please initialize the log4j system properly.
name: jdbctemplate

Process finished with exit code 0

注意：Spring配置文件中对继承的配置，DataSource注入方式，通过继承来注入，从而简化编程。

上面用的是Spring的自己的数据源实现，现在假如要换成apache的DBCP数据源，则配置改为如下即可：

<bean id="dataSource"
 class="org.apache.commons.dbcp.BasicDataSource" singleton="true">
 <property name="driverClassName">
 <value>com.mysql.jdbc.Driver</value>
 </property>
 <property name="url">
 <value>jdbc:mysql://localhost:3306/springdb</value>
 </property>
 <property name="username">
 <value>root</value>
 </property>
 <property name="password">
 <value>leizhimin</value>
 </property>
</bean>

实际上仅仅是更改一下数据源的calss实现。

上一页 [1] [2]

【责编:Ken】