## QT学习(10)–QT中对数据库操作:insert语句、select语句如何传参
(1)对于insert语句
void Reg::saveDataBase(QString s1,QString s2)//将用户注册信息存入数据库
{
sql=new Qsqlite;
sql->initSql();
uniqueId++;
QSqlQuery query;
//query.exec(QObject::tr(“insert into user values(uniqueId,s1,s2)”));//若用这种方式,会显示该函数的形式参数未被引用,所以错误
query.exec(QObject::tr(“insert into user values(uniqueId,’%1’,’%2’)”).arg(s1,s2));//这种方式是正确的
// qDebug()<<uniqueId;
}
(2)对于select语句
bool Dialog::readDataBase(QString s1,QString s2)//从数据库中读取用户注册信息
{
sql=new Qsqlite;
sql->initSql();
QSqlQuery query;
if(query.exec(QObject::tr(“select username,password from user where username=’%1’ and password=’%2’”).arg(s1,s2)))
return 1;
else
return 0;
}