登录密码比对的两种方法

登录密码比对的两种方法

        //方法一
        QString sqlstr = QString("select count(*) from adminusr where user = 'admin' and pw='%1'").arg(ui->txPassword->text());
        qDebug()<<sqlstr;
        psqlquery.exec(sqlstr);
       while (psqlquery.next()) {
            if(psqlquery.value(0).toInt() == 1)

            {

                qDebug()<<"zhaodaole ";

            }
        }
//方法二
       QString sqlstr = QString("select pw from adminusr where user = 'admin'");
       qDebug()<<sqlstr;
       psqlquery.exec(sqlstr);
       while (psqlquery.next()) {
       qDebug()<<psqlquery.value(0).toString();
           if(psqlquery.value(0).toString() == ui->txPassword->text())
           {
               qDebug()<<"zhaodaole ";
           }
      }