毕业设计：学生管理系统源码，界面为Qt，数据库为sqlite 代码里可以借鉴 sql 语句的操作

#include "DataManage.h" #include <QDebug> #include <QFileInfo> #include <QSqlDatabase> #include <QSqlQuery> #include "Config.h" QAtomicPointer<DataManage> DataManage::m_instance = 0; QMutex DataManage::m_mutex; DataManage::DataManage(QObject *parent) : QObject(parent) { createDatabase(); } DataManage *DataManage::instance() { #ifndef Q_ATOMIC_POINTER_TEST_AND_SET_IS_ALWAYS_NATIVE if(!QAtomicPointer::isTestAndSetNative())//运行时检测 qDebug() << "Error: TestAndSetNative not supported!"; #endif /*! * 使用双重检测。 * testAndSetOrders操作保证在原子操作前和后的的内存访问 * 不会被重新排序。 */ if(m_instance.testAndSetOrdered(0, 0))//第一次检测 { QMutexLocker locker(&m_mutex);//加互斥锁。 m_instance.testAndSetOrdered(0, new DataManage);//第二次检测。 } return m_instance; } QSqlDatabase *DataManage::getDb() { return &m_db; } int DataManage::getCurrRow(const QString &table) { int count = -1; QString tmp = QString("SELECT count(ROWID) FROM %1;").arg(table); QSqlQuery query(m_db); query.exec(tmp); if (query.next()) { count = query.value(0).toInt(); } qDebug() << "Table " << table << " count = " << count; return count; } bool DataManage::createDatabase() { QString databaseName(DATABASE_NAME); QFileInfo info(databaseName); bool isExits = info.exists(); m_db = QSqlDatabase::addDatabase("QSQLITE"); m_db.setDatabaseName(databaseName); //设置数据源名称 m_db.setUserName(DATABASE_USER); //登录用户 m_db.setPassword(DATABASE_PSWD); m_isDbOpened = m_db.open(); if (!m_isDbOpened) { qDebug() << "数据库打开失败"; return false; } if (!isExits) { QSqlQuery query(m_db); bool ok = false; /*课程表 CREATE TABLE "schedule" ( "id" INTEGER NOT NULL UNIQUE, "subject" TEXT NOT NULL, "credit" NUMERIC NOT NULL, PRIMARY KEY("id" AUTOINCREMENT) ); */ ok = query.exec("CREATE TABLE 'schedule' (\ 'id' INTEGER NOT NULL UNIQUE,\ 'subject' TEXT NOT NULL,\ 'credit' NUMERIC NOT NULL,\ PRIMARY KEY('id' AUTOINCREMENT));\ "); if (!ok) { qWarning() << "[ERRPR]CREATE TABLE 'schedule'"; return false; } ok = query.exec("INSERT INTO 'main'.'schedule' ('subject', " "'credit') VALUES ('高数', '3');"); if (!ok) { qWarning() << "[ERRPR]INSERT INTO 'main'.'schedule'(高数)"; return false; } ok = query.exec("INSERT INTO 'main'.'schedule' ('subject', " "'credit') VALUES ('英语', '2');"); if (!ok) { qWarning() << "[ERRPR]INSERT INTO 'main'.'schedule'(英语)"; return false; } ok = query.exec("INSERT INTO 'main'.'schedule' ('subject', " "'credit') VALUES ('操作系统', '3');"); if (!ok) { qWarning() << "[ERRPR]INSERT INTO 'main'.'schedule'(操作系统)"; return false; } ok = query.exec("INSERT INTO 'main'.'schedule' ('subject', " "'credit') VALUES ('计算机网络', '3');"); if (!ok) { qWarning() << "[ERRPR]INSERT INTO 'main'.'schedule'(计算机网络)"; return false; } /*学生信息 CREATE TABLE "student" ( "id" INTEGER NOT NULL UNIQUE, "name" TEXT NOT NULL, "gender" TEXT NOT NULL, "addr" TEXT NOT NULL, "phone" TEXT, "class" TEXT NOT NULL, PRIMARY KEY("id" AUTOINCREMENT) ); */ ok = query.exec("CREATE TABLE 'student' ( \ 'id' INTEGER NOT NULL UNIQUE,\ 'name' TEXT NOT NULL,\ 'gender' TEXT NOT NULL,\ 'addr' TEXT NOT NULL,\ 'phone' TEXT,\ 'class' TEXT NOT NULL,\ PRIMARY KEY('id' AUTOINCREMENT)\ );"); if (!ok) { qWarning() << "[ERRPR]CREATE TABLE 'student'"; return false; } query.exec( "INSERT INTO 'main'.'student' ('name', 'gender', 'addr', " "'phone', 'class') VALUES ('张三', '男', '北京市昌平区', " "'13188888888', '产业互联网学院1902班');"); query.exec( "INSERT INTO 'main'.'student' ('name', 'gender', 'addr', " "'phone', 'class') VALUES ('李四', '男', '北京市昌平区', " "'13188888880', '产业互联网学院1902班');"); query.exec( "INSERT INTO 'main'.'student' ('name', 'gender', 'addr', " "'phone', 'class') VALUES ('王五', '男', '北京市昌平区', " "'13188888880', '产业互联网学院1902班');"); query.exec( "INSERT INTO 'main'.'student' ('name', 'gender', 'addr', " "'phone', 'class') VALUES ('赵六', '男', '北京市昌平区', " "'13188888880', '产业互联网学院1902班');"); /* 成绩单 CREATE TABLE "transcript" ( "id" INTEGER NOT NULL UNIQUE, "student_id" INTEGER NOT NULL, "schedule_id" INTEGER NOT NULL, "score" NUMERIC NOT NULL, FOREIGN KEY("student_id") REFERENCES "student"("id") on delete cascade on update cascade, FOREIGN KEY("schedule_id") REFERENCES "schedule"("id") on delete cascade on update cascade, PRIMARY KEY("id" AUTOINCREMENT) ) */ ok = query.exec("CREATE TABLE 'transcript' (\ 'id' INTEGER NOT NULL UNIQUE,\ 'student_id' INTEGER NOT NULL,\ 'schedule_id' INTEGER NOT NULL,\ 'score' NUMERIC NOT NULL,\ FOREIGN KEY('student_id') REFERENCES 'student'('id') on delete cascade on update cascade,\ FOREIGN KEY('schedule_id') REFERENCES 'schedule'('id') on delete cascade on update cascade,\ PRIMARY KEY('id' AUTOINCREMENT)\ );"); if (!ok) { qWarning() << "[ERRPR]CREATE TABLE 'transcript'"; return false; } // 张三的成绩 query.exec("INSERT INTO 'main'.'transcript' ('student_id', " "'schedule_id', 'score') VALUES ('1', '1', '91');"); query.exec("INSERT INTO 'main'.'transcript' ('student_id', " "'schedule_id', 'score') VALUES ('1', '2', '92');"); query.exec("INSERT INTO 'main'.'transcript' ('student_id', " "'schedule_id', 'score') VALUES ('1', '3', '93');"); query.exec("INSERT INTO 'main'.'transcript' ('student_id', " "'schedule_id', 'score') VALUES ('1', '4', '94');"); // 李四的成绩 query.exec("INSERT INTO 'main'.'transcript' ('student_id', " "'schedule_id', 'score') VALUES ('2', '1', '59');"); query.exec("INSERT INTO 'main'.'transcript' ('student_id', " "'schedule_id', 'score') VALUES ('2', '2', '67');"); query.exec("INSERT INTO 'main'