Qt Creater 设计的登录注册界面 使用SQLite数据库

- 日理万妓 2024-02-21 11:13 114阅读 0赞

Qt Creater 设计的登录注册界面 使用SQLite数据库

案例截图

" class="reference-link">登录页面登录页面

" class="reference-link">注册页面注册页面

项目目录结构截图

目录结构

代码

main.cpp
  1. #include "mainwindow.h"
  3. #include <QApplication>
  5. int main(int argc, char *argv[])
  6. {
  8.     QApplication a(argc, argv);
  9.     MainWindow w;
  10.     //第一个是去掉原边框及标题栏，第二个是保留最小化及还原功能，主要是为了还原，最小化下面实现了
  11.     w.setWindowFlags(Qt::FramelessWindowHint | Qt::WindowMinimizeButtonHint);
  12.     w.show();
  13.     return a.exec();
  14. }

mainwindow.cpp

  1. #include "mainwindow.h"
  2. #include "ui_mainwindow.h"
  3. #include "signup.h"
  4. #include <QGraphicsDropShadowEffect>
  6. MainWindow::MainWindow(QWidget *parent)
  7.     : QMainWindow(parent)
  8.     , ui(new Ui::MainWindow)
  9. {
  11.     ui->setupUi(this);
  12.     //设置图片
  13.     QPixmap *pix = new QPixmap(":/images/blue.png");
  14.     QSize sz = ui->label_image->size();
  15.     ui->label_image->setPixmap(pix->scaled(sz));
  17.     //设置图片阴影效果
  18.     QGraphicsDropShadowEffect *shadow = new QGraphicsDropShadowEffect(this);
  19.     shadow->setOffset(-3, 0);
  20.     shadow->setColor(QColor(136,136,136));
  21.     shadow->setBlurRadius(30);
  22.     ui->label_image->setGraphicsEffect(shadow);
  23. }
  25. MainWindow::~MainWindow()
  26. {
  28.     delete ui;
  29. }
  31. void sqlite_Init()
  32. {
  35.     QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
  36.     db.setDatabaseName("user.db");
  37.     if(!db.open())
  38.     {
  40.         qDebug()<<"open error";
  41.     }
  42.     //create excle
  43.     QString createsql=QString("create table if not exists user(id integer primary key autoincrement,"
  44.                                 "username ntext unique not NULL,"
  45.                                 "password ntext not NULL)");
  46.     QSqlQuery query;
  47.     if(!query.exec(createsql)){
  49.         qDebug()<<"table create error";
  50.     }
  51.     else{
  53.         qDebug()<<"table create success";
  54.     }
  55. }
  57. void MainWindow::on_btn_signin_clicked()
  58. {
  60.     sqlite_Init();
  61.     QString username = ui->lineEdit_username->text();
  62.     QString password = ui->lineEdit_password->text();
  63.     QString sql=QString("select * from user where username='%1' and password='%2'").arg(username,password);
  64.     //创建执行语句对象
  65.     QSqlQuery query(sql);
  66.     //判断执行结果
  67.     if(!query.next())
  68.     {
  70.         qDebug()<<"Login error";
  71.         QMessageBox::information(this,"登录认证","登录失败,账户或者密码错误");
  72.     }
  73.     else
  74.     {
  76.         qDebug()<<"Login success";
  77.         QMessageBox::information(this,"登录认证","登录成功");
  78.         //登录成功后可以跳转到其他页面
  79.         QWidget *w = new QWidget;
  80.         w->show();
  81.         this->close();
  82.     }
  83. }
  86. void MainWindow::on_btn_signup_clicked()
  87. {
  89.     this->close();
  90.     Signup *s = new Signup;
  91.     s->show();
  92. }
  95. void MainWindow::on_btn_close_clicked()
  96. {
  98.     this->close();
  99. }

