-
大小: 3KB文件類型: .rar金幣: 2下載: 1 次發(fā)布日期: 2021-06-12
- 語言: 數(shù)據(jù)庫
- 標(biāo)簽: qt??sqlite??登錄??
資源簡介
初學(xué)者可以看看,一個簡單的qt連接sqlite完成登錄的小demo,我也是初學(xué),每做一個demo都會放上來的

代碼片段和文件信息
#include?“dialog.h“
#include?“ui_dialog.h“
#include?“QDebug“
#include?“QtSql/QSqlError“
#include?“QMessageBox“
Dialog::Dialog(QWidget?*parent)?:
????QDialog(parent)
????ui(new?Ui::Dialog)
{
????ui->setupUi(this);
????if(QSqlDatabase::contains(“qt_sql_default_connection“))
??????db?=?QSqlDatabase::database(“qt_sql_default_connection“);
????else
??????db?=?QSqlDatabase::addDatabase(“QSQLITE“);
??????db.setDatabaseName(“storehouse.db“);
??????if(!db.open())
??????{
??????????qDebug()< ??????}
}
Dialog::~Dialog()
{
????delete?ui;
}
void?Dialog::on_loginButton_clicked()
{
????QSqlQuery?query;
????QString?username?=?ui->lineEditUsername->text();
????QString?password?=?ui->lineEditPassword->text();
????QString?sql;
????sql?=?QString(“select?*?from?user?where?username?=?‘%1‘?and?password?=?‘%2‘“).arg(username).arg(password);
????qDebug()<
???query.exec(sql);
???if(!query.first())
???{
???????QMessageBox::about(this?“l(fā)ogin“?“l(fā)ogin?error“);
???????return;
???}
???QMessageBox::about(NULL?“l(fā)ogin“?“l(fā)ogin?success“);
????db.close();
????accept();
}
void?Dialog::on_cancelButton_clicked()
{
????reject();
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1239??2017-11-18?13:35??sqlite_login\dialog.cpp
?????文件????????449??2017-11-18?11:35??sqlite_login\dialog.h
?????文件???????2041??2017-11-18?11:10??sqlite_login\dialog.ui
?????文件????????175??2017-11-18?10:53??sqlite_login\main.cpp
?????文件???????3072??2017-11-18?12:18??sqlite_login\storehouse.db
?????文件????????375??2017-11-18?11:11??sqlite_login\test_login.pro
?????文件????????357??2017-11-18?13:43??sqlite_login\說明文檔.txt
?????目錄??????????0??2017-11-18?13:41??sqlite_login
-----------?---------??----------?-----??----
?????????????????7708????????????????????8
評論
共有 條評論