linux mysql存取图片_linux下opencv读取图片并存储到mysql数据库中

弄了好久的一段代码，ide用的eclipse，数据库连接不会的自己去找吧，网上蛮多的；功能虽然不是很强，但还是蛮有借鉴意义的。

#include

#include

#include

#include

#include

#include

#include

#include

using namespace std;

string IntToStr(int num)

{

stringstream ss;

ss.clear();

ss<

return ss.str();

}

int main()

{

//定义数据库连接信息

const char user[] = "root"; //username

const char pswd[] = "phancie"; //password

const char host[] = "localhost"; //or"127.0.0.1"

const char table[] = "phancie_vision"; //database

unsigned int port = 3306; //server port

MYSQL 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))

{

cout<

//设置编码格式,否则在cmd下无法显示中文

mysql_query(&myCont, "SET NAMES GBK");

int image_id = 1;

char filename[256];

//IplImage *image=0;

sprintf(filename , "/phancie/phv_images/imgs_orgsrc/imgs_natural/imgs_people/wuqilong/%d.jpg" , image_id );

IplImage* src = cvLoadImage(filename);

cout<

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();

cout<

int res = mysql_query(&myCont,sql_insert);

if(!res)

{

printf("插入成功,受影响行数:%lu\n",(ulong)mysql_affected_rows(&myCont));

}

else

{

cout<

}

image_id++;

sprintf(filename , "/phancie/phv_images/imgs_orgsrc/imgs_natural/imgs_people/wuqilong/%d.jpg" , image_id );

src= cvLoadImage(filename);

}

}

else

{

cout<

}

if(result!=NULL) mysql_free_result(result);//释放结果资源

mysql_close(&myCont);//断开连接

return 0;

}