#include?“dbconnect.h“
#include?“ui_dbconnect.h“
#include?se>
#include?
#include?
#include?
#include?

DbConnect::DbConnect（QWidget?*parent）?:
????QDialog（parent）
????ui（new?Ui::DbConnect）
{
????ui->setupUi（this）;
????QStringList?drivers?=?QSqlDatabase::drivers（）;
????ui->dbComboBox->addItems（drivers）;
????ui->status_Label->setText（tr（“狀態(tài)：準(zhǔn)備連接數(shù)據(jù)庫(kù)“））;
}

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

void?DbConnect::on_submit_clicked（）
{
???if（ui->dbComboBox->currentText（）.isEmpty（））
???{
???????ui->status_Label->setText（tr（“請(qǐng)選擇一個(gè)數(shù)據(jù)庫(kù)驅(qū)動(dòng)“））;
???????ui->dbComboBox->setFocus（）;
???}
???else?if（ui->dbComboBox->currentText（）==“QSQLITE“）
???{
???????creatDB（）;
???????accept（）;
???}
???else

???????QMessageBox::information（thistr（“數(shù)據(jù)庫(kù)“）tr（“對(duì)不起，目前只有’QSQLITE‘驅(qū)動(dòng)可用！“））;
}
void?DbConnect::creatDB（）
{
????QSqlError?err;
????QSqlDatabase?db?=?QSqlDatabase::addDatabase（“QSQLITE“）;
????db.setDatabaseName（“student“）;
????db.open（）;
????if（!db.open（））
????{
????????err?=?db.lastError（）;
????????qDebug（）<????}
????else
????ui->status_Label->setText（tr（“創(chuàng)建sqlite數(shù)據(jù)庫(kù)成功“））;

????QSqlQuery?query;
????bool?success=query.exec（“create?table?student?（id?int?primary?keyname?varchar（40）age?intmajor?varchar（40）credit?intaddress?varchar（40））“）;
????if?（success）
????????qDebug（）<ject::tr（“數(shù)據(jù)庫(kù)表創(chuàng)建成功“）;
????query.exec（Qobject::tr（“insert?into?student?values（1‘李小龍‘?32?‘截拳道‘?100?‘中國(guó)‘）“））;
????query.exec（Qobject::tr（“insert?into?student?values（2‘李四‘?60?‘猴拳‘??80?‘北京‘）“））;
????query.exec（Qobject::tr（“insert?into?student?values（3‘張三‘?31?‘跆拳道‘?90?‘上海‘）“））;
????query.exec（Qobject::tr（“insert?into?student?values（4‘王五‘?30?‘截拳道‘?88?‘南京‘）“））;
????query.exec（Qobject::tr（“insert?into?student?values（5‘小明‘?18?‘截拳道‘??92?‘深圳‘）“））;

}
void?DbConnect::on_cancel_clicked（）
{
???close（）;
}

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????目錄???????????0??2017-01-16?22:22??StudentMangeSystem\
?????文件????????2104??2017-01-14?21:36??StudentMangeSystem\dbconnect.cpp
?????文件?????????428??2017-01-14?09:37??StudentMangeSystem\dbconnect.h
?????文件????????2819??2017-01-14?09:16??StudentMangeSystem\dbconnect.ui
?????文件?????????314??2017-01-14?19:27??StudentMangeSystem\main.cpp
?????文件????????8080??2017-01-16?22:18??StudentMangeSystem\mainwindow.cpp
?????文件????????1349??2017-01-16?22:18??StudentMangeSystem\mainwindow.h
?????文件?????????451??2017-01-14?09:13??StudentMangeSystem\StudentMangeSystem.pro
?????文件???????23865??2017-01-16?22:22??StudentMangeSystem\StudentMangeSystem.pro.user