|
本帖最后由 z55716368 于 2015-5-7 14:20 编辑
可以在数据库中查询
我在Qt里面用tableview插入就不可以了 不知道是不是我代码问题
上代码:
//功能:导入数据库表到tablev中显示
//参数:
//返回:
initTable();
QSqlQuery query;
query.exec("SELECT a.Address,b.DeviceExplain,c.DeviceExplain,a.AgreementVersion,a.FirmwarmVersion,a.EquipmentCapacity,a.LoopNumber,a.PortNumber,a.PotterRate,a.TimeOut,a.InstallAddress,a.describe"
"FROM tb_controllerinformation a "
"LEFT JOIN tb_devicemodelcomparison b ON b.ModelID=a.ModelID"
"LEFT JOIN tb_devicetypecomparison c ON c.TypeID=a.TypeID");
int i = 0;
while(query.next())
{
m_model->setItem(i, 0, new QStandardItem(query.value(1).toString()));
m_model->setItem(i, 1, new QStandardItem(query.value(2).toString()));
m_model->setItem(i, 2, new QStandardItem(query.value(3).toString()));
m_model->setItem(i, 3, new QStandardItem(query.value(4).toString()));
m_model->setItem(i, 4, new QStandardItem(query.value(5).toString()));
m_model->setItem(i, 5, new QStandardItem(query.value(6).toString()));
m_model->setItem(i, 6, new QStandardItem(query.value(7).toString()));
m_model->setItem(i, 7, new QStandardItem(query.value(8).toString()));
m_model->setItem(i, 8, new QStandardItem(query.value(9).toString()));
m_model->setItem(i, 9, new QStandardItem(query.value(10).toString()));
m_model->setItem(i, 10, new QStandardItem(query.value(11).toString()));
m_model->setItem(i, 11, new QStandardItem(query.value(12).toString()));
m_model->setItem(i, 12, new QStandardItem(query.value(13).toString()));
i++; |
|