| | |
| | | {
|
| | | if (result != NULL)
|
| | | mysql_free_result(result);
|
| | |
|
| | | mysql_close(&myCont);
|
| | | }
|
| | |
|
| | |
| | | else
|
| | | {
|
| | | std::cout<<"mysql_real_connect failed"<<std::endl;
|
| | | std::cout<<"db_init(my_db mydb) end"<<std::endl;
|
| | | return false;
|
| | | }
|
| | | 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;
|
| | | else
|
| | | return false;
|
| | | }
|
| | |
|
| | | bool DBuntil::db_select(person* per)
|
| | |
| | | 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;
|
| | | mysql_query(&myCont, "SET NAMES utf8");//设置编码格式
|
| | |
|
| | | res = mysql_query(&myCont,sql);//查询
|
| | | if (!res)
|
| | | {
|
| | |
| | | {
|
| | | return true;
|
| | | }
|
| | | else
|
| | | {}
|
| | | }
|
| | | else
|
| | | {}
|
| | | return false;
|
| | | }
|
| | |
|
| | |
| | | {
|
| | | return true;
|
| | | }
|
| | | return false;
|
| | | else
|
| | | return false;
|
| | | } |