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);
}

}