?? cgi_image.cc
字號(hào):
#include <mysqlcppapi/mysqlcppapi.h>#include <iostream>#define MY_DATABASE "telcent"#define MY_TABLE "fax"#define MY_HOST "localhost"#define MY_USER "root"#define MY_PASSWORD ""#define MY_FIELD "fax" // BLOB field#define MY_KEY "datet" // PRIMARY KEYint main (int argc, char *argv[]){ if (argc < 2) { std::cerr << "Usage : cgi_image primary_key_value" << std::endl << std::endl; return -1; } std::cout << "Content-type: image/jpeg" << std::endl; mysqlcppapi::Connection con; try { con.set_Host(MY_HOST); con.set_User(MY_USER); con.set_Password(MY_PASSWORD); con.set_Port(3306); con.set_Timeout(60); con.connect(); con.select_database(MY_DATABASE); mysqlcppapi::Query query = con.create_Query(); query << "SELECT " << MY_FIELD << " FROM " << MY_TABLE << " WHERE " << MY_KEY << " = " << argv[1]; mysqlcppapi::Result_Use res = query.use(); mysqlcppapi::Row row=res.fetch_row(); mysqlcppapi::Result_Use::type_vecLengths vecLengths = res.get_lengths(); std::cout << "Content-length: " << vecLengths[0] << std::endl << std::endl; const char* pchRawData = row[0].data(); std::cout.write(pchRawData, vecLengths[0]); return 0; } catch (mysqlcppapi::ex_BadQuery& er) { std::cerr << "Error: " << er.what() << " " << con.errnum() << std::endl; return -1; }}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -