Qt Creator 模块学习 —— QSQLITE数据库中的简单的注册登录
注册
QSqlQuery sql;
QString s;
QString id = ui->lineEdit->text();
QString pd1 = ui->lineEdit_2->text();
QString pd2 = ui->lineEdit_3->text();
if(id==""||pd1==""||pd2==""){
QMessageBox::warning(this,"注册失败","输入内容不能为空");
}
if(id.length()!=2||pd1.length()<=3)
{ QMessageBox::critical(this,"注册情况","员工号为2位,密码不能小于3位!");
return;}
if(pd1!=pd2)
{
QMessageBox::critical(this,"提示","两次密码不同");return ;}
s=QString("insert into passwordtable(key, password) values('%1','%2')").arg(id).arg(pd1);
if(sql.exec(s))
{
QMessageBox::information(this,"注册情况","注册成功");
this->close();
}
else
QMessageBox::critical(this,"注册情况","注册失败");
登录
QSqlQuery query;
QString id = ui->lineEdit->text();
QString pd = ui->lineEdit_2->text();
QString str=QString("select * from passwordtable where key='%1' and password='%2'").arg(id).arg(pd);
query.exec(str);
if(id==""||pd=="")
{ QMessageBox::critical(this,"登录情况","请输入账号或密码");
return ;}
if(query.first())
{
QMessageBox::information(this,"登录情况","登录成功");
this->hide();
s.show();
}
else
QMessageBox::critical(this,"登录情况","密码不正确!");
后续会发一个学生管理系统或是店铺管理系统的小程序。