iLand
Public Member Functions | Static Public Member Functions | List of all members
SqlHelper Class Reference

A helper class for simple execution of database commands. More...

#include <sqlhelper.h>

Public Member Functions

 SqlHelper ()
 

Static Public Member Functions

static QVariant queryValue (const QString &query, const QSqlDatabase &database)
 query a single value from database More...
 
static bool executeSql (const QString &query, const QSqlDatabase &database)
 execute DML (insert, update, ...) More...
 

Detailed Description

A helper class for simple execution of database commands.

Constructor & Destructor Documentation

◆ SqlHelper()

SqlHelper::SqlHelper ( )

Member Function Documentation

◆ executeSql()

bool SqlHelper::executeSql ( const QString &  query,
const QSqlDatabase &  database 
)
static

execute DML (insert, update, ...)

execute 'query' against database 'database'.

Use for insert, update, ... statements without return values.

◆ queryValue()

QVariant SqlHelper::queryValue ( const QString &  query,
const QSqlDatabase &  database 
)
static

query a single value from database

execute 'query' against database 'database'.

The first column of the first row are returned. A Null-Variant is returned, if the query has no results.


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