56,687
社区成员
发帖
与我相关
我的任务
分享
try
{
EsExeSql::FieldInfo fi;
EsExeSql::PointerSet ps;
fi.push_back(make_pair("modelId", EsExeSql::TB_INT));
fi.push_back(make_pair("faultName", EsExeSql::TB_STRING));
fi.push_back(make_pair("faultRank", EsExeSql::TB_INT));
fi.push_back(make_pair("lockMark", EsExeSql::TB_BOOL));
fi.push_back(make_pair("usingMark", EsExeSql::TB_BOOL));
fi.push_back(make_pair("faultArea", EsExeSql::TB_DOUBLE));
ps.push_back((void*)&m_nModelID);
ps.push_back((void*)&m_strFaultName);
ps.push_back((void*)&m_nFaultLevel);
ps.push_back((void*)&m_bIsLocked);
ps.push_back((void*)&m_bIsUsed);
ps.push_back((void*)&m_dbFaceArea);
if (m_obDataPoint.m_nLen > 0 && m_obDataPoint.m_pData)
{
fi.push_back(make_pair("scatterPoint", EsExeSql::TB_BLOB));
ps.push_back((void*)&m_obDataPoint);
}
if (m_obCtrlPoint.m_nLen > 0 && m_obCtrlPoint.m_pData)
{
fi.push_back(make_pair("controlPoint", EsExeSql::TB_BLOB));
ps.push_back((void*)&m_obCtrlPoint);
}
if (m_obArris.m_nLen > 0 && m_obArris.m_pData)
{
fi.push_back(make_pair("faultArris", EsExeSql::TB_BLOB));
ps.push_back((void*)&m_obArris);
}
if (m_obFaultEdge.m_nLen > 0 && m_obFaultEdge.m_pData)
{
fi.push_back(make_pair("faultEdges", EsExeSql::TB_BLOB));
ps.push_back((void*)&m_obFaultEdge);
}
if (m_obFaultTri.m_nLen > 0 && m_obFaultTri.m_pData)
{
fi.push_back(make_pair("faultTriangleGrid", EsExeSql::TB_BLOB));
ps.push_back((void*)&m_obFaultTri);
}
if (m_obFaultInfo.m_nLen > 0 && m_obFaultInfo.m_pData)
{
fi.push_back(make_pair("faultInfo", EsExeSql::TB_BLOB));
ps.push_back((void*)&m_obFaultInfo);
}
if (m_obBox.m_nLen > 0 && m_obBox.m_pData)
{
fi.push_back(make_pair("boxInfo", EsExeSql::TB_BLOB));
ps.push_back((void*)&m_obBox);
}
unsigned long long unId = 0;
char tablename[256];
memset(tablename, 0, 256);
sprintf_s(tablename, "%s.FAULT_DATA_INFO", EsMySql::EsGetCurrentUseDB().c_str());
bool bRet = EsExeSql::EsInsertBlob(tablename, fi, ps, &unId);
m_nFaultID = unId;
return m_nFaultID;
}
catch (const Exception& er)
{
string strErr = _T("Error:");
strErr += er.what();
AfxMessageBox(strErr.c_str());
return -1;
}
trymysql> create table tlb(id int primary key, col2 longblob);
Query OK, 0 rows affected (0.11 sec)
mysql> insert into tlb values(1, null);
Query OK, 1 row affected (0.00 sec)
mysql> insert into tlb values(2, 0xAB);
Query OK, 1 row affected (0.00 sec)
mysql> insert into tlb values(3, '');
Query OK, 1 row affected (0.00 sec)
mysql> select length(col2) from tlb;
+--------------+
| length(col2) |
+--------------+
| NULL |
| 1 |
| 0 |
+--------------+
3 rows in set (0.00 sec)