2009年1月9日
oracle 函數(shù) Create or REPLACE FUNCTION AAAAA ( P_USER_ID_I IN VARCHAR2 --接收輸入?yún)?shù) ) RETURN SYS_REFCURSOR AS P_RESULT_SET_O SYS_REFCURSOR; --返回游標(biāo) X_SQL VARCHAR2(200); BEGIN X_SQL :='select user_id,user_name,email from user_mst where user_id like ''%' || P_USER_ID_I ||'%'''; --生成SQL語句 OPEN P_RESULT_SET_O FOR X_SQL; RETURN P_RESULT_SET_O; --返回游標(biāo) END AAAAA; JAVA 程序調(diào)用 CallableStatement cstmt = null; ResultSet rs = null; try { String callSql = "{? = call AAAAA(?)}"; cstmt = conn.prepareCall(callSql); cstmt.setString(2, "userName"); cstmt.registerOutParameter(1, oracle.jdbc.OracleTypes.CURSOR); cstmt.execute(); rs = (ResultSet) cstmt.getObject(1); if (rs != null) { System.out.print("usercd"); System.out.print("userName"); System.out.println("EMAIL"); while (rs.next()) { System.out.print(rs.getString(1)+" "); System.out.print(rs.getString(2)+" "); System.out.println(rs.getString(3)); } }
posted @ 2009-01-09 11:02 越戰(zhàn)越勇 閱讀(129) | 評論 (0) | 編輯 收藏
Powered by: BlogJava Copyright © 越戰(zhàn)越勇