通過數(shù)據(jù)庫實(shí)現(xiàn)學(xué)生管理系統(tǒng)
widget.cpp
#include "widget.h"
#include "ui_widget.h"
Widget::Widget(QWidget *parent)
: QWidget(parent)
, ui(new Ui::Widget)
{
ui->setupUi(this);
//判斷數(shù)據(jù)庫對(duì)象是否包含了自己使用的數(shù)據(jù)庫 Studemt.db
if(!db.contains("Student.db"))
{
//添加一個(gè)數(shù)據(jù)庫
db = QSqlDatabase::addDatabase("QSQLITE"); //表示使用的是sqlite3版本的數(shù)據(jù)庫
//給數(shù)據(jù)庫命名
db.setDatabaseName("Student.db");
}
//打開數(shù)據(jù)庫
if(!db.open())
{
QMessageBox::information(this,"提示","數(shù)據(jù)庫打開失敗");
return;
}
//此時(shí)說明數(shù)據(jù)庫創(chuàng)建完畢并打開
//就可以創(chuàng)建數(shù)據(jù)表了
//需要使用SQL語句，需要使用QSQLQuerry類對(duì)象完成
//準(zhǔn)備SQL語句
QString sql = "create table if not exists myTable(" //創(chuàng)建表的sql語句
"id integer primary key autoincrement," //id主鍵，允許自增
"numb integer," //學(xué)號(hào)，是整形
"name varchar(10)," //姓名 字符串
"score integer,"
"sex varchar(4))"; //性別 字符串
//定義語句執(zhí)行者
QSqlQuery querry;
//使用queery執(zhí)行SQL語句
if(!querry.exec(sql))
{
QMessageBox::information(this,"失敗","創(chuàng)建表失敗");
}else
{
QMessageBox::information(this,"成功","創(chuàng)建表成功");
}
}
Widget::~Widget()
{
delete ui;
}
//錄入按鈕對(duì)應(yīng)的槽函數(shù)
void Widget::on_btn1_clicked()
{
//獲取ui界面中要存入數(shù)據(jù)庫中的數(shù)據(jù)
int numb_ui = ui->edit1->text().toInt(); //獲取學(xué)號(hào)
QString name_ui = ui->edit2->text(); //獲取姓名
int score_ui = ui->edit3->text().toInt(); //獲取分?jǐn)?shù)
QString sex_ui = ui->edit4->text(); //獲取性別
if(numb_ui == 0 || name_ui.isEmpty() || score_ui == 0||sex_ui.isEmpty())
{
QMessageBox::information(this,"提示","請(qǐng)將信息填充完整");
return ;
}
//準(zhǔn)備SQL語句
QString sql = QString("insert into myTable(numb,name,score,sex)"
"values(%1,'%2',%3,'%4')")
.arg(numb_ui).arg(name_ui).arg(score_ui).arg(sex_ui);
//定義語句執(zhí)行官
QSqlQuery querry;
//調(diào)用執(zhí)行者的相關(guān)函數(shù)執(zhí)行SQL語句
if(!querry.exec(sql))
{
QMessageBox::information(this,"失敗","插入失敗");
}else
{
QMessageBox::information(this,"成功","插入成功");
}
}
//展示按鈕對(duì)應(yīng)的槽函數(shù)
void Widget::on_btn2_clicked()
{
//準(zhǔn)備SQL語句
QString sql = "select * from myTable";
//準(zhǔn)備語句執(zhí)行者
QSqlQuery querry;
if(!querry.exec(sql))
{
QMessageBox::information(this,"失敗","查找失敗");
return;
}
//此時(shí)將查找的所有結(jié)果全都都放在querry對(duì)象中
//可以通過next函數(shù)不斷遍歷查詢結(jié)果
int i = 0; //記錄行號(hào)
while(querry.next())
{
//遍歷任意一組記錄，querry.record
//querry.record();
//要找到每條一條記錄 中的每個(gè)數(shù)據(jù)使用
//qDebug() << querry.record().value(2);
//返回當(dāng)前記錄對(duì)應(yīng)數(shù)據(jù)項(xiàng)的個(gè)數(shù)
//querry.record().count();
//將記錄的某一項(xiàng)的數(shù)據(jù)轉(zhuǎn)變成了字符串
//querry.record().value(2).toString();
//將數(shù)據(jù)庫中的表格展示到ui界面
//ui->tableWidget->setItem();
for(int j = 0; j<querry.record().count()-1; j++)
{
ui->tableWidget->setItem(i,j,new QTableWidgetItem(querry.record().value(j+1).toString()));
}
i++; //進(jìn)行下一行
}
}
//查找按鈕
void Widget::on_btn3_clicked()
{
//獲取ui界面中要存入數(shù)據(jù)庫中的數(shù)據(jù)
int numb_ui = ui->edit1->text().toInt(); //獲取學(xué)號(hào)
QString name_ui = ui->edit2->text(); //獲取姓名
int score_ui = ui->edit3->text().toInt(); //獲取分?jǐn)?shù)
QString sex_ui = ui->edit4->text(); //獲取性別
if(numb_ui != 0)
{
ui->tableWidget->clear();
//準(zhǔn)備SQL語句
QString sql = QString("select * from myTable where %1 == numb").arg(numb_ui);
//準(zhǔn)備語句執(zhí)行者
QSqlQuery querry;
if(!querry.exec(sql))
{
QMessageBox::information(this,"失敗","查找失敗");
return;
}
int i = 0; //記錄行號(hào)
while(querry.next())
{
for(int j = 0; j<querry.record().count()-1; j++)
{
ui->tableWidget->setItem(i,j,new QTableWidgetItem(querry.record().value(j+1).toString()));
}
i++; //進(jìn)行下一行
}
}else if(!name_ui.isEmpty())
{
ui->tableWidget->clear();
//準(zhǔn)備SQL語句
QString sql = QString("select * from myTable where '%2' == name").arg(name_ui);
//準(zhǔn)備語句執(zhí)行者
QSqlQuery querry;
if(!querry.exec(sql))
{
QMessageBox::information(this,"失敗","查找失敗");
return;
}
int i = 0; //記錄行號(hào)
while(querry.next())
{
for(int j = 0; j<querry.record().count()-1; j++)
{
ui->tableWidget->setItem(i,j,new QTableWidgetItem(querry.record().value(j+1).toString()));
}
i++; //進(jìn)行下一行
}
}else if(score_ui != 0)
{
ui->tableWidget->clear();
//準(zhǔn)備SQL語句
QString sql = QString("select * from myTable where %3 == score").arg(score_ui);
//準(zhǔn)備語句執(zhí)行者
QSqlQuery querry;
if(!querry.exec(sql))
{
QMessageBox::information(this,"失敗","查找失敗");
return;
}
int i = 0; //記錄行號(hào)
while(querry.next())
{
for(int j = 0; j<querry.record().count()-1; j++)
{
ui->tableWidget->setItem(i,j,new QTableWidgetItem(querry.record().value(j+1).toString()));
}
i++; //進(jìn)行下一行
}
}else if(!sex_ui.isEmpty())
{
ui->tableWidget->clear();
//準(zhǔn)備SQL語句
QString sql = QString("select * from myTable where '%4' == sex").arg(sex_ui);
//準(zhǔn)備語句執(zhí)行者
QSqlQuery querry;
if(!querry.exec(sql))
{
QMessageBox::information(this,"失敗","查找失敗");
return;
}
int i = 0; //記錄行號(hào)
while(querry.next())
{
for(int j = 0; j<querry.record().count()-1; j++)
{
ui->tableWidget->setItem(i,j,new QTableWidgetItem(querry.record().value(j+1).toString()));
}
i++; //進(jìn)行下一行
}
}
}
//刪除按鈕
void Widget::on_btn4_clicked()
{
//獲取ui界面中要存入數(shù)據(jù)庫中的數(shù)據(jù)
int numb_ui = ui->edit1->text().toInt(); //獲取學(xué)號(hào)
QString name_ui = ui->edit2->text(); //獲取姓名
int score_ui = ui->edit3->text().toInt(); //獲取分?jǐn)?shù)
QString sex_ui = ui->edit4->text(); //獲取性別
if(numb_ui != 0 )
{
ui->tableWidget->clear();
//準(zhǔn)備SQL語句
QString sql = QString("delete from myTable where %1 == numb").arg(numb_ui);
//準(zhǔn)備語句執(zhí)行者
QSqlQuery querry;
if(!querry.exec(sql))
{
QMessageBox::information(this,"失敗","刪除失敗");
return;
}
else
{
QMessageBox::information(this,"成功","刪除成功");
}
//準(zhǔn)備SQL語句
QString sql1 = "select * from myTable";
querry.exec(sql1);
int i = 0; //記錄行號(hào)
while(querry.next())
{
for(int j = 0; j<querry.record().count()-1; j++)
{
ui->tableWidget->setItem(i,j,new QTableWidgetItem(querry.record().value(j+1).toString()));
}
i++; //進(jìn)行下一行
}
}else if(!name_ui.isEmpty())
{
ui->tableWidget->clear();
//準(zhǔn)備SQL語句
QString sql = QString("delete from myTable where '%2' == name").arg(name_ui);
//準(zhǔn)備語句執(zhí)行者
QSqlQuery querry;
if(!querry.exec(sql))
{
QMessageBox::information(this,"失敗","刪除失敗");
return;
}
else
{
QMessageBox::information(this,"成功","刪除成功");
}
int i = 0; //記錄行號(hào)
while(querry.next())
{
for(int j = 0; j<querry.record().count()-1; j++)
{
ui->tableWidget->setItem(i,j,new QTableWidgetItem(querry.record().value(j+1).toString()));
}
i++; //進(jìn)行下一行
}
}else if(score_ui != 0)
{
ui->tableWidget->clear();
//準(zhǔn)備SQL語句
QString sql = QString("delete from myTable where %3 == score").arg(score_ui);
//準(zhǔn)備語句執(zhí)行者
QSqlQuery querry;
if(!querry.exec(sql))
{
QMessageBox::information(this,"失敗","刪除失敗");
return;
}
else
{
QMessageBox::information(this,"成功","刪除成功");
}
int i = 0; //記錄行號(hào)
while(querry.next())
{
for(int j = 0; j<querry.record().count()-1; j++)
{
ui->tableWidget->setItem(i,j,new QTableWidgetItem(querry.record().value(j+1).toString()));
}
i++; //進(jìn)行下一行
}
}else if(!sex_ui.isEmpty())
{
ui->tableWidget->clear();
//準(zhǔn)備SQL語句
QString sql = QString("delete from myTable where '%4' == sex").arg(sex_ui);
//準(zhǔn)備語句執(zhí)行者
QSqlQuery querry;
if(!querry.exec(sql))
{
QMessageBox::information(this,"失敗","刪除失敗");
return;
}
else
{
QMessageBox::information(this,"成功","刪除成功");
}
int i = 0; //記錄行號(hào)
while(querry.next())
{
for(int j = 0; j<querry.record().count()-1; j++)
{
ui->tableWidget->setItem(i,j,new QTableWidgetItem(querry.record().value(j+1).toString()));
}
i++; //進(jìn)行下一行
}
}
}
widget.h
#ifndef WIDGET_H
#define WIDGET_H
#include <QWidget>
#include<QSqlDatabase> //數(shù)據(jù)庫管理類
#include<QSqlQuery> //執(zhí)行SQL語句對(duì)應(yīng)的類
#include<QSqlRecord> //記錄類
#include<QMessageBox>
#include<QDebug>
QT_BEGIN_NAMESPACE
namespace Ui { class Widget; }
QT_END_NAMESPACE
class Widget : public QWidget
{
Q_OBJECT
public:
Widget(QWidget *parent = nullptr);
~Widget();
private slots:
void on_btn1_clicked();
void on_btn2_clicked();
void on_btn3_clicked();
void on_btn4_clicked();
private:
Ui::Widget *ui;
//定義一個(gè)數(shù)據(jù)庫對(duì)象
QSqlDatabase db;
};
#endif // WIDGET_H
?
?tcp服務(wù)器
#include "widget.h"
#include "ui_widget.h"
Widget::Widget(QWidget *parent)
: QWidget(parent)
, ui(new Ui::Widget)
{
ui->setupUi(this);
//給服務(wù)器指針實(shí)例化對(duì)象
server = new QTcpServer(this);
}
Widget::~Widget()
{
delete ui;
}
//啟動(dòng)服務(wù)器按鈕對(duì)應(yīng)的槽函數(shù)
void Widget::on_btn_clicked()
{
//獲取ui界面上的端口號(hào)
quint16 port = ui->edit->text().toUInt();
if(!server->listen(QHostAddress::Any,port))
{
QMessageBox::critical(this,"失敗","服務(wù)器啟動(dòng)失敗");
return;
}else
{
QMessageBox::information(this,"成功","服務(wù)器啟動(dòng)成功");
}
connect(server,&QTcpServer::newConnection,this,&Widget::newConnection_slot);
}
//處理的newConnection信號(hào)的槽函數(shù)的實(shí)現(xiàn)
void Widget::newConnection_slot()
{
qDebug() << "有新的客戶端發(fā)來連接請(qǐng)求";
QTcpSocket *s = server->nextPendingConnection();
//將獲取的套接字存放到客戶端容器中
clientList.push_back(s);
connect(s,&QTcpSocket::readyRead,this,&Widget::redyRead_slot);
}
//關(guān)于readyRead信號(hào)的槽函數(shù)
void Widget::redyRead_slot()
{
//刪除客戶端鏈表中的無效客戶端套接字
for(int i=0;i<clientList.count();i++)
{
if(clientList[i]->state() == 0)
{
clientList.removeAt(i); // 將下標(biāo)為i的客戶端移除掉
}
}
//遍歷所有客戶端，查看是哪個(gè)客戶端發(fā)來數(shù)據(jù)
for(int i=0;i<clientList.count();i++)
{
if(clientList[i]->bytesAvailable() != 0)
{
QByteArray msg = clientList[i]->readAll();
//將數(shù)據(jù)展示到ui界面上
ui->msglist->addItem(QString::fromLocal8Bit(msg));
//接接受的消息發(fā)送到所有客戶端，發(fā)送給所有客戶端
for(int j=0;j<clientList.count();j++)
{
clientList[j]->write(msg);
}
}
}
}tcp客戶端文章來源：http://www.zghlxwxcb.cn/news/detail-694605.html
#include "widget.h"
#include "ui_widget.h"
Widget::Widget(QWidget *parent)
: QWidget(parent)
, ui(new Ui::Widget)
{
ui->setupUi(this);
//客戶端指針實(shí)例化空間
socket = new QTcpSocket(this);
connect(socket,&QTcpSocket::connected,this,&Widget::connected_slot);
connect(socket,&QTcpSocket::readyRead,this,&Widget::readyRead_slot);
connect(socket,&QTcpSocket::disconnected,this,&Widget::disconnected_slot);
}
Widget::~Widget()
{
delete ui;
}
//連接服務(wù)器按鈕對(duì)應(yīng)的槽函數(shù)
void Widget::on_btn2_clicked()
{
//獲取ui界面的信息
userName = ui->edit2->text(); //獲取用戶名
QString hostName = ui->edit3->text(); //獲取主機(jī)地址
quint16 port= ui->edit4->text().toUInt(); //獲取端口號(hào)
socket->connectToHost(hostName,port);
}
void Widget::connected_slot()
{
QMessageBox::information(this,"成功","連接服務(wù)器成功");
//順便向服務(wù)器發(fā)送一條信息
QString msg = userName + ":進(jìn)入聊天室";
socket->write(msg.toLocal8Bit());
}
//關(guān)于readyRead信號(hào)的槽函數(shù)
void Widget::readyRead_slot()
{
//讀取該客戶端中的數(shù)據(jù)
QByteArray msg = socket->readAll();
//將數(shù)據(jù)展示在ui界面
ui->listWidget->addItem(QString::fromLocal8Bit(msg));
}
//發(fā)送消息
void Widget::on_btn1_clicked()
{
//獲取ui界面中編輯文本的內(nèi)容
QString m = ui->edit1->text();
//整合要發(fā)送的信息
QString msg = userName + ":" + m;
//將消息發(fā)送給服務(wù)器
socket->write(msg.toLocal8Bit());
//將消息編輯框中的內(nèi)容清空
ui->edit1->clear();
}
//斷開服務(wù)器
void Widget::on_btn3_clicked()
{
//準(zhǔn)備要發(fā)送的信息
QString msg = userName + ":離開聊天室";
socket->write(msg.toLocal8Bit());
socket->disconnectFromHost()；
}
void Widget::disconnected_slot()
{
QMessageBox::information(this,"退出","退出成功");
}
文章來源地址http://www.zghlxwxcb.cn/news/detail-694605.html
到了這里，關(guān)于qt連接tcp通信和連接數(shù)據(jù)庫的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
