call_package_function.java

来自「oracle的一些详细资料oracle的一些详细资料 看看吧~~」· Java 代码 · 共 40 行

package java_call_oracle_package;

import java.sql.*;
import oracle.jdbc.OracleTypes;

public class Call_Package_Function {
    private Connection conn = null;
    private CallableStatement stmt = null;
    public Call_Package_Function() {
        try {
            conn = GetConn.getConn();
            stmt = conn.prepareCall("{?=call myPack.QueryName(?)}");
            //因为第一个是返回值 好比存储过程的out  所以要注册
            stmt.registerOutParameter(1, OracleTypes.VARCHAR);
            stmt.setInt(2, 1002);
            stmt.execute();
            System.out.println("结果为: " + stmt.getString(1));
        } catch (Exception e) {
            System.out.println(e.getMessage().toString());
        } finally {
            safeClose();
        }
    }

    public void safeClose() {
        try {
            if (conn != null) {
                conn.close();
            } else if (stmt != null) {
                stmt.close();
            }
        } catch (Exception e) {}
    }

    public static void main(String[] args) {
        new Call_Package_Function();
    }

}