Qt——连接mysql增删查改（仓库管理极简版）

news/2024/7/24 5:45:28 标签: qt, mysql, 开发语言

目录

UI布局设计

.pro文件

 mainwindow.h

main.cpp

UI布局设计

.pro文件

QT       += core gui
QT       += core gui sql
QT       += sql

greaterThan(QT_MAJOR_VERSION, 4): QT += widgets

CONFIG += c++11

# The following define makes your compiler emit warnings if you use
# any Qt feature that has been marked deprecated (the exact warnings
# depend on your compiler). Please consult the documentation of the
# deprecated API in order to know how to port your code away from it.
DEFINES += QT_DEPRECATED_WARNINGS

# You can also make your code fail to compile if it uses deprecated APIs.
# In order to do so, uncomment the following line.
# You can also select to disable deprecated APIs only up to a certain version of Qt.
#DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000    # disables all the APIs deprecated before Qt 6.0.0

SOURCES += \
    main.cpp \
    mainwindow.cpp

HEADERS += \
    mainwindow.h

FORMS += \
    mainwindow.ui

# Default rules for deployment.
qnx: target.path = /tmp/$${TARGET}/bin
else: unix:!android: target.path = /opt/$${TARGET}/bin
!isEmpty(target.path): INSTALLS += target

 mainwindow.h

#ifndef MAINWINDOW_H
#define MAINWINDOW_H

#include <QMainWindow>
#include <QMessageBox>
#include <QtSql/QSqlDatabase>
#include <QtSql/QSqlQuery>
#include <QDebug>
#include <QtSql/QSqlQueryModel>

QT_BEGIN_NAMESPACE
namespace Ui { class MainWindow; }
QT_END_NAMESPACE

class MainWindow : public QMainWindow
{
    Q_OBJECT

public:
    MainWindow(QWidget *parent = nullptr);
    ~MainWindow();

private slots:
    void ReshowTable_goods();
    void ReshowTable_people();
    void on_move_goods_clicked();

    void on_move_people_clicked();


   void on_pushButton_addgoods_clicked();

   void on_pushButton_selectgoods_clicked();

   void on_pushButton_changegoods_clicked();

   void on_pushButton_deletegoods_clicked();


   void on_pushButton_addpeople_clicked();

   void on_pushButton_selectpeople_clicked();

   void on_pushButton_changepeople_clicked();

   void on_pushButton_deletepeople_clicked();

private:
    Ui::MainWindow *ui;

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

    QSqlQueryModel *goodsMode;//货物数据模型
    QSqlQueryModel *peopleMode;//工作人员数据模型

};
#endif // MAINWINDOW_H

main.cpp

#include "mainwindow.h"

#include <QApplication>

int main(int argc, char *argv[])
{
    QApplication a(argc, argv);
    MainWindow w;
    w.show();
    return a.exec();
}

mainwindow.cpp

#include "mainwindow.h"
#include "ui_mainwindow.h"
void sqlconnect(QWidget* parent);
MainWindow::MainWindow(QWidget *parent)
    : QMainWindow(parent)
    , ui(new Ui::MainWindow)
{
    ui->setupUi(this);
    goodsMode = new QSqlQueryModel(ui->tableView_goods);
     peopleMode = new QSqlQueryModel(ui->tableView_people);//绑定
    sqlconnect(this);

}

void sqlconnect(QWidget* parent)
{


    //连接数据库
      QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
      db.setHostName("127.0.0.1");
      db.setPort(3306);

      db.setDatabaseName("sqlconnect");//数据库名称
      db.setUserName("root");//用户名
      db.setPassword("");//密码



      qDebug()<<"available drivers:";
      QStringList drivers = QSqlDatabase::drivers();
      for(auto driver: drivers)
          qDebug() << driver;
      bool ok = db.open();
      if(ok==0)
      {
          QMessageBox::information(parent, "提示","数据库连接失败");
          parent->close();
          qDebug()<<"数据库连接失败";
      }

      //若数据库中没有表，则新建
      QSqlQuery query;

      QString createTableGoods="create table if not exists goods(id int primary key auto_increment,name varchar(10),number int, price varchar(10), data varchar(15),server varchar(10),endline int,code varchar(15));";
      QString createTableWoker="create table if not exists woker(name varchar(10),phonenumber varchar(20), sex varchar(8), age int);";
      query.exec(createTableGoods);
      query.exec(createTableWoker);
}

MainWindow::~MainWindow()
{
    delete ui;
}
//___________________________________________________________________________________________________________
void MainWindow::ReshowTable_goods()
{
    goodsMode->setHeaderData(0,Qt::Horizontal,tr("入库编号"));
    goodsMode->setHeaderData(1,Qt::Horizontal,tr("名称"));
    goodsMode->setHeaderData(2,Qt::Horizontal,tr("数量"));
    goodsMode->setHeaderData(3,Qt::Horizontal,tr("单价"));
    goodsMode->setHeaderData(4,Qt::Horizontal,tr("生产日期"));
    goodsMode->setHeaderData(5,Qt::Horizontal,tr("供应商"));
    goodsMode->setHeaderData(6,Qt::Horizontal,tr("保质期"));
    goodsMode->setHeaderData(7,Qt::Horizontal,tr("条形码编号"));
    ui->tableView_goods->setModel(goodsMode);
}

void MainWindow::on_move_goods_clicked()
{
    ui->stackedWidget->setCurrentIndex(0);
}

void MainWindow::on_move_people_clicked()
{
     ui->stackedWidget->setCurrentIndex(1);
}

void MainWindow::on_pushButton_addgoods_clicked()
{
    QString id = ui->lineEdit_goods_id->text();
    QString name = ui->lineEdit_goods_name->text();
    QString number = ui->lineEdit_goods_number->text();
    QString price = ui->lineEdit_goods_price->text();
    QString data = ui->lineEdit_goods_data->text();
    QString server = ui->lineEdit_goods_server->text();
    QString endline = ui->lineEdit_goods_endline->text();
    QString code = ui->lineEdit_goods_code->text();

    QSqlQuery query;
    QString str1 = "" + id +",'"+ name +"'," + number + ",'" +price+"','"+data+"','" +server+"',"+endline+",'"+ code+"'";
    QString str = "insert into goods(id,name,number,price,data,server,endline,code) values("+ str1 +");";


    bool success = query.exec(str);
    if(success)
    {
        QMessageBox::information(this, "提示","入库成功");
    }
    else
    {
         QMessageBox::information(this, "提示","入库失败，请检查输入的数据是否正确");
    }
    goodsMode->setQuery("select * from goods;");
    ReshowTable_goods();
}


void MainWindow::on_pushButton_selectgoods_clicked()
{
    goodsMode->setQuery("select * from goods;");
    ReshowTable_goods();
}

void MainWindow::on_pushButton_changegoods_clicked()
{
    QSqlQuery query;
    QString str = "update goods set id = '"+ ui->lineEdit_goods_id->text() + "', name='" + ui->lineEdit_goods_name->text()
            + "',number='" + ui->lineEdit_goods_number->text() + "',price='" + ui->lineEdit_goods_price->text()
            + "',server='" + ui->lineEdit_goods_server->text()+ "',data='" + ui->lineEdit_goods_data->text()
            + "',code='" + ui->lineEdit_goods_code->text()+ "',endline='" + ui->lineEdit_goods_endline->text()
            + "' where number='" + ui->lineEdit_goods_id->text() + "';";
    query.exec(str);
    QMessageBox::information(this, "修改成功", "表信息修改成功");
    goodsMode->setQuery("select * from goods;");
    ReshowTable_goods();
}

