資源簡介
linux環境下QT語言寫的學生成績管理系統,該系統的數據庫為sqlite3,具有登錄、注冊、學業成績增刪改查、學生信息增刪改查等功能

代碼片段和文件信息
#include?“cou_info_dataform.h“
#include?“ui_cou_info_dataform.h“
#include?se>
#include?
#include?
cou_info_dataForm::cou_info_dataForm(QWidget?*parent)?:
????QWidget(parent)
????ui(new?Ui::cou_info_dataForm)
{
????ui->setupUi(this);
}
cou_info_dataForm::~cou_info_dataForm()
{
????delete?ui;
}
void?cou_info_dataForm::on_pushButton_clicked()
{
????QSqlDatabase?db;
????//db?=?QSqlDatabase::addDatabase(“QSQLITE“);
????if(QSqlDatabase::contains(“qt_sql_default_connection“))
????{
????????db?=?QSqlDatabase::database(“qt_sql_default_connection“);
????}
????else
????{
????????db?=?QSqlDatabase::addDatabase(“QSQLITE“);
????}
????db.setDatabaseName(“test.db“);
????db.open();
????QSqlQuery?query;
????query.exec(“create?table?course(cno?text?primary?keycname?text?not?nullccredit?text)“);
????query.exec(“insert?into?course?values(‘BL20‘‘Math‘‘5‘)“);
????QSqlQueryModel?*model?=?new?QSqlQueryModel;
????model->setQuery(“SELECT?*?FROM?course“);
????model->setHeaderData(0?Qt::Horizontal?tr(“cno“));
????model->setHeaderData(1?Qt::Horizontal?tr(“cname“));
????model->setHeaderData(2?Qt::Horizontal?tr(“ccredit“));
????ui->tableView->setModel(model);
}
void?cou_info_dataForm::on_return_2_clicked()
{
????emit?fun5();
????this->close();
}
void?cou_info_dataForm::on_pushButton_2_clicked()
{
????QString?str1;
????QSqlDatabase?db;
????//db?=?QSqlDatabase::addDatabase(“QSQLITE“);
????if(QSqlDatabase::contains(“qt_sql_default_connection“))
????{
????????db?=?QSqlDatabase::database(“qt_sql_default_connection“);
????}
????else
????{
????????db?=?QSqlDatabase::addDatabase(“QSQLITE“);
????}
????db.setDatabaseName(“test.db“);
????db.open();
????str1.sprintf(“select?*?from?course?where?cno=‘%s‘“ui->lineEdit_cno->text().toStdString().data());
????QSqlQueryModel?*model?=?new?QSqlQueryModel;
????model->setQuery(str1);
????model->setHeaderData(0?Qt::Horizontal?tr(“cno“));
????model->setHeaderData(1?Qt::Horizontal?tr(“cname“));
????model->setHeaderData(2?Qt::Horizontal?tr(“ccredit“));
????ui->tableView->setModel(model);
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-02-06?20:14??login1\
?????文件????????2096??2015-12-24?16:10??login1\cou_info_dataform.cpp
?????文件?????????490??2015-12-24?16:07??login1\cou_info_dataform.h
?????文件???????14088??2015-12-25?11:00??login1\cou_info_dataform.o
?????文件????????2048??2015-12-25?11:00??login1\cou_info_dataform.ui
?????文件????????2190??2015-12-24?16:15??login1\gra_info_form.cpp
?????文件?????????458??2015-12-24?16:14??login1\gra_info_form.h
?????文件???????14004??2015-12-25?11:16??login1\gra_info_form.o
?????文件????????2037??2015-12-25?11:16??login1\gra_info_form.ui
?????文件??????126331??2015-12-25?11:16??login1\login1
?????文件?????????805??2015-12-24?11:50??login1\login1.pro
?????文件???????16288??2015-12-25?19:07??login1\login1.pro.user
?????文件???????????0??2015-12-25?08:57??login1\login1.pro.user.1.3
?????文件?????????170??2015-12-24?09:23??login1\main.cpp
?????文件????????1592??2015-12-24?15:58??login1\main.o
?????文件????????1598??2015-12-24?10:50??login1\mainform.cpp
?????文件?????????839??2015-12-24?10:36??login1\mainform.h
?????文件???????14560??2015-12-25?11:01??login1\mainform.o
?????文件????????3899??2015-12-25?11:01??login1\mainform.ui
?????文件????????3015??2015-12-24?16:43??login1\mainform1.cpp
?????文件?????????722??2015-12-24?14:12??login1\mainform1.h
?????文件???????25292??2015-12-25?11:00??login1\mainform1.o
?????文件????????4587??2015-12-25?11:00??login1\mainform1.ui
?????文件????????2432??2015-12-24?16:46??login1\mainform2.cpp
?????文件?????????586??2015-12-24?13:08??login1\mainform2.h
?????文件???????19488??2015-12-25?11:00??login1\mainform2.o
?????文件????????3637??2015-12-25?11:00??login1\mainform2.ui
?????文件????????2379??2015-12-24?16:48??login1\mainform3.cpp
?????文件?????????574??2015-12-24?13:32??login1\mainform3.h
?????文件???????19372??2015-12-25?11:00??login1\mainform3.o
?????文件????????3628??2015-12-25?11:00??login1\mainform3.ui
............此處省略35個文件信息
評論
共有 條評論