| | |
|---|
| | | #include <cstdio>
|
|---|
| | | #include <iostream>
|
|---|
| | |
|
|---|
| | |
|
|---|
| | | MYSQL myCont;
|
|---|
| | | MYSQL_RES *result;
|
|---|
| | | MYSQL_ROW sql_row;
|
|---|
| | |
|
|---|
| | | DBuntil::DBuntil() {}
|
|---|
| | |
|
|---|
| | | DBuntil::DBuntil(my_db mydb)
|
|---|
| | | DBuntil::DBuntil()
|
|---|
| | | {
|
|---|
| | | if(mysql_init(&myCont)!=NULL)
|
|---|
| | | {
|
|---|
| | | std::cout<<"init succeed"<<std::endl;
|
|---|
| | | }
|
|---|
| | | else
|
|---|
| | | std::cout<<"init failed"<<std::endl;
|
|---|
| | |
|
|---|
| | | if(mysql_real_connect(&myCont, mydb.host, mydb.user, mydb.pswd, mydb.db, mydb.port, NULL, 0) != NULL)
|
|---|
| | | {
|
|---|
| | | std::cout<<"mysql_real_connect succeed"<<std::endl;
|
|---|
| | | }
|
|---|
| | | else
|
|---|
| | | std::cout<<"mysql_real_connect failed"<<std::endl;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | DBuntil::~DBuntil()
|
|---|
| | |
|---|
| | | mysql_close(&myCont);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | bool DBuntil::db_init(my_db mydb)
|
|---|
| | | {
|
|---|
| | | std::cout<<"db_init(my_db mydb) start"<<std::endl;
|
|---|
| | |
|
|---|
| | | if(mysql_init(&myCont)!=NULL)
|
|---|
| | | {
|
|---|
| | | std::cout<<"init succeed"<<std::endl;
|
|---|
| | | }
|
|---|
| | | else
|
|---|
| | | std::cout<<"init failed"<<std::endl;
|
|---|
| | |
|
|---|
| | | if(mysql_real_connect(&myCont, mydb.host, mydb.user, mydb.pswd, mydb.db, mydb.port, NULL, 0) != NULL)
|
|---|
| | | {
|
|---|
| | | std::cout<<"mysql_real_connect succeed"<<std::endl;
|
|---|
| | | std::cout<<"db_init(my_db mydb) end"<<std::endl;
|
|---|
| | | return true;
|
|---|
| | | }
|
|---|
| | | else
|
|---|
| | | {
|
|---|
| | | std::cout<<"mysql_real_connect failed"<<std::endl;
|
|---|
| | | }
|
|---|
| | | std::cout<<"db_init(my_db mydb) end"<<std::endl;
|
|---|
| | | return false;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | bool DBuntil::db_search(person* per)
|
|---|
| | | {
|
|---|
| | | std::cout<<"db_search start"<<std::endl;
|
|---|
| | | //db_init()
|
|---|
| | | if(db_select(per))
|
|---|
| | | {
|
|---|
| | |
|
|---|
| | | return true;
|
|---|
| | | }
|
|---|
| | | return false;
|
|---|
| | |
|---|
| | | bool DBuntil::db_select(person* per)
|
|---|
| | | {
|
|---|
| | | std::cout<<"db_select start"<<std::endl;
|
|---|
| | | sprintf( sql, "select a.p_id,b.`name`,b.img from face_person a,user_info b where a.face_id = %d AND a.p_id = b.pid " ,per->f_id );
|
|---|
| | |
|
|---|
| | | mysql_query(&myCont, "SET NAMES utf8"); //设置编码格式
|
|---|
| | | sprintf( sql, "select a.p_id,b.name,b.img from face_person a,user_info b where a.face_id = %d AND a.p_id = b.pid " ,per->f_id );
|
|---|
| | | std::cout<<"==========start============"<<std::endl;
|
|---|
| | | std::cout<<"per->f_id="<<per->f_id<<std::endl;
|
|---|
| | | std::cout<<sql<<std::endl;
|
|---|
| | | std::cout<<"==========end=============="<<std::endl;
|
|---|
| | | if(!mysql_query(&myCont, "SET NAMES utf8"))//设置编码格式
|
|---|
| | | {
|
|---|
| | | std::cout<<"SET NAMES utf8"<<std::endl;
|
|---|
| | | }
|
|---|
| | | else
|
|---|
| | | std::cout<<"SET NAMES utf8 failed"<<std::endl;
|
|---|
| | | res = mysql_query(&myCont,sql);//查询
|
|---|
| | | if (!res)
|
|---|
| | | {
|
|---|
| | | result = mysql_store_result(&myCont);
|
|---|
| | | if (result)
|
|---|
| | | if (result != NULL)
|
|---|
| | | {
|
|---|
| | | while (sql_row = mysql_fetch_row(result))
|
|---|
| | | {
|
|---|
| | | //获取具体的数据
|
|---|
| | | per->p_id = atoi( sql_row[0]);
|
|---|
| | | per->name = sql_row[1];
|
|---|
| | |
|
|---|
| | | std::cout<<"per->p_id="<<per->p_id<<std::endl;
|
|---|
| | | std::cout<<"per->name="<<per->name<<std::endl;
|
|---|
| | | std::cout<<"per->f_id="<<per->f_id<<std::endl;
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | else
|
|---|
| | | std::cout<<"result is null?"<<std::endl;
|
|---|
| | | }
|
|---|
| | | else
|
|---|
| | | {
|
|---|
