Advertisement
Guest User

Untitled

a guest
Jul 1st, 2011
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. QSqlDatabase db = QSqlDatabase::database();
  2. if (!db.open()){
  3. QMaemo5InformationBox::information(this,"ERROR: Cannot open database in dlgAccount",QMaemo5InformationBox::NoTimeout);
  4. return;
  5. }
  6. QSqlQuery sql;
  7. // are we adding a new account?
  8. // if (account_id == 0){
  9. sql.prepare("insert into accounts (status,acc_name,uname,pw,service) values (?,?,?,?,?)");
  10. //sql.bindValue(":account_id",QVariant(QVariant::Int));
  11. sql.bindValue(0,QVariant("D"));
  12. sql.bindValue(1,QVariant(acc_name));
  13. sql.bindValue(2,QVariant(uname));
  14. sql.bindValue(3,QVariant(pw));
  15. sql.bindValue(4,QVariant(service));
  16. /*
  17. }
  18. // else updating existing account
  19. else {
  20. sql.prepare("update accounts set acc_name=:acc_name,uname=:uname,pw=:pw,service=:service where account_id=:account_id");
  21. sql.bindValue(":acc_name",acc_name);
  22. sql.bindValue(":uname",uname);
  23. sql.bindValue(":pw",pw);
  24. sql.bindValue(":service",service);
  25. sql.bindValue(":account_id",account_id);
  26. }
  27. */
  28. if (!sql.exec()){
  29. QMaemo5InformationBox::information(this,"error2: "+sql.lastError().text(),QMaemo5InformationBox::NoTimeout);
  30. db.close();
  31. return;
  32. }
  33. db.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement