util.cpp
上传用户:dzyhzl
上传日期:2019-04-29
资源大小:56270k
文件大小:1k
- #include <iostream>
- #include <iomanip>
- #include "util.hh"
- void print_stock_table(Query& query) {
- query.reset();
- query << "select * from stock";
- // You can write to the query object like you would any other ostrem
- Result res = query.store();
- // Query::store() executes the query and returns the results
- cout << "Query: " << query.preview() << endl;
- // Query::preview() simply returns a string with the current query
- // string in it.
- cout << "Records Found: " << res.size() << endl << endl;
-
- Row row;
- cout.setf(ios::left);
- cout << setw(17) << "Item"
- << setw(4) << "Num"
- << setw(7) << "Weight"
- << setw(7) << "Price"
- << "Date" << endl
- << endl;
-
- Result::iterator i;
- // The Result class has a read-only Random Access Iterator
- for (i = res.begin(); i != res.end(); i++) {
- row = *i;
- cout << setw(17) << row[0]
- << setw(4) << row[1]
- << setw(7) << row["weight"]
- // you can use either the index number or column name when
- // retrieving the colume data as demonstrated above.
- << setw(7) << row[3]
- << row[4] << endl;
- }
- }