void MainWindow::on_pushButton_deletegoods_clicked()
{
    QSqlQuery query;
    int currentrow = ui->tableView_goods->currentIndex().row();
    goodsMode->removeRow(currentrow);
    if(currentrow != -1)//若选中一行
    {
        int ok  =  QMessageBox::warning(this,tr("删除当前行!"),tr("你确定删除当前行吗？"), QMessageBox::Yes,QMessageBox::No);
        //如确认删除
        if(ok == QMessageBox::Yes)
        {
            goodsMode->removeRow(currentrow);
            QString id = goodsMode->data(goodsMode->index(currentrow,0)).toString();//获取id
            QString del = "delete from goods where id='" + id + "';";
            query.exec(del);
            goodsMode->setQuery("select * from goods");
            ui->tableView_goods->setModel(goodsMode);
            QMessageBox::information(this, "删除成功", "所选信息删除成功");
        }
    }
    else
        QMessageBox::information(this, "提示", "请选择你要删除的信息行");
}

//__________________________________________________________________________________________________________________
void MainWindow::ReshowTable_people()
{
    peopleMode->setHeaderData(0,Qt::Horizontal,tr("姓名"));
    peopleMode->setHeaderData(1,Qt::Horizontal,tr("性别"));
    peopleMode->setHeaderData(2,Qt::Horizontal,tr("年龄"));
    peopleMode->setHeaderData(3,Qt::Horizontal,tr("电话"));
    ui->tableView_people->setModel(peopleMode);


}
void MainWindow::on_pushButton_addpeople_clicked()
{
    QString name = ui->lineEdit_people_name->text();
    QString sex = ui->lineEdit_people_sex->text();
    QString age = ui->lineEdit_people_age->text();
    QString phonenumber = ui->lineEdit_people_phonenumber->text();

    QSqlQuery query;
    QString str1 = "'" + name +"','"+ phonenumber +"','" + sex + "'," +age+"";
    QString str = "insert into woker(name,phonenumber,sex,age) values("+ str1 +");";

    bool success = query.exec(str);
    if(success)
    {
        QMessageBox::information(this, "提示","增加成功");
    }
    else
    {
         QMessageBox::information(this, "提示","操作失败，请检查输入的数据是否正确");
    }
    goodsMode->setQuery("select * from woker;");
    ReshowTable_people();
}

void MainWindow::on_pushButton_selectpeople_clicked()
{

   peopleMode->setQuery("select * from woker;");

   ReshowTable_people();

}


void MainWindow::on_pushButton_changepeople_clicked()
{
    QSqlQuery query;
    QString str = "update goods set name = '"+ ui->lineEdit_people_name->text() + "', sex='" + ui->lineEdit_people_sex->text()
            + "',age=" + ui->lineEdit_people_age->text() + ",phonenumber='" + ui->lineEdit_people_phonenumber->text()
            + "' where number='" + ui->lineEdit_goods_id->text() + "';";
    query.exec(str);
    QMessageBox::information(this, "修改成功", "表信息修改成功");
    goodsMode->setQuery("select * from woker;");
    ReshowTable_people();
}

void MainWindow::on_pushButton_deletepeople_clicked()
{
    QSqlQuery query;
    int currentrow = ui->tableView_people->currentIndex().row();
    peopleMode->removeRow(currentrow);
    if(currentrow != -1)//若选中一行
    {
        int ok  =  QMessageBox::warning(this,tr("删除当前行!"),tr("你确定删除当前行吗？"), QMessageBox::Yes,QMessageBox::No);
        //如确认删除
        if(ok == QMessageBox::Yes)
        {
            peopleMode->removeRow(currentrow);
            QString name = peopleMode->data(peopleMode->index(currentrow,0)).toString();//获取姓名
            QString del = "delete from woker where name='" + name + "';";
            query.exec(del);
            peopleMode->setQuery("select * from woker");
            ui->tableView_people->setModel(peopleMode);
            QMessageBox::information(this, "删除成功", "所选信息删除成功");
        }
    }
    else
        QMessageBox::information(this, "提示", "请选择你要删除的信息行");
}

