ODBC 연걸로 SQL 프로시저 사용해서 데이터 내려받기

void clicked()
{
    str20                            _SettleID,
                                     _SelesID,
                                     _SCanId,
                                     _CouponNumber,
                                     _ItemID,
                                     _ConfigId,
                                     _Status,
                                     _Ticket_Fr,
                                     _Ticket_To;
    TEST_CouponstatusInquiry         _CouponstatusInquiry;
    LoginProperty _loginProperty;
    OdbcConnection _odbcConnection;
    Statement _statement;
    ResultSet _resultSet;
    _Ticket_Fr       =   StartCouponId.text();
    _Ticket_To       =   EndCouponId.text();
    _loginProperty = new LoginProperty();
    _loginProperty.setServer("Server IP");  //ServerName
    _loginProperty.setDatabase("IF_TicketMaster");     //DBName
    try
    {
        _odbcConnection = new OdbcConnection(_loginProperty);
    }
    catch
    {
        return;
    }
    _statement = _odbcConnection.createStatement();
    _resultSet = _statement.executeQuery("Exec  IF_TicketMaster..[usp_Ticket_info] '020001 1675284','020001 1675284'"); //stored procedure name
    while(_resultSet.next())
    {
        //ODBC 방식은 받아오는 순서가 1부터 시작합니다.
        _CouponNumber   = _resultSet.GetString(1);
        _Status         = _resultSet.GetString(2);
        _ItemID         = _resultSet.GetString(3);
        _ConfigId       = _resultSet.GetString(4);
        _SelesID        = _resultSet.GetString(5);
        _SettleID       = _resultSet.GetString(6);
        _SCanId         = _resultSet.GetString(7);
        select _CouponstatusInquiry;
        _CouponstatusInquiry.clear();
        _CouponstatusInquiry.TEST_CouponId  = _CouponNumber;
        _CouponstatusInquiry.TEST_ItemID    = _ItemID;     
        _CouponstatusInquiry.TEST_ConfigId  = _ConfigId;    
        _CouponstatusInquiry.TEST_Status    = _Status;
        _CouponstatusInquiry.TEST_SalesId   = _SelesID;
        _CouponstatusInquiry.TEST_PackID    = _SCanId;
        _CouponstatusInquiry.TEST_SettleId  = _SettleID;
        _CouponstatusInquiry.insert();
    }
    super();
    TEST_CouponstatusInquiry_ds.executeQuery();
}    //"EX ) Exec  IF_TicketMaster..[usp_Ticket_info] '020001 1675284','020001 1675284'"
<--------------------------------------------------------------------------------------------------->