Login

[JonB]

@123456789
Permissions? To copy & paste code extracts into the text of your posts like I suggested?

[123456789]

LOGIN.CPP

#include "login.h"
#include "ui_login.h"

#define Path_to_DB "C:/Users/kss/Documents/ex3/este.sqlite"

login::login(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::login)
{
ui->setupUi(this);

myDb = QSqlDatabase::addDatabase("QSQLITE");
myDb.setDatabaseName(Path_to_DB);
QFileInfo checkFile(Path_to_DB);

if (checkFile.isFile())
{
    if(myDb.open())
    {
         ui->lblresult->setText("entrou");
    }

}else{
    ui->lblresult->setText("not");
}

}

login::~login()
{
delete ui;
qDebug() <<"connect closed";
myDb.close();
}

void login::on_pushButton_2_clicked()
{
ui->txtpass->setText("");
ui->txtuser->setText("");
}

void login::on_pushButton_clicked()
{
QString Username, Password;
Username = ui->txtuser->text();
Password = ui->txtpass->text();
QString Rol1 = ui->cmbniveis->currentText();

QSqlQuery qry;
if(qry.exec("SELECT User, Password, Role FROM Users Where User=\'" + Username +
            "\' AND Password=\'" + Password + "\' /*AND Role=\'" + Rol1 + "\'" ))
{
    if(qry.next())
    {
        ui->lblresult->setText("Connectado");
        QString msg = "Username = " + qry.value(0).toString() + "\n" +
                      "Password = " + qry.value(1).toString();
                      "Role = " + qry.value(2).toString();

        QMessageBox::warning(this, "Bem sucedido", msg);
    }else{

  ui->lblresult->setText("errado");
    }


}

}

[jsulm]

@123456789 said in Login:

/*AND

What is this?
Also use http://doc.qt.io/qt-5/qsqlquery.html#lastError to see what the error was.

[123456789]

@JonB
help me please

[JonB]

@123456789
Both I & @jsulm have indeed told you what you need to do/read up. In a forum like this you need to put some effort in yourself, nobody wants to keep writing your complete code for you, we have our own work to do too....

[123456789]

Where?
Not result
QSqlQuery qry;
if(qry.exec("SELECT User, Password, Role FROM Users Where User='" + Username +
"' Password='" + Password + "' /* Role='" + Rol1 + "'" ))
{

@jsulm
@JonB

[jsulm]

@123456789 When qry.exec() fails I would assume...

[123456789]

what @jsulm

[JonB]

@123456789

if (qry.exec(...)) {
   ...
} else {
  qDebug() << qry.lastError();
}

[jsulm]

@JonB said in Login:

qDebug(qry.lastError());

qDebug() << qry.lastError();