Module qtjambi.sql

Package io.qt.sql

Class QSqlQuery

java.lang.Object

io.qt.QtObject

io.qt.sql.QSqlQuery

All Implemented Interfaces:

QtObjectInterface, Cloneable

public class QSqlQuery
extends QtObject
implements Cloneable

Means of executing and manipulating SQL statements

Java wrapper for Qt class QSqlQuery

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	QSqlQuery.BatchExecutionMode	Java wrapper for Qt enum QSqlQuery::BatchExecutionMode

Constructor Summary

Constructors

Constructor	Description
QSqlQuery()	Overloaded constructor for QSqlQuery(java.lang.String, io.qt.sql.QSqlDatabase)
QSqlQuery(QSqlDatabase db)	See QSqlQuery::QSqlQuery(QSqlDatabase)
QSqlQuery(QSqlQuery other)	See QSqlQuery::QSqlQuery(QSqlQuery)
QSqlQuery(QSqlResult r)	See QSqlQuery::QSqlQuery(QSqlResult*)
QSqlQuery(String query)	Overloaded constructor for QSqlQuery(java.lang.String, io.qt.sql.QSqlDatabase) with db = new io.qt.sql.QSqlDatabase().
QSqlQuery(String query, QSqlDatabase db)	See QSqlQuery::QSqlQuery(QString,QSqlDatabase)

Method Summary

Modifier and Type	Method	Description
final void	addBindValue(Object val)	Overloaded function for addBindValue(java.lang.Object, io.qt.sql.QSql.ParamType) with type = new io.qt.sql.QSql.ParamType(1).
final void	addBindValue(Object val, QSql.ParamType type)	See QSqlQuery::addBindValue(QVariant,QSql::ParamType)
final void	addBindValue(Object val, QSql.ParamTypeFlag ... type)	Overloaded function for addBindValue(java.lang.Object, io.qt.sql.QSql.ParamType).
final void	assign(QSqlQuery other)	See QSqlQuery::operator=(QSqlQuery)
final int	at()	See QSqlQuery::at()const
final void	bindValue(int pos, Object val)	Overloaded function for bindValue(int, java.lang.Object, io.qt.sql.QSql.ParamType) with type = new io.qt.sql.QSql.ParamType(1).
final void	bindValue(int pos, Object val, QSql.ParamType type)	See QSqlQuery::bindValue(int,QVariant,QSql::ParamType)
final void	bindValue(int pos, Object val, QSql.ParamTypeFlag ... type)	Overloaded function for bindValue(int, java.lang.Object, io.qt.sql.QSql.ParamType).
final void	bindValue(String placeholder, Object val)	Overloaded function for bindValue(java.lang.String, java.lang.Object, io.qt.sql.QSql.ParamType) with type = new io.qt.sql.QSql.ParamType(1).
final void	bindValue(String placeholder, Object val, QSql.ParamType type)	See QSqlQuery::bindValue(QString,QVariant,QSql::ParamType)
final void	bindValue(String placeholder, Object val, QSql.ParamTypeFlag ... type)	Overloaded function for bindValue(java.lang.String, java.lang.Object, io.qt.sql.QSql.ParamType).
final Object	boundValue(int pos)	See QSqlQuery::boundValue(int)const
final Object	boundValue(String placeholder)	See QSqlQuery::boundValue(QString)const
final String	boundValueName(int pos)	See QSqlQuery::boundValueName(int)const
final QStringList	boundValueNames()	See QSqlQuery::boundValueNames()const
final QList<Object>	boundValues()	See QSqlQuery::boundValues()const
final void	clear()	See QSqlQuery::clear()
QSqlQuery	clone()	Creates and returns a copy of this object.
final QSqlDriver	driver()	See QSqlQuery::driver()const
final boolean	exec()	See QSqlQuery::exec()
final boolean	exec(String query)	See QSqlQuery::exec(QString)
final boolean	execBatch()	Overloaded function for execBatch(io.qt.sql.QSqlQuery.BatchExecutionMode) with mode = io.qt.sql.QSqlQuery.BatchExecutionMode.ValuesAsRows.
final boolean	execBatch(QSqlQuery.BatchExecutionMode mode)	See QSqlQuery::execBatch(QSqlQuery::BatchExecutionMode)
final String	executedQuery()	See QSqlQuery::executedQuery()const
final void	finish()	See QSqlQuery::finish()
final boolean	first()	See QSqlQuery::first()
final boolean	isActive()	See QSqlQuery::isActive()const
final boolean	isForwardOnly()	See QSqlQuery::isForwardOnly()const
final boolean	isNull(int field)	See QSqlQuery::isNull(int)const
final boolean	isNull(String name)	See QSqlQuery::isNull(QString)const
final boolean	isPositionalBindingEnabled()	See QSqlQuery::isPositionalBindingEnabled()const
final boolean	isSelect()	See QSqlQuery::isSelect()const
final boolean	isValid()	See QSqlQuery::isValid()const
final boolean	last()	See QSqlQuery::last()
final QSqlError	lastError()	See QSqlQuery::lastError()const
final Object	lastInsertId()	See QSqlQuery::lastInsertId()const
final String	lastQuery()	See QSqlQuery::lastQuery()const
final boolean	next()	See QSqlQuery::next()
final boolean	nextResult()	See QSqlQuery::nextResult()
final QSql.NumericalPrecisionPolicy	numericalPrecisionPolicy()	See QSqlQuery::numericalPrecisionPolicy()const
final int	numRowsAffected()	See QSqlQuery::numRowsAffected()const
final boolean	prepare(String query)	See QSqlQuery::prepare(QString)
final boolean	previous()	See QSqlQuery::previous()
final QSqlRecord	record()	See QSqlQuery::record()const
final QSqlResult	result()	See QSqlQuery::result()const
final boolean	seek(int i)	Overloaded function for seek(int, boolean) with relative = false.
final boolean	seek(int i, boolean relative)	See QSqlQuery::seek(int,bool)
final void	setForwardOnly(boolean forward)	See QSqlQuery::setForwardOnly(bool)
final void	setNumericalPrecisionPolicy(QSql.NumericalPrecisionPolicy precisionPolicy)	See QSqlQuery::setNumericalPrecisionPolicy(QSql::NumericalPrecisionPolicy)
final void	setPositionalBindingEnabled(boolean enable)	See QSqlQuery::setPositionalBindingEnabled(bool)
final int	size()	See QSqlQuery::size()const
final void	swap(QSqlQuery other)	See QSqlQuery::swap(QSqlQuery&)
final Object	value(int i)	See QSqlQuery::value(int)const
final Object	value(String name)	See QSqlQuery::value(QString)const

Methods inherited from class io.qt.QtObject

dispose, equals, isDisposed

Methods inherited from class java.lang.Object

finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

QSqlQuery

public QSqlQuery(QSqlDatabase db)

See QSqlQuery::QSqlQuery(QSqlDatabase)

Parameters:

db -

QSqlQuery

public QSqlQuery(QSqlQuery other)

See QSqlQuery::QSqlQuery(QSqlQuery)

Parameters:

other -

QSqlQuery

public QSqlQuery(QSqlResult r)

See QSqlQuery::QSqlQuery(QSqlResult*)

Parameters:

r -

QSqlQuery

public QSqlQuery(String query,
 QSqlDatabase db)

See QSqlQuery::QSqlQuery(QString,QSqlDatabase)

Parameters:

query -

db -

QSqlQuery

public QSqlQuery(String query)

Overloaded constructor for QSqlQuery(java.lang.String, io.qt.sql.QSqlDatabase) with db = new io.qt.sql.QSqlDatabase().

QSqlQuery

public QSqlQuery()

Overloaded constructor for QSqlQuery(java.lang.String, io.qt.sql.QSqlDatabase)

with:

• query = (String)null
• db = new io.qt.sql.QSqlDatabase()

Method Details

addBindValue

@QtUninvokable
public final void addBindValue(Object val,
 QSql.ParamType type)

See QSqlQuery::addBindValue(QVariant,QSql::ParamType)

Parameters:

val -

type -

at

@QtUninvokable
public final int at()

See QSqlQuery::at()const

Returns:

bindValue

@QtUninvokable
public final void bindValue(String placeholder,
 Object val,
 QSql.ParamType type)

See QSqlQuery::bindValue(QString,QVariant,QSql::ParamType)

Parameters:

placeholder -

val -

type -

bindValue

@QtUninvokable
public final void bindValue(int pos,
 Object val,
 QSql.ParamType type)

See QSqlQuery::bindValue(int,QVariant,QSql::ParamType)

Parameters:

pos -

val -

type -

boundValue

@QtUninvokable
public final Object boundValue(String placeholder)

See QSqlQuery::boundValue(QString)const

Parameters:

placeholder -

Returns:

boundValue

@QtUninvokable
public final Object boundValue(int pos)

See QSqlQuery::boundValue(int)const

Parameters:

pos -

Returns:

boundValueName

@QtUninvokable
public final String boundValueName(int pos)

See QSqlQuery::boundValueName(int)const

Parameters:

pos -

Returns:

Since:

This function was introduced in Qt 6.6.

boundValueNames

@QtUninvokable
public final QStringList boundValueNames()

See QSqlQuery::boundValueNames()const

Returns:

Since:

This function was introduced in Qt 6.6.

boundValues

@QtUninvokable
public final QList<Object> boundValues()

See QSqlQuery::boundValues()const

Returns:

Since:

This function was introduced in Qt 6.0.

clear

@QtUninvokable
public final void clear()

See QSqlQuery::clear()

driver

@QtUninvokable
public final QSqlDriver driver()

See QSqlQuery::driver()const

Returns:

exec

@QtUninvokable
public final boolean exec()

See QSqlQuery::exec()

Returns:

exec

@QtUninvokable
public final boolean exec(String query)

See QSqlQuery::exec(QString)

Parameters:

query -

Returns:

execBatch

@QtUninvokable
public final boolean execBatch(QSqlQuery.BatchExecutionMode mode)

See QSqlQuery::execBatch(QSqlQuery::BatchExecutionMode)

Parameters:

mode -

Returns:

executedQuery

@QtUninvokable
public final String executedQuery()

See QSqlQuery::executedQuery()const

Returns:

finish

@QtUninvokable
public final void finish()

See QSqlQuery::finish()

first

@QtUninvokable
public final boolean first()

See QSqlQuery::first()

Returns:

isActive

@QtUninvokable
public final boolean isActive()

See QSqlQuery::isActive()const

Returns:

isForwardOnly

@QtUninvokable
public final boolean isForwardOnly()

See QSqlQuery::isForwardOnly()const

Returns:

isNull

@QtUninvokable
public final boolean isNull(String name)

See QSqlQuery::isNull(QString)const

Parameters:

name -

Returns:

isNull

@QtUninvokable
public final boolean isNull(int field)

See QSqlQuery::isNull(int)const

Parameters:

field -

Returns:

isPositionalBindingEnabled

@QtUninvokable
public final boolean isPositionalBindingEnabled()

See QSqlQuery::isPositionalBindingEnabled()const

Returns:

Since:

This function was introduced in Qt 6.7.

isSelect

@QtUninvokable
public final boolean isSelect()

See QSqlQuery::isSelect()const

Returns:

isValid

@QtUninvokable
public final boolean isValid()

See QSqlQuery::isValid()const

Returns:

last

@QtUninvokable
public final boolean last()

See QSqlQuery::last()

Returns:

lastError

@QtUninvokable
public final QSqlError lastError()

See QSqlQuery::lastError()const

Returns:

lastInsertId

@QtUninvokable
public final Object lastInsertId()

See QSqlQuery::lastInsertId()const

Returns:

lastQuery

@QtUninvokable
public final String lastQuery()

See QSqlQuery::lastQuery()const

Returns:

next

@QtUninvokable
public final boolean next()

See QSqlQuery::next()

Returns:

nextResult

@QtUninvokable
public final boolean nextResult()

See QSqlQuery::nextResult()

Returns:

numRowsAffected

@QtUninvokable
public final int numRowsAffected()

See QSqlQuery::numRowsAffected()const

Returns:

numericalPrecisionPolicy

@QtUninvokable
public final QSql.NumericalPrecisionPolicy numericalPrecisionPolicy()

