91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 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個文件信息

評論

共有 條評論

相關資源