signup.cpp

  1. #include "signup.h"
  2. #include "ui_signup.h"
  3. #include "mainwindow.h"
  5. Signup::Signup(QWidget *parent) :
  6.     QWidget(parent),
  7.     ui(new Ui::Signup)
  8. {
  10.     ui->setupUi(this);
  11.     //设置图片
  12.     QPixmap *pix = new QPixmap(":/images/women.png");
  13.     QSize sz = ui->label_image->size();
  14.     ui->label_image->setPixmap(pix->scaled(sz));
  15. }
  17. Signup::~Signup()
  18. {
  20.     delete ui;
  21. }
  23. void Signup::on_btn_return_clicked()
  24. {
  26.     MainWindow *w = new MainWindow;
  27.     w->show();
  28.     this->close();
  29. }
  32. void Signup::on_btn_sure_clicked()
  33. {
  35.     sqlite_Init();
  36.     QString username = ui->lineEdit_username->text();
  37.     QString password = ui->lineEdit_passwd->text();
  38.     QString surepass = ui->lineEdit_surepasswd->text();
  39.     //判断密码是否一致
  40.     if(password == surepass)
  41.     {
  43.         QString sql=QString("insert into user(username,password) values('%1','%2');")
  44.                           .arg(username).arg(password);
  45.         //创建执行语句对象
  46.         QSqlQuery query;
  47.         //判断执行结果
  48.         if(!query.exec(sql))
  49.         {
  51.             qDebug()<<"insert into error";
  52.             QMessageBox::information(this,"注册认证","插入失败！");
  53.         }
  54.         else
  55.         {
  57.             qDebug()<<"insert into success";
  58.             QMessageBox::information(this,"注册认证","插入成功！");
  59.             MainWindow *w = new MainWindow;
  60.             w->show();
  61.             this->close();
  62.         }
  64.     }else{
  66.         QMessageBox::information(this,"注册认证","两次密码输入不一致");
  67.     }
  68. }

页面UI

