custom4.cpp
上传用户:dzyhzl
上传日期:2019-04-29
资源大小:56270k
文件大小:2k
- #include <iostream>
- #include <iomanip>
- #include <set>
- #include <sqlplus.hh>
- #include <custom.hh>
- sql_create_5(stock,
- 1, // This number is used to make a SSQLS less-than-comparable.
- // If this number is n then if the first n elements are the
- // same the two SSQLS are the same.
- // In this case if two two stock's "item" are the same then
- // the two stock are the same.
- 5, // this number should generally be the same as the number of
- // elements in the list unless you have a good reason not to.
- string,item, int,num, double,weight, double,price, Date,sdate)
- int main() {
- try { // its in one big try block
-
- Connection con(use_exceptions);
- con.connect("mysql_cpp_data");
- Query query = con.query();
- query << "select * from stock";
-
- set<stock> res;
- query.storein(res);
- // here we are storing the elements in a set not a vector.
- cout.setf (ios::left);
- cout << setw (17) << "Item"
- << setw (4) << "Num"
- << setw (7) << "Weight"
- << setw (7) << "Price"
- << "Date" << endl
- << endl;
- // Now we we iterate through the set. Since it is a set the list will
- // naturally be in order.
-
- set<stock>::iterator i;
- cout.precision(3);
- for (i = res.begin (); i != res.end (); i++) {
- cout << setw (17) << i->item.c_str ()
- << setw (4) << (int)(i->num)
- // VC++ gives an error when using cout << on a long long, so
- // it's cast to an int here
- << setw (7) << i->weight
- << setw (7) << i->price
- << i->sdate
- << endl;
- }
-
- i = res.find(stock("Hamburger Buns"));
- if (i != res.end())
- cout << "Hamburger Buns found. Currently " << (int)(i->num) << " in stock.n";
- // VC++ gives an error when using cout << on a long long, so
- // it's cast to an int here
- else
- cout << "Sorry no Hamburger Buns found in stockn";
- // Now we are using the set's find method to find out how many
- // Hamburger Buns are in stock.
- return 0;
- } catch (BadQuery er) {
- cerr << "Error: " << er.error << endl;
- return -1;
- } catch (BadConversion er) {
- cerr << "Error: Tried to convert "" << er.data << "" to a ""
- << er.type_name << ""." << endl;
- return -1;
- }
- }