[color=red]一:无返回值的存储过程[/color]
存储过程为:
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2) AS
BEGIN
INSERT INTO HYQ.B_ID (I_ID,I_NAME) VALUES (PARA1, PARA2);
END TESTA;
调用方法为:
CallableStatement proc = null;
proc = conn.prepareCall("{ call HYQ.TESTA(?,?) }");
proc.setString(1, "100");
proc.setString(2, "TestOne");
proc.execute();
[color=red]二:有返回值的存储过程(非列表)[/color]
存储过程为:
CREATE OR REPLACE PROCEDURE TESTB(PARA1 IN VARCHAR2,PARA2 OUT VARCHAR2) AS
BEGIN
SELECT INTO PARA2 FROM TESTTB WHERE I_ID= PARA1;
END TESTB;
调用方法为:
CallableStatement proc = null;
proc = conn.prepareCall("{ call HYQ.TESTB(?,?) }");
proc.setString(1, "100");
proc.registerOutParameter(2, java.sql.Types.VARCHAR);
proc.execute();
String testPrint = proc.getString(2);
System.out.println("=testPrint=is="+testPrint);
[color=red]三:函数[/color]
函数形如:
create or replace function f_get_class(ar_date in date,ar_offset in number,runFac varchar2) return varchar2 is
......
return(lv_classid);
exception
when others then
return null;
end f_get_class;
调用方法为:
CallableStatement cstmt=conn.prepareCall("{?=call f_get_class(?,?,?)}");
cstmt.setString(2, null);
cstmt.setInt(3, 0);
cstmt.setString(4, "07")
cstmt.registerOutParameter(1,java.sql.Types.VARCHAR);
cstmt.executeUpdate();
newClassid = cstmt.getString(1);
out.println(newClassid);
存储过程为:
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2) AS
BEGIN
INSERT INTO HYQ.B_ID (I_ID,I_NAME) VALUES (PARA1, PARA2);
END TESTA;
调用方法为:
CallableStatement proc = null;
proc = conn.prepareCall("{ call HYQ.TESTA(?,?) }");
proc.setString(1, "100");
proc.setString(2, "TestOne");
proc.execute();
[color=red]二:有返回值的存储过程(非列表)[/color]
存储过程为:
CREATE OR REPLACE PROCEDURE TESTB(PARA1 IN VARCHAR2,PARA2 OUT VARCHAR2) AS
BEGIN
SELECT INTO PARA2 FROM TESTTB WHERE I_ID= PARA1;
END TESTB;
调用方法为:
CallableStatement proc = null;
proc = conn.prepareCall("{ call HYQ.TESTB(?,?) }");
proc.setString(1, "100");
proc.registerOutParameter(2, java.sql.Types.VARCHAR);
proc.execute();
String testPrint = proc.getString(2);
System.out.println("=testPrint=is="+testPrint);
[color=red]三:函数[/color]
函数形如:
create or replace function f_get_class(ar_date in date,ar_offset in number,runFac varchar2) return varchar2 is
......
return(lv_classid);
exception
when others then
return null;
end f_get_class;
调用方法为:
CallableStatement cstmt=conn.prepareCall("{?=call f_get_class(?,?,?)}");
cstmt.setString(2, null);
cstmt.setInt(3, 0);
cstmt.setString(4, "07")
cstmt.registerOutParameter(1,java.sql.Types.VARCHAR);
cstmt.executeUpdate();
newClassid = cstmt.getString(1);
out.println(newClassid);