#include?“add.h“
#include?“ui_add.h“
#include?“menu.h“
#include?“database.h“
Add::Add（QWidget?*parent）?:
????QWidget（parent）
????ui（new?Ui::Add）
{
????ui->setupUi（this）;
????ui->Name_lineEdit->setPlaceholderText（“Can‘t?enter?Numbers“）;
????ui->Num_lineEdit_2->setValidator（new?QIntValidator（））;
????ui->Num_lineEdit_2->setPlaceholderText（“enter?Numbers“）;
????ui->Age_lineEdit_4->setValidator（new?QIntValidator（0110））;
????ui->Age_lineEdit_4->setPlaceholderText（“enter?Numbers“）;
????QRegExp?regExp（“[A-Za-z][A-Za-z][A-Za-z]“）;
????ui->Name_lineEdit->setValidator（new?QRegExpValidator（regExpthis））;
????ui->Sex_lineEdit->setPlaceholderText（“input?W?or?M“）;
?????QRegExp?regExp1（“[WM]“）;
?????ui->Sex_lineEdit->setValidator（new?QRegExpValidator（regExp1this））;
}

Add::~Add（）
{
????delete?ui;
}

void?Add::on_Exit3_Button_clicked（）
{
????this->close（）;
}

void?Add::on_Return2_Button_clicked（）
{
????this->close（）;
????Menu?*m=new?Menu（）;
????m->show（）;
????//qDebug（）<<“jj:“<}

void?Add::on_Add1_Button_clicked（）
{
????QSqlDatabase?qdb;
????if??（QSqlDatabase::contains（“qt_sql_default_connection“））
????????qdb=QSqlDatabase::database（“qt_sql_default_connection“）;
????else
????????qdb=QSqlDatabase::addDatabase（“QSQLITE“）;
????qdb.setDatabaseName（“test1.db“）;
????qdb.open（）;
????QSqlQuery?query;
????if（!check（））
????{
????query.prepare（“insert?into?StudentInfo（IDnamesexage）?values（:ID:name:sex:age）“）;
????QString?name=ui->Name_lineEdit->text（）;
????QString?num=ui->Num_lineEdit_2->text（）;
????QString?sex=ui->Sex_lineEdit->text（）;
????QString?age=ui->Age_lineEdit_4->text（）;
????int?IDvalue=num.toInt（）;
????int?agevalue=age.toInt（）;
????query.bindValue（“:ID“IDvalue）;
????query.bindValue（“:age“agevalue）;
????query.bindValue（“:name“name）;
????query.bindValue（“:sex“sex）;
????query.exec（）;
????ui->AddTip_label_3->setText（QString::fromUtf8（“Add?Succeed!“））;
????qdb.close（）;
????}
????else
???????ui->AddTip_label_3->setText（QString::fromUtf8（“Failed:the?same?ID?!“））;
}

void?Add::on_Rest_Button_clicked（）
{
????ui->Name_lineEdit->clear（）;
????ui->Num_lineEdit_2->clear（）;
????ui->Sex_lineEdit->clear（）;
????ui->Age_lineEdit_4->clear（）;
????ui->AddTip_label_3->clear（）;
}
bool?Add::check（）
{
????QSqlDatabase?qdb;
????if??（QSqlDatabase::contains（“qt_sql_default_connection“））
????????qdb=QSqlDatabase::database（“qt_sql_default_connection“）;
????else
????????qdb=QSqlDatabase::addDatabase（“QSQLITE“）;
????qdb.setDatabaseName（“test1.db“）;
????qdb.open（）;
????QSqlQuery?query;
????query.prepare（“select?ID?from?StudentInfo?where?ID=:ID“）;
????query.bindValue（“:ID“ui->Num_lineEdit_2->text（）.toInt（））;
????query.exec（）;
????while（query.next（））
????{
????????return?true;
????}
????return?false;
}

void?Add::on_Modify_Button_clicked（）
{
????//ui->Num_lineEdit_2->validator（）;
????QSqlDatabase?qdb;
????if??（QSqlDatabase::contains（“qt_sql_default_connection“））
????????qdb=QSqlDatabase::database（“qt_sql_default_connection“）;
????else
????????qdb=QSqlDatabase::addDatabase（“QSQLIT

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-07-10?08:34??秦盛?2014441748\
?????目錄???????????0??2017-07-05?22:41??秦盛?2014441748\Student\
?????文件??????990978??2017-06-26?14:59??秦盛?2014441748\Student\1.png
?????文件???????34632??2017-06-26?14:59??秦盛?2014441748\Student\2.jpg
?????文件???????18933??2017-06-26?15:02??秦盛?2014441748\Student\3.jpg
?????文件???????72484??2017-06-26?15:03??秦盛?2014441748\Student\4.jpg
?????文件??????116395??2017-06-26?15:03??秦盛?2014441748\Student\5.jpg
?????文件???????16607??2017-06-26?15:04??秦盛?2014441748\Student\6.jpg
?????文件???????59307??2017-06-26?15:04??秦盛?2014441748\Student\7.jpg
?????文件????????3487??2017-06-30?05:26??秦盛?2014441748\Student\add.cpp
?????文件?????????485??2017-06-26?14:04??秦盛?2014441748\Student\add.h
?????文件????????5135??2017-06-26?15:18??秦盛?2014441748\Student\add.ui
?????文件?????????122??2017-06-20?10:51??秦盛?2014441748\Student\database.h
?????文件????????1736??2017-06-26?15:55??秦盛?2014441748\Student\dialog.cpp
?????文件?????????403??2017-06-20?11:21??秦盛?2014441748\Student\dialog.h
?????文件????????3474??2017-06-26?16:09??秦盛?2014441748\Student\dialog.ui
?????文件?????????251??2017-06-26?15:09??秦盛?2014441748\Student\loginview.qrc
?????文件?????????165??2017-06-20?11:02??秦盛?2014441748\Student\main.cpp
?????文件?????????864??2017-06-26?15:29??秦盛?2014441748\Student\menu.cpp
?????文件?????????360??2017-06-20?14:10??秦盛?2014441748\Student\menu.h
?????文件????????2414??2017-06-26?15:38??秦盛?2014441748\Student\menu.ui
?????文件????????4207??2017-07-02?10:11??秦盛?2014441748\Student\search.cpp
?????文件?????????708??2017-07-02?10:08??秦盛?2014441748\Student\search.h
?????文件????????5359??2017-07-02?10:08??秦盛?2014441748\Student\search.ui
?????文件????????1171??2017-06-21?18:45??秦盛?2014441748\Student\Student.pro
?????文件???????24112??2017-07-02?02:06??秦盛?2014441748\Student\Student.pro.user
?????文件?????6628864??2017-07-10?08:34??秦盛?2014441748\學(xué)生管理系統(tǒng).doc