QT项目-学生管理系统

前言

本文章主要讲解本人在QT学习期间所开发的项目-学生管理系统，代码主要参考于网上查找。

一、界面展示

 功能主要包括，学生信息的插入删除，以及修改。

再加上按照id，或者成绩的升降序排序

二、代码展示

1.pro

QT       += core gui sql

greaterThan(QT_MAJOR_VERSION, 4): QT += widgets

TARGET = 12
TEMPLATE = app

# The following define makes your compiler emit warnings if you use
# any feature of Qt which has been marked as deprecated (the exact warnings
# depend on your compiler). Please consult the documentation of the
# deprecated API in order to know how to port your code away from it.
DEFINES += QT_DEPRECATED_WARNINGS

# You can also make your code fail to compile if you use deprecated APIs.
# In order to do so, uncomment the following line.
# You can also select to disable deprecated APIs only up to a certain version of Qt.
#DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000    # disables all the APIs deprecated before Qt 6.0.0


SOURCES += \
        main.cpp \
        widget.cpp

HEADERS += \
        widget.h

FORMS += \
        widget.ui

2.widget.h

#ifndef STUDENTDIALOG_H
#define STUDENTDIALOG_H

#include <QDialog>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlQueryModel>
#include <QSqlError>
#include <QDebug>
#include <QMessageBox>
namespace Ui {
class StudentDialog;
}

class StudentDialog : public QDialog
{
    Q_OBJECT

public:
    explicit StudentDialog(QWidget *parent = 0);
    ~StudentDialog();
private:
    //创建数据库
    void createDB();
    //创建数据表
    void createTable();
    //查询
    void queryTable();

private slots:
    //插入
    void on_InsertpushButton_clicked();
    //删除
    void on_DelpushButton_clicked();
    //修改
    void on_UpdatepushButton_clicked();
    //排序按钮
    void on_sortpushButton_clicked();
    //清空
    void CleanEdit();

private:
    Ui::StudentDialog *ui;
    //建立和数据库的连接
    QSqlDatabase db;
    //保存结果集
    QSqlQueryModel model;
};

#endif // STUDENTDIALOG_H

3. main.cpp

#include "widget.h"
#include <QApplication>

int main(int argc, char *argv[])
{