From 43af8d48ca0d2ec219a7641d5555fe4c2479b047 Mon Sep 17 00:00:00 2001
From: houxiao <houxiao@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期二, 10 一月 2017 09:32:54 +0800
Subject: [PATCH] commit for add new file
---
RtspFace/demo/src/db/DBuntil.cpp | 50 +++++++++++++++++++++++++++++++++++---------------
1 files changed, 35 insertions(+), 15 deletions(-)
diff --git a/RtspFace/demo/src/db/DBuntil.cpp b/RtspFace/demo/src/db/DBuntil.cpp
index 5eaeddc..27a2c76 100644
--- a/RtspFace/demo/src/db/DBuntil.cpp
+++ b/RtspFace/demo/src/db/DBuntil.cpp
@@ -8,18 +8,22 @@
MYSQL_RES *result;
MYSQL_ROW sql_row;
-DBuntil::() {}
+DBuntil::DBuntil(){}
DBuntil::DBuntil(my_db mydb)
{
- if(mysql_init(&myCont)!=NULL) {
+ if(mysql_init(&myCont)!=NULL)
+ {
std::cout<<"init succeed"<<std::endl;
- } else
+ }
+ 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) {
+ 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
+ }
+ else
std::cout<<"mysql_real_connect failed"<<std::endl;
}
@@ -31,47 +35,63 @@
mysql_close(&myCont);
}
-person DBuntil::db_rearch(int f_id)
+*person DBuntil::db_rearch(int f_id)
{
person p= {0,""};
db_select(f_id,&p);
//瀵圭粨鏋勪綋璧嬪��
- return p;
+ return &p;
}
-int DBuntil::db_select(int f_id,person* per)
+bool DBuntil::db_select(int f_id,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 );
mysql_query(&myCont, "SET NAMES utf8"); //璁剧疆缂栫爜鏍煎紡
res = mysql_query(&myCont,sql);//鏌ヨ
- if (!res) {
+ if (!res)
+ {
result = mysql_store_result(&myCont);
- if (result) {
- while (sql_row = mysql_fetch_row(result)) { //鑾峰彇鍏蜂綋鐨勬暟鎹�
+ if (result)
+ {
+ while (sql_row = mysql_fetch_row(result))
+ {
+ //鑾峰彇鍏蜂綋鐨勬暟鎹�
per->p_id = atoi( sql_row[0]);
per->name = sql_row[1];
}
}
- } else {
+ }
+ else
+ {
std::cout<<"query sql failed!"<<std::endl;
return false;
}
return true;
}
-int DBuntil::db_add(int f_id,person *per)
+bool DBuntil::db_add(int f_id,person *per)
{
//
sprintf( sql, "INSERT INTO user_info(NAME, img) VALUES('%s', NULL)" , per->name );
res = mysql_query(&myCont,sql);
- if(!res) {
+ if(!res)
+ {
sprintf( sql, "INSERT INTO face_person(p_id, face_id) VALUES (LAST_INSERT_ID(), %d)" , f_id );
res = mysql_query(&myCont,sql);
- if(!res) {
+ if(!res)
+ {
return true;
}
}
return false;
+}
+
+bool DBuntil::db_register(int f_id,person *per)
+{
+ if(db_add(f_id,per)){
+ return true;
+ }
+ return false;
}
\ No newline at end of file
--
Gitblit v1.8.0