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();
}