连接本地mysql，如果要在别的地方运行，要有mysql的环境


http://www.niftyadmin.cn/n/5172751.html

相关文章

mysql从A库复制表到B库的时候报：MySQL ERROR：1153

mysql从A库复制表到B库的时候报：MySQL ERROR：1153

今天操作数据表从A库迁移到B库的时候报了这个问题: MySQL ERROR&#xff1a;1153&#xff1b;因为表比较大&#xff0c;我导出SQL文件查看大概有1.8G&#xff0c;里面存放的都是图片信息。我其中尝试了多种方法&#xff0c;使用navicat 工具中的数据 同步&#xff0c;还有表复制…
阅读更多...
Ubuntu 下监控并自动重启网卡

Ubuntu 下监控并自动重启网卡

很多时候网站服务器挂掉也可能是因为网卡挂掉了&#xff0c;如果你网站不能访问时 SSH 也无效了一般都是这个问题。这时可以通过一个定时脚本监控网络并进行自动重启。 1 创建脚本 auto_restart_network.sh 4 5 6 7 8 9 #!/bin/bash ping www.baidu.com -c 1 >/dev/null i…
阅读更多...
图论12-无向带权图及实现

图论12-无向带权图及实现

文章目录 带权图1.1带权图的实现1.2 完整代码 带权图 1.1带权图的实现 在无向无权图的基础上&#xff0c;增加边的权。 使用TreeMap存储边的权重。 遍历输入文件&#xff0c;创建TreeMap adj存储每个节点。每个输入的adj节点链接新的TreeMap&#xff0c;存储相邻的边和权重 …
阅读更多...
计算机网络的发展及应用

计算机网络的发展及应用

计算机网络是计算机技术和通信技术高度发展并相互结合的产物。一方面&#xff0c;通信系统为计算机之间的数据传送提供最重要的支持&#xff1b;另一方面&#xff0c;由于计算机技术渗透到了通信领域&#xff0c;极大地提高了通信网络的性能。计算机网络的诞生和发展&#xff0…
阅读更多...
C_5练习题

C_5练习题

一、单项选择题(本大题共20小题,每小题2分,共40分。在每小题给出的四个备选项中,选出一个正确的答案,并将所选项前的字母填写在答题纸的相应位置上。) 下列叙述中错误的是()。 A.计算机不能直接执行用C语言编写的源程序 B.C程序经C编译程序编译后,生成扩展名为obj的文件是一个…
阅读更多...
Unity Mirror学习（三）ClientRpc特性使用

Unity Mirror学习（三）ClientRpc特性使用

ClientRpc特性 1&#xff0c;从服务端任意一网络对象发送到客户端 2&#xff0c;修饰方法的&#xff0c;在服务器上调用此方法&#xff0c;它将在所有客户端执行&#xff08;我的理解:服务端广播消息&#xff0c;消息方法&#xff09; 3&#xff0c;此方法不会在本地执行 它和…
阅读更多...
VueRequest——管理请求状态库

VueRequest——管理请求状态库

文章目录 前言一、为什么选择 VueRequest&#xff1f;二、使用步骤1.安装2.用例 前言 VueRequest——开发文档 VueReques——GitHub地址 在以往的业务项目中&#xff0c;我们经常会被 loading 状态的管理、请求的节流防抖、接口数据的缓存、分页等重复的功能实现所困扰。每次开…
阅读更多...
SpringBoot+MybatisPlus Restful示例

SpringBoot+MybatisPlus Restful示例

增删改查,分页 CREATE TABLE tbl_book ( id int NOT NULL AUTO_INCREMENT, type varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, desc_ription varchar(255) CHAR…
阅读更多...
最新文章

Copyright @ 2022~2023