qtforum.de

Code: Alles auswählen

#include <QtGui>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QtSql>
#include "eingabe.h"
#include "ui_eingabe.h"
#include "connection.h"


Eingabe::Eingabe(QWidget *parent) :
    QWidget(parent)
{

    ui.setupUi(this);

    connect(ui.AttributeButton, SIGNAL(clicked()), this, SLOT(Attribute()));
    connect(ui.VideoButton, SIGNAL(clicked()), this, SLOT(Video()));
    connect(ui.EndeButton, SIGNAL(clicked()), this, SLOT(Ende()));

}

void Eingabe::Attribute()
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName("Eingabedatenbank.sqlite");
    //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;

    db.open();

    if(db.isOpen()){

        Attribut1 =  ui.AttributeLine->text();
        Attribut2 =  ui.AttributeLine_2->text();
        Attribut3 =  ui.AttributeLine_3->text();
        Attribut4 =  ui.AttributeLine_4->text();
        Attribut5 =  ui.AttributeLine_5->text();
        Attribut6 =  ui.AttributeLine_6->text();
        Attribut7 =  ui.AttributeLine_7->text();
        Attribut8 =  ui.AttributeLine_8->text();
        Attribut9 =  ui.AttributeLine_9->text();
        Attribut10 =  ui.AttributeLine_10->text();
        Attribut11 =  ui.AttributeLine_11->text();
        Attribut12 =  ui.AttributeLine_12->text();
        Attribut13 =  ui.AttributeLine_13->text();
        Attribut14 =  ui.AttributeLine_14->text();
        Attribut15 =  ui.AttributeLine_15->text();

        QSqlQuery query;
        query.exec("create table eingabe (id int primary key, "
                   "Attribut_1 varchar(50), Attribut_2 varchar(50), Attribut_3 varchar(50), Attribut_4 varchar(50), "
                   "Attribut_5 varchar(50), Attribut_6 varchar(50), Attribut_7 varchar(50), Attribut_8 varchar(50), "
                   "Attribut_9 varchar(50), Attribut_10 varchar(50), Attribut_11 varchar(50), Attribut_12 varchar(50), "
                   "Attribut_13 varchar(50), Attribut_14 varchar(50), Attribut_15 varchar(50)");
        query.exec("insert into eingabe values(1, 'Attribut1')");
        query.exec("insert into eingabe values(2, 'Attribut2')");
        query.exec("insert into eingabe values(3, 'Attribut3')");
        query.exec("insert into eingabe values(4, 'Attribut4')");
        query.exec("insert into eingabe values(5, 'Attribut5')");
        query.exec("insert into eingabe values(6, 'Attribut6')");
        query.exec("insert into eingabe values(7, 'Attribut7')");
        query.exec("insert into eingabe values(8, 'Attribut8')");
        query.exec("insert into eingabe values(9, 'Attribut9')");
        query.exec("insert into eingabe values(10, 'Attribut10'");
        query.exec("insert into eingabe values(11, 'Attribut11')");
        query.exec("insert into eingabe values(12, 'Attribut12')");
        query.exec("insert into eingabe values(13, 'Attribut13')");
        query.exec("insert into eingabe values(14, 'Attribut14')");
        query.exec("insert into eingabe values(15, 'Attribut15')");
    }
    else {
    QMessageBox::information( this, "Achtung", "Speichern fehlgeschlagen!" );
    }




    ui.AttributeLine->setReadOnly(true);
    ui.AttributeLine_2->setReadOnly(true);
    ui.AttributeLine_3->setReadOnly(true);
    ui.AttributeLine_4->setReadOnly(true);
    ui.AttributeLine_5->setReadOnly(true);
    ui.AttributeLine_6->setReadOnly(true);
    ui.AttributeLine_7->setReadOnly(true);
    ui.AttributeLine_8->setReadOnly(true);
    ui.AttributeLine_9->setReadOnly(true);
    ui.AttributeLine_10->setReadOnly(true);
    ui.AttributeLine_11->setReadOnly(true);
    ui.AttributeLine_12->setReadOnly(true);
    ui.AttributeLine_13->setReadOnly(true);
    ui.AttributeLine_14->setReadOnly(true);
    ui.AttributeLine_15->setReadOnly(true);

    ui.AttributeButton->setEnabled(false);
    ui.VideoButton->show();
    ui.EndeButton->show();

    db.close();
}[code]