用QT+MySQL编写图书管理系统（五）——在表格中添加下拉框、长文本格式

本项目以及配套数据库已经上传到CSDN，大家可根据需要下载：

1. 项目
   https://download.csdn.net/download/qq_41544842/14934412
2. 数据库
   https://download.csdn.net/download/qq_41544842/14934435

我们发现在添加/修改如性别、学院等字段时，数据的内容是有要求的，是不可以由操作者随意改变的。因此，我们最好在表格中为这些字段加上下拉框。除此之外，在书籍的表格中，摘要这个字段最好换成长文本格式。

首先新建tabviewDelegate.h和tabviewDelegate.cpp

tabviewDelegate.h:

#ifndef TABVIEWDELEGATE_H
#define TABVIEWDELEGATE_H

#include <QItemDelegate>
#include <QComboBox>
class tabviewDelegate: public QItemDelegate
{
public:
    tabviewDelegate(QObject *parent = 0);
    QWidget *createEditor(QWidget *parent, const QStyleOptionViewItem &option,const QModelIndex &index) const;
    void setEditorData(QWidget *editor, const QModelIndex &index) const;
    void setModelData(QWidget *editor, QAbstractItemModel *model,const QModelIndex &index) const;
    void updateEditorGeometry(QWidget *editor,const QStyleOptionViewItem &option, const QModelIndex &index) const;
    QString type;
};

#endif // TABVIEWDELEGATE_H

tabviewDelegate.cpp

#include "tabviewDelegate.h"
#include <QTextEdit>
#include <QDebug>
tabviewDelegate::tabviewDelegate(QObject *parent)
{}
QWidget *tabviewDelegate::createEditor(QWidget *parent, const QStyleOptionViewItem &option, const QModelIndex &index) const
{//设置单元格格式，编写下拉框的内容
    if(type == "sex"){
        QComboBox *editor = new QComboBox(parent);
        editor->addItem(tr("男"));
        editor->addItem(tr("女"));
        return editor;
    }
    else if(type=="status"){
        QComboBox *editor = new QComboBox(parent);
        editor->addItem(tr("已借出"));
        editor->addItem(tr("未借出"));
        return editor;
    }
    else if(type=="warning"){
        QComboBox *editor = new QComboBox(parent);
        editor->addItem(tr("yes"));
        editor->addItem(tr("no"));
        return editor;
    }
    else if(type=="department"){
        QComboBox *editor = new QComboBox(parent);
        editor->addItem(tr("艺术学院"));
        editor->addItem(tr("药学院"));
        editor->addItem(tr("建筑与环境学院"));
        editor->addItem(tr("临床医学院"));
        editor->addItem(tr("生命科学学院"));
        editor->addItem(tr("化学学院"));
        editor->addItem(tr("历史文化学院"));
        editor->addItem(tr("公共卫生学院"));
        editor->addItem(tr("经济学院"));
        editor->addItem(tr("机械工程学院"));
        editor->addItem(tr("基础医学与法医学院"));
        editor->addItem(tr("物理学院"));
        editor->addItem(tr("电气工程学院"));
        editor->addItem(tr("马克思主义学院"));
        editor->addItem(tr("水利水电学院"));
        editor->addItem(tr("商学院"));
        editor->addItem(tr("材料科学与工程学院"));
        editor->addItem(tr("数学学院"));
        editor->addItem(tr("高分子科学与工程学院"));
        editor->addItem(tr("口腔医学院"));
        editor->addItem(tr("文学与新闻学院"));
        editor->addItem(tr("轻工科学与工程学院"));
        editor->addItem(tr("化学工程学院"));
        editor->addItem(tr("外国语学院"));
        editor->addItem(tr("国际关系学院"));
        editor->addItem(tr("公共管理学院"));
        editor->addItem(tr("电子信息学院"));
        editor->addItem(tr("法学院"));
        editor->addItem(tr("空天科学与工程学院"));
        editor->addItem(tr("计算机学院"));
        editor->addItem(tr("体育学院"));
        editor->addItem(tr("网络空间安全学院"));
        editor->addItem(tr("软件学院"));
        editor->addItem(tr("灾后重建学院"));
        return editor;
    }
    else{//书籍摘要那一列，长文本格式
        QTextEdit *editor = new QTextEdit(parent);
        return editor;
    }
}
void tabviewDelegate::setEditorData(QWidget *editor, const QModelIndex &index) const
{//把表格的列和上个函数编写的类型进行对应。哪个类型是下拉框，哪个类型是长文本
    QString text =index.model()->data(index,Qt::DisplayRole).toString();
    if(type == "sex"||type == "status"||type == "warning"||type == "department"){
        QComboBox *cmb = static_cast<QComboBox*>(editor);
        cmb->setCurrentText(text);
    }
    else{
        QTextEdit *textedit = static_cast<QTextEdit*>(editor);
        textedit->setText(text);
    }
}
void tabviewDelegate::setModelData(QWidget *editor, QAbstractItemModel *model, const QModelIndex &index) const
{//单元格获取从下拉框中选择的那个数据
    QString text;
    if(type == "sex"||type == "status"||type == "warning"||type == "department"){
        QComboBox *cmb = static_cast<QComboBox*>(editor);
        text= cmb->currentText();
    }
    else{
        QTextEdit *edit = static_cast<QTextEdit*>(editor);
        text= edit->toPlainText();
    }
    model->setData(index,text);
}
void tabviewDelegate::updateEditorGeometry(QWidget *editor, const QStyleOptionViewItem &option, const QModelIndex &index) const
{
    editor->setGeometry(option.rect);
}

