Referencia de la Clase QSqlRecord

The QSqlRecord class encapsulates a database record, i.e. a set of database fields. Más...

#include <qsqlrecord.h>

Diagrama de herencias de QSqlRecord

Lista de todos los miembros.

Métodos públicos
	QSqlRecord ()
	QSqlRecord (const QSqlRecord &other)
QSqlRecord &	operator= (const QSqlRecord &other)
virtual	~QSqlRecord ()
virtual QVariant	value (int i) const
virtual QVariant	value (const QString &name) const
virtual void	setValue (int i, const QVariant &val)
virtual void	setValue (const QString &name, const QVariant &val)
bool	isGenerated (int i) const
bool	isGenerated (const QString &name) const
virtual void	setGenerated (const QString &name, bool generated)
virtual void	setGenerated (int i, bool generated)
virtual void	setNull (int i)
virtual void	setNull (const QString &name)
bool	isNull (int i)
bool	isNull (const QString &name)
bool	isNull (int i) const
bool	isNull (const QString &name) const
int	position (const QString &name) const
QString	fieldName (int i) const
QSqlField *	field (int i)
QSqlField *	field (const QString &name)
const QSqlField *	field (int i) const
const QSqlField *	field (const QString &name) const
virtual void	append (const QSqlField &field)
virtual void	insert (int pos, const QSqlField &field)
virtual void	remove (int pos)
bool	isEmpty () const
bool	contains (const QString &name) const
virtual void	clear ()
virtual void	clearValues (bool nullify=FALSE)
uint	count () const
virtual QString	toString (const QString &prefix=QString::null, const QString &sep=",") const
virtual QStringList	toStringList (const QString &prefix=QString::null) const
	QSqlRecord ()
	QSqlRecord (const QSqlRecord &other)
QSqlRecord &	operator= (const QSqlRecord &other)
virtual	~QSqlRecord ()
virtual QVariant	value (int i) const
virtual QVariant	value (const QString &name) const
virtual void	setValue (int i, const QVariant &val)
virtual void	setValue (const QString &name, const QVariant &val)
bool	isGenerated (int i) const
bool	isGenerated (const QString &name) const
virtual void	setGenerated (const QString &name, bool generated)
virtual void	setGenerated (int i, bool generated)
virtual void	setNull (int i)
virtual void	setNull (const QString &name)
bool	isNull (int i)
bool	isNull (const QString &name)
bool	isNull (int i) const
bool	isNull (const QString &name) const
int	position (const QString &name) const
QString	fieldName (int i) const
QSqlField *	field (int i)
QSqlField *	field (const QString &name)
const QSqlField *	field (int i) const
const QSqlField *	field (const QString &name) const
virtual void	append (const QSqlField &field)
virtual void	insert (int pos, const QSqlField &field)
virtual void	remove (int pos)
bool	isEmpty () const
bool	contains (const QString &name) const
virtual void	clear ()
virtual void	clearValues (bool nullify=FALSE)
uint	count () const
virtual QString	toString (const QString &prefix=QString::null, const QString &sep=",") const
virtual QStringList	toStringList (const QString &prefix=QString::null) const

---

Descripción detallada

The QSqlRecord class encapsulates a database record, i.e. a set of database fields.

sql

The QSqlRecord class encapsulates the functionality and characteristics of a database record (usually a table or view within the database). QSqlRecords support adding and removing fields as well as setting and retrieving field values.

QSqlRecord is implicitly shared. This means you can make copies of the record in time O(1). If multiple QSqlRecord instances share the same data and one is modifying the record's data then this modifying instance makes a copy and modifies its private copy - thus it does not affect other instances.

Ver también:

QSqlRecordInfo

---

Documentación del constructor y destructor

QSqlRecord::QSqlRecord

(

)

Constructs an empty record.

QSqlRecord::QSqlRecord

(

const QSqlRecord &

other

)

Constructs a copy of other.

QSqlRecord::~QSqlRecord

(

)

[virtual]

Destroys the object and frees any allocated resources.

QSqlRecord::QSqlRecord

(

)

QSqlRecord::QSqlRecord

(

const QSqlRecord &

other

)

virtual QSqlRecord::~QSqlRecord

(

)

[virtual]

---

Documentación de las funciones miembro

void QSqlRecord::append

(

const QSqlField &

field

)

[virtual]

Append a copy of field field to the end of the record.

Reimplementado en QSqlIndex y QSqlIndex.

virtual void QSqlRecord::append

(

const QSqlField &

field

)

[virtual]

Reimplementado en QSqlIndex y QSqlIndex.

void QSqlRecord::clear

(

void

)

[virtual]

Removes all the record's fields.

Ver también:

clearValues()

Reimplementado en QSqlCursor, QSqlSelectCursor, QSqlCursor y QSqlSelectCursor.

