[자바 소스] PL/SQL 자바에서 이용하기 예제 소스

PL/SQL 자바에서 이용하기

 

 

package cstmt;

 

import java.sql.*;

 

import conn.*;

 

public class TestCstmt1 {

 

    public static void main(String[] args) {

        new TestCstmt1().execute();

    }

 

    public void execute() {

        Connection conn = null;

        CallableStatement cstmt = null;

       

       

        try {

            conn = MyConn.getConnection();

            cstmt = conn.prepareCall("{call p_loop2(?,?,?)}");

            /*

             * PROCEDURE P_LOOP2

               (  V_START IN NUMBER 

                , V_END IN NUMBER 

                , V_RESULT OUT NUMBER]

               )

               in 변수는 set~ 해주고

               out 변수는 register 해준다.

             */

            cstmt.setInt(1, 500);

            cstmt.setInt(2, 10000);

            cstmt.registerOutParameter(3, Types.NUMERIC);

            cstmt.execute();

            int result = cstmt.getInt(3);    // v_result 값을 받아온다.

            System.out.println(result);

           

           

        } catch (SQLException e) {

           

            e.printStackTrace();

        } finally {

            try { if( cstmt!=null) cstmt.close(); }

            catch (SQLException e) { e.printStackTrace(); }

            try { if( conn!=null) conn.close(); }

            catch (SQLException e) { e.printStackTrace(); }

        }

    }

 

}