complic1.cpp
上传用户:dzyhzl
上传日期:2019-04-29
资源大小:56270k
文件大小:2k
- #include <windows.h>
- #include <iostream>
- #include <iomanip>
- #include <sqlplus.hh>
- int main() {
- try { // its in one big try block
- Connection con(use_exceptions);
- con.connect("mysql_cpp_data");
- // Here I broke making the connection into two calls.
- // The first one creates the Connection object with the
- // use exceptions option turned on and the second one
- // makes the connection
-
- Query query = con.query();
-
- query << "select * from stock";
- Result res = query.store();
-
- cout << "Query: " << query.preview() << endl;
- 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;
-
- cout.precision(3);
- for (i = res.begin(); i != res.end(); i++) {
- row = *i;
- cout << setw(17) << row["ITEM"] << "," << setw(4) << row[1]
- << setw(7) << (double) row[2]
- // This is converting the row to a double so that we
- // can set the precision of it.
- // ColData has the nice feature that it will convert to
- // any of the basic c++ types. if there is a problem
- // in the conversion it will throw an exception (which I
- // cache below). To test it try changing the 2 in row[2]
- // to row[0]
- << setw(7) << (double)row[3];
- Date date = row["SDATE"];
- // The ColData is implicitly converted to a date here.
- cout.setf(ios::right);
- cout.fill('0');
- cout << setw(2) << date.month << "-" << setw(2) << date.day << endl;
- cout.fill(' ');
- cout.unsetf(ios::right);
- }
- return 0;
- } catch (BadQuery er) { // handle any connection or
- // query errors that may come up
- cerr << "Error: " << er.error << endl;
- return -1;
- } catch (BadConversion er) { // handle bad conversions
- cerr << "Error: Tried to convert "" << er.data << "" to a ""
- << er.type_name << ""." << endl;
- return -1;
- }
- }