QImage MainWindow::MatToImage(const Mat &m)  //Mat轉(zhuǎn)Image
{
    switch(m.type())
    {
        case CV_8UC1:
        {
            QImage img((uchar *)m.data,m.cols,m.rows,m.cols * 1, QImage::Format_Grayscale8);
            return img;
        }
            break;
        case CV_8UC3:
        {
            QImage img((uchar *)m.data,m.cols,m.rows,m.cols * 3, QImage::Format_RGB888);
            return img.rgbSwapped();  //因為在QT中彩色圖象是RGB的順序，但是在OPENCV中是BGR的順序，所以要轉(zhuǎn)一下
        }
            break;
        case CV_8UC4:
        {
            QImage img((uchar *)m.data,m.cols,m.rows,m.cols * 4, QImage::Format_ARGB32);
            return img;
        }
            break;
        default:     //如果是默認的，那么將其返回為一個空對象
        {
            QImage img;
            return img;
        }
    }
}

Mat MainWindow::ImageToMat(const QImage &img,bool inCloneImageData)  //Image轉(zhuǎn)Mat
{
    switch(img.format())
    {
        case QImage::Format_Indexed8:   //單通道
        {
            Mat  mat( img.height(), img.width(), CV_8UC1,
                          const_cast<uchar*>(img.bits()), static_cast<size_t>(img.bytesPerLine()) );

            return (inCloneImageData ? mat.clone() : mat);
        }
        // 8-bit, 3 通道
        case QImage::Format_RGB32:   //這種寫法表示并列關系
        case QImage::Format_RGB888:
        {
            if ( !inCloneImageData )
            {
                qWarning() << "CVS::QImageToCvMat() - Conversion requires cloning because we use a temporary QImage";
            }

            QImage  swapped = img;

            if ( img.format() == QImage::Format_RGB32 )
            {
                swapped = swapped.convertToFormat( QImage::Format_RGB888 );
            }

            swapped = swapped.rgbSwapped();  //因為在QT中彩色圖象是RGB的順序，但是在OPENCV中是BGR的順序，所以要轉(zhuǎn)一下

            return Mat( swapped.height(), swapped.width(), CV_8UC3,
                        const_cast<uchar*>(swapped.bits()), static_cast<size_t>(swapped.bytesPerLine()) ).clone();
        }
        // 8-bit, 4 channel
        case QImage::Format_ARGB32:
        case QImage::Format_ARGB32_Premultiplied:
        {
            Mat  mat( img.height(), img.width(), CV_8UC4,
                          const_cast<uchar*>(img.bits()), static_cast<size_t>(img.bytesPerLine()) );

            return (inCloneImageData ? mat.clone() : mat);
        }

        // 8-bit, 1 channel
        default:
            qWarning() << "CVS::QImageToCvMat() - QImage format not handled in switch:" << img.format();
            break;
        }
    return Mat();
}

QPixmap MainWindow::MatToPixmap(const Mat &m)
{
    return QPixmap::fromImage(MatToImage(m));   //相當于先將Mat轉(zhuǎn)成Image,再轉(zhuǎn)成Pixmap
}

void MainWindow::Upmysql()   //將處理的圖片上傳至數(shù)據(jù)庫
{
    QImage pix=ui->Process_image->pixmap()->toImage();
    Mat m=ImageToMat(pix);  //QImage--->Mat格式轉(zhuǎn)換
    int height = pix.height();   //定義這兩者的目的是為了傳給Mat的構(gòu)造函數(shù)
    int width = pix.width();
    int iSize = m.total() * m.elemSize();   //記錄Mat圖像的大小，以便于創(chuàng)建同等大小的字節(jié)數(shù)組
    unsigned char* bytes = new unsigned char[iSize];   //創(chuàng)建一個字節(jié)數(shù)組，用于保存二進制數(shù)據(jù)
    memcpy(bytes, m.data, iSize * sizeof(unsigned char));    //將Mat類型的數(shù)據(jù)賦給byte數(shù)組
    //qDebug()<<QByteArray((char*)bytes, 100);    //查看前100個字符
    QByteArray sbuf = QByteArray::fromRawData((char *)bytes, iSize * sizeof(unsigned char));   //將unsigned char轉(zhuǎn)為QByteArray類型

    QVariant var(sbuf);   //將QByteArray類型轉(zhuǎn)成QVariant以便于插入到MYSql
    QSqlQuery query;   //下面為數(shù)據(jù)庫查詢的一種方式，要特別注意格式的要求
    //創(chuàng)建數(shù)據(jù)表的時候，一定要注意數(shù)據(jù)的大小，比方說圖片blob為64k，mediumblob為16m
    query.prepare("INSERT INTO Image_All (id, img_data) "
                        "VALUES (:id, :img_data)");
    query.bindValue(":id", 77877);    //我這里隨便設的
    query.bindValue(":img_data",var);
    if(query.exec())
    {
        qDebug()<<"圖片成功上傳至數(shù)據(jù)庫";
    }
    else{
        qDebug()<<"圖片上傳數(shù)據(jù)庫失敗";
    }

    QString sql1=QString("select img_data from Image_All where id='33'");   //獲取數(shù)據(jù)庫中圖片數(shù)據(jù)
    if(query.exec(sql1)) //執(zhí)行sql語句是否成功
    {
        while(query.next())//指向下一條
        {
            //根據(jù)下標將返回結(jié)果進行分割
            QByteArray TEXT1=query.value(0).toByteArray();  //將查詢結(jié)果以QByteArray形式返回
            unsigned char *data2;
             data2 = reinterpret_cast<unsigned char*>(TEXT1.data());   //將QByteArray類型轉(zhuǎn)為unsigned char
            Mat image=Mat(height,width,CV_8UC3,data2);      //將unsigned char轉(zhuǎn)成Mat類型的數(shù)據(jù)
            QPixmap temp = MatToPixmap(image);
            ui->Process_image->setPixmap(temp);
        }

    }else
    {
        qDebug()<<"從數(shù)據(jù)庫獲取圖片失敗";
    }

}