-
大小: 1.98MB文件類型: .rar金幣: 2下載: 0 次發(fā)布日期: 2023-10-15
- 語言: 數(shù)據(jù)庫
- 標簽:
資源簡介
利用QT連接MYSQL進行數(shù)據(jù)庫課程實驗的設計,壓縮包里還有QT CREATOR的教程以及實驗要求文檔,對于想學習利用QT編寫圖形界面的同學有一定幫助。售票系統(tǒng)實現(xiàn)了管理員和用戶的分離以及各種對數(shù)據(jù)庫的基本操作。

代碼片段和文件信息
#include?“bookcardlg.h“
#include?“ui_bookcardlg.h“
#include?
#include?
#include?
#include?
#include?ject>
#include?
#include?
#include?
#include?
#include?
bookcardlg::bookcardlg(QWidget?*parent)?:
????QDialog(parent)
????ui(new?Ui::bookcardlg)
{
????ui->setupUi(this);
}
bookcardlg::~bookcardlg()
{
????delete?ui;
}
void?bookcardlg::on_buttonBox_2_accepted()
{
????QSqlQuery?query1;
????QSqlQuery?query2;
????QSqlQuery?query3;
????QSqlQuery?query4;
????int?availnum;
????query1.prepare(“select?*?from?cars?where?location=?“);
????query1.addBindValue(ui->lineEdit_2->text());
????query1.exec();
????if(query1.next()){???//找到指定地點的車輛
????????availnum=query1.value(3).toInt();
????????qDebug()< ????????if(availnum>=ui->lineEdit_3->text().toInt()){?//有車,可以預訂
????????????query2.prepare(“select?*?from?cutomers?where?custname=?“);
????????????query2.addBindValue(ui->lineEdit_4->text());
????????????query2.exec();
????????????if(query2.next()){????//老客戶
????????????????int?pwd=query2.value(1).toInt();
????????????????if(pwd!=ui->lineEdit_5->text().toInt()){?//密碼不對
?????????????????????QMessageBox::warning(thistr(“failed“)tr(“sorry!?the?flight?not?exist“)QMessageBox::Close);
????????????????}
????????????????else{
????????????????????query3.prepare(“update?cars?set?numavail=numavail-??where?location=?“);?//修改車輛數(shù)據(jù)庫
????????????????????query3.addBindValue(ui->lineEdit_3->text().toInt());
????????????????????query3.addBindValue(ui->lineEdit_2->text());
????????????????????query3.exec();
????????????????????query4.prepare(“insert?into?reservations?values(????)“);
????????????????????query4.addBindValue(ui->lineEdit_4->text());
????????????????????query4.addBindValue(3);
????????????????????query4.addBindValue(ui->lineEdit_2->text());
????????????????????query4.addBindValue(ui->lineEdit_3->text().toInt());
????????????????????query4.exec();
????????????????????QMessageBox::warning(thistr(“SUCCESS“)tr(“BOOK?SUCCESSFULLY!“)QMessageBox::Close);
????????????????}
????????????}
????????????else{???????????//新客戶
????????????????query3.prepare(“insert?into?customers?values(??)“);
????????????????query3.addBindValue(ui->lineEdit_4->text());
????????????????query3.addBindValue(ui->lineEdit_5->text().toInt());
????????????????query3.exec();
????????????????query3.prepare(“update?cars?set?numavail=numavail-??where?location=?“);
????????????????query3.addBindValue(ui->lineEdit_3->text().toInt());
????????????????query3.addBindValue(ui->lineEdit_2->text());
????????????????query3.exec();
????????????????query4.prepare(“insert?into?reservations?values(????)“);
????????????????query4.addBindValue(ui->lineEdit_4->text());
????????????????query4.addBindValue(3);
????????????????query4.addBindValue(ui->lineEdit_2->text());
????????????????query4.addBindValue(ui->lineEdit_3
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????4824??2011-05-24?20:51??travel\bookcardlg.cpp
?????文件????????436??2011-05-24?16:35??travel\bookcardlg.h
?????文件???????5608??2011-05-24?18:00??travel\bookcardlg.ui
?????文件???????7823??2011-05-25?23:15??travel\bookflidlg.cpp
?????文件????????508??2011-05-25?17:10??travel\bookflidlg.h
?????文件??????10306??2011-05-25?17:10??travel\bookflidlg.ui
?????文件???????4683??2011-05-24?22:53??travel\bookhoteldlg.cpp
?????文件????????415??2011-05-24?20:51??travel\bookhoteldlg.h
?????文件???????5605??2011-05-24?18:04??travel\bookhoteldlg.ui
?????文件???????2656??2011-05-24?13:45??travel\carsdlg.cpp
?????文件????????486??2011-05-23?23:21??travel\carsdlg.h
?????文件???????7297??2011-05-24?13:11??travel\carsdlg.ui
?????文件???????6874??2011-05-26?20:51??travel\chandlg.cpp
?????文件????????519??2011-05-24?17:04??travel\chandlg.h
?????文件??????10847??2011-05-24?17:08??travel\chandlg.ui
?????文件????????722??2011-05-23?18:11??travel\connection.h
?????文件???????2477??2011-05-24?13:05??travel\custdlg.cpp
?????文件????????523??2011-05-24?13:05??travel\custdlg.h
?????文件???????7332??2011-05-24?22:24??travel\custdlg.ui
?????文件???????1704??2011-05-24?21:40??travel\dingdandlg.cpp
?????文件????????399??2011-05-24?21:24??travel\dingdandlg.h
?????文件???????2652??2011-05-24?23:21??travel\dingdandlg.ui
?????文件???????2686??2011-05-24?13:05??travel\hoteldlg.cpp
?????文件????????494??2011-05-24?00:05??travel\hoteldlg.h
?????文件???????7296??2011-05-24?18:00??travel\hoteldlg.ui
?????文件???????1695??2011-05-24?21:56??travel\linedlg.cpp
?????文件????????338??2011-05-24?21:56??travel\linedlg.h
?????文件???????2642??2011-05-24?21:56??travel\linedlg.ui
?????文件???????2448??2011-05-25?14:57??travel\logindlg.cpp
?????文件????????441??2011-05-24?23:06??travel\logindlg.h
............此處省略67個文件信息
評論
共有 條評論