mainwindow.ui

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <ui version="4.0">
  3.  <class>MainWindow</class>
  4.  <widget class="QMainWindow" name="MainWindow">
  5.   <property name="geometry">
  6.    <rect>
  7.     <x>0</x>
  8.     <y>0</y>
  9.     <width>780</width>
  10.     <height>520</height>
  11.    </rect>
  12.   </property>
  13.   <property name="windowTitle">
  14.    <string>MainWindow</string>
  15.   </property>
  16.   <property name="styleSheet">
  17.    <string notr="true">background-color: rgb(255, 255, 255);</string>
  18.   </property>
  19.   <widget class="QWidget" name="centralwidget">
  20.    <widget class="QLabel" name="label_image">
  21.     <property name="geometry">
  22.      <rect>
  23.       <x>385</x>
  24.       <y>10</y>
  25.       <width>380</width>
  26.       <height>500</height>
  27.      </rect>
  28.     </property>
  29.     <property name="text">
  30.      <string/>
  31.     </property>
  32.    </widget>
  33.    <widget class="QLabel" name="label">
  34.     <property name="geometry">
  35.      <rect>
  36.       <x>10</x>
  37.       <y>10</y>
  38.       <width>200</width>
  39.       <height>20</height>
  40.      </rect>
  41.     </property>
  42.     <property name="text">
  43.      <string>切换页面</string>
  44.     </property>
  45.    </widget>
  46.    <widget class="QLabel" name="label_2">
  47.     <property name="geometry">
  48.      <rect>
  49.       <x>60</x>
  50.       <y>80</y>
  51.       <width>200</width>
  52.       <height>40</height>
  53.      </rect>
  54.     </property>
  55.     <property name="styleSheet">
  56.      <string notr="true">font: 87 20pt "仿宋";</string>
  57.     </property>
  58.     <property name="text">
  59.      <string>现在登录</string>
  60.     </property>
  61.    </widget>
  62.    <widget class="QPushButton" name="btn_signin">
  63.     <property name="geometry">
  64.      <rect>
  65.       <x>70</x>
  66.       <y>400</y>
  67.       <width>80</width>
  68.       <height>24</height>
  69.      </rect>
  70.     </property>
  71.     <property name="styleSheet">
  72.      <string notr="true">background-color: qlineargradient(spread:pad, x1:0.52, y1:1, x2:0.54, y2:0, 
  73. stop:0.0112994 rgba(64, 145, 252, 255), 
  74. stop:1 rgba(255, 255, 255, 255));
  75. color: rgb(255, 255, 255);
  77. border:0px groove gray;border-radius:
  78. 7px;padding:2px 4px;
  79. font: 14pt "Candara";</string>
  80.     </property>
  81.     <property name="text">
  82.      <string>登陆</string>
  83.     </property>
  84.    </widget>
  85.    <widget class="QPushButton" name="btn_signup">
  86.     <property name="geometry">
  87.      <rect>
  88.       <x>210</x>
  89.       <y>400</y>
  90.       <width>80</width>
  91.       <height>24</height>
  92.      </rect>
  93.     </property>
  94.     <property name="styleSheet">
  95.      <string notr="true">background-color: qlineargradient(spread:pad, x1:0.52, y1:1, x2:0.54, y2:0, 
  96. stop:0.0112994 rgba(64, 145, 252, 255), 
  97. stop:1 rgba(255, 255, 255, 255));
  98. color: rgb(255, 255, 255);
  100. border:0px groove gray;border-radius:
  101. 7px;padding:2px 4px;
  102. font: 14pt "Candara";</string>
  103.     </property>
  104.     <property name="text">
  105.      <string>注册</string>
  106.     </property>
  107.    </widget>
  108.    <widget class="QLineEdit" name="lineEdit_username">
  109.     <property name="geometry">
  110.      <rect>
  111.       <x>60</x>
  112.       <y>230</y>
  113.       <width>240</width>
  114.       <height>40</height>
  115.      </rect>
  116.     </property>
  117.     <property name="styleSheet">
  118.      <string notr="true">background-color: rgb(247, 247, 247);
  119. border:1px groove gray;border-radius:
  120. 7px;padding:2px 4px;
  121. font: 10pt "Candara";</string>
  122.     </property>
  123.     <property name="placeholderText">
  124.      <string>输入账号</string>
  125.     </property>
  126.    </widget>
  127.    <widget class="QLineEdit" name="lineEdit_password">
  128.     <property name="geometry">
  129.      <rect>
  130.       <x>60</x>
  131.       <y>300</y>
  132.       <width>240</width>
  133.       <height>40</height>
  134.      </rect>
  135.     </property>
  136.     <property name="styleSheet">
  137.      <string notr="true">background-color: rgb(247, 247, 247);
  138. border:1px groove gray;border-radius:
  139. 7px;padding:2px 4px;
  140. font: 10pt "Candara";</string>
  141.     </property>
  142.     <property name="placeholderText">
  143.      <string>输入密码</string>
  144.     </property>
  145.    </widget>
  146.    <widget class="QPushButton" name="btn_close">
  147.     <property name="geometry">
  148.      <rect>
  149.       <x>725</x>
  150.       <y>15</y>
  151.       <width>36</width>
  152.       <height>36</height>
  153.      </rect>
  154.     </property>
  155.     <property name="styleSheet">
  156.      <string notr="true">background-color:transparent;
  157. image: url(:/images/exit.png);</string>
  158.     </property>
  159.     <property name="text">
  160.      <string/>
  161.     </property>
  162.    </widget>
  163.   </widget>
  164.  </widget>
  165.  <resources/>
  166.  <connections/>
  167. </ui>

