Qt的QTreeView控件实现节点的增删改功能并保存入库

本文主要是介绍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控件实现节点的增删改功能并保存入库的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---