virtual void QSqlRecord::clear

(

)

[virtual]

Reimplementado en QSqlCursor, QSqlSelectCursor, QSqlCursor y QSqlSelectCursor.

void QSqlRecord::clearValues

(

bool

nullify = FALSE

)

[virtual]

Clears the value of all fields in the record. If nullify is TRUE, (the default is FALSE), each field is set to NULL.

virtual void QSqlRecord::clearValues

(

bool

nullify = FALSE

)

[virtual]

bool QSqlRecord::contains

(

const QString &

name

)

const

Returns TRUE if there is a field in the record called name; otherwise returns FALSE.

bool QSqlRecord::contains

(

const QString &

name

)

const

uint QSqlRecord::count

(

)

const

Returns the number of fields in the record.

uint QSqlRecord::count

(

)

const

QSqlField * QSqlRecord::field

(

int

i

)

Returns the field at position i within the record, or 0 if it cannot be found.

QSqlField * QSqlRecord::field

(

const QString &

name

)

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Returns the field called name within the record, or 0 if it cannot be found. Field names are not case-sensitive.

const QSqlField * QSqlRecord::field

(

const QString &

name

)

const

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Returns the field called name within the record, or 0 if it cannot be found. Field names are not case-sensitive.

const QSqlField * QSqlRecord::field

(

int

i

)

const

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta.

QSqlField* QSqlRecord::field

(

int

i

)

QSqlField* QSqlRecord::field

(

const QString &

name

)

const QSqlField* QSqlRecord::field

(

int

i

)

const

const QSqlField* QSqlRecord::field

(

const QString &

name

)

const

QString QSqlRecord::fieldName

(

int

i

)

const

Returns the name of the field at position i. If the field does not exist, QString::null is returned.

QString QSqlRecord::fieldName

(

int

i

)

const

void QSqlRecord::insert	(	int	pos,
		const QSqlField &	field
	)		[virtual]

Insert a copy of field at position pos. If a field already exists at pos, it is removed.

virtual void QSqlRecord::insert	(	int	pos,
		const QSqlField &	field
	)		[virtual]

bool QSqlRecord::isEmpty

(

void

)

const

Returns TRUE if there are no fields in the record; otherwise returns FALSE.

bool QSqlRecord::isEmpty

(

)

const

bool QSqlRecord::isGenerated

(

int

i

)

const

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Returns TRUE if the record has a field at position i and this field is to be generated (the default); otherwise returns FALSE.

Ver también:

setGenerated()

bool QSqlRecord::isGenerated

(

int

i

)

const

bool QSqlRecord::isGenerated

(

const QString &

name

)

const

bool QSqlRecord::isGenerated

(

const QString &

name

)

const

Returns TRUE if the record has a field called name and this field is to be generated (the default); otherwise returns FALSE.

Ver también:

setGenerated()

bool QSqlRecord::isNull

(

int

i

)

bool QSqlRecord::isNull

(

const QString &

name

)

bool QSqlRecord::isNull

(

int

i

)

const

Reimplementado en QSqlCursor y QSqlCursor.

bool QSqlRecord::isNull

(

const QString &

name

)

bool QSqlRecord::isNull

(

int

i

)

bool QSqlRecord::isNull

(

const QString &

name

)

const

Reimplementado en QSqlCursor y QSqlCursor.

bool QSqlRecord::isNull

(

int

i

)

const

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Returns TRUE if the field i is NULL or if there is no field at position i; otherwise returns FALSE.

Ver también:

fieldName()

Reimplementado en QSqlCursor y QSqlCursor.

bool QSqlRecord::isNull

(

const QString &

name

)

const

Returns TRUE if the field called name is NULL or if there is no field called name; otherwise returns FALSE.

Ver también:

position()

Reimplementado en QSqlCursor y QSqlCursor.

QSqlRecord& QSqlRecord::operator=

(

const QSqlRecord &

other

)

QSqlRecord & QSqlRecord::operator=

(

const QSqlRecord &

other

)

Sets the record equal to other.

int QSqlRecord::position

(

const QString &

name

)

const

Returns the position of the field called name within the record, or -1 if it cannot be found. Field names are not case-sensitive. If more than one field matches, the first one is returned.

int QSqlRecord::position

(

const QString &

name

)

const

void QSqlRecord::remove

(

int

pos

)

[virtual]

Removes the field at pos. If pos does not exist, nothing happens.

Reimplementado en QSqlCursor, QSqlSelectCursor, QSqlCursor y QSqlSelectCursor.

virtual void QSqlRecord::remove

(

int

pos

)

[virtual]

Reimplementado en QSqlCursor, QSqlSelectCursor, QSqlCursor y QSqlSelectCursor.

