qtablewidget与mysql_QtableWidget实现显示MySql数据库表

1.初始化Qtablewidget

QSqlQuery query;

int row =0;

int columns = 0;

//初始化行数

QString sql = QString("select count(*) as row from student");

query.exec(sql);

if(query.first())

{

row = query.value("row").toInt();

ui->tableWidget->setRowCount(row);

}

//初始化列数(mysql中存在一个information_schema这个数据库，存放各个表的信息)

sql = QString("select count(*) as columus from information_schema.COLUMNS where table_name='student'");

query.exec(sql);

if(query.first())

{

columns = query.value("columns").toInt();

ui->tableWidget->setColumnCount(columns);//列

}

2.设置表头

QStringList header;

//将表头写入表格

header< ui->tableWidget->setHorizontalHeaderLabels(header);

//自动调整宽度

<