mywun.h
#ifndef MYWUN_H
#define MYWUN_H
#include <QDialog>
#include <QMessageBox>
#include <QString>
#include <QDebug>
#include <QPixmap>
namespace Ui {
class MyWun;
}
class MyWun : public QDialog
{
Q_OBJECT
public:
explicit MyWun(QWidget *parent = nullptr);
~MyWun();
private slots:
void on_login_btn_clicked();
void on_cancel_clicked();
private:
Ui::MyWun *ui;
};
#endif // MYWUN_H
student.h
#ifndef STUDENT_H
#define STUDENT_H
#include <QWidget>
#include <QSqlDatabase>//连接数据的类
#include <QSqlQuery>//执行sql语句的类
#include <QSqlQueryModel>//执行sql语句的类
#include <QSqlError>//获取sql错误的类
#include <QString>
#include <QDebug>
#include <QMessageBox>
namespace Ui {
class Student;
}
class Student : public QWidget
{
Q_OBJECT
public:
explicit Student(QWidget *parent = nullptr);
~Student();
//连接数据库的函数
void connect_to_datebase();
void create_table();
void select_all_date();
private slots:
void on_add_btn_clicked();
void on_delete_btn_clicked();
void on_modify_btn_clicked();
void on_search_btn_clicked();
void on_sort_btn_clicked();
private:
Ui::Student *ui;
QSqlDatabase db;//数据库句柄
QSqlQuery *query;//查询的句柄
QSqlQueryModel *model;//查询数据库的句柄
};
#endif // STUDENT_H
main.cpp
#include "mywun.h"
#include "student.h"
#include <QApplication>
int main(int argc, char *argv[])
{
QApplication a(argc, argv);
MyWun w;
//当w退出时如果的返回的是Accepted 就打开新的窗口
if(QDialog::Accepted == w.exec()){
Student s;
s.show();
return a.exec();
}
return 0;
}
mywun.cpp
#include "mywun.h"
#include "ui_mywun.h"
MyWun::MyWun(QWidget *parent) :
QDialog(parent),
ui(new Ui::M