方式一 :
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="oracle.jdbc.driver.OracleDriver"></property>
<property name="jdbcUrl" value="jdbc:oracle:thin:@127.0.0.1:1521:ORCL"></property>
<property name="user" value="scott"></property>
<property name="password" value="tiger"></property>
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource">
<ref local="dataSource" />
</property>
</bean>
方式二 :
编写一个类继承 JdbcDaoSupport 配置文件中 注入这个类
<bean id="jdbcTest" class="com.xml.jdbc.jdbcTest">
<property name="dataSource">
<ref bean="dataSource" />
</property>
</bean>
public class jdbcTest extends JdbcDaoSupport {
public void test() {
this.getJdbcTemplate().execute(new StatementCallback() {
@Override
public Object doInStatement(Statement state) throws SQLException, DataAccessException {
// TODO Auto-generated method stub
final List list = new ArrayList();// annotation
String sql = " select SYSTIMESTAMP from dual ";// annotation
ResultSet resultSet = null;
try {
resultSet = state.executeQuery(sql);
while (resultSet.next()) {
list.add(resultSet.getTimestamp("SYSTIMESTAMP"));
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
if (resultSet != null) {
resultSet.close();
}
}
for (Object object : list) {
System.out.println(object);
}
return list;
}
});
}
此方法中可以获取到 connection 链接对象