From 0bad0e6b94c566f63bb97661850899f679fd1d12 Mon Sep 17 00:00:00 2001
From: pans <pans@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期三, 04 一月 2017 16:06:48 +0800
Subject: [PATCH]
---
RtspFace/demo/src/db/DBuntil.cpp | 44 ++++++++++++++++++++++++++++++++------------
1 files changed, 32 insertions(+), 12 deletions(-)
diff --git a/RtspFace/demo/src/db/DBuntil.cpp b/RtspFace/demo/src/db/DBuntil.cpp
index 5eaeddc..8f9f108 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;
}
@@ -46,32 +50,48 @@
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