signup.ui

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <ui version="4.0">
  3.  <class>Signup</class>
  4.  <widget class="QWidget" name="Signup">
  5.   <property name="geometry">
  6.    <rect>
  7.     <x>0</x>
  8.     <y>0</y>
  9.     <width>790</width>
  10.     <height>520</height>
  11.    </rect>
  12.   </property>
  13.   <property name="windowTitle">
  14.    <string>Form</string>
  15.   </property>
  16.   <property name="styleSheet">
  17.    <string notr="true">background-color: rgb(255, 255, 255);</string>
  18.   </property>
  19.   <widget class="QLabel" name="label_image">
  20.    <property name="geometry">
  21.     <rect>
  22.      <x>15</x>
  23.      <y>15</y>
  24.      <width>380</width>
  25.      <height>490</height>
  26.     </rect>
  27.    </property>
  28.    <property name="text">
  29.     <string/>
  30.    </property>
  31.   </widget>
  32.   <widget class="QLabel" name="label_2">
  33.    <property name="geometry">
  34.     <rect>
  35.      <x>470</x>
  36.      <y>20</y>
  37.      <width>131</width>
  38.      <height>31</height>
  39.     </rect>
  40.    </property>
  41.    <property name="styleSheet">
  42.     <string notr="true">font: 87 20pt "Arial Black";</string>
  43.    </property>
  44.    <property name="text">
  45.     <string>你好!</string>
  46.    </property>
  47.   </widget>
  48.   <widget class="QLabel" name="label_3">
  49.    <property name="geometry">
  50.     <rect>
  51.      <x>470</x>
  52.      <y>60</y>
  53.      <width>261</width>
  54.      <height>41</height>
  55.     </rect>
  56.    </property>
  57.    <property name="styleSheet">
  58.     <string notr="true">font: 87 20pt "Arial Black";</string>
  59.    </property>
  60.    <property name="text">
  61.     <string>欢迎加入我们</string>
  62.    </property>
  63.   </widget>
  64.   <widget class="QLabel" name="label_4">
  65.    <property name="geometry">
  66.     <rect>
  67.      <x>470</x>
  68.      <y>140</y>
  69.      <width>131</width>
  70.      <height>16</height>
  71.     </rect>
  72.    </property>
  73.    <property name="styleSheet">
  74.     <string notr="true">font: 10pt "Arial";</string>
  75.    </property>
  76.    <property name="text">
  77.     <string>用户名:</string>
  78.    </property>
  79.   </widget>
  80.   <widget class="QLabel" name="label_5">
  81.    <property name="geometry">
  82.     <rect>
  83.      <x>470</x>
  84.      <y>200</y>
  85.      <width>131</width>
  86.      <height>16</height>
  87.     </rect>
  88.    </property>
  89.    <property name="styleSheet">
  90.     <string notr="true">font: 10pt "Arial";</string>
  91.    </property>
  92.    <property name="text">
  93.     <string>密码:</string>
  94.    </property>
  95.   </widget>
  96.   <widget class="QLabel" name="label_6">
  97.    <property name="geometry">
  98.     <rect>
  99.      <x>470</x>
  100.      <y>260</y>
  101.      <width>131</width>
  102.      <height>16</height>
  103.     </rect>
  104.    </property>
  105.    <property name="styleSheet">
  106.     <string notr="true">font: 10pt "Arial";</string>
  107.    </property>
  108.    <property name="text">
  109.     <string>再次输入密码:</string>
  110.    </property>
  111.   </widget>
  112.   <widget class="QLineEdit" name="lineEdit_username">
  113.    <property name="geometry">
  114.     <rect>
  115.      <x>470</x>
  116.      <y>160</y>
  117.      <width>200</width>
  118.      <height>30</height>
  119.     </rect>
  120.    </property>
  121.   </widget>
  122.   <widget class="QLineEdit" name="lineEdit_passwd">
  123.    <property name="geometry">
  124.     <rect>
  125.      <x>470</x>
  126.      <y>220</y>
  127.      <width>200</width>
  128.      <height>30</height>
  129.     </rect>
  130.    </property>
  131.   </widget>
  132.   <widget class="QLineEdit" name="lineEdit_surepasswd">
  133.    <property name="geometry">
  134.     <rect>
  135.      <x>470</x>
  136.      <y>290</y>
  137.      <width>200</width>
  138.      <height>30</height>
  139.     </rect>
  140.    </property>
  141.   </widget>
  142.   <widget class="QPushButton" name="btn_sure">
  143.    <property name="geometry">
  144.     <rect>
  145.      <x>470</x>
  146.      <y>350</y>
  147.      <width>111</width>
  148.      <height>24</height>
  149.     </rect>
  150.    </property>
  151.    <property name="styleSheet">
  152.     <string notr="true">background-color: rgb(29, 123, 255);
  153. color: rgb(255, 255, 255);
  154. font: 25 9pt "Bahnschrift Light";</string>
  155.    </property>
  156.    <property name="text">
  157.     <string>确定</string>
  158.    </property>
  159.   </widget>
  160.   <widget class="QPushButton" name="btn_return">
  161.    <property name="geometry">
  162.     <rect>
  163.      <x>470</x>
  164.      <y>400</y>
  165.      <width>111</width>
  166.      <height>24</height>
  167.     </rect>
  168.    </property>
  169.    <property name="styleSheet">
  170.     <string notr="true">background-color: rgb(29, 123, 255);
  171. color: rgb(255, 255, 255);
  172. font: 25 9pt "Bahnschrift Light";</string>
  173.    </property>
  174.    <property name="text">
  175.     <string>返回登录</string>
  176.    </property>
  177.   </widget>
  178.  </widget>
  179.  <resources/>
  180.  <connections/>
  181. </ui>

