图书管理系统学生界面

2019-11-06 07:16:16

字体：大中小

来源：转载

供稿：网友

头文件

#ifndef STUDENTWIN_H#define STUDENTWIN_H#include<QtGui>class stdwin:public QWidget{ Q_OBJECTpublic 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(); }}

上一篇：图书管理系统图书信息界面

下一篇：蓝桥杯 - 算法训练字符串的展开 C语言实现

学习交流

索泰发布一款GTX 1070 Mini迷你版本:小机

索泰发布一款GTX 1070 Mini迷你版本:小机箱大爱...

热门图片

猜你喜欢的新闻

猜你喜欢的关注