QT day5

数据库完成登入注册

mainwindow.h

#ifndef MAINWINDOW_H
#define MAINWINDOW_H
#include <QMainWindow>
#include<QDebug>
#include<QPushButton>
#include<QLineEdit>
#include<QLabel>
#include <QMainWindow>
#include<QMessageBox>//消息对话框                     //输出函数对应的头文件
#include <QIcon>
#include"form.h"
/*******数据库***********/
#include<QSqlDatabase>//数据库
#include<QSqlRecord>
#include<QMessageBox>
#include<QSqlQuery>
QT_BEGIN_NAMESPACE
namespace Ui { class MainWindow; }
QT_END_NAMESPACE

class MainWindow : public QMainWindow
{
    Q_OBJECT

signals:
    void jump();//自定义跳转信号函数
    void jump2();//自定义跳转信号函数
private slots:
    void on_btn1_clicked();
    void on_btn2_clicked();

    void on_btn3_clicked();

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

private:
    Ui::MainWindow *ui;
     QPushButton *btn1;
     QPushButton *btn2;
      QPushButton *btn3;
      QLineEdit *edit1;
       QLineEdit *edit2;
        QSqlDatabase mydb;//数据库
};
#endif // MAINWINDOW_H

mainwindow.cpp

#include "mainwindow.h"
#include "ui_mainwindow.h"

MainWindow::MainWindow(QWidget *parent)
    : QMainWindow(parent)
    , ui(new Ui::MainWindow)
{
    ui->setupUi(this);
    this->setFixedSize(600,400);//设置固定尺寸
    this->setWindowIcon(QIcon(":/new/prefix1/tuku/yh.png"));//改变左上角图标的位
    this->setWindowTitle("易碗浆糊");//窗口的名字
    //this->setStyleSheet("background-color:pink;");//背景颜色
    QLabel *lab1=new QLabel(this);//实例化一个标签
    lab1->resize(600,170);//重新设置尺寸
    lab1->setStyleSheet("background-color:yellow");
    lab1->setAlignment(Qt::AlignCenter);
    lab1->setPixmap(QPixmap(":/new/prefix1/tuku/fjh.png"));
    lab1->setScaledContents(true);
    this->setStyleSheet("background-color:white;");//背景颜色

    //用户名框
    edit1=new QLineEdit(this);
    edit1->resize(230,45);
    edit1->move(lab1->x()+200,lab1->y()+200);
    edit1->setPlaceholderText("用户名");//设置占位文本
    //密码框
    edit2=new QLineEdit(this);
    edit2->resize(230,45);
    edit2->move(edit1->x(),edit1->y()+75);
    edit2->setPlaceholderText("密码");//设置占位文本
    edit2->setEchoMode(QLineEdit::Password);//设置回显模式
    //实例化一个标签
    QLabel *lab2=new QLabel(this);
    lab2->resize(45,45);//重新设置尺寸
    lab2->setAlignment(Qt::AlignCenter);
    lab2->setPixmap(QPixmap(":/new/prefix1/tuku/wxn.png"));
    lab2->setScaledContents(true);
    lab2->move(lab1->x()+140,lab1->y()+200);
    //实例化一个标签
    QLabel *lab3=new QLabel(this);
    lab3->resize(45,45);//重新设置尺寸
    lab3->setAlignment(Qt::AlignCenter);
    lab3->setPixmap(QPixmap(":/new/prefix1/tuku/wxnnn.png"));
    lab3->setScaledContents(true);
    lab3->move(lab1->x()+140,lab1->y()+275);
    //实例化一个按钮
    //QPushButton *btn1=new QPushButton(this);
    this->btn1=new QPushButton("btn1",this);
    btn1->setText("登录");
    btn1->resize(70,40);
    btn1->move(lab3->x()+80,lab3->y()+70);
    btn1->setIcon(QIcon(":/new/prefix1/tuku/wq.png"));
    connect(btn1,&QPushButton::clicked,this,&MainWindow::on_btn1_clicked);

    // btn1->setStyleSheet("background-color:white;border-radius:10px;");//设置组件背景色

    //实例化一个按钮
    // QPushButton *btn2=new QPushButton(this);
    this->btn2=new QPushButton("btn2",this);
    btn2->setText("取消");
    btn2->resize(70,40);
    btn2->move(btn1->x()+130,btn1->y());
    // btn2->setStyleSheet("background-color:white;border-radius:10px;");//设置组件背景色
    btn2->setIcon(QIcon(":/new/prefix1/tuku/wq2.png"));
    connect(btn2,&QPushButton::clicked,this,&MainWindow::on_btn2_clicked);
    //实例化一个按钮
    this->btn3=new QPushButton("btn2",this);
    btn3->setText("注册");
    btn3->resize(70,45);
    btn3->move(edit1->x()+235,edit1->y());
    connect(btn3,&QPushButton::clicked,this,&MainWindow::on_btn3_clicked);
    /************************************************/
    if(!mydb.contains("mydatabase.db"))
    {
        mydb=QSqlDatabase::addDatabase("QSQLITE");
        //设置数据库的名字
        mydb.setDatabaseName("mydatabase.db");
    }
    if(!mydb.open())
    {
        QMessageBox::information(this,"失败","数据库打开失败");
        return;
    }
    //准备sql语句
    QString sql="create table if not exists user_info("
                "name varchar(10),"//用户名
            "mm integer)";//密码




}
void MainWindow::on_btn1_clicked()
{

    //准备sql语句
    QString sql="select *from user_info";
    //准备语句执行者
    QSqlQuery querry;
    //执行sql语句
    if(!querry.exec(sql))
    {
        QMessageBox::information(this,"提示","执行失败");
        return;
    }
    int flg=0;
    QSqlRecord rec = querry.record();//总行
    while(querry.next())
    {

        for(int i=0;i<rec.count();i++)
        {   if(edit1->text()==querry.record().value(0).toString() &&edit2->text()==querry.record().value(1).toString()){
                flg=1;

                break;
            }

        }
    }
    if(flg==1)//登入成功
    {
        emit jump();
        this->hide();
    }
    else if(flg==0)//数据库没有相应的密码和用户
    {

        QMessageBox box(QMessageBox::Critical,"密码错误","账号密码不匹配,是否重新登录",
                        QMessageBox::Yes|QMessageBox::No,
                        this);
        box.setButtonText(QMessageBox::Yes,"OK");
        box.setButtonText(QMessageBox::No,"cancel");
        int ret=box.exec();
        if(ret==QMessageBox::Yes)
        {
            edit1->clear();//清空
            edit2->clear();//清空
        }else if(ret==QMessageBox::No)
        {
            this->close();

        }
    }

    if(edit1->text()=="admin" &&edit2->text()=="12345")
    {

        emit jump();
        this->hide();
    }


}
void MainWindow::on_btn2_clicked()
{


    int ret1= QMessageBox::question(this,"问题","是否确定要退出登录",QMessageBox::Yes|QMessageBox::No,QMessageBox::No);
    //对用户选中的按钮进行判断
    if(ret1==QMessageBox::Yes)
    {
        this->close();
    }else if(ret1==QMessageBox::No)
    {
        edit1->clear();//清空
        edit2->clear();//清空
    }

}