该功能用于mainwindow这个界面，因此：

MainWindow::MainWindow(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::MainWindow)
{
    ui->setupUi(this);
    this->setWindowTitle(QStringLiteral("多功能书籍管理系统"));
    model = new QSqlTableModel(this);
    model->setTable("books");
    model->setEditStrategy(QSqlTableModel::OnManualSubmit);
    model->select();

    model2 = new QSqlTableModel(this);
    model2->setTable("users");
    model2->setEditStrategy(QSqlTableModel::OnManualSubmit);
    model2->select();

    setTitle();
    ReadOnlyDelegate * readOnlyDelegate = new ReadOnlyDelegate();

    ui->tableView->setModel(model);
    ui->tableView->verticalHeader()->setVisible(false);
    ui->tableView->setItemDelegateForColumn(0, readOnlyDelegate);
    ui->tableView->setColumnWidth(4,110);
    ui->tableView->setColumnWidth(6,150);

    ui->tableView_2->setModel(model2);
    ui->tableView_2->verticalHeader()->setVisible(false);
    ui->tableView_2->setItemDelegateForColumn(0, readOnlyDelegate);
    ui->tableView_2->setColumnWidth(1,100);
   //将表格的列和编写的类型进行对应，注意看好列数，以及看好这个字段属于哪个表
    tabviewDelegate *textedit = new tabviewDelegate(this);
    //books表中的摘要字段
    ui->tableView->setItemDelegateForColumn(6,textedit);

    tabviewDelegate *cmb = new tabviewDelegate(this);
    cmb->type = "sex";//users表中的性别字段
    ui->tableView_2->setItemDelegateForColumn(4,cmb);

    tabviewDelegate *cmb2 = new tabviewDelegate(this);
    cmb2->type = "status";//books表中的借还状态字段
    ui->tableView->setItemDelegateForColumn(7,cmb2);

    tabviewDelegate *cmb3 = new tabviewDelegate(this);
    cmb3->type = "warning";//users表中的检验超期字段
    ui->tableView_2->setItemDelegateForColumn(7,cmb3);

    tabviewDelegate *cmb4 = new tabviewDelegate(this);//选择学院
    cmb4->type = "department";//users表中的学院字段
    ui->tableView_2->setItemDelegateForColumn(5,cmb4);

}

效果如下：