头文件

mainwindow.h
  1. #ifndef MAINWINDOW_H
  2. #define MAINWINDOW_H
  4. #include <QMainWindow>
  6. #include <QSqlDatabase>
  7. #include <QSqlQuery>
  8. #include <QMessageBox>
  9. #include <QDebug>
  11. void sqlite_Init();
  13. QT_BEGIN_NAMESPACE
  14. namespace Ui {
  15.      class MainWindow; }
  16. QT_END_NAMESPACE
  18. class MainWindow : public QMainWindow
  19. {
  21.     Q_OBJECT
  23. public:
  24.     MainWindow(QWidget *parent = nullptr);
  25.     ~MainWindow();
  27. private slots:
  28.     void on_btn_signin_clicked();
  30.     void on_btn_signup_clicked();
  32.     void on_btn_close_clicked();
  34. private:
  35.     Ui::MainWindow *ui;
  36. };
  37. #endif // MAINWINDOW_H

signup.h

  1. #ifndef SIGNUP_H
  2. #define SIGNUP_H
  4. #include <QWidget>
  6. namespace Ui {
  8. class Signup;
  9. }
  11. class Signup : public QWidget
  12. {
  14.     Q_OBJECT
  16. public:
  17.     explicit Signup(QWidget *parent = nullptr);
  18.     ~Signup();
  20. private slots:
  21.     void on_btn_return_clicked();
  23.     void on_btn_sure_clicked();
  25. private:
  26.     Ui::Signup *ui;
  27. };
  29. #endif // SIGNUP_H

项目文件 Login.pro

  1. QT       += core gui sql
  3. greaterThan(QT_MAJOR_VERSION, 4): QT += widgets
  5. CONFIG += c++17
  7. # You can make your code fail to compile if it uses deprecated APIs.
  8. # In order to do so, uncomment the following line.
  9. #DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000    # disables all the APIs deprecated before Qt 6.0.0
  11. SOURCES += \
  12.     main.cpp \
  13.     mainwindow.cpp \
  14.     signup.cpp
  16. HEADERS += \
  17.     mainwindow.h \
  18.     signup.h
  20. FORMS += \
  21.     mainwindow.ui \
  22.     signup.ui
  24. # Default rules for deployment.
  25. qnx: target.path = /tmp/$${TARGET}/bin
  26. else: unix:!android: target.path = /opt/$${TARGET}/bin
  27. !isEmpty(target.path): INSTALLS += target
  29. RESOURCES += \
  30.     images.qrc

图片资源

登录页面图
按钮
close按钮
注册页面图
women

发表评论

表情：
评论列表 （有 0 条评论，114人围观）

还没有评论，来说两句吧...

相关阅读

    相关 qt sqlite数据库操作

    \\\\\Qt 提供了与平台以及数据库种类无关的访问SQL数据库的接口， QSqlDatabase对象象征了数据库的关联。下面就qt 操作sqlite3数据库做总结。\\\\\

    青旅半醒青旅半醒/ 0 赞/ 434 阅读