图书管理系统主界面
头文件
#ifndef MYWEIGET_H #define MYWEIGET_H #include<QtGui> class cmyweiget:public QWidget { Q_OBJECT public slots: void dba_slots(void); void student_slots(void); public: cmyweiget(QWidget *parent=0); public: QLabel la,lb,lc; QPushButton DBADENGLU,STUDENTDENGLU; QLineEdit ZHANGHAO; QLineEdit MIMA; }; #endif实现
#include "myWeiget.h" #include "studentinfo.h" #include "studentwin.h" #include "dbawin.h" #include "tushuku.h" #include <QSqlDriver> #include <QSqlDatabase> #include <QSqlQuery> #include <QtSql> cmyweiget::cmyweiget(QWidget *parent) :QWidget(parent),la(QObject::tr("图书管理系统"),this), lb(QObject::tr("用户名"),this),lc(QObject::tr("密码"),this), DBADENGLU(QObject::tr("管理员登录"),this),STUDENTDENGLU(QObject::tr("学生登录"),this), ZHANGHAO(this),MIMA(this) { la.setGeometry(100,30,250,51); lc.setGeometry(82,150,54,30); lb.setGeometry(82,100,54,30); QFont font("Aharoni",26); QFont font2("Aharoni",9); la.setFont(font); lb.setFont(font2); lc.setFont(font2); DBADENGLU.setGeometry(QRect(50,200,100,40)); STUDENTDENGLU.setGeometry(QRect(250,200,100,40)); ZHANGHAO.setGeometry(QRect(142,100,133,30)); MIMA.setGeometry(QRect(142,150,133,30)); connect(&DBADENGLU,SIGNAL(clicked(void)),this,SLOT(dba_slots(void))); connect(&STUDENTDENGLU,SIGNAL(clicked(void)),this,SLOT(student_slots(void))); } void cmyweiget::dba_slots() { QString loginid=ZHANGHAO.text().trimmed(); QString loginpassWord=MIMA.text().trimmed(); QSqlQuery query; query.exec("SELECT * FROM dbalogin"); while(query.next()) { QString id=query.value(0).toString(); QString password=query.value(1).toString(); if(loginid==id && loginpassword==password) { dbawin *s= new dbawin(); s->show(); break; } } } void cmyweiget::student_slots() { QString loginid=ZHANGHAO.text().trimmed(); QString loginpassword=MIMA.text().trimmed(); QSqlQuery query; query.exec("SELECT * FROM studentlogin"); while(query.next()) { QString id=query.value(0).toString(); QString password=query.value(1).toString(); if(loginid==id && loginpassword==password) { stdwin *s= new stdwin(); s->show(); break; } } }