Qt登录注册界面连接数据库实现

ui界面通过ui编辑器编写：

 

login.cpp


#include "farm_login.h"
#include "ui_farm_login.h"
#include <QLineEdit>
#include <QMessageBox>
#include <QtSql>

//登录界面

farm_login::farm_login(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::farm_login)
{
    ui->setupUi(this);

    //设置背景图片
    this->setObjectName("farm_login");    //这句话一定要有，不然，整个界面上的控件背景都跟界面背景一样
    this->setStyleSheet("#farm_login{border-image:url(:/picture/图片.png)}");

    //隐藏关闭、最大化、最小化
    setWindowFlags(Qt::FramelessWindowHint);

    //用户名输入提示
    ui->farm_login_user_lineEdit->setPlaceholderText("請输入用户名");

    //密码输入提示
    ui->farm_login_pwd_lineEdit->setPlaceholderText("请输入密码");



}

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

void farm_login::on_farm_login_reg_pushButton_clicked()
{
    regwin.show();
    this->close();
}

void farm_login::on_farm_login_close_clicked()
{
    this->close();
}

void farm_login::on_farm_login_min_clicked()
{
    this->showMinimized();
}

void farm_login::on_farm_login_login_pushButton_clicked()
{
    QString user;
    QString pwd;
    user = ui->farm_login_user_lineEdit->text();//获取用户名
    pwd = ui->farm_login_pwd_lineEdit->text();//获取密码
    if(user == "")
        QMessageBox::warning(this,"","用户名不能为空！");
    else if(pwd == "")
        QMessageBox::warning(this,"","密码不能为空！");
    else
    {
        
        //sql语句在数据库中进行查询验证
        QString S =QString("select * from litterfarm.farmer where farm_user='%1' and farm_pwd='%2' ").arg(user).arg(pwd);
        QSqlQuery query;
         if(query.exec(S))
            {
             index.show();
             this->close();
         }
         else
            QMessageBox::warning(NULL,"Error","用户名或密码错误！！！");

    }
}

 

注册界面也同样有ui编辑器编写：

regist.cpp

#include "farm_reg.h"
#include "ui_farm_reg.h"
#include "farm_login.h"
#include <QString>
#include <QMessageBox>
#include <QtSql>

farm_reg::farm_reg(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::farm_reg)
{
    ui->setupUi(this);

    //隐藏关闭、最大化、最小化
    setWindowFlags(Qt::FramelessWindowHint);

    //用户名输入提示
    ui->farm_reg_user_lineEdit->setPlaceholderText("請输入用户名");

    //密码输入提示
    ui->farm_reg_pwd_lineEdit->setPlaceholderText("请输入密码");


}

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

void farm_reg::on_farm_reg_close_pushButton_clicked()
{
    this->close();
}

void farm_reg::on_farm_reg_back_pushButton_clicked()
{
    login = new farm_login;
    login->show();
    this->close();
}

void farm_reg::on_farm_reg_reg_pushButton_clicked()
{
    QString user;
    QString pwd;
    user = ui->farm_reg_user_lineEdit->text();
    pwd = ui->farm_reg_pwd_lineEdit->text();
    if(user == "")
        QMessageBox::warning(this,"","用户名不能为空！");
    else if(pwd == "")
        QMessageBox::warning(this,"","密码不能为空！");
    else
    {
        QString i=QString("insert into litterfarm.farmer values ('%1','%2'); ").arg(user).arg(pwd);
        QString S =QString("select * from litterfarm.farmer where farm_user='%1' ").arg(user);
        QSqlQuery query;
         if(query.exec(i))
            {

             QMessageBox::information(NULL, "注册成功", "注册成功！！！", QMessageBox::Yes);
             login = new farm_login;
             login->show();
             this->close();
         }
         else if(query.exec(S)&&query.first())
            QMessageBox::warning(NULL,"Error","用户名重复！！！");
         else
            QMessageBox::warning(NULL,"Error","注册失败，请重试！！！");

    }


}

void farm_reg::on_farm_reg_min_pushButton_clicked()
{
    this->showMinimized();
}