qt与mysql数据可视化

include<QSqlDatabase>

#include<QDebug>

#include<QSqlQuery>

#include<QSqlTableModel>

#include<QTableView>

#include<QSqlRecord>

#include<QString>

#include<QItemSelectionModel>

#include<QModelIndexList>

Widget::Widget(QWidget *parent) :

    QWidget(parent),

    ui(new Ui::Widget)

{

    ui->setupUi(this);

    db=QSqlDatabase::addDatabase("QMYSQL");

    db.setHostName("127.0.0.1");

    db.setPort(3306);

    db.setUserName("root");

    db.setPassword("332437798");

    db.setDatabaseName("mysql");

    if(!db.open())

        qDebug()<<"dataBase can not open!";

    else

    {

        qDebug()<<"Database connect successful!";

    }

    QSqlQuery query;

    query.exec("set names gbk");

    model=new QSqlTableModel(this,db);   //注意

    model->setTable("stu_info");

    //table.setGeometry(100,100,450,150);

    ui->tableView->setModel(model);

    model->setEditStrategy(QSqlTableModel::OnManualSubmit);

    model->select();

   // ui->tableview->show();

    model->setHeaderData(0,Qt::Horizontal,QObject::tr("序号"));

    model->setHeaderData(1,Qt::Horizontal,QObject::tr("分数"));

    model->setHeaderData(2,Qt::Horizontal,QObject::tr("name"));

    model->setHeaderData(3,Qt::Horizontal,QObject::tr("年龄"));

    model->setHeaderData(4,Qt::Horizontal,QObject::tr("性别"));

    model->setHeaderData(5,Qt::Horizontal,QObject::tr("编号"));

}

Widget::~Widget()

{

    delete ui;

}

void Widget::on_comfirm_clicked()

{

    model->submitAll();

}

void Widget::on_pushButton_clicked()

{

    QSqlRecord record=model->record();

    int rows=model->rowCount();

    model->insertRecord(rows,record);

    model->submitAll();

}

void Widget::on_cancel_clicked()

{

    model->revertAll(); //撤销

    model->submitAll();//提交

    ui->tableView->setModel(NULL);

    model->setTable("stu_info");

    ui->tableView->setModel(model);

    model->select();

}

void Widget::on_check_clicked()  //设置过滤条件

{

    QString str=ui->lineEdit->text();

    QString cdt=QString("name='%1'").arg(str);

    qDebug()<<cdt;

    model->setFilter(cdt);

    model->select();

}

void Widget::on_delete_clicked()

{

    QItemSelectionModel *selections = ui->tableView->selectionModel();

    QModelIndexList selected = selections->selectedIndexes();

    for (int i=0;i<selected.size();i++)

    {

            model->removeRow(selected[i].row());

    }

    model->submitAll();

    model->setTable("stu_info");

    ui->tableView->setModel(model);

    model->select();

}