cstmt_impl.cpp
上传用户:yhdzpy8989
上传日期:2007-06-13
资源大小:13604k
文件大小:6k
- /*
- * ===========================================================================
- * PRODUCTION $Log: cstmt_impl.cpp,v $
- * PRODUCTION Revision 1000.3 2004/06/01 19:18:18 gouriano
- * PRODUCTION PRODUCTION: UPGRADED [GCC34_MSVC7] Dev-tree R1.15
- * PRODUCTION
- * ===========================================================================
- */
- /* $Id: cstmt_impl.cpp,v 1000.3 2004/06/01 19:18:18 gouriano Exp $
- * ===========================================================================
- *
- * PUBLIC DOMAIN NOTICE
- * National Center for Biotechnology Information
- *
- * This software/database is a "United States Government Work" under the
- * terms of the United States Copyright Act. It was written as part of
- * the author's official duties as a United States Government employee and
- * thus cannot be copyrighted. This software/database is freely available
- * to the public for use. The National Library of Medicine and the U.S.
- * Government have not placed any restriction on its use or reproduction.
- *
- * Although all reasonable efforts have been taken to ensure the accuracy
- * and reliability of the software and data, the NLM and the U.S.
- * Government do not and cannot warrant the performance or results that
- * may be obtained by using this software or data. The NLM and the U.S.
- * Government disclaim all warranties, express or implied, including
- * warranties of performance, merchantability or fitness for any particular
- * purpose.
- *
- * Please cite the author in any work or product based on this material.
- *
- * ===========================================================================
- *
- * File Name: $Id: cstmt_impl.cpp,v 1000.3 2004/06/01 19:18:18 gouriano Exp $
- *
- * Author: Michael Kholodov
- *
- * File Description: Callable statement implementation
- *
- *
- * $Log: cstmt_impl.cpp,v $
- * Revision 1000.3 2004/06/01 19:18:18 gouriano
- * PRODUCTION: UPGRADED [GCC34_MSVC7] Dev-tree R1.15
- *
- * Revision 1.15 2004/05/17 21:10:28 gorelenk
- * Added include of PCH ncbi_pch.hpp
- *
- * Revision 1.14 2004/04/26 14:16:56 kholodov
- * Modified: recreate the command objects each time the Get...() is called
- *
- * Revision 1.13 2004/04/12 14:25:33 kholodov
- * Modified: resultset caching scheme, fixed single connection handling
- *
- * Revision 1.12 2004/04/08 15:56:58 kholodov
- * Multiple bug fixes and optimizations
- *
- * Revision 1.11 2004/03/12 16:27:09 sponomar
- * correct nested querys
- *
- * Revision 1.9 2004/02/26 18:52:34 kholodov
- * Added: more trace messages
- *
- * Revision 1.8 2002/12/05 17:37:23 kholodov
- * Fixed: potential memory leak in CStatement::HasMoreResults() method
- * Modified: getter and setter name for the internal CDB_Result pointer.
- *
- * Revision 1.7 2002/10/03 18:50:00 kholodov
- * Added: additional TRACE diagnostics about object deletion
- * Fixed: setting parameters in IStatement object is fully supported
- * Added: IStatement::ExecuteLast() to execute the last statement with
- * different parameters if any
- *
- * Revision 1.6 2002/09/09 20:48:57 kholodov
- * Added: Additional trace output about object life cycle
- * Added: CStatement::Failed() method to check command status
- *
- * Revision 1.5 2002/05/16 22:11:11 kholodov
- * Improved: using minimum connections possible
- *
- * Revision 1.4 2002/04/05 19:33:08 kholodov
- * Added: ExecuteUpdate() to skip all resultsets returned (if any)
- *
- * Revision 1.3 2002/02/08 21:29:54 kholodov
- * SetDataBase() restored, connection cloning algorithm changed
- *
- * Revision 1.2 2002/02/05 17:24:02 kholodov
- * Put into NCBI scope
- *
- * Revision 1.1 2002/01/30 14:51:21 kholodov
- * User DBAPI implementation, first commit
- *
- *
- *
- *
- */
- #include <ncbi_pch.hpp>
- #include "conn_impl.hpp"
- #include "cstmt_impl.hpp"
- #include "rs_impl.hpp"
- #include "basetmpl.hpp"
- #include <dbapi/driver/public.hpp>
- BEGIN_NCBI_SCOPE
- // implementation
- CCallableStatement::CCallableStatement(const string& proc,
- int nofArgs,
- CConnection* conn)
- : CStatement(conn), m_status(0), m_nofParams(nofArgs)
- {
- SetIdent("CCallableStatement");
- SetBaseCmd(conn->GetCDB_Connection()->RPC(proc.c_str(), nofArgs));
- }
- CCallableStatement::~CCallableStatement()
- {
- Notify(CDbapiClosedEvent(this));
- }
- CDB_RPCCmd* CCallableStatement::GetRpcCmd()
- {
- return (CDB_RPCCmd*)GetBaseCmd();
- }
- bool CCallableStatement::HasMoreResults()
- {
- _TRACE("CCallableStatement::HasMoreResults(): Calling parent method");
- bool more = CStatement::HasMoreResults();
- if( more
- && GetCDB_Result() != 0
- && GetCDB_Result()->ResultType() == eDB_StatusResult ) {
-
- _TRACE("CCallableStatement::HasMoreResults(): Status result received");
- CDB_Int *res = 0;
- while( GetCDB_Result()->Fetch() ) {
- res = dynamic_cast<CDB_Int*>(GetCDB_Result()->GetItem());
- }
- if( res != 0 ) {
- m_status = res->Value();
- _TRACE("CCallableStatement::HasMoreResults(): Return status "
- << m_status );
- delete res;
- }
- more = CStatement::HasMoreResults();
- }
- return more;
- }
-
- void CCallableStatement::SetParam(const CVariant& v,
- const string& name)
- {
- GetRpcCmd()->SetParam(name, v.GetData(), false);
- }
-
- void CCallableStatement::SetOutputParam(const CVariant& v,
- const string& name)
- {
- GetRpcCmd()->SetParam(name, v.GetData(), true);
- }
-
-
- void CCallableStatement::Execute()
- {
- SetFailed(false);
- GetRpcCmd()->Send();
- }
- void CCallableStatement::ExecuteUpdate()
- {
- Execute();
- while( HasMoreResults() );
- }
- int CCallableStatement::GetReturnStatus()
- {
- return m_status;
- }
- void CCallableStatement::Close()
- {
- Notify(CDbapiClosedEvent(this));
- FreeResources();
- }
- END_NCBI_SCOPE