-
Notifications
You must be signed in to change notification settings - Fork 0
/
user.cpp
40 lines (37 loc) · 1.16 KB
/
user.cpp
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
#include "user.h"
#include <QSql>
#include <QSqlQuery>
#include <QSqlError>
#include <QDebug>
#include <QMessageBox>
user::user(QObject* parent):QObject(parent)
{
this->username = "test";
this->password = "test";
}
user::user(QString usr, QString passwd, QObject* parent):QObject(parent), username(usr), password(passwd) {}
bool user::check_login() {
QSqlQuery query;
QString cmd = "SELECT user.* FROM user WHERE user.username = :user AND user.password = :passwd;";
query.prepare(cmd);
query.bindValue(":user", this->username);
query.bindValue(":passwd", this->password);
if(query.exec()) {
if(query.next()) {
qInfo() << query.value(1);
return true;
}
else {
QMessageBox box;
box.setText("Incorrect username or password!!!");
box.exec();
return false;
}
}
else {
QMessageBox box;
box.setText("query failed unable to access database!!!");
box.exec();
return false;
}
}