主界面
#ifndef DBAWIN_H#define DBAWIN_H#include<QtGui>class dbawin:public QWidget{ Q_OBJECTpublic slots: void ret(void); void lend(void); void change(void); void changestudent(void);public: dbawin(QWidget *parent=0);public: QLabel lendla,retla; QPushButton lendb,retb,inputb,changb,changes; QLineEdit lendline,retline;};#endif實現
#include "myWeiget.h"#include "studentinfo.h"#include "studentwin.h"#include "dbawin.h"#include "tushuku.h"#include <QSqlDriver>#include <QSqlDatabase>#include <QSqlQuery>#include <QtSql>dbawin::dbawin(QWidget *parent) :QWidget(parent),lendla(QObject::tr("借書號"),this),lendline(this), retla(QObject::tr("還書號"),this),retline(this), lendb(QObject::tr("借出"),this),retb(QObject::tr("歸還"),this), changb(QObject::tr("修改庫存圖書"),this), changes(QObject::tr("修改學生信息"),this){ retla.setGeometry(30,30,50,30); retline.setGeometry(100,30,100,30); retb.setGeometry(QRect(250,30,60,30)); lendla.setGeometry(30,90,50,30); lendline.setGeometry(100,90,100,30); lendb.setGeometry(QRect(250,90,60,30)); inputb.setGeometry(QRect(80,200,100,40)); changb.setGeometry(QRect(50,200,100,40)); changes.setGeometry(QRect(220,200,100,40)); connect(&lendb,SIGNAL(clicked(void)),this,SLOT(lend(void))); connect(&retb,SIGNAL(clicked(void)),this,SLOT(ret(void))); connect(&changb,SIGNAL(clicked(void)),this,SLOT(change(void))); connect(&changes,SIGNAL(clicked(void)),this,SLOT(changestudent(void)));}void dbawin::lend(){ QString bno=lendline.text().trimmed(); QSqlQuery query; query.PRepare("UPDATE book SET 借閱狀態='out' WHERE 書號=:bno"); query.bindValue(":bno",bno); query.exec(); QSqlQuery query2; query2.prepare("select * from book where 書號=:bno"); query2.bindValue(":bno",bno); query2.exec(); QSqlQueryModel *model = new QSqlQueryModel; model->setQuery(query2); QTableView *view = new QTableView; view->setModel(model); view->show();}void dbawin::ret(){ QString bno=retline.text().trimmed(); QSqlQuery query; query.prepare("UPDATE book SET 借閱狀態='in' WHERE 書號=:bno"); query.bindValue(":bno",bno); query.exec(); QSqlQuery query2; query2.prepare("select * from book where 書號=:bno"); query2.bindValue(":bno",bno); query2.exec(); QSqlQueryModel *model = new QSqlQueryModel; model->setQuery(query2); QTableView *view = new QTableView; view->setModel(model); view->show();}void dbawin::change(){ tushuku *d= new tushuku(); d->show();}void dbawin::changestudent(){ studentinfo *d= new studentinfo(); d->show();}新聞熱點
疑難解答
