From 2abba1eed779847b85ef44401f2ae410fba56cd8 Mon Sep 17 00:00:00 2001
From: pans <pans@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期三, 04 一月 2017 19:42:20 +0800
Subject: [PATCH]
---
RtspFace/demo/src/DBuntil.cpp | 16 ++++++++++++----
1 files changed, 12 insertions(+), 4 deletions(-)
diff --git a/RtspFace/demo/src/DBuntil.cpp b/RtspFace/demo/src/DBuntil.cpp
index 3fe23c9..027ace7 100644
--- a/RtspFace/demo/src/DBuntil.cpp
+++ b/RtspFace/demo/src/DBuntil.cpp
@@ -49,22 +49,30 @@
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 );
-
+ 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;
mysql_query(&myCont, "SET NAMES utf8"); //璁剧疆缂栫爜鏍煎紡
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
{
--
Gitblit v1.8.0