深圳品牌策划公司排名,做抖音seo用哪些软件,地方门户网站资讯该怎么做,外贸营销网弄了好久的一段代码#xff0c;ide用的eclipse#xff0c;数据库连接不会的自己去找吧#xff0c;网上蛮多的#xff1b;功能虽然不是很强#xff0c;但还是蛮有借鉴意义的。 #include stdio.h
#include stdlib.h
#include string.h
#include ide用的eclipse数据库连接不会的自己去找吧网上蛮多的功能虽然不是很强但还是蛮有借鉴意义的。 #include stdio.h
#include stdlib.h
#include string.h
#include mysql.h
#include iostream#include string#include opencv/cv.h
#include opencv/highgui.h
using namespace std;string IntToStr(int num)
{stringstream ss;ss.clear();ssnum;return ss.str();
}int main()
{//定义数据库连接信息const char user[] root; //usernameconst char pswd[] phancie; //passwordconst char host[] localhost; //or127.0.0.1const char table[] phancie_vision; //databaseunsigned int port 3306; //server portMYSQL myCont;MYSQL_RES *result;//MYSQL_ROW sql_row;//MYSQL_FIELD *fd;//char column[32][32];mysql_init(myCont);if(mysql_real_connect(myCont,host,user,pswd,table,port,NULL,0)){coutconnect succeed!endl;//设置编码格式,否则在cmd下无法显示中文mysql_query(myCont, SET NAMES GBK);int image_id 1;char filename[256];//IplImage *image0;sprintf(filename , /phancie/phv_images/imgs_orgsrc/imgs_natural/imgs_people/wuqilong/%d.jpg , image_id );IplImage* src cvLoadImage(filename);cout\n开始存储图片信息 \n;while(src){int orgExists 1;int orgWidth src-width;int orgHeight src-height;int orgDepth src-depth;int orgWidthStep src-widthStep;int thumbExists 0;string path /phancie/phv_images/imgs_orgsrc/imgs_natural/imgs_people/wuqilong/IntToStr(image_id).jpg;const char* orgRelativaPath path.c_str();//定义数据库操作语句//将图片信息插入数据库中string orgsql insert into phvImages(orgExists,orgWidth,orgHeigth,orgDepth,orgRelativePath,orgWidthStep,thumbExists);orgsql values(IntToStr(orgExists),IntToStr(orgWidth),IntToStr(orgHeight),IntToStr(orgDepth),orgRelativaPath,IntToStr(orgWidthStep),IntToStr(thumbExists));//将std::string类型转换为const char*const char *sql_insert orgsql.c_str();coutsql_insertendl;int res mysql_query(myCont,sql_insert);if(!res){printf(插入成功,受影响行数:%lu\n,(ulong)mysql_affected_rows(myCont));}else{coutquery sql failed!endl;}image_id;sprintf(filename , /phancie/phv_images/imgs_orgsrc/imgs_natural/imgs_people/wuqilong/%d.jpg , image_id );src cvLoadImage(filename);}}else{coutconnect failed!endl;}if(result!NULL) mysql_free_result(result);//释放结果资源mysql_close(myCont);//断开连接return 0;}