procedure_have_param.java

oracle的一些详细资料oracle的一些详细资料 看看吧~~

package java_call_oracle_procedure;

//大家注意 操作ORACLE一般功能还是用的java.sql.*包  高级功能用oracle自己的包
import java.sql.Connection;
import java.sql.CallableStatement;

public class Procedure_Have_Param {
    private Connection conn = null;
    private CallableStatement cstmt = null;
    public Procedure_Have_Param() {
        try {
            //通用的连接类获得连接
            conn = GetConn.getOracleConn();
            cstmt = conn.prepareCall("{call myPro2(?,?,?,?)}");
            cstmt.setInt(1, 10001);
            cstmt.setString(2, "Who am i");
            cstmt.setString(3, "XiaoLiu");
            cstmt.setInt(4, 3);
            cstmt.execute(); //执行存储过程cstmt.execute() 返回boolean值  返回false代表成功了 true代表失败
            System.out.println("成功了啊!");

        } catch (Exception e) {
            System.out.println(e.getMessage().toString());
        } finally {
            safeClose();
        }
    }

    public void safeClose() {
        try {
            if (conn != null) {
                conn.close();
            } else if (cstmt != null) {
                cstmt.close();
            }
        } catch (Exception e) {
            System.out.println(e.getMessage().toString());
        }
    }

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