//注册按钮的槽函数
void MainWindow::on_btn3_clicked()
{
    emit jump2();
    this->hide();
}

MainWindow::~MainWindow()
{
    delete ui;
}

from.h

#ifndef FORM_H
#define FORM_H
#include<QMessageBox>//消息对话框
#include <QMainWindow>
#include <QWidget>
namespace Ui {
class Form;
}

class Form : public QWidget
{
    Q_OBJECT

public slots:
    void jump_slot();
 void on_bt3_clicked();
public:
    explicit Form(QWidget *parent = nullptr);
    ~Form();



private:
    Ui::Form *ui;

};

#endif // FORM_H

form.cpp

#include "form.h"
#include "ui_form.h"

Form::Form(QWidget *parent) :
    QWidget(parent),
    ui(new Ui::Form)
{
    ui->setupUi(this);
    this->setWindowIcon(QIcon(":/new/prefix1/tuku/yh.png"));//改变左上角图标的位
    this->setWindowTitle("成功");//窗口的名字

}

Form::~Form()
{
    delete ui;
}
//跳转
void Form::jump_slot()
{

     this->show();

}


void Form::on_bt3_clicked()
{
    close();
}

zcfrom.h

#ifndef ZCFROM_H
#define ZCFROM_H
#include<QMessageBox>//消息对话框
#include <QMainWindow>
#include <QWidget>
#include <QMainWindow>
#include<QDebug>
#include<QPushButton>
#include<QLineEdit>
#include<QLabel>
#include <QMainWindow>
#include<QMessageBox>//消息对话框                     //输出函数对应的头文件
#include <QIcon>
#include"form.h"
/*******数据库***********/
#include<QSqlDatabase>//数据库
#include<QSqlRecord>
#include<QMessageBox>
#include<QSqlQuery>
namespace Ui {
class zcfrom;
}