See QSqlQuery::numericalPrecisionPolicy()const

Returns:

assign

@QtUninvokable
public final void assign(QSqlQuery other)

See QSqlQuery::operator=(QSqlQuery)

Parameters:

other -

Since:

This function was introduced in Qt 6.2.

prepare

@QtUninvokable
public final boolean prepare(String query)

See QSqlQuery::prepare(QString)

Parameters:

query -

Returns:

previous

@QtUninvokable
public final boolean previous()

See QSqlQuery::previous()

Returns:

record

@QtUninvokable
public final QSqlRecord record()

See QSqlQuery::record()const

Returns:

result

@QtUninvokable
public final QSqlResult result()

See QSqlQuery::result()const

Returns:

seek

@QtUninvokable
public final boolean seek(int i,
 boolean relative)

See QSqlQuery::seek(int,bool)

Parameters:

i -

relative -

Returns:

setForwardOnly

@QtUninvokable
public final void setForwardOnly(boolean forward)

See QSqlQuery::setForwardOnly(bool)

Parameters:

forward -

setNumericalPrecisionPolicy

@QtUninvokable
public final void setNumericalPrecisionPolicy(QSql.NumericalPrecisionPolicy precisionPolicy)

See QSqlQuery::setNumericalPrecisionPolicy(QSql::NumericalPrecisionPolicy)

Parameters:

precisionPolicy -

setPositionalBindingEnabled

@QtUninvokable
public final void setPositionalBindingEnabled(boolean enable)

See QSqlQuery::setPositionalBindingEnabled(bool)

Parameters:

enable -

Since:

This function was introduced in Qt 6.7.

size

@QtUninvokable
public final int size()

See QSqlQuery::size()const

Returns:

swap

@QtUninvokable
public final void swap(QSqlQuery other)

See QSqlQuery::swap(QSqlQuery&)

Parameters:

other -

Since:

This function was introduced in Qt 6.2.

value

@QtUninvokable
public final Object value(String name)

See QSqlQuery::value(QString)const

Parameters:

name -

Returns:

value

@QtUninvokable
public final Object value(int i)

See QSqlQuery::value(int)const

Parameters:

i -

Returns:

clone

@QtUninvokable
public QSqlQuery clone()

Creates and returns a copy of this object.

See QSqlQuery::QSqlQuery(QSqlQuery)

Overrides:

clone in class Object

addBindValue

@QtUninvokable
public final void addBindValue(Object val)

Overloaded function for addBindValue(java.lang.Object, io.qt.sql.QSql.ParamType) with type = new io.qt.sql.QSql.ParamType(1).

addBindValue

@QtUninvokable
public final void addBindValue(Object val,
 QSql.ParamTypeFlag ... type)

Overloaded function for addBindValue(java.lang.Object, io.qt.sql.QSql.ParamType).

bindValue

@QtUninvokable
public final void bindValue(String placeholder,
 Object val)

Overloaded function for bindValue(java.lang.String, java.lang.Object, io.qt.sql.QSql.ParamType) with type = new io.qt.sql.QSql.ParamType(1).

bindValue

@QtUninvokable
public final void bindValue(String placeholder,
 Object val,
 QSql.ParamTypeFlag ... type)

Overloaded function for bindValue(java.lang.String, java.lang.Object, io.qt.sql.QSql.ParamType).

bindValue

@QtUninvokable
public final void bindValue(int pos,
 Object val)

Overloaded function for bindValue(int, java.lang.Object, io.qt.sql.QSql.ParamType) with type = new io.qt.sql.QSql.ParamType(1).

bindValue

@QtUninvokable
public final void bindValue(int pos,
 Object val,
 QSql.ParamTypeFlag ... type)

Overloaded function for bindValue(int, java.lang.Object, io.qt.sql.QSql.ParamType).

execBatch

@QtUninvokable
public final boolean execBatch()

Overloaded function for execBatch(io.qt.sql.QSqlQuery.BatchExecutionMode) with mode = io.qt.sql.QSqlQuery.BatchExecutionMode.ValuesAsRows.

seek

@QtUninvokable
public final boolean seek(int i)

Overloaded function for seek(int, boolean) with relative = false.