1 #ifndef DBTOOLS_H

     2 #define DBTOOLS_H

     3 

     4 #include <QObject>

     5 

     6 class DBTools : QObject

     7 {

     8     Q_OBJECT

     9 public:

    10     explicit DBTools(QObject *parent = 0);

    11     ~DBTools();

    12 

    13 public:

    14     void importCSV(QString fileName);

    15     void testDB();

    16 

    17 signals:

    18 

    19 public slots:

    20 

    21 private:

    22     bool createDB();

    23     void insertContact( QString name, QString mobile, QString deskphone,

    24                         int xtn, QString email, QString skype,

    25                         QString twitter, QString title, int site,

    26                         int department, int floor);

    27     int getLastInsertRowId();

    28     bool createTable(QString sqlStmt);

    29 

    30 };

    31 

    32 #endif // DBTOOLS_H