亚洲一区二区欧美,国产一区二区福利,精品一区二区三区在线观看

java調(diào)oracle返回游標(biāo)

create ? or ? replace ?package?mypack? is

?Type?ref_cur? is ?ref? cursor ;

? function ?getCur? return ?ref_cur;

end ;?

create ? or ? replace ?package?body?mypack? as

?? function ?getCur? return ?ref_cur? is

????cur1?ref_cur?;

???? begin

??????? open ?cur1? for ? select ? * ? from ?sales;

??????? return ?cur1;

???? end ;?

?? end ?mypack;

? -- java代碼

?? package ?store;

import ?java.sql. * ;

import ?oracle.jdbc. * ;

public ? class ?Test? {

???? public ?Test()? {

????}

???Connection?conn? = ? null ;

???? public ? static ? void ?main(String[]?args)? {

????????Test?test? = ? new ?Test();

????????test.openCursor();

????}

???? private ? void ?getConnection()? throws ?ClassNotFoundException,?SQLException? {

????????Class.forName( " oracle.jdbc.driver.OracleDriver " );

????????String?url = " jdbc:oracle:thin:@localhost:1521:ydgl " ;

????????conn = DriverManager.getConnection(url, " system " , " manager " );

????}

???? public ? void ?openCursor()

???? {

???

???ResultSet?rs? = ? null ;

???CallableStatement?stmt? = ? null ;

???String?sql? = ? " {??=?call?mypack.getCur()} " ;

?? try

?? {?

???getConnection();

???stmt? = ?conn.prepareCall(sql);

???stmt.registerOutParameter( 1 ,OracleTypes.CURSOR);

???stmt.execute();

???rs? = ?((OracleCallableStatement)stmt).getCursor( 1 );

??? while (rs.next())

?? {

???String?xm? = ?rs.getString( 1 );

???Date?dtime? = ?rs.getDate( 2 );

??? int ?count = rs.getInt( 3 );

???String?city = rs.getString( 5 );

???System.out.println( " name: " + xm + " ?|?Time: " + ?dtime.toLocaleString() + " ?|?Count: " + count + " ?|City: " + city);

???}

catch (Exception?ex) {

???ex.printStackTrace();

??}

}

posted on 2006-04-28 21:11 record java and net 閱讀(982) 評論(0) 編輯收藏所屬分類: java

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發(fā)表評論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關(guān)文章: [推薦]系統(tǒng)發(fā)郵件測試 Dumbster Selenium測試使用筆記 JDBC 4.0 Enhancements in Java SE 6 java連接postgreSQL數(shù)據(jù)庫簡單使用我的收藏夾-2006-06-26 這些題目,你能答對多少？ java調(diào)oracle返回游標(biāo) XML在Java中的應(yīng)用

blogjava's web log

java調(diào)oracle返回游標(biāo)

導(dǎo)航

常用鏈接

留言簿(44)

新聞檔案

2.動態(tài)語言

3.工具箱

9.文檔教程

友情鏈接

搜索

最新評論