Написал небольшой класс для работы с бд посредством Qt.
Использовать класс нужно так:
тут пишем свою
строку коннекта:
--------------------------------------------------------------------------------------------
this->dbo.setDatabaseName( "CONNECTION STRING" );
--------------------------------------------------------------------------------------------
Потом так:
--------------------------------------------------------------------------------------------
1 RDatabase dbs;
2 dbs.init( "my_connection" );
3 if ( dbs.connect() ){
4 dbs.exec( "SELECT id, name FROM table" );
5 for ( int i = 0; i < dbs.count(); i++ ){
6 /*второй параметр 1 для перемещения курсора*/
7 id = dbs.value( 0, 1 );
8 name = dbs.value( 1 );
9 }
10 dbs.disconnect();
11 }
--------------------------------------------------------------------------------------------
Код класса
RDatabase.h--------------------------------------------------------------------------------------------
19
20 #ifndef RDATABASE_H_
21 #define RDATABASE_H_
22
23 #include <QtSql/QSqlDatabase>
24 #include <QtSql/QSqlQuery>
25 #include <QtSql/QSqlResult>
26 #include <QtSql/QSqlError>
27
28 class RDatabase {
29
30 public:
31 RDatabase();
32 virtual ~RDatabase();
33
34 public:
35 void init( const QString &name );
36 bool connect();
37 bool connected() const;
38 bool reconnect();
39 void disconnect();
40 bool exec( const QString &query );
41 const QString value( int i, int r = 0 );
42 int count();
43 const QString getLastError();
44
45 private:
46 QSqlDatabase dbo;
47 QSqlQuery dbq;
48 bool initialized;
49
50 };
51
52 #endif /* RDATABASE_H_ */
--------------------------------------------------------------------------------------------
RDatabase.cpp--------------------------------------------------------------------------------------------
19
20 #include "RDatabase.h"
21
22 RDatabase::RDatabase(){
23 this->initialized = false;
24 }
25
26 RDatabase::~RDatabase(){
27
28 }
29
30 /*
31 * Public members
32 */
33 void RDatabase::init(const QString &name){
34 if ( !this->initialized ){
35 this->dbo = QSqlDatabase::addDatabase( "QODBC", name );
36 /*
37 this->dbo.setDatabaseName( "DRIVER={MySQL ODBC 3.51 Driver};"
38 "Server=localhost;Port=3306;"
39 "Option=16384;Stmt=;Database=test;"
40 "Uid=root;Pwd=password" );
41 */
42 this->dbo.setDatabaseName( "CONNECTION STRING" );
45 }
46 this->initialized = true;
47 }
48 bool RDatabase::connect(){
49 return this->dbo.open();
50 }
51 bool RDatabase::connected() const{
52 return this->dbo.isOpen();
53 }
54 bool RDatabase::reconnect(){
55 this->dbo = QSqlDatabase::database( this->dbo.connectionName(), true );
56 return this->dbo.open();
57 }
58 void RDatabase::disconnect(){
59 this->dbo.close();
60 }
61 bool RDatabase::exec(const QString &query){
62 this->dbq = this->dbo.exec( query );
63 return this->dbq.isActive();
64 }
65 const QString RDatabase::value(int i, int r){
66 if ( r != 0 ) this->dbq.next();
67 return this->dbq.value( i ).toString();
68 }
69 int RDatabase::count(){
70 return this->dbq.numRowsAffected();
71 }
72 const QString RDatabase::getLastError(){
73 return this->dbo.lastError().text();
74 }
--------------------------------------------------------------------------------------------
