数据库
#include "mainwindow.h"
#include "ui_mainwindow.h"
#include<QPushButton>
#include<QSqlQuery>
#include<QDebug>
#include<QSqlError>
MainWindow::MainWindow(QWidget *parent)
: QMainWindow(parent)
, ui(new Ui::MainWindow)
{
ui->setupUi(this);
QSqlQuery query;
if(!query.exec("create table if not exists student(id int,name text)")){
qDebug()<<query.lastError().text();
}
query.exec("insert into student values(0,'Jack')");
}
MainWindow::~MainWindow()
{
delete ui;
}
void MainWindow::on_insertBt_clicked()
{
QString sql=QString("insert into student values(%1,'%2')").arg(ui->idEdit->text()).arg(ui->nameEdit->text());
QSqlQuery query;
if(!query.exec(sql)){
qDebug()<<query.lastError().text();
}
}
登录界面
main.cpp
#include "widget.h"
#include<QSqlDatabase>
#include <QApplication>
#include<QDebug>
#include<QSqlError>
#include<QSqlQuery>
int main(int argc, char *argv[])
{
QApplication a(argc, argv);
QSqlDatabase db3=QSqlDatabase::addDatabase("QSQLITE");
db3.setDatabaseName("my3.db");
if(!db3.open()){
qDebug()<<db3.lastError().text();
}
QString sql="create table if not exists user(id integer primary key autoincrement,username varchar(256) unique,password varchar(256))";
QSqlQuery query;
if(!query.exec(sql)){
qDebug()<<query.lastError().text();
}
Widget w;
w.show();
return a.exec();
}
widget.cpp
#include "widget.h"
#include "ui_widget.h"
#include<QSqlDatabase>
#include<QDebug>
#include<QSqlError>
#include<QSqlQuery>
#include<QMessageBox>
#include<QSqlRecord>
Widget::Widget(QWidget *parent)
: QWidget(parent)
, ui(new Ui::Widget)
{
ui->setupUi(this);
}
Widget::~Widget()
{
delete ui;
}
void Widget::on_regEdit_clicked()
{
QString username=ui->nameEdit->text();
QString password=ui->passEdit->text();
QString sql=QString("insert into user(username,password)values('%1','%2')")
.arg(username).arg(password);
QSqlQuery query;
if(!query.exec(sql)){
qDebug()<<query.lastError().text();
QMessageBox::warning(this,"注册","注册失败");
return;
}else{
QMessageBox::warning(this,"注册","注册成功");
}
}
void Widget::on_loginEdit_clicked()
{
QString username=ui->nameEdit->text();
QString password=ui->passEdit->text();
QString sql=QString("select * from user where username='%1' and password='%2'").arg(username).arg(password);
QSqlQuery query;
if(!query.exec(sql)){
qDebug()<<query.lastError().text();
return;
}
if(!query.next()){
qDebug()<<"false";
}else{
qDebug()<<"true";
}
QSqlRecord record=query.record();
qDebug()<<record.value("username").toString();
qDebug()<<record.value("password").toString();
}