도움이..되실련지.. ^^

=============================================================

[SP Script]

DROP PROCEDURE IF EXISTS TEST_SEL;
CREATE TABLE test (seq int, a varchar(50), b varchar(50));
DELIMITER //

CREATE PROCEDURE TEST_SEL()
BEGIN
 select * from test;
END
//
DELIMITER ;

=============================================================

[Java TEST 소스]

import java.io.*;
import java.util.*;
import java.sql.*;
import java.text.*;

public class TestMySQL {   
       
    public static void main(String args[]){
                           
       Connection con = null;
        String CLASS_NAME = null;
        String DB_URL = null;
        String USR = null;
        String PASSWD = null;
        PreparedStatement stmt    = null;  
        ResultSet rs            = null;  
       int i=0;

        try {                     

            CLASS_NAME        = "com.mysql.jdbc.Driver";
            DB_URL            = "jdbc:mysql://localhost:3306/test";
            USR                = "root";
            PASSWD            = "root";
                                   
            System.out.println("MySQL db연결");
            Class.forName(CLASS_NAME);
            con    = DriverManager.getConnection(DB_URL,USR,PASSWD);
            con.setAutoCommit(false);

            stmt = con.prepareStatement(" call test_sel()" );
            rs = stmt.executeQuery();
                while(rs.next()){       
                    System.out.println("COL 1:" + rs.getString(1));
                    System.out.println("COL 2:" + rs.getString(2));
                    System.out.println("COL 3:" + rs.getString(3));
     i++;
                }
                System.out.println("COUNT:" +i);
            rs.close();
            stmt.close();
            con.close();
                                   
        }catch(SQLException e) {
            System.out.println("TestMySQL main Error : " + e.toString());
            System.out.println("TestMySQL main SQLSTATE : " + e.getSQLState());
            System.out.println("TestMySQL main ERROR_CODE : " + e.getErrorCode());
        }catch (Exception e) {
            System.out.println("TestMySQL main Error : " + e.toString());
            System.out.println("TestMySQL main Error : " + e.getMessage());
        }finally{                                
            System.out.println("MySQL 결과 END");
        }   
    }   
}