void QSqlRecord::setGenerated	(	const QString &	name,
		bool	generated
	)		[virtual]

Sets the generated flag for the field called name to generated. If the field does not exist, nothing happens. Only fields that have generated set to TRUE are included in the SQL that is generated, e.g. by QSqlCursor.

Ver también:

isGenerated()

Reimplementado en QSqlCursor, QSqlSelectCursor, QSqlCursor y QSqlSelectCursor.

void QSqlRecord::setGenerated	(	int	i,
		bool	generated
	)		[virtual]

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Sets the generated flag for the field i to generated.

Ver también:

isGenerated()

Reimplementado en QSqlCursor, QSqlSelectCursor, QSqlCursor y QSqlSelectCursor.

virtual void QSqlRecord::setGenerated	(	const QString &	name,
		bool	generated
	)		[virtual]

Reimplementado en QSqlCursor, QSqlSelectCursor, QSqlCursor y QSqlSelectCursor.

virtual void QSqlRecord::setGenerated	(	int	i,
		bool	generated
	)		[virtual]

Reimplementado en QSqlCursor, QSqlSelectCursor, QSqlCursor y QSqlSelectCursor.

void QSqlRecord::setNull

(

int

i

)

[virtual]

Sets the value of field i to NULL. If the field does not exist, nothing happens.

virtual void QSqlRecord::setNull

(

const QString &

name

)

[virtual]

virtual void QSqlRecord::setNull

(

int

i

)

[virtual]

void QSqlRecord::setNull

(

const QString &

name

)

[virtual]

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Sets the value of the field called name to NULL. If the field does not exist, nothing happens.

virtual void QSqlRecord::setValue	(	int	i,
		const QVariant &	val
	)		[virtual]

Reimplementado en QSqlCursor y QSqlCursor.

void QSqlRecord::setValue	(	int	i,
		const QVariant &	val
	)		[virtual]

Sets the value of the field at position i to val. If the field does not exist, nothing happens.

Reimplementado en QSqlCursor y QSqlCursor.

void QSqlRecord::setValue	(	const QString &	name,
		const QVariant &	val
	)		[virtual]

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Sets the value of the field called name to val. If the field does not exist, nothing happens.

Reimplementado en QSqlCursor y QSqlCursor.

virtual void QSqlRecord::setValue	(	const QString &	name,
		const QVariant &	val
	)		[virtual]

Reimplementado en QSqlCursor y QSqlCursor.

virtual QString QSqlRecord::toString	(	const QString &	prefix = QString::null,
		const QString &	sep = ","
	)		const [virtual]

Reimplementado en QSqlCursor, QSqlSelectCursor, QSqlCursor y QSqlSelectCursor.

QString QSqlRecord::toString	(	const QString &	prefix = QString::null,
		const QString &	sep = ","
	)		const [virtual]

Returns a list of all the record's field names as a string separated by sep.

Note that fields which are not generated are not included (see {isGenerated()}). The returned string is suitable, for example, for generating SQL SELECT statements. If a prefix is specified, e.g. a table name, all fields are prefixed in the form:

"\a{prefix}.\<fieldname\>"

Reimplementado en QSqlCursor, QSqlSelectCursor, QSqlCursor y QSqlSelectCursor.

QStringList QSqlRecord::toStringList

(

const QString &

prefix = QString::null

)

const [virtual]

Returns a list of all the record's field names, each having the prefix prefix.

Note that fields which have generated set to FALSE are not included. (See {isGenerated()}). If prefix is supplied, e.g. a table name, all fields are prefixed in the form:

"\a{prefix}.\<fieldname\>"

virtual QStringList QSqlRecord::toStringList

(

const QString &

prefix = QString::null

)

const [virtual]

QVariant QSqlRecord::value

(

const QString &

name

)

const [virtual]

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Returns the value of the field called name in the record. If field name does not exist the resultant behaviour is undefined.

Reimplementado en QSqlCursor y QSqlCursor.

QVariant QSqlRecord::value

(

int

i

)

const [virtual]

Returns the value of the field located at position i in the record. If field i does not exist the resultant behaviour is undefined.

This function should be used with {QSqlQuery}s. When working with a QSqlCursor the value(const QString&) overload which uses field names is more appropriate.

Reimplementado en QSqlCursor y QSqlCursor.

virtual QVariant QSqlRecord::value

(

const QString &

name

)

const [virtual]

Reimplementado en QSqlCursor y QSqlCursor.

virtual QVariant QSqlRecord::value

(

int

i

)

const [virtual]

Reimplementado en QSqlCursor y QSqlCursor.

---

La documentación para esta clase fue generada a partir de los siguientes ficheros:

• src/qt/include/qsqlrecord.h
• src/qt/src/sql/qsqlrecord.h
• src/qt/src/sql/qsqlrecord.cpp