statement Class Reference

SQL query statement. More...

#include <zbl.hpp>

List of all members.

Public Member Functions
	statement (database &db, const z::string &sql)
	Default constructor.
bool	next ()
	Fetch the next record, execute the sql query when first called.
bool	exec ()
	Execute the sql statement.
void	finish ()
	Free up statement resources.
int	insert ()
	Insert a record.
void	bind (const z::string &key, const z::any &val)
	Bind a query argument.
any	getVar (const int &idx)
	Get any value.
Private Attributes
database &	_db
	The database.
QSqlQuery	_val
	The value.

---

Detailed Description

SQL query statement.

---

Constructor & Destructor Documentation

statement	(	database &	db,
		const z::string &	sql
	)		[inline, explicit]

Default constructor.

Parameters:

db	The database for the statement
sql	The SQL query

---

Member Function Documentation

void bind	(	const z::string &	key,
		const z::any &	val
	)

Bind a query argument.

Parameters:

key	Name of argument
val	Value to bind

bool exec

(

)

[inline]

Execute the sql statement.

Returns:

True if success, else false

z::any getVar

(

const int &

idx

)

Get any value.

Parameters:

idx	Column number of value to fetch

Returns:

The any value

int insert

(

)

Insert a record.

Returns:

The id of the record just inserted

bool next

(

)

[inline]

Fetch the next record, execute the sql query when first called.

Returns:

True if more data available, else false

---

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

• /home/renji/Data/projects/zenlang/sources/zbl/zbl.hpp
• /home/renji/Data/projects/zenlang/sources/zbl/zbl.cpp