qt sql中二进制文件通过QByteArray读写
从数据库到文件
QSqlQuery myquery( *pDatabase);
QByteArray myba;
if(myquery.exec(sql))
{
QSqlRecord myrecord = myquery.record();
if (myquery.next()) {
myba = myquery.value(myrecord.indexOf("Settings")).toByteArray();//读取二进制对象
}
}
else
{
initBoundary();
return false;
}
QFile mybfile(MapDataFilename);
if (!mybfile.open(QIODevice::WriteOnly))
{
initBoundary();
return false;
}
mybfile.write (myba);
mybfile.close();
从文件到数据库
//将文件存入数据库
QByteArray mapData;
QFile file(MapDataFilename);
if (!file.open(QIODevice::ReadOnly))
return false;
mapData = file.readAll();
file.close();
QSqlDatabase* pDatabase = CAccessController::getInstance()->getAccesser(g_dbXMLFilePath);
if (pDatabase ==0 )
{
// QMessageBox::information(this, "Error", CAccessController::getInstance()->lastError());
return false;
}
QSqlQuery query( *pDatabase);
query.prepare("update p_project SET Settings = :set where ID_P = :idp");
query.bindValue (":set",mapData);
query.bindValue (":idp",CMainConfig::CurProjectID);
bool bRtn = query.exec();
if (!bRtn)
{
QSqlError er =query.lastError ();
QString ss= er.text();
return false;
}