图书管理系统学生信息界面

2019-11-06 07:16:24

字体：大中小

来源：转载

供稿：网友

头文件

#ifndef STUDENTINFO_H#define STUDENTINFO_H#include <QtGui>class studentinfo:public QWidget{ Q_OBJECTpublic slots: void change1(void); void dele1(void); void input1(void);public: studentinfo(QWidget *parent=0);public: QLabel id2,pass,name,dept; QPushButton input,change,dele; QLineEdit idline,passline,nameline,deptline;};#endif

实现

#include "myWeiget.h"#include "studentinfo.h"#include "studentwin.h"#include "dbawin.h"#include "tushuku.h"#include <QSqlDriver>#include <QSqlDatabase>#include <QSqlQuery>#include <QtSql>studentinfo::studentinfo(QWidget *parent) :QWidget(parent),id2(QObject::tr("用户名"),this),pass(QObject::tr("密码"),this), name(QObject::tr("姓名"),this),dept(QObject::tr("院系"),this), input(QObject::tr("增加"),this),change(QObject::tr("修改"),this), dele(QObject::tr("删除"),this), idline(this),passline(this),nameline(this),deptline(this){ id2.setGeometry(20,20,60,30); pass.setGeometry(100,20,60,30); name.setGeometry(180,20,60,30); dept.setGeometry(260,20,60,30); idline.setGeometry(20,70,60,30); passline.setGeometry(100,70,60,30); nameline.setGeometry(180,70,60,30); deptline.setGeometry(260,70,60,30); input.setGeometry(QRect(30,200,100,40)); change.setGeometry(QRect(370,200,100,40)); dele.setGeometry(QRect(200,200,100,40)); connect(&input,SIGNAL(clicked(void)),this,SLOT(input1(void))); connect(&change,SIGNAL(clicked(void)),this,SLOT(change1(void))); connect(&dele,SIGNAL(clicked(void)),this,SLOT(dele1(void)));}void studentinfo::input1(){ QString sno=idline.text().trimmed(); QString spass=passline.text().trimmed(); QString sname=nameline.text().trimmed(); QString sdept=deptline.text().trimmed(); QSqlQuery query; query.PRepare("INSERT INTO studentlogin values(:sno,:spass,:sname,:sdept)"); query.bindValue(":sno",sno); query.bindValue(":spass",spass); query.bindValue(":sname",sname); query.bindValue(":sdept",sdept); query.exec(); QSqlQuery query2; query2.exec("select * from studentlogin"); QSqlQueryModel *model = new QSqlQueryModel; model->setQuery(query2); QTableView *view = new QTableView; view->setModel(model); view->show();}void studentinfo::change1(){ QString sno=idline.text().trimmed(); QString spass=passline.text().trimmed(); QString sname=nameline.text().trimmed(); QString sdept=deptline.text().trimmed(); QSqlQuery query; query.prepare("DELETE from studentlogin where 用户名=:sno"); query.bindValue(":sno",sno); query.exec(); query.prepare("INSERT INTO studentlogin values(:sno,:spass,:sname,:sdept)"); query.bindValue(":sno",sno); query.bindValue(":spass",spass); query.bindValue(":sname",sname); query.bindValue(":sdept",sdept); query.exec(); QSqlQuery query2; query2.exec("select * from studentlogin"); QSqlQueryModel *model = new QSqlQueryModel; model->setQuery(query2); QTableView *view = new QTableView; view->setModel(model); view->show();}void studentinfo::dele1(){ QString sno=idline.text().trimmed(); QString spass=passline.text().trimmed(); QString sname=nameline.text().trimmed(); QString sdept=deptline.text().trimmed(); QSqlQuery query; query.prepare("DELETE from studentlogin where 用户名=:sno"); query.bindValue(":sno",sno); query.exec(); QSqlQuery query2; query2.exec("select * from studentlogin"); QSqlQueryModel *model = new QSqlQueryModel; model->setQuery(query2); QTableView *view = new QTableView; view->setModel(model); view->show();}

上一篇：1068. 万绿丛中一点红(20)乙级

下一篇：图书管理系统主界面