Qt连接MySql并增加表数据，删除数据工程文件包。

#include "mainwindow.h" #include "ui_mainwindow.h" MainWindow::MainWindow(QWidget *parent) : QMainWindow(parent), ui(new Ui::MainWindow) { ui->setupUi(this); } MainWindow::~MainWindow() { delete ui; } void MainWindow::myLayout() { QWidget *centerWindow = new QWidget; this->setCentralWidget(centerWindow); Button_1 = new QPushButton("连接MySql"); Button_2 = new QPushButton("添加数据"); Button_3 = new QPushButton("更新数据"); Button_4 = new QPushButton("删除数据"); Line_1 = new QLineEdit; Line_2 = new QLineEdit; Line_3 = new QLineEdit; Line_4 = new QLineEdit; Label_1 = new QLabel("id"); Label_2 = new QLabel("name"); Label_3 = new QLabel("age"); Label_4 = new QLabel("score"); Button_1->setMinimumHeight(50); Button_2->setMinimumHeight(50); Button_3->setMinimumHeight(50); Button_4->setMinimumHeight(50); connect(Button_1,SIGNAL(clicked(bool)),this,SLOT(button_1_clicked())); connect(Button_2,SIGNAL(clicked(bool)),this,SLOT(button_2_clicked())); connect(Button_3,SIGNAL(clicked(bool)),this,SLOT(button_3_clicked())); connect(Button_4,SIGNAL(clicked(bool)),this,SLOT(button_4_clicked())); QGridLayout *layout = new QGridLayout; layout->addWidget(Line_1,0,1,1,3,Qt::Alignment()); layout->addWidget(Line_2,1,1,1,3,Qt::Alignment()); layout->addWidget(Line_3,2,1,1,3,Qt::Alignment()); layout->addWidget(Line_4,3,1,1,3,Qt::Alignment()); layout->addWidget(Button_1,4,0,Qt::Alignment()); layout->addWidget(Button_2,4,1,Qt::Alignment()); layout->addWidget(Button_3,4,2,Qt::Alignment()); layout->addWidget(Button_4,4,3,Qt::Alignment()); layout->addWidget(Label_1,0,0,Qt::Alignment()); layout->addWidget(Label_2,1,0,Qt::Alignment()); layout->addWidget(Label_3,2,0,Qt::Alignment()); layout->addWidget(Label_4,3,0,Qt::Alignment()); layout->setMargin(12); centerWindow->setLayout(layout); } void MainWindow::button_1_clicked() { QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL"); db.setHostName("127.0.0.1");//数据库服务器ip db.setUserName("root");//数据库用户名 db.setPassword("123456");//数据库密码 db.setDatabaseName("mydata");//使用哪个数据库 //端口号就使用默认的3306吧,因为在本地 if( !db.open() )//打开数据库,如果返回false表示打开失败 { QMessageBox::warning(this,"错误",db.lastError().text() );//打开失败,显示错误信息 return; }else { QMessageBox::warning(this,"恭喜~~~","Mysql连接成功！"); } QSqlQuery query; QString sql = "create table student(id int primary key auto_increment,name varchar(255),age int,score int);"; query.exec(sql); } void MainWindow::button_2_clicked() { int id = Line_1->text().toInt(); QString name = Line_2->text(); int age = Line_3->text().toInt(); int score = Line_4->text().toInt(); QString sql = QString("insert into student(id,name,age,score) values('%1','%2','%3','%4')").arg(id).arg(name).arg(age).arg(score); QSqlQuery query; query.exec(sql); } void MainWindow::button_3_clicked() { int id = Line_1->text().toInt(); QString name = Line_2->text(); int age = Line_3->text().toInt(); int score = Line_4->text().toInt(); QString sql = QString("update student set id='%1',name='%2',age='%3',score='%4' where id='%5'").arg(id).arg(name).arg(age).arg(score).arg(id); QSqlQuery query; query.exec(sql); } void MainWindow::button_4_clicked() { int id = Line_1->text().toInt(); QString sql = QString("delete from student where id = '%1'").arg(id); QSqlQuery query; query.exec(sql); }