class zcfrom : public QWidget
{

    Q_OBJECT
signals:
    void jump3();//自定义跳转信号函数
public slots:
    void jump2_slot();
public:
    explicit zcfrom(QWidget *parent = nullptr);
    ~zcfrom();

private slots:
    void on_zcBttn_clicked();

    void on_fhbttn_clicked();

private:
    Ui::zcfrom *ui;
     QSqlDatabase mydb;//数据库
};

#endif // ZCFROM_H

zcfrom.cpp

#include "zcfrom.h"
#include "ui_zcfrom.h"

zcfrom::zcfrom(QWidget *parent) :
    QWidget(parent),
    ui(new Ui::zcfrom)
{
    ui->setupUi(this);
    this->setWindowTitle("注册");//窗口的名字
    this->setWindowIcon(QIcon(":/new/prefix1/tuku/yh.png"));//改变左上角图标的位
    if(!mydb.contains("mydatabase.db"))
    {
        mydb=QSqlDatabase::addDatabase("QSQLITE");
        //设置数据库的名字
        mydb.setDatabaseName("mydatabase.db");
    }
    if(!mydb.open())
    {
        QMessageBox::information(this,"失败","数据库打开失败");
        return;
    }
    //准备sql语句
    QString sql="create table if not exists user_info("
            "name varchar(10),"//用户名
            "mm integer)";//密码
    //准备语句执行者
    QSqlQuery querry;
    //让语句执行者指向sql语句
    //成功true失败false
    if(!querry.exec(sql))
    {
        QMessageBox::information(this,"失败","失败");
        return;
    }
}

zcfrom::~zcfrom()
{
    delete ui;
}
void zcfrom::jump2_slot()
{

     this->show();

}
//确定
void zcfrom::on_zcBttn_clicked()
{

    QString name=ui->nameEdit->text();
    int mm=ui->mmEdit->text().toInt();
    if(name.isEmpty()||mm==0)
    {
        QMessageBox::information(this,"提示","数据未填写完整");
        return;
    }
    //准备sql语句
    QString sql=QString("insert into user_info(name,mm)"
            "values('%1',%4)").arg(name).arg(mm);
   QSqlQuery querry;
   if(!querry.exec(sql))
   {
       QMessageBox::information(this,"失败","注册失败");
       return;
   }else
   {
       ui->nameEdit->clear();
       ui->mmEdit->clear();
       QMessageBox::information(this,"成功","注册成功");
       //此界面消失
       emit jump3();
       this->hide();
   }
}
//返回登录按钮的槽函数

void zcfrom::on_fhbttn_clicked()
{
    emit jump3();
    this->hide();
}

main.cpp

#include "mainwindow.h"
#include "form.h"
#include <QApplication>
#include "zcfrom.h"
int main(int argc, char *argv[])
{
    QApplication a(argc, argv);
    MainWindow w;
    w.show();
    Form s;//定义第二个界面
    QObject::connect(&w,&MainWindow::jump,&s,&Form::jump_slot);
    zcfrom s2;//定义第二个界面
    QObject::connect(&w,&MainWindow::jump2,&s2,&zcfrom::jump2_slot);

    QObject::connect(&s2,&zcfrom::jump3,&w,&MainWindow::show);//定义第二个界面

    return a.exec();
}

03dljm.pro

QT       += core gui 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 += \
    form.cpp \
    main.cpp \
    mainwindow.cpp \
    zcfrom.cpp

HEADERS += \
    form.h \
    mainwindow.h \
    zcfrom.h

FORMS += \
    form.ui \
    mainwindow.ui \
    zcfrom.ui

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

RESOURCES += \
    ttp.qrc

INCLUDEPATH += D:/opencv/opencv3.4-qt-intall/install/include
INCLUDEPATH += D:/opencv/opencv3.4-qt-intall/install/include/opencv
INCLUDEPATH += D:/opencv/opencv3.4-qt-intall/install/include/opencv2
LIBS += D:/opencv/opencv3.4-qt-intall/install/x86/mingw/lib/libopencv_*.a

 

智能指针思维导图