Spring2.5中JDBC连接数据库与JdbcTemplate的学习笔记

applicationContext.xml中的配置文件如下:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans  default-autowire ="autodetect">
     <bean id ="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
         <property name ="driverClassName">
             <value>oracle.jdbc.driver.OracleDriver</value>
         </property>
         <property name ="url">
             <value>jdbc:oracle:thin:@localhost:1521:orcl</value>
          </property>
         <property name="username">
             <value>scott</value>
         </property>
         <property name="password">
             <value>tiger</value>
         </property>
     </bean>

</beans>
这个是具体连接数据库的java类 PersistenceFactory
package com.oztime.factory;
import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class PersistenceFactory {
private ApplicationContext tx;
//读取applicationContext.xml中的信息
public ApplicationContext getContext(){
tx=new ClassPathXmlApplicationContext("applicationContext.xml");
return tx;
}
//获取配置文件中的数据源
     public DataSource getDataSource(){
    DataSource datasource=null;
      datasource=(DataSource)this.getContext().getBean("dataSource");
      return datasource;
     }
     //连接数据库的方法
     public Connection makeConnection(){
    Connection conn=null;
    try {
conn=getDataSource().getConnection();
System.out.println(conn);
System.out.println("连接数据库成功！");
} catch (SQLException e) {
e.printStackTrace();
}
    return conn;
     }
     public Persistence getPersistence(DataSource dataSource){
Persistence persistence=new Persistence(dataSource);
persistence.setDataSource(dataSource);
return persistence;
}
}


下面是与数据库交互的java类 Persistenc
package com.oztime.factory;
import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
//import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
/*
*
* 与数据库交互的类
*/

public class Persistence {
private JdbcTemplate jdbcTemplate;
// private NamedParameterJdbcTemplate namedParameterJdbcTemplate = null;
private DataSource dataSource;
public Persistence(DataSource dataSource){
this.dataSource=dataSource;
this.jdbcTemplate=new JdbcTemplate(this.dataSource);
// this.namedParameterJdbcTemplate=new NamedParameterJdbcTemplate(this.jdbcTemplate);
}
public void setDataSource(DataSource dataSource) {
this.dataSource = dataSource;
this.jdbcTemplate = new JdbcTemplate(this.dataSource);
// this.namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(jdbcTemplate);
}
public DataSource getDataSource(){
return dataSource;
}

//具体的与数据库交互的方法
public void save(String sql){
jdbcTemplate.execute(sql);
System.out.println("插入数据成功！！！");
}
}

下面是具体的测试类 Test

package com.oztime.factory;
public class Test {
public static void main(String agrs[]){
PersistenceFactory f=new PersistenceFactory();
f.makeConnection();
Persistence per=f.getPersistence(f.getDataSource());
String sql="insert into t_user values(1,'zhangsan','ssssss')";
per.save(sql);
}

}