Advertisement
Guest User

Untitled

a guest
Nov 13th, 2017
414
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  db.open();
  2.  
  3.       QSqlQuery q;
  4.       ui->textBrowser_2->append(e.train_name+"_people " + QString::number(T.passangers.size()));
  5.       for(int i = 0; i< T.passangers.size();i++)//Add passengers
  6.       {
  7.           QString bot = "bot";
  8.           QString privilages = "No";
  9.           QString dataB = e.train_name+"_people";
  10. ui->textBrowser_2->append(QString::number(i+1)+" "+T.passangers[i].left_city+" "+T.passangers[i].arrival_city+" "+T.passangers[i].name+" "
  11. +T.passangers[i].surname+" "+QString::number(T.passangers[i].wagon)+" "+QString::number(T.passangers[i].place)+" "+QString::number(T.passangers[i].way_distance));
  12. q.exec("INSERT INTO " +dataB +"(depart_city,arrival_city,firstname,lastname,bot,vagon,place,privilages,distance,ticket_price)"
  13.           +"values('"+T.passangers[i].left_city+"','"+T.passangers[i].arrival_city+"','"+T.passangers[i].name+"','"
  14. +T.passangers[i].surname+"','"+bot+"','"+T.passangers[i].wagon+"','"+T.passangers[i].place+"','"+privilages+"','"+T.passangers[i].way_distance+"','"+T.passangers[i].ticket_cost+"')");
  15.       }
  16.        i++;
  17.        db.close();
  18.  
  19. //my table in db
  20. s += "_people";
  21.            if(query.exec("create table "+s+" "
  22.                                                  "(id integer primary key, "
  23.                                                  "depart_city varchar(30), "
  24.                                                  "arrival_city varchar(30), "
  25.                                                  "firstname varchar(30), "
  26.                                                  "lastname varchar(30), "
  27.                                                  "bot varchar(10),"
  28.                                                  "vagon integer,"
  29.                                                  "place integer,"
  30.                                                  "privileges varchar(5), "
  31.                                                  "distance integer, "
  32.                                                  "ticket_price integer)"))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement