本文主要是介绍Qt的QTreeView控件实现节点的增删改功能并保存入库，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
1.首先需要使用Qt创建一个Qt GUI应用.
2.基类选择QWidget.
3.自动生成好的工程目录如下,而kqdicwidget.ui文件和相应的.cpp和.h文件是我后来添加的按钮弹出窗口文件.
4.设计好UI界面,对象名如下.
4.如下就是dicwidget.cpp文件的代码.
dicwidget.h文件如下.
#ifndef DICWIDGET_H
#define DICWIDGET_H#include <QWidget>
#include <QtGui>
#include <QSqlQuery>namespace Ui {
class DicWidget;
}class DicWidget : public QWidget
{Q_OBJECTpublic:explicit DicWidget(QWidget *parent = 0);~DicWidget();private:Ui::DicWidget *ui;public slots:void curIndex(); //combobox的信号与槽函数private slots:void on_AddBtn_clicked();void on_UpdataBtn_clicked();void on_DelBtn_clicked();void on_ExitBtn_clicked();void on_SaveBtn_clicked();private:void InitCombo(); //初始化Comboboxvoid ConnectDataBase(); //连接数据库void LoadTree(); //刷新树列表void reftree(QStandardItem*); //递归遍历树void reftreechild(QStandardItem*,int&); //递归遍历子项private:QStandardItemModel *model; //标准项目模型public:QStandardItem *currentItem;public:QMap<QString,QString> NameTypeMap; //QMap方便数据的映射QString addName;QStringList listname;QList<int> listslid;QList<int> listdlid;QStringList header;QString dicname;QString name;QString type;int refslid; //定义全局变量int refdlid;
};#endif // DICWIDGET_H
dicwidget.cpp文件如下.
#include "dicwidget.h"
#include "ui_dicwidget.h"
#include <QMessageBox>#include <QSqlDatabase>
#include <QSqlQueryModel>
#include <QSqlQuery>
#include "kqdatedicwidget.h"#include <QDialog>
#include <QDebug>
#include <QStandardItemModel>
#include <QTreeWidget>#pragma execution_character_set("utf-8")DicWidget::DicWidget(QWidget *parent) :QWidget(parent),ui(new Ui::DicWidget)
{ui->setupUi(this);this->setFixedSize(540,300);//初始化combobox控件InitCombo();connect(ui->comboBox,SIGNAL(currentIndexChanged(QString)),this,SLOT(curIndex()));//设置窗口的属性this->setWindowFlags(Qt::WindowCloseButtonHint|Qt::MSWindowsFixedSizeDialogHint);ui->treeView->setEditTriggers(QAbstractItemView::NoEditTriggers); //设置TreeView为不可编辑
}DicWidget::~DicWidget()
{delete ui;
}void DicWidget::InitCombo() //初始化combobox
{ConnectDataBase(); //连接本地数据库方法QSqlQuery query;query.exec("select * from ATT_DIC_TREE where SJID = 0 order by type");while(query.next()){QString map_name = query.value(0).toString(); //获取数据库字段值QString map_type = query.value(1).toString();NameTypeMap[map_name] = map_type; //使用QMap映射值ui->comboBox->addItem(map_name); //设置值到combobox上}
}void DicWidget::curIndex() //combobox的点击后执行的槽方法
{ConnectDataBase();QSqlQuery query;QString rSql = QString("SELECT * FROM ATT_DIC_TREE where TYPE = '%1' and sjid = 0").arg(NameTypeMap[ui->comboBox->currentText()]); //使用映射获取数据库的typequery.exec(rSql);header.clear(); //QStringList的header的变量while(query.next()){QString r_name = query.value(4).toString();dicname = query.value(4).toString();header << r_name; //获取的值存入header中}model = new QStandardItemModel(ui->treeView);//model->setHorizontalHeaderLabels(QStringList()<<QStringLiteral("DICNAME"));model->setHorizontalHeaderLabels(header); //设置TreeView的头标题listname.clear(); //清空List数据listslid.clear();listdlid.clear();LoadTree();
}void DicWidget::LoadTree() //加载树控件
{QSqlQuery query;QString dtype = NameTypeMap[ui->comboBox->currentText()]; //映射出type
// int i = ui->comboBox->currentIndex();
// QString dtype = QString::number(i+1,10);QString sql = QString("SELECT * FROM ATT_DIC_TREE where TYPE = '%1' order by SJID,DLID;").arg(dtype);query.exec(sql);//如下开始从QMap中的数据加载到树控件上while(query.next()){QMap<int,QStandardItem*> mMapItems;while(query.next()){int dlid = query.value(2).toInt();int sjid = query.value(3).toInt();QString name = query.value(4).toString();if(sjid==0 || mMapItems.constFind(sjid)==mMapItems.constEnd()){QStandardItem *itemProject2 = new QStandardItem(name);itemProject2->setData(name);model->appendRow(itemProject2);mMapItems[dlid]=itemProject2;}else if(mMapItems.constFind(sjid)!=mMapItems.constEnd()){QStandardItem* pPar=mMapItems[sjid];QStandardItem* item0 = new QStandardItem(name);item0->setData(name);pPar->appendRow(item0);mMapItems[dlid]=item0;}if(name.isEmpty())break;}break;}QString NameTypeSql = QString("SELECT * FROM ATT_DIC_TREE where type = '%1' and sjid = 0").arg(dtype);query.exec(NameTypeSql);while(query.next())name = query.value(0).toString();ui->treeView->setModel(model);
}void DicWidget::ConnectDataBase() //与本地mdb数据库的连接
{QString sDbNm ="C:/Users/Administrator/Desktop/SysDic.mdb"; //路径可修改QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");QString dsn = QString("DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};FIL={MS Access};DBQ=%1;").arg(sDbNm);db.setDatabaseName(dsn);db.setUserName("");db.setPassword("");bool ok = db.open();if(!ok){QMessageBox messagebox;messagebox.setText("Database error");messagebox.exec();db.close();}
}void DicWidget::on_AddBtn_clicked() //添加按钮的方法
{QStandardItemModel *model1 = static_cast<QStandardItemModel*>(ui->treeView->model());QModelIndex currentindex = ui->treeView->currentIndex();if(currentindex.row()==-1) //如果未选中树节点的一项则returnreturn;currentItem = model1->itemFromIndex(currentindex);kqDateDicWidget dlg; //点击按钮后弹出一个窗口进行数据的添加dlg.setTitle("add"); //次窗口的ui是kqdatadicwidget.ui相应的.cpp和.h文件见项目目录dlg.setModal(true);dlg.exec();QString additem = dlg.GetValues(); //获取弹出窗口输入的值if(!additem.isEmpty()){QStandardItem *itemChild = new QStandardItem(additem);currentItem->appendRow(itemChild);ui->treeView->setExpanded(currentindex,true); //每添加一项则展开当前子项}// ConnectDataBase();
// QSqlQuery query;
// QString sql = QString("SELECT * FROM ATT_DIC_TREE where DICNAME = '%1' order by SJID,DLID;").arg(currentItem->text());
// query.exec(sql);// while(query.next())
// {
// addDlid = query.value(2).toInt();
// addName = query.value(0).toString();
// }// int i = ui->comboBox->currentIndex();
// QString dtype = QString::number(i+1,10);
// QString maxDlidSql = QString("SELECT max(DLID) FROM ATT_DIC_TREE where type = '%1'").arg(dtype);
// query.exec(maxDlidSql);// while(query.next())
// maxDlid = query.value(0).toInt();
}void DicWidget::on_UpdataBtn_clicked() //修改按钮的方法
{QStandardItemModel *model1 = static_cast<QStandardItemModel*>(ui->treeView->model());QModelIndex currentindex = ui->treeView->currentIndex();if(currentindex.row()==-1)return;currentItem = model1->itemFromIndex(currentindex);kqDateDicWidget dlg;dlg.setTitle("update");dlg.setModal(true);dlg.exec();QString additem = dlg.GetValues();if(!additem.isEmpty()){//QStandardItem *itemChild = new QStandardItem(additem);currentItem->setText(additem); //实现修改树节点的文本}
}void DicWidget::on_DelBtn_clicked() //删除树节点的方法
{QStandardItemModel *model1 = static_cast<QStandardItemModel*>(ui->treeView->model());QModelIndex currentindex = ui->treeView->currentIndex();if(currentindex.row()==-1) //如果没有选中树节点则提示需要选中节点{int war = QMessageBox::warning(NULL,"warning","Please select a deletion item !",QMessageBox::Yes|QMessageBox::No,QMessageBox::Yes);if(war == QMessageBox::Yes || war == QMessageBox::No)return;}int rb = QMessageBox::warning(NULL,"warning","Are you sure to delete !",QMessageBox::Yes|QMessageBox::No,QMessageBox::Yes);if(rb == QMessageBox::Yes){currentItem = model1->itemFromIndex(currentindex);if(!currentItem->parent()){model1->removeRow(currentindex.row());//currentItem->removeRows(0,currentItem->rowCount());//delete currentItem->takeRow(currentindex.row());return;}QStandardItem *parent = currentItem->parent();parent->removeRow(currentindex.row()); //删除树节点//delete parent->takeChild(currentindex.row());}
}void DicWidget::reftree(QStandardItem* item) //递归遍历树的方法开始
{if(item==nullptr)return;QString itemname = item->text(); //获取树的一层节点的数据listname.append(itemname);listslid.append(refslid);listdlid.append(refdlid);reftreechild(item,refdlid); //开始遍历树节点的子项节点
}void DicWidget::reftreechild(QStandardItem* model,int& dlid) //递归子项的方法
{int nSJID=dlid;for(int i=0;i<model->rowCount();i++){QStandardItem* childitem2 = model->child(i);dlid++;QString childtext = childitem2->text(); //设置下一个节点listname.append(childtext);listslid.append(nSJID);listdlid.append(dlid);reftreechild(childitem2,dlid); //递归}
}void DicWidget::on_SaveBtn_clicked() //保存按钮的方法
{refslid = 1; //通过数据库的规则从根节点的下一个节点开始遍历(设置初始值)refdlid = 2; //自身id为2的开始设置for(int i =0;i<model->rowCount();i++){QStandardItem* childItem = model->item(i,0);reftree(childItem); //调用遍历树的方法refdlid++; //除去根节点的下一级节点的id自加}ConnectDataBase();QSqlQuery query;// int i = ui->comboBox->currentIndex();
// QString dtype = QString::number(i+1,10);QString dtype = NameTypeMap[ui->comboBox->currentText()];//先删除当前选中的combobox的数据QString delSql = QString("delete from ATT_DIC_TREE where type = '%1'").arg(dtype);query.exec(delSql);//开始保存入库,将根节点的数据保存如数据库中QString root_str = dicname;QString firstSql = QString("insert into ATT_DIC_TREE (NAME,TYPE,DLID,SJID,DICNAME,DICCODE) values ('%1','%2',%3,%4,'%5','%6')").arg(name).arg(dtype).arg(1).arg(0).arg(root_str).arg(123);query.exec(firstSql);//开始将所有节点(除去根节点)保存入数据库中for(int n=0;n<listslid.size();n++){int list_sjid = listslid.at(n);int list_dlid = listdlid.at(n);QString list_name = listname.at(n);QString InsertSql = QString("insert into ATT_DIC_TREE (NAME,TYPE,DLID,SJID,DICNAME,DICCODE) values ('%1','%2',%3,%4,'%5','%6')").arg(name).arg(dtype).arg(list_dlid).arg(list_sjid).arg(list_name).arg(123);query.exec(InsertSql);}QMessageBox::information(this,"Save","Save Success !",QMessageBox::Yes|QMessageBox::No,QMessageBox::Yes);
}void DicWidget::on_ExitBtn_clicked() //退出按钮的方法
{this->close();
}
5.如下就是点击按钮后弹出一个窗口,用来修改数据的ui文件和.cpp文件还有.h文件.
kqdatedicwidget.ui文件的设计如下.
kqdatedicwidget.h文件代码如下.
#ifndef KQDATEDICWIDGET_H
#define KQDATEDICWIDGET_H#include <QDialog>namespace Ui {
class kqDateDicWidget;
}class kqDateDicWidget : public QDialog
{Q_OBJECTpublic:explicit kqDateDicWidget(QWidget *parent = 0);~kqDateDicWidget();private slots:void on_pushButton_2_clicked();void on_okBtn_clicked();private:Ui::kqDateDicWidget *ui;public:QString addname;public:QString GetValues();void setTitle(QString);signals:void dlgReturn(QString);
};#endif // KQDATEDICWIDGET_H
kqdatedicwidget.cpp文件代码如下.
#include "kqdatedicwidget.h"
#include "ui_kqdatedicwidget.h"
#include <QMessageBox>kqDateDicWidget::kqDateDicWidget(QWidget *parent) :QDialog(parent),ui(new Ui::kqDateDicWidget)
{this->setMinimumSize(200,120);this->setMaximumSize(200,120);//设置窗口的属性this->setWindowFlags(Qt::WindowCloseButtonHint|Qt::MSWindowsFixedSizeDialogHint);ui->setupUi(this);
}kqDateDicWidget::~kqDateDicWidget()
{delete ui;
}void kqDateDicWidget::on_pushButton_2_clicked() //取消按钮的方法
{this->close();
}void kqDateDicWidget::on_okBtn_clicked() //确定按钮的方法
{addname = ui->lineEdit->text(); //获取文本框的值if(addname.isEmpty()){QMessageBox::information(NULL,"Tip","Please enter text !",QMessageBox::Yes|QMessageBox::No,QMessageBox::Yes);return;}this->close();
}QString kqDateDicWidget::GetValues()
{return addname; //返回文本框的值
}void kqDateDicWidget::setTitle(QString type) //根据点击的按钮的不同来设置窗口的标题
{if(type == "add")this->setWindowTitle("Add Fileds");else if(type == "update")this->setWindowTitle("Update Fileds");else if(type == "delete")this->setWindowTitle("Delete Files");
}
6.下面就是main.cpp的文件了main.cpp文件没有什么修改的.
#include "dicwidget.h"
#include <QApplication>int main(int argc, char *argv[])
{QApplication a(argc, argv);DicWidget w;w.setWindowTitle("QtTreeView的设置");w.show();return a.exec();
}
7.实现的效果图片.
未修改treeview节点的原数据图如下.
然后我在棒球节点下添加一个 "陈棒球" 节点,我再修改自行车节点为 "大雄的自行车",最后删除胖虎节点,最后点击保存.
下面是修改win10的树控件的风格为win7的风格,让TreeView控件有连接线
#include <QStyleFactory>构造函数里面
{ui->setupUi(this);......ui->treeView->setStyle(QStyleFactory::create("windows"));//让行政区树有连接线
}效果如下:
需要下载该小工具项目的源码和该项目的mdb数据库的请点击链接: : QTreeView控件实现节点的增删改并保存入库_qtreeview增删改查,qtreeview添加节点-C++代码类资源-CSDN下载
或者在百度云链接: 百度网盘 请输入提取码 提取码: awp3
这篇关于Qt的QTreeView控件实现节点的增删改功能并保存入库的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
