oracle上创建了这样一个存储过程
CREATE PROCEDURE T_LBSELE1
(OUT_NUM OUT varchar2)
AS
BEGIN
SELECT FILE_TYPE_NO into OUT_NUM FROM T_LB WHERE FILE_TYPE_NO='06';
END T_LBSELE1;
用JDBC 如何取得OUT_NUM
CREATE PROCEDURE T_LBSELE1
(OUT_NUM OUT varchar2)
AS
BEGIN
SELECT FILE_TYPE_NO into OUT_NUM FROM T_LB WHERE FILE_TYPE_NO='06';
END T_LBSELE1;
用JDBC 如何取得OUT_NUM
callstmt = conn.prepareCall("{call T_LBSELE1(?)}");
callstmt.registerOutParameter(1, Types.VARCHAR);
String OUT_NUM = callstmt.getString(1);
callstmt = conn.prepareCall("{call T_LBSELE1(?)}");
callstmt.registerOutParameter(1, Types.VARCHAR);
callstmt.executeQuery(); //提交一下得到
String OUT_NUM = callstmt.getString(1);