StudentInformationManagementSystem.zip

#include "admin_find_show.h" #include "ui_admin_find_show.h" #include <QSqlQuery> #include<QMessageBox> #include<QDebug> admin_find_show::admin_find_show(QWidget *parent) : QDialog(parent), ui(new Ui::admin_find_show) { //添加背景图片的代码 this->setAutoFillBackground(true); QPalette palette; QPixmap pixmap(":/pic/ff.jpg"); palette.setBrush(QPalette::Window, QBrush(pixmap)); this->setPalette(palette); ui->setupUi(this); QSqlDatabase db= QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName("StudentInformationManagementSystem.db"); if ( !db.open()){ qDebug()<<"没有打开！"; } } admin_find_show::~admin_find_show() { delete ui; } void admin_find_show::on_findBtn_clicked() { QString findId= ui->id_find->text(); QString findName=ui->name_find->text(); //多表查询知识点 select table1.abc from table1 inner join table2 on table1.xxx=table2.xxx; QSqlQuery query1;//执行第一个sql语句 QSqlQuery query2;//执行第二个sql语句 if(!findId.isEmpty()){ QString sqlById1=QString("select student.id,student.name,student.sex,student.age,student.address,student.phone_number,student.dormitory,student.className,class.department,class.instructor,class.instructor_number,class.people_number from student inner join class on student.className=class.name and student.id='%1'").arg(findId); query1.exec(sqlById1); bool Notfond=true; bool InfoNotAll=true; while (query1.next()) { QString id=query1.value(0).toString(); QString name=query1.value(1).toString(); QString sex=query1.value(2).toString(); QString age=query1.value(3).toString(); QString address=query1.value(4).toString(); QString phoneNumber=query1.value(5).toString(); QString dormitory=query1.value(6).toString(); QString className=query1.value(7).toString(); QString department=query1.value(8).toString(); QString instructor=query1.value(9).toString(); QString instructorPhone=query1.value(10).toString(); //下面为查到的信息 ui->IdLineEdit->setText(id); ui->NameLineEdit->setText(name); ui->SexLineEdit->setText(sex); ui->AgeLineEdit->setText(age); ui->AddressLineEdit->setText(address); ui->PhoneNumberLineEdit->setText(phoneNumber); ui->DormitoryLineEdit->setText(dormitory); ui->classLineEdit->setText(className); ui->DepartmentLineEdit->setText(department); ui->InstructorLineEdit->setText(instructor); ui->InstructorPhoneNumberLineEdit->setText(instructorPhone); Notfond=false; InfoNotAll=false; } if(InfoNotAll){ QString sqlById2=QString("select student.id,student.name,student.sex,student.age,student.address,student.phone_number,student.dormitory,student.className from student where student.id='%1'").arg(findId); query2.exec(sqlById2); while (query2.next()) { QString id=query2.value(0).toString(); QString name=query2.value(1).toString(); QString sex=query2.value(2).toString(); QString age=query2.value(3).toString(); QString address=query2.value(4).toString(); QString phoneNumber=query2.value(5).toString(); QString dormitory=query2.value(6).toString(); QString className=query2.value(7).toString(); //下面为查到的信息 ui->IdLineEdit->setText(id); ui->NameLineEdit->setText(name); ui->SexLineEdit->setText(sex); ui->AgeLineEdit->setText(age); ui->AddressLineEdit->setText(address); ui->PhoneNumberLineEdit->setText(phoneNumber); ui->DormitoryLineEdit->setText(dormitory); ui->classLineEdit->setText(className); ui->DepartmentLineEdit->setText("null"); ui->InstructorLineEdit->setText("null"); ui->InstructorPhoneNumberLineEdit->setText("null"); Notfond=false; } } if(Notfond){ QMessageBox::information(this, "警告", "未找到相关信息"); this->close(); admin_find_show *adminFindShow=new admin_find_show; adminFindShow->show(); } } else{ QString sqlByName1=QString("select student.id,student.name,student.sex,student.age,student.address,student.phone_number,student.dormitory,student.className,class.department,class.instructor,class.instructor_number,class.people_number from student inner join class on student.className=class.name and student.name='%1'").arg(findName); query1.exec(sqlByName1); bool Notfond=true; bool InfoNotAll=true; while (query1.next()) { QString id=query1.value(0).toString(); QString name=query1.value(1).toString(); QString sex=query1.value(2).toString(); QString age=query1.value(3).toString(); QString address=query1.value(4).toString(); QString phoneNumber=query1.value(5).toString(); QString dormitory=query1.value(6).toString(); QString className=query1.value(7).toString(); QString department=query1.value(8).toString(); QString instructor=query1.value(9).toString(); QString instructorPhone=query1.value(10).toString(); //下面为查到的信息 ui->IdLineEdit->setText(id); ui->NameLineEdit->setText(name); ui->SexLineEdit->setText(sex); ui->AgeLineEdit->setText(age); ui->AddressLineEdit->setText(address); ui->PhoneNumberLineEdit->setText(phoneNumber); ui->DormitoryLineEdit->setText(dormitory); ui->classLineEdit->setText(className); ui->DepartmentLineEdit->setText(department); ui->InstructorLineEdit->setText(instructor); ui->InstructorPhoneNumberLineEdit->setText(instructorPhone); Notfond=false; InfoNotAll=false; } if(InfoNotAll){ QString sqlByName2=QString("select student.id,student.name,student.sex,student.age,student.address,student.phone_number,student.dormitory,student.className from student where student.name='%1'").arg(findName); query2.exec(sqlByName2); while (query2.next()) { QString id=query2.value(0).toString(); QString name=query2.value(1).toString(); QString sex=query2.value(2).toString(); QString age=query2.value(3).toString(); QString address=query2.value(4).toString(); QString phoneNumber=query2.value(5).toString(); QString dormitory=query2.value(6).toString(); QString className=query2.value(7).toString(); //下面为查到的信息 ui->IdLineEdit->setText(id); ui->NameLineEdit->setText(name); ui->SexLineEdit->setText(sex); ui->AgeLineEdit->setText(age); ui->AddressLineEdit->setText(address); ui->PhoneNumberLineEdit->setText(phoneNumber); ui->DormitoryLineEdit->setText(dormitory); ui->classLineEdit->setText(className); ui->DepartmentLineEdit->setText("null"); ui->InstructorLineEdit->setText("null");