oracle存储过程:
从教学计划表查询计划号为v_jxjhh的教学计划
create or replace procedure My_Test(v_jxjhh in varchar2,ref_cursor out sys_refcursor) asstr_sql varchar2(1000);beginopen ref_cursor forselect * from Jxjhkcxxb where jxjhh=v_jxjhh;end My_Test;
java程序:
package com.test;import java.sql.Connection;import java.sql.DatabaseMetaData;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.SQLException;import java.sql.Statement;public class New_procedure {public static void main(String[] args) throws ClassNotFoundException,SQLException {String driver = "oracle.jdbc.driver.OracleDriver";String strUrl