call_package_procedure.java~52~

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

package java_call_oracle_package;

import java.sql.*;

public class Call_Package_Procedure {
    private Connection conn = null;
    private CallableStatement stmt = null;
    public Call_Package_Procedure() {
        try {
            conn = GetConn.getConn();
            stmt = conn.prepareCall(
                    "{call myPac.RegisterClassInformation(?,?)}");
            stmt.setInt(1, 105);
            stmt.setString(2, "T43");
            stmt.execute(); //false 代表成功
            System.out.println("");
            //stmt.executeUpdate(); //返回0代表成功
            System.out.println("成功了!");
        } catch (Exception ex) {
        } 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_Procedure();
    }

}