基于QT的通讯录
环境配置:集成在vs2017的qt
一…h和.cpp文件
QtAddress.h代码部分
#pragma once
#include <QtWidgets/QMainWindow>
#include "ui_QtAddress.h"
#include<QMessageBox>
#include <QtSql/QSqlDatabase>
#include <QtSql/QSqlError>
#include <QsqlQuery>
#include <QDebug>
#include "mysql.h"
class QtAddress : public QMainWindow
{
Q_OBJECT
public:
QtAddress(QWidget *parent = Q_NULLPTR);
private:
Ui::QtAddressClass ui;
QSqlDatabase database;
QSqlQuery query;
void search();
void add();
void into();
void modify();
void clear();
};
因为本通讯录使用了数据库,所以增加了很多数据库头文件。在这里使用的数据库是MySQL8.0版本以上。
1.查询函数 sreach() 功能描述:能够根据用户输入的姓名和群组,从数据库查询,并生成相应的弹窗。
void QtAddress::search()//查询
{
QString strname = ui.lineEdit_name1->text();
QString strgroup = ui.lineEdit_group1->text();
QString show_name;
QString show_group;
/*QSqlQuery query(database);*/
query = QSqlQuery(database);
query.prepare("select * from addlist");
if (query.exec())
{
qDebug() << "read successfully";
while (query.next())
{
show_name = query.value("name").toString();
show_group = query.value("group").toString();
qDebug() << query.value("name").toString()
<< query.value("group").toString();
if (show_name == strname && show_group == strgroup)
{
QMessageBox::information(NULL, "success", QString::fromUtf8("找到了!!!"), QMessageBox::Yes);
break;
}
}
if (show_name != strname || show_group != strgroup)
{
QMessageBox::warning(this, "error", QString::fromUtf8("没有找到,请检查输入的姓名或群组是否正确!"));
}
}
else
{
qDebug() << query.lastError().text();
}
}
2.新增函数,能够添加新联系人到数据库
void QtAddress::add()//新增
{
QString name = ui.lineEdit_name2->text();
QString group = ui.lineEdit_group2->text();
QString tele = ui.lineEdit_tele->text();
/*QSqlQuery query(database);*/
query = QSqlQuery(database);
query.prepare("insert into addlist (`name`,`group`,`tele`) values(:name,:group,:tele)");
qDebug() << QString("insert into addlist (`name`,`group`,`tele`) values(:name,:group,:tele)");
query.bindValue(":name", name);
query.bindValue(":group", group);
query.bindValue(":tele", tele);
if (query.exec())
{
QMessageBox::information(NULL, "success", QString::fromUtf8("新增成功"), QMessageBox::Yes);
}
else
{
QMessageBox::warning(this, "error", QString::fromUtf8("新增失败"));
qDebug()<< query.lastError().text();
}
}
3.导入函数,能够把数据里指定表的数据导出到qt界面tableWidget里面。这里的tableWidget表不全,是在构造函数中初始化列名的,后面会给出.cpp的全部代码。
void QtAddress::into()//导入
{
/*QSqlQuery query(database);*/
query.prepare("select * from addlist");
int i = 0;
if (query.exec())
{
while (query.next())
{
ui.tableWidget->setRowCount(i + 1);
ui.tableWidget->setItem(i, 0, new QTableWidgetItem(query.value(0).toString()));
ui.tableWidget->setItem(i, 1, new QTableWidgetItem(query.value(1).toString()));
ui.tableWidget->setItem(i, 2, new QTableWidgetItem(query.value(2).toString()));
i++;
}
QMessageBox::information(NULL, "success", QString::fromUtf8("导入成功!"), QMessageBox::Yes);
}
}
4.修改函数,顾名思义,就是可以修改联系人的所有信息,包括姓名、群组、联系方式,同时也会修改到数据库。
void QtAddress::modify()//修改
{
QString strname = ui.lineEdit_name2->text();
QString strgroup = ui.lineEdit_group2->text();
QString strtele = ui.lineEdit_tele->text();
QList<QTableWidgetItem*> items = ui.tableWidget->selectedItems();
QTableWidgetItem *item = items.at(0);
QString oldName = item->text();
items.at(0)->setText(strname);
items.at(1)->setText(strgroup);
//QString oldGroup=item_group->text();
items.at(2)->setText(strtele);
//QString oldPhone=item_phone->text();
/*QSqlQuery query(database);*/
query.prepare("update addlist set `name`=:name,`group`=:group,`tele`=:tele where `name`=:oldName");
query.bindValue(":name", strname);
query.bindValue(":group", strgroup);
query.bindValue(":tele", strtele);
query.bindValue(":oldName", oldName);
if (query.exec()) {
QMessageBox::information(NULL, "success", QString::fromUtf8("修改成功!"), QMessageBox::Yes);
}
else
{
QMessageBox::warning(this, "error", QString::fromUtf8("修改失败!"));
qDebug() << query.lastError().text();
}
}
5.清空函数,这个函数是最简单的,功能是将数据库和tableWidget里的数据全部清空。
void QtAddress::clear()//清空
{
ui.tableWidget->clearContents();//清空表格数据(表头保留)
query.prepare("delete from addlist");
if (query.exec()) {
QMessageBox::information(NULL, "success", QString::fromUtf8("清空成功!"), QMessageBox::Yes);
}
}
完整的.cpp文件
#include "QtAddress.h"
#pragma execution_character_set("utf-8")//解决乱码问题
QtAddress::QtAddress(QWidget *parent)
: QMainWindow(parent)
{
ui.setupUi(this);
this->setWindowTitle("通讯录");
ui.tableWidget->setColumnCount(3);
QStringList headers;
headers << "姓名" << "群组"<<"联系方式";
ui.tableWidget->setHorizontalHeaderLabels(headers);//设置表头
ui.tableWidget->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);//表头填充并平均分
//ui.tableWidget->horizontalHeader()->setSectionResizeMode(0, QHeaderView::ResizeToContents);//将最后一列填充满表格
ui.tableWidget->setSelectionBehavior(QAbstractItemView::SelectRows);//一次选中一行
//槽函数
connect(ui.searchbtn, &QPushButton::clicked, this, &QtAddress::search);
connect(ui.addbtn, &QPushButton::clicked, this, &QtAddress::add);
connect(ui.intobtn, &QPushButton::clicked, this, &QtAddress::into);
connect(ui.modifybtn, &QPushButton::clicked, this, &QtAddress::modify);
connect(ui.clearbtn, &QPushButton::clicked, this, &QtAddress::clear);
//连接数据库
if (QSqlDatabase::contains("db_connection"))
{
database = QSqlDatabase::database("QMYSQL", "db_connection");
}
else
{
database = QSqlDatabase::addDatabase("QMYSQL");
database.setHostName("localhost");
database.setPort(3306);
database.setUserName("root");
database.setPassword("password");
database.setDatabaseName("db_connection");
}
if (!database.open())
{
qDebug() << "fail to connect mysql:" << database.lastError().text();
}
else
{
qDebug() << "open database success";
}
}
void QtAddress::search()//查询
{
QString strname = ui.lineEdit_name1->text();
QString strgroup = ui.lineEdit_group1->text();
QString show_name;
QString show_group;
/*QSqlQuery query(database);*/
query = QSqlQuery(database);
query.prepare("select * from addlist");
if (query.exec())
{
qDebug() << "read successfully";
while (query.next())
{
show_name = query.value("name").toString();
show_group = query.value("group").toString();
qDebug() << query.value("name").toString()
<< query.value("group").toString();
if (show_name == strname && show_group == strgroup)
{
QMessageBox::information(NULL, "success", QString::fromUtf8("找到了!!!"), QMessageBox::Yes);
break;
}
}
if (show_name != strname || show_group != strgroup)
{
QMessageBox::warning(this, "error", QString::fromUtf8("没有找到,请检查输入的姓名或群组是否正确!"));
}
}
else
{
qDebug() << query.lastError().text();
}
}
void QtAddress::add()//新增
{
QString name = ui.lineEdit_name2->text();
QString group = ui.lineEdit_group2->text();
QString tele = ui.lineEdit_tele->text();
/*QSqlQuery query(database);*/
query = QSqlQuery(database);
query.prepare("insert into addlist (`name`,`group`,`tele`) values(:name,:group,:tele)");
qDebug() << QString("insert into addlist (`name`,`group`,`tele`) values(:name,:group,:tele)");
query.bindValue(":name", name);
query.bindValue(":group", group);
query.bindValue(":tele", tele);
if (query.exec())
{
QMessageBox::information(NULL, "success", QString::fromUtf8("新增成功"), QMessageBox::Yes);
}
else
{
QMessageBox::warning(this, "error", QString::fromUtf8("新增失败"));
qDebug()<< query.lastError().text();
}
}
void QtAddress::into()//导入
{
/*QSqlQuery query(database);*/
query.prepare("select * from addlist");
int i = 0;
if (query.exec())
{
while (query.next())
{
ui.tableWidget->setRowCount(i + 1);
ui.tableWidget->setItem(i, 0, new QTableWidgetItem(query.value(0).toString()));
ui.tableWidget->setItem(i, 1, new QTableWidgetItem(query.value(1).toString()));
ui.tableWidget->setItem(i, 2, new QTableWidgetItem(query.value(2).toString()));
i++;
}
QMessageBox::information(NULL, "success", QString::fromUtf8("导入成功!"), QMessageBox::Yes);
}
}
void QtAddress::modify()//修改
{
QString strname = ui.lineEdit_name2->text();
QString strgroup = ui.lineEdit_group2->text();
QString strtele = ui.lineEdit_tele->text();
QList<QTableWidgetItem*> items = ui.tableWidget->selectedItems();
QTableWidgetItem *item = items.at(0);
QString oldName = item->text();
items.at(0)->setText(strname);
items.at(1)->setText(strgroup);
//QString oldGroup=item_group->text();
items.at(2)->setText(strtele);
//QString oldPhone=item_phone->text();
/*QSqlQuery query(database);*/
query.prepare("update addlist set `name`=:name,`group`=:group,`tele`=:tele where `name`=:oldName");
query.bindValue(":name", strname);
query.bindValue(":group", strgroup);
query.bindValue(":tele", strtele);
query.bindValue(":oldName", oldName);
if (query.exec()) {
QMessageBox::information(NULL, "success", QString::fromUtf8("修改成功!"), QMessageBox::Yes);
}
else
{
QMessageBox::warning(this, "error", QString::fromUtf8("修改失败!"));
qDebug() << query.lastError().text();
}
}
void QtAddress::clear()//清空
{
ui.tableWidget->clearContents();//清空表格数据(表头保留)
query.prepare("delete from addlist");
if (query.exec()) {
QMessageBox::information(NULL, "success", QString::fromUtf8("清空成功!"), QMessageBox::Yes);
}
}
main函数,基本上是编译器自动生成的,无改动。
#include "QtAddress.h"
#include <QtWidgets/QApplication>
int main(int argc, char *argv[])
{
QApplication a(argc, argv);
QtAddress w;
w.show();
return a.exec();
}
运行截图及QT控件使用(下面那个表是tableWidget控件)
注意!!!
1.如果要使用此代码,需要更改数据库名、表名、数据库密码等。
写代码时遇到的问题!
1.之前我的数据库版本时32位,而vs2017是64位,所有一直连接不上数据库,各位连不上数据库的小伙伴也可以检查一下自己数据库的版本哦。
此代码还有很多完善空间,欢迎大家指正!