aa

#include "loginadmin.h"
#include "ui_loginadmin.h"
#include <QSqlDatabase>
#include <QtSql/QSqlError>
#include <QtSql/QSqlQuery>
#include <QMessageBox>

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

    QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
    db.setHostName("localhost");
    db.setDatabaseName("registroDev");
    db.setPort(543);
    db.setUserName("postgres");
    db.setPassword("Lb1045723");

    if(!db.open()){
        QMessageBox::warning(this, "Error", db.lastError().text());
    }else{
        QMessageBox::information(this, "Genial", "Conexion con DB exitosa");

    }


}

LoginAdmin::~LoginAdmin()
{
    delete ui;
}

void LoginAdmin::on_pushButton_clicked()
{

    QString sid = ui->lineEdit_ID->text();
    QString sclave = ui->lineEdit_CLAVE->text();

    QSqlQuery query;
    QString q = "SELECT username, password FROM registros WHERE username='" + sid + "';";
    query.exec(q);

    while(query.next())
    {
        QString user = query.value(0).toString();
        QString passwd = query.value(1).toString();

        if(sid == user && sclave == passwd){
            QMessageBox::information(this, "Cool", "Bienvenido");
        }else {
            QMessageBox::warning(this, "Error", "No existe esta cuenta");
        }
    }

}