From 332d18eb6733a5400a2cfd3a3faa2e056bd2a02c Mon Sep 17 00:00:00 2001
From: pans <pans@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期三, 04 一月 2017 19:07:05 +0800
Subject: [PATCH]
---
RtspFace/demo/src/DBuntil.cpp | 30 +++++++++++++++++-------------
1 files changed, 17 insertions(+), 13 deletions(-)
diff --git a/RtspFace/demo/src/DBuntil.cpp b/RtspFace/demo/src/DBuntil.cpp
index 27a2c76..3fe23c9 100644
--- a/RtspFace/demo/src/DBuntil.cpp
+++ b/RtspFace/demo/src/DBuntil.cpp
@@ -8,7 +8,7 @@
MYSQL_RES *result;
MYSQL_ROW sql_row;
-DBuntil::DBuntil(){}
+DBuntil::DBuntil() {}
DBuntil::DBuntil(my_db mydb)
{
@@ -35,18 +35,21 @@
mysql_close(&myCont);
}
-*person DBuntil::db_rearch(int f_id)
+bool DBuntil::db_search(person* per)
{
- person p= {0,""};
- db_select(f_id,&p);
- //瀵圭粨鏋勪綋璧嬪��
- return &p;
+ std::cout<<"db_search start"<<std::endl;
+ if(db_select(per))
+ {
+
+ return true;
+ }
+ return false;
}
-bool DBuntil::db_select(int f_id,person* per)
+bool DBuntil::db_select(person* per)
{
-
- 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 " , f_id );
+ 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"); //璁剧疆缂栫爜鏍煎紡
res = mysql_query(&myCont,sql);//鏌ヨ
@@ -71,14 +74,14 @@
return true;
}
-bool DBuntil::db_add(int f_id,person *per)
+bool DBuntil::db_add(person *per)
{
//
sprintf( sql, "INSERT INTO user_info(NAME, img) VALUES('%s', NULL)" , per->name );
res = mysql_query(&myCont,sql);
if(!res)
{
- sprintf( sql, "INSERT INTO face_person(p_id, face_id) VALUES (LAST_INSERT_ID(), %d)" , f_id );
+ sprintf( sql, "INSERT INTO face_person(p_id, face_id) VALUES (LAST_INSERT_ID(), %d)" , per->f_id );
res = mysql_query(&myCont,sql);
if(!res)
{
@@ -88,9 +91,10 @@
return false;
}
-bool DBuntil::db_register(int f_id,person *per)
+bool DBuntil::db_register(person *per)
{
- if(db_add(f_id,per)){
+ if(db_add(per))
+ {
return true;
}
return false;
--
Gitblit v1.8.0