1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
| #ifndef CONNECTIONDATABASE_H_
#define CONNECTIONDATABASE_H_
#include <QApplication>
#include <QMessageBox>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
static bool CreateConnectionDatabase()
{
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(":memory:");
if (!db.open()) {
QMessageBox::critical(0, qApp->tr("Cannot open database"),
qApp->tr("Unable to establish a database connection.\n"
"This example needs SQLite support. Please read "
"the Qt SQL driver documentation for information how "
"to build it.\n\n"
"Click Cancel to exit."), QMessageBox::Cancel);
return false;
}
QSqlQuery query;
query.exec("create table Iptables (nameFirewall varchar(20) primary key,id int secondary key "
"adresseIPFirewall varchar(20), masqueReseauFirewall varchar(20),"
"adresseMACFirewall varchar(20), descriptionFirewall varchar(100))");
query.exec("create table tableViewRules (id int primary key, "
"Source varchar(20), Destination varchar(20),"
"Service varchar(20), Interface varchar(20),"
"Direction varchar(20), Action varchar(20),"
"Options varchar(20), Commentaires varchar(50))");
query.exec("create table tableViewNAT (id int primary key, "
"Source originale varchar(20), Destination originale varchar(20),"
"Service original varchar(20), Source traduite varchar(20),"
"Destination traduite varchar(20), Service traduit varchar(20),"
"Options varchar(20), Commentaires varchar(50))");
return true;
}
#endif /* CONNECTIONDATABASE_H_ */ |
Partager