Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- db.open();
- QSqlQuery q;
- ui->textBrowser_2->append(e.train_name+"_people " + QString::number(T.passangers.size()));
- for(int i = 0; i< T.passangers.size();i++)//Add passengers
- {
- QString bot = "bot";
- QString privilages = "No";
- QString dataB = e.train_name+"_people";
- ui->textBrowser_2->append(QString::number(i+1)+" "+T.passangers[i].left_city+" "+T.passangers[i].arrival_city+" "+T.passangers[i].name+" "
- +T.passangers[i].surname+" "+QString::number(T.passangers[i].wagon)+" "+QString::number(T.passangers[i].place)+" "+QString::number(T.passangers[i].way_distance));
- q.exec("INSERT INTO " +dataB +"(depart_city,arrival_city,firstname,lastname,bot,vagon,place,privilages,distance,ticket_price)"
- +"values('"+T.passangers[i].left_city+"','"+T.passangers[i].arrival_city+"','"+T.passangers[i].name+"','"
- +T.passangers[i].surname+"','"+bot+"','"+T.passangers[i].wagon+"','"+T.passangers[i].place+"','"+privilages+"','"+T.passangers[i].way_distance+"','"+T.passangers[i].ticket_cost+"')");
- }
- i++;
- db.close();
- //my table in db
- s += "_people";
- if(query.exec("create table "+s+" "
- "(id integer primary key, "
- "depart_city varchar(30), "
- "arrival_city varchar(30), "
- "firstname varchar(30), "
- "lastname varchar(30), "
- "bot varchar(10),"
- "vagon integer,"
- "place integer,"
- "privileges varchar(5), "
- "distance integer, "
- "ticket_price integer)"))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement