SQLQuery Class Reference

#include <SQL.h>

Inheritance diagram for SQLQuery:

Public Member Functions
	SQLQuery (SQLConnection *_conn) __DCL_THROWS1(SQLException *)
	SQLQuery (SQLConnection &_conn) __DCL_THROWS1(SQLException *)
virtual	~SQLQuery ()
void	prepare (const String &_sql) __DCL_THROWS1(SQLException *)
void	execute () __DCL_THROWS1(SQLException *)
void	execute (const String &_sql) __DCL_THROWS1(SQLException *)
void	fetch () __DCL_THROWS1(SQLException *)
bool	moreResults () __DCL_THROWS1(SQLException *)
bool	eof () const
int64_t	affectedRows () const
_CONST SQLFields &	fields () _CONST
_CONST SQLParams &	params () _CONST
SQL::Query *	handle () const
SQLConnection *	connection () const
Public Member Functions inherited from Object
virtual String	toString () const
virtual void	destroy ()
String	className () const
bool	isInstanceOf (const std::type_info &typeinfo) const
virtual const std::type_info &	typeInfo () const

Protected Attributes
SQL::Query *	__handle
SQLConnection *	__connection
SQLFields	__fields
SQLParams	__params

Additional Inherited Members
Protected Member Functions inherited from Object
virtual	~Object ()
	Object ()

Detailed Description

Definition at line 275 of file SQL.h.

Constructor & Destructor Documentation

SQLQuery() [1/2]

SQLQuery::SQLQuery

(

SQLConnection *

_conn

)

Definition at line 267 of file SQLQuery.cpp.

{
    initialize(_conn);
}

SQLQuery() [2/2]

SQLQuery::SQLQuery

(

SQLConnection &

_conn

)

Definition at line 272 of file SQLQuery.cpp.

{
    initialize(&_conn);
}

~SQLQuery()

SQLQuery::~SQLQuery ( )

virtual

Definition at line 277 of file SQLQuery.cpp.

{
    __connection->handle()->destroyQueryInstance(__handle);
}

Member Function Documentation

affectedRows()

int64_t SQLQuery::affectedRows ( ) const

inline

Definition at line 96 of file SQL.inl.

{
    return __handle->affectedRows();
}

connection()

SQLConnection * SQLQuery::connection ( ) const

inline

Definition at line 116 of file SQL.inl.

{
    return __connection;
}

eof()

bool SQLQuery::eof ( ) const

inline

Definition at line 91 of file SQL.inl.

{
    return __handle->eof();
}

execute() [1/2]

void SQLQuery::execute

(

)

Definition at line 316 of file SQLQuery.cpp.

{
    if (!__handle->execute()) {
#ifdef __DCL_DEBUG
        throw new SQLException(this, __sql);
#else
        throw new SQLException(this, NULL);
#endif
    }
 
    if (__handle->fieldCount() > 0 && __fields.isEmpty())
        __fields.initialize(this);
}

execute() [2/2]

void SQLQuery::execute

(

const String &

_sql

)

Definition at line 330 of file SQLQuery.cpp.

{
    prepare(_sql);
    execute();
}

fetch()

void SQLQuery::fetch

(

)

Definition at line 336 of file SQLQuery.cpp.

{
    if (!__handle->fetch()) {
        throw new SQLException(this, NULL);
    }
}

fields()

_CONST SQLFields & SQLQuery::fields ( )

inline

Definition at line 101 of file SQL.inl.

{
    return __fields;
}

handle()

SQL::Query * SQLQuery::handle ( ) const

inline

Definition at line 111 of file SQL.inl.

{
    return __handle;
}

moreResults()

bool SQLQuery::moreResults

(

)

Definition at line 343 of file SQLQuery.cpp.

{
    bool _moreResults = false;
    if (!__handle->moreResults(&_moreResults)) {
        throw new SQLException(this, NULL);
    }
 
    __fields.clear();
    if (__handle->fieldCount() > 0) {
        __fields.initialize(this);
    }
 
    return  _moreResults;
}

params()

_CONST SQLParams & SQLQuery::params ( )

inline

Definition at line 106 of file SQL.inl.

{
    return __params;
}

prepare()

void SQLQuery::prepare

(

const String &

_sql

)

Definition at line 282 of file SQLQuery.cpp.

{
#ifdef __DCL_DEBUG
    __sql = _sql;
#endif
 
    __params.clear();
    __fields.clear();
 
    String sql;
    StringArray names;
    __sql_transform__(_sql, __handle->placeholder(), sql, names);
    // __DCL_TRACE2(L"[%zd][%ls]\n", names.size(), sql.data());
 
    ByteString mbs;
    try {
        mbs = UTF8Encoder::encode(sql);
    }
    catch (CharsetConvertException* _cause) {
        throw new SQLException(this, _cause);
    }
 
    if (!__handle->prepare(mbs, mbs.length(), names.size())) {
#ifdef __DCL_DEBUG
        throw new SQLException(this, __sql);
#else
        throw new SQLException(this, NULL);
#endif
    }
 
    if (__handle->paramCount() > 0)
        __params.initialize(this, names);
}

Member Data Documentation

__connection

SQLConnection* SQLQuery::__connection

protected

Definition at line 302 of file SQL.h.

__fields

SQLFields SQLQuery::__fields

protected

Definition at line 303 of file SQL.h.

__handle

SQL::Query* SQLQuery::__handle

protected

Definition at line 301 of file SQL.h.

__params

SQLParams SQLQuery::__params

protected

Definition at line 304 of file SQL.h.

---

The documentation for this class was generated from the following files:

• SQL.h
• SQL.inl
• SQLQuery.cpp