Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- QSqlDatabase db = QSqlDatabase::database();
- if (!db.open()){
- QMaemo5InformationBox::information(this,"ERROR: Cannot open database in dlgAccount",QMaemo5InformationBox::NoTimeout);
- return;
- }
- QSqlQuery sql;
- // are we adding a new account?
- // if (account_id == 0){
- sql.prepare("insert into accounts (status,acc_name,uname,pw,service) values (?,?,?,?,?)");
- //sql.bindValue(":account_id",QVariant(QVariant::Int));
- sql.bindValue(0,QVariant("D"));
- sql.bindValue(1,QVariant(acc_name));
- sql.bindValue(2,QVariant(uname));
- sql.bindValue(3,QVariant(pw));
- sql.bindValue(4,QVariant(service));
- /*
- }
- // else updating existing account
- else {
- sql.prepare("update accounts set acc_name=:acc_name,uname=:uname,pw=:pw,service=:service where account_id=:account_id");
- sql.bindValue(":acc_name",acc_name);
- sql.bindValue(":uname",uname);
- sql.bindValue(":pw",pw);
- sql.bindValue(":service",service);
- sql.bindValue(":account_id",account_id);
- }
- */
- if (!sql.exec()){
- QMaemo5InformationBox::information(this,"error2: "+sql.lastError().text(),QMaemo5InformationBox::NoTimeout);
- db.close();
- return;
- }
- db.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement