至顶网›软件频道 ›Spring调用Oracle的Function函数

Spring调用Oracle的Function函数

扫一扫
分享文章到微信
扫一扫
关注官方公众号
至顶头条

直接调用Oracle内部函数Function的文章

作者：builder.com.cn 来源：来源网站 2007年11月25日

最近搜索了很多网上讲Spring 操作Oracle内部对象的例子，基本上是介绍调用存储过程的~直接调用Oracle内部函数Function的文章真的不多~这里，法老参考了Spring论坛上外国友人的例子，写一个DEMO供大家参考~

测试Oracle函数:
Here is a basic function that returns sysdate in a REF CURSOR:

FUNCTION MY_DEMO_FNC

RETURN MY_REFCURSOR_PKG.RefCursor

return_date MY_REFCURSOR_PKG.RefCursor;

BEGIN

OPEN return_date FOR 'select sysdate from dual';

return return_date;

END MY_DEMO_FNC;

测试程序:
Here is the class that accesses it:

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.HashMap;

import java.util.Map;

import javax.sql.DataSource;

import oracle.jdbc.OracleTypes;

import org.springframework.jdbc.core.RowCallbackHandler;

import org.springframework.jdbc.core.SqlOutParameter;

import org.springframework.jdbc.datasource.DriverManagerDataSource;

import org.springframework.jdbc.object.StoredProcedure;

public class RefCursorTestDao

{

public static void main(String[] args) throws Exception

{

new RefCursorTestDao().execute();

}

public void execute() throws Exception

{

DataSource ds = new DriverManagerDataSource(

"oracle.jdbc.driver.OracleDriver",

"jdbc:oracle:thin:@localhost:1521:SID1",

"user", "password");

DemoStoredProcedure proc = new DemoStoredProcedure(ds);

Map params = new HashMap();

proc.execute(params);

}

private class DemoStoredProcedure extends StoredProcedure

{

public static final String SQL = "MY_TEST_PKG.MY_DEMO_FNC";

public DemoStoredProcedure(DataSource ds)

{

setDataSource(ds);

setSql(SQL);

setFunction(true);

declareParameter(

new SqlOutParameter(

"whatever", OracleTypes.CURSOR, new DemoRowMapper()));

compile();

}

private class DemoRowMapper implements RowCallbackHandler

{

public void processRow(ResultSet rs) throws SQLException

{

System.out.println(rs.getTimestamp(1));

}

The process is the same for a real procedure with the REF CURSOR as an OUT parameter, but #setFunction should be false instead of true.
参考地址:http://forum.springframework.org/archive/index.php/t-10054.html

Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1901215

VIP专区

VIP用户

普通用户

邮件订阅

如果您非常迫切的想了解IT领域最新产品与技术信息，那么订阅至顶网技术邮件将是您的最佳途径之一。

重磅专题

往期文章

Spring调用Oracle的Function函数

业界热点: