数据库.rar

#include "adminstudentinfor.h" #include "ui_adminstudentinfor.h" #include"mainwindow.h" #include"globel.h" #include"adminlogin.h" #include <QMessageBox> #include"adminstudentinforcheckall.h" #include <QPaintEvent> #include <QPainter> adminstudentinfor::adminstudentinfor(QWidget *parent) : QWidget(parent), ui(new Ui::adminstudentinfor) { ui->setupUi(this); } adminstudentinfor::~adminstudentinfor() { delete ui; } void adminstudentinfor::on_charu_clicked()//add { QString sid1=ui->xuehao1->text(); QString sid=ui->xuehao->text(); QString name=ui->xingming->text(); QString sex=ui->xingbie->text(); QString department=ui->xueyuan->text(); QString major=ui->zhuanye->text(); QString tclass=ui->banji->text(); QString id=ui->id->text(); QString password=ui->mima->text(); QString award=ui->jiangli->text(); QString punish=ui->chengfa->text(); QSqlQuery query; query.exec("select sid from student"); bool T2=true; while(query.next()) { QString sidfound= query.value(0).toString(); if(sidfound.compare(sid)==0) { QMessageBox::information(this ,tr("提示") , tr("该编号已存在不允许再次添加!")); T2=false; } } if(T2==true)//原本不存在 { QString sql; sql = QString("insert into student (sid,name,sex,department,major,class,id,password,award,punish)" " VALUES ('%1', '%2' , '%3','%4','%5','%6','%7','%8','%9','%10' )") .arg(sid).arg(name).arg(sex).arg(department).arg(major).arg(tclass).arg(id).arg(password).arg(award).arg(punish); bool ok = query.exec(sql);//提交 if(ok) { QMessageBox::information(this ,tr("提示") , tr("添加成功!")); } else { QMessageBox::information(this ,tr("提示") , tr("添加失败!")); } } } void adminstudentinfor::on_shanchu_clicked() { QString sid1=ui->xuehao1->text(); QString sid=ui->xuehao->text(); QString name=ui->xingming->text(); QString sex=ui->xingbie->text(); QString department=ui->xueyuan->text(); QString major=ui->zhuanye->text(); QString tclass=ui->banji->text(); QString id=ui->id->text(); QString password=ui->mima->text(); QString award=ui->jiangli->text(); QString punish=ui->chengfa->text(); QSqlQuery query; // db.exec("SET NAMES 'GBK'"); query.exec("select sid from student"); bool T2=true; while(query.next()) { QString sidfound= query.value(0).toString(); if(sid.compare(sidfound)==0) { QString sql; sql = QString("DELETE FROM student " " where sid = '%0' ").arg(sid); QSqlQuery query; bool ok = query.exec(sql); if(ok) { QMessageBox::information(this ,tr("提示") , tr("删除成功!")); T2=false; } else { QMessageBox::information(this ,tr("提示") , tr("删除失败!")); T2=false; } } } if(T2==true) { QMessageBox::information(this ,tr("提示") , tr("改编号不存在无法删除")); } } void adminstudentinfor::on_gengxin_clicked() { QString sid1=ui->xuehao1->text(); QString sid=ui->xuehao->text(); QString name=ui->xingming->text(); QString sex=ui->xingbie->text(); QString department=ui->xueyuan->text(); QString major=ui->zhuanye->text(); QString tclass=ui->banji->text(); QString id=ui->id->text();//身份证号 QString password=ui->mima->text(); QString award=ui->jiangli->text(); QString punish=ui->chengfa->text(); QSqlQuery query; query.exec("select sid from student"); bool T2=true; while(query.next()) { QString sidfound= query.value(0).toString(); if(sid.compare(sidfound)==0) { QString sql; sql = QString("UPDATE student " "set name='%0',sex='%1',department='%2',major='%3',class='%4',id='%5',password='%6',award='%7',punish='%8'" " where sid = '"+sid+"' ") .arg(name).arg(sex).arg(department).arg(major).arg(tclass).arg(id).arg(password).arg(award).arg(punish); QSqlQuery query; bool ok = query.exec(sql); if(ok) { QMessageBox::information(this ,tr("提示") , tr("更改成功!")); T2=false; } else { QMessageBox::information(this ,tr("提示") , tr("更改失败!")); T2=false; } } } if(T2==true) { QMessageBox::information(this ,tr("提示") , tr("该编号不存在，无法更改")); } } void adminstudentinfor::on_all_clicked() { QSqlQuery query; query.exec("select sid,name,sex,department,major,class,award,punish from student"); while(query.next()) { QStringList q; q.clear(); QString sid = query.value(0).toString(); QString name = query.value(1).toString(); QString sex = query.value(2).toString(); QString department =query.value(3).toString(); QString major=query.value(4).toString(); QString tclass=query.value(5).toString(); QString award=query.value(6).toString(); QString punish=query.value(7).toString(); q<<sid<<name<<sex<<department<<major<<tclass<<award<<punish; list_all_student.append(q); } this- rel='nofollow' onclick='return false;'>hide(); adminstudentinforcheckall *rt=new adminstudentinforcheckall; rt->show(); } void adminstudentinfor::on_chaxun_clicked() { QSqlQuery query; //query.exec("SET NAMES 'GBK'"); QString sid1=ui->xuehao1->text(); QString sid=ui->xuehao->text(); query.exec("select sid,name,sex,department,major,class,id,password,award,punish from student where sid='"+sid1+"'"); if(query.next()) { // qDebug()<<"第一条数据为"<<query.value(0).toString(); ui->xuehao->setText(query.value(0).toString()); ui->xingming->setText(query.value(1).toString()); ui->xingbie->setText(query.value(2).toString()); ui->xueyuan->setText(query.value(3).toString()); ui->zhuanye->setText(query.value(4).toString()); ui->banji->setText(query.value(5).toString()); ui->id->setText(query.value(6).toString()); ui->mima->setText(query.value(7).toString()); ui->jiangli->setText(query.value(8).toString()); ui->chengfa->setText(query.value(9).toString()); } else { if(sid.compare("")==0)//空是什么意思？？ return; else QMessageBox::information(this, "警告", "不存在你所要查找的编号"); } } void adminstudentinfor::on_fanhui_clicked() { this->hide(); adminlogin *dg=new adminlogin; dg->show(); } void adminstudentinfor::paintEvent (QPaintEvent *event) { QPainter painter(this); painter.drawPixmap(rect(), QPixmap(":/admin.jpeg"), QRect()); }