linux环境下QT语言写的学生成绩管理系统

#include "widget.h" #include "ui_widget.h" #include <QDebug> #include <QtSql/QSqlDatabase> #include <QtSql/QSqlQuery> #include <QMessageBox> Widget::Widget(QWidget *parent) : QWidget(parent), ui(new Ui::Widget) //构造函数 { ui->setupUi(this); mainform =new mainForm; } Widget::~Widget() { delete ui; } void Widget::on_Log_resgister_clicked() { ui->stackedWidget->setCurrentIndex(1); } void Widget::on_reg_login_clicked() { ui->stackedWidget->setCurrentIndex(0); } void Widget::on_register_2_clicked() { QString str1; //1.create connection QSqlDatabase db= QSqlDatabase::addDatabase("QSQLITE"); //2.set db name db.setDatabaseName("mydb"); //3.open.dbs bool ok =db.open(); if(!ok) { qDebug("open error\n"); } else { qDebug("open success\n"); } //4.operator db QSqlQuery query; query.exec("create table std2(id integer primary key,name text,sco text)"); str1.sprintf("insert into std2 values(null,'%s','%s')",ui->reg_id->text().toStdString().data(),ui->reg_pwd->text().toStdString().data()); // str1=ui->reg_id->text().toStdString().data(); //str2=ui->reg_pwd->text().toStdString().data(); // query.prepare("INSERT INTO std2(id,name,sco)" // "VALUES:id,:name,:sco"); // query.bindValue(":id",1001); //query.bindValue(":name",str1); //query.bindValue("sco",str2); if(ui->reg_id->text().isEmpty()||ui->reg_pwd->text().isEmpty()) //判断输入的是否为空 { QMessageBox msgBox; msgBox.setText("Register failed !! Please input id or pwd!!"); msgBox.exec(); } else { if(ui->reg_pwd->text()!=ui->reg_ensurepwd->text()) { QMessageBox msgBox; msgBox.setText("Register failed !! Please input pwd again!!"); msgBox.exec(); } else { if(query.exec(str1)) { QMessageBox msgBox; msgBox.setText("Register success!!"); msgBox.exec(); ui->reg_id->clear(); ui->reg_pwd->clear(); ui->reg_ensurepwd->clear(); } else { QMessageBox msgBox; msgBox.setText("Register failed!!"); msgBox.exec(); } } } //5.close.db db.close(); } void Widget::on_login_clicked() { /* QSqlDatabase db= QSqlDatabase::addDatabase("QSQLITE"); //2.set db name db.setDatabaseName("mydb"); //3.open.db bool ok =db.open(); if(!ok) { qDebug("open error\n"); } else { qDebug("open success\n"); } QString sql; sql.sprintf("SELECT name FROM std2 where name=%s",ui->Log_id->text().toStdString().data()); query.exec(sql); QSqlQuery query(sql); while (query.next()) { //显示查询结果，相当于回调函数 QString name= query.value(0).toString(); qDebug()<<"name:"<<name; this->hide(); main->show(); }*/ QString str; QSqlDatabase db= QSqlDatabase::addDatabase("QSQLITE"); //2.set db name db.setDatabaseName("mydb"); //3.open.db bool ok =db.open(); if(!ok) { qDebug("open error\n"); } else { qDebug("open success\n"); } QSqlQuery query; str.sprintf("select * from std2 where name='%s' and sco='%s'",ui->Log_id_2->text().toStdString().data(),ui->Log_pwd->text().toStdString().data()); query.exec(str); if(ui->Log_id_2->text().isEmpty()||ui->Log_pwd->text().isEmpty()) { QMessageBox msgBox; msgBox.setText("Please enter name or pwd!!"); msgBox.exec(); } else { if(query.next()) { //显示查询结果，相当于回调函数 mainform->getid(ui->Log_id_2->text()); this->hide(); mainform->show(); } else { QMessageBox msgBox; msgBox.setText("There is a error either name or pwd!!"); msgBox.exec(); } } /* if(ui->Log_id->text().isEmpty()||ui->Log_pwd->text().isEmpty()) { QMessageBox msgBox; msgBox.setText("Login failed!!"); msgBox.exec(); } else { if(query.exec(str)) { mainform->show(); this->hide(); QMessageBox msgBox; msgBox.setText("Login success!!"); msgBox.exec(); ui->Log_id->clear(); ui->Log_pwd->clear(); } else { QMessageBox msgBox; msgBox.setText("Login failed!!"); msgBox.exec(); } }*/ } void Widget::on_Log_cancel_clicked() { exit(0); }