Mag’lumatlar bazasina jalg’aniw protsesi Dasturew mb va mbbtlari haqqinda tusinikler

QT da to’mendegi MBBTlarig’a jalg’aniw mumkin:

• QDB2 IBM DB2 (version 7.1 and above)
• QIBASE Borland InterBase
• QMYSQL MySQL
• QOCI Oracle Call Interface Driver
• QODBC Open Database Connectivity (ODBC) - Microsoft SQL Server and other ODBC-compliant databases
• QPSQL PostgreSQL (versions 7.3 and above)
• QSQLITE2 SQLite version 2
• QSQLITE SQLite version 3
• QSYMSQL SQLite version 3 for Symbian SQL Database
• QTDS Sybase Adaptive Server Note: obsolete from Qt 4.7

Maǵlıwmatlar bazası hám DBMS haqqında tiykarǵı túsinikler.

Accessga jalg’aniw:

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");

db.setHostName("bigblue");

db.setDatabaseName("flightdb");

db.setUserName("acarlson");

db.setPassword("1uTbSbAs");

bool ok = db.open();

Maǵlıwmatlar bazası hám DBMS haqqında tiykarǵı túsinikler.

Accessge jalg’aniw :

Loyiha faylida:

QT += sql

Qandaydan bir faylda:

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");

qDebug() << db.drivers();

db.setHostName("localhost");

db.setDatabaseName("MSDB");

qDebug() << db.open();

Maǵlıwmatlar bazası hám DBMS haqqında tiykarǵı túsinikler

Sorawlar jaratiw:

QSqlQuery query;

query.exec("SELECT name,salary FROM employee WHERE salary> 500");

while (query.next()) {

QString name = query.value(0).toString();

int salary = query.value(1).toInt();

qDebug() << name << salary;

}

Maǵlıwmatlar bazası hám DBMS haqqında tiykarǵı túsinikler

Mag’lumatlarndi Mbga jaziw :

1) QSqlQuery query;

query.exec("INSERT INTO employee (id, name, salary) "

"VALUES (1001, 'Thad Beaumont', 65000)");

2) QSqlQuery query;

query.prepare("INSERT INTO employee (id, name, salary) "

"VALUES (:id, :name, :salary)");

query.bindValue(":id", 1001);

query.bindValue(":name", "Thad Beaumont");

query.bindValue(":salary", 65000);

query.exec();

Maǵlıwmatlar bazası hám DBMS haqqında tiykarǵı túsinikler

Mag’lumatlardi Mbga jaziw :

3) QSqlQuery query;

query.prepare("INSERT INTO employee (id, name, salary) "

"VALUES (?, ?, ?)");

query.addBindValue(1001);

query.addBindValue("Thad Beaumont");

query.addBindValue(65000);

query.exec();