图书管理系统学生界面

头文件

#ifndef STUDENTWIN_H #define STUDENTWIN_H #include<QtGui> class stdwin:public QWidget { Q_OBJECT public slots: void lookfor_slots(void); public: stdwin(QWidget *parent=0); public: QLabel std1,std2,std3; QPushButton fbbegin; QLineEdit stdfbno,stdfbname,stdfbpublication; }; #endif // STUDENTWIN_H

实现

#include "myWeiget.h" #include "studentinfo.h" #include "studentwin.h" #include "dbawin.h" #include "tushuku.h" #include <QSqlDriver> #include <QSqlDatabase> #include <QSqlQuery> #include <QtSql> stdwin::stdwin(QWidget *parent) :QWidget(parent),std1(QObject::tr("请输入书名"),this), std2(QObject::tr("请输入书号"),this),std3(QObject::tr("请输入书的出版社"),this), stdfbno(this),stdfbname(this),stdfbpublication(this),fbbegin(QObject::tr("查询"),this) { std1.setGeometry(40,30,110,30); std2.setGeometry(40,90,110,30); std3.setGeometry(40,150,140,30); QFont font("Aharoni",26); QFont font2("Aharoni",19); stdfbname.setFont(font2); stdfbno.setFont(font2); stdfbpublication.setFont(font2); fbbegin.setGeometry(QRect(150,200,100,40)); stdfbname.setGeometry(QRect(180,30,160,30)); stdfbno.setGeometry(QRect(180,90,160,30)); stdfbpublication.setGeometry(QRect(180,150,160,30)); connect(&fbbegin,SIGNAL(clicked(void)),this,SLOT(lookfor_slots(void))); } void stdwin::lookfor_slots() { QString bno=stdfbno.text().trimmed(); QString bpubl=stdfbpublication.text().trimmed(); QString bname = stdfbname.text(); if(bno.isEmpty()) { if((!bname.isEmpty())&&(!bpubl.isEmpty())) { QSqlQuery query; query.PRepare("SELECT * FROM book WHERE 书名=:bname AND 出版社=:bpubl"); query.bindValue(":bname",bname); query.bindValue(":bpubl",bpubl); query.exec(); QSqlQueryModel *model = new QSqlQueryModel; model->setQuery(query); QTableView *view = new QTableView; view->setModel(model); view->show();} if(bname.isEmpty()&&(!bpubl.isEmpty())) { QSqlQuery query; query.prepare("SELECT * FROM book WHERE 出版社=:bpubl"); query.bindValue(":bpubl",bpubl); query.exec(); QSqlQueryModel *model = new QSqlQueryModel; model->setQuery(query); QTableView *view = new QTableView; view->setModel(model); view->show();} if((!bname.isEmpty())&&bpubl.isEmpty()) { QSqlQuery query; query.prepare("SELECT * FROM book WHERE 书名=:bname"); query.bindValue(":bname",bname); query.exec(); QSqlQueryModel *model = new QSqlQueryModel; model->setQuery(query); QTableView *view = new QTableView; view->setModel(model); view->show();} } else { QSqlQuery query; query.prepare("SELECT * FROM book WHERE 书号=:bno "); query.bindValue(":bno",bno); query.exec(); QSqlQueryModel *model = new QSqlQueryModel; model->setQuery(query); QTableView *view = new QTableView; view->setModel(model); view->show(); } }