From 3465c52e01909d9879c480019b945fd6d42ae6a4 Mon Sep 17 00:00:00 2001
From: fertao <fertao@163.com>
Date: 星期六, 02 八月 2025 10:04:49 +0800
Subject: [PATCH] mod vsCode
---
/dev/null | 0
Server/付林涛/code/vscode/tiankai/tiankai/MYSQLDB.h | 27 +++++++++++++
Server/付林涛/code/vscode/tiankai/tiankai/SaveFile.h | 9 +++-
Server/付林涛/code/vscode/tiankai/tiankai/tiankai.vcxproj.filters | 9 ++++
Server/付林涛/code/vscode/tiankai/ipch/TIANKAI-bfe2fe17/TIANKAI-4f0af82d.ipch | 0
Server/付林涛/code/vscode/tiankai/tiankai/tiankai.vcxproj | 1
Server/付林涛/code/vscode/tiankai/tiankai/SaveSQL.cpp | 22 +++++++++-
Server/付林涛/code/vscode/tiankai/tiankai/SaveSQL.h | 4 +
Server/付林涛/code/vscode/tiankai/.vs/tiankai/v14/.suo | 0
Server/付林涛/code/vscode/tiankai/tiankai.VC.db | 0
10 files changed, 66 insertions(+), 6 deletions(-)
diff --git "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/.vs/tiankai/v14/.suo" "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/.vs/tiankai/v14/.suo"
index b462618..9cf4dcd 100644
--- "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/.vs/tiankai/v14/.suo"
+++ "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/.vs/tiankai/v14/.suo"
Binary files differ
diff --git "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/ipch/TIANKAI-bfe2fe17/TIANKAI-4f0af82d.ipch" "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/ipch/TIANKAI-bfe2fe17/TIANKAI-4f0af82d.ipch"
new file mode 100644
index 0000000..59f880a
--- /dev/null
+++ "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/ipch/TIANKAI-bfe2fe17/TIANKAI-4f0af82d.ipch"
Binary files differ
diff --git "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai.VC.VC.opendb" "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai.VC.VC.opendb"
deleted file mode 100644
index 1f0bd9c..0000000
--- "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai.VC.VC.opendb"
+++ /dev/null
Binary files differ
diff --git "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai.VC.db" "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai.VC.db"
index f24a51b..82b2e46 100644
--- "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai.VC.db"
+++ "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai.VC.db"
Binary files differ
diff --git "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/MYSQLDB.h" "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/MYSQLDB.h"
new file mode 100644
index 0000000..cbeeddf
--- /dev/null
+++ "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/MYSQLDB.h"
@@ -0,0 +1,27 @@
+#pragma once
+#pragma once
+#include <iostream>
+#include <string>
+#include <vector>
+#include <WinSock2.h>//给数据库连接提供网络支持
+// #include "MYSQL/include/mysql.h"
+using namespace std;
+//ws2_32.lib
+#pragma comment(lib,"ws2_32.lib")//加载网络静态库
+#pragma comment(lib,"./MYSQL/lib/libmysql.lib")//加载mysql静态库
+
+class MYSQLDB
+{
+public:
+ MYSQLDB();
+ ~MYSQLDB();
+
+
+ int query(const string sql, vector<vector<string>>& result);//查询结果集
+ int insert_del_update(const string sql);//插入、删除、更新操作
+private:
+ bool init();//初始化数据库
+private:
+// MYSQL* m_mysql;//mysql的指针
+
+};
\ No newline at end of file
diff --git "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/SaveFile.h" "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/SaveFile.h"
index 9449571..f4c6b89 100644
--- "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/SaveFile.h"
+++ "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/SaveFile.h"
@@ -5,14 +5,19 @@
#include <iomanip>
#include <sstream>
#include "struct_data.h"
-#define BUF_MAX_SIZE (8 * 1024)
-#define FILE_PATH "./"
+#define BUF_MAX_SIZE (8 * 1024) // 固定包大小8k
+#define FILE_PATH "./" // 合代码最好修改
class SaveFile
{
public:
SaveFile();
~SaveFile();
+ /*
+ if(Head->type == UPLOAD_REQ) 就进来调用fileop()函数就可以了,其他函数不用调。
+ */
int fileop(char* str, int len);
+
+private:
int fileHead(char* str, int len);
int fileData(char* str, int len);
int fileFin(char* str, int len);
diff --git "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/SaveSQL.cpp" "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/SaveSQL.cpp"
index 70469ae..c2f1821 100644
--- "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/SaveSQL.cpp"
+++ "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/SaveSQL.cpp"
@@ -15,7 +15,18 @@
{
// 这个语句有sql注入问题，数据库不应该提供接口帮我们插入吗？
std::string sql = "select file_id from files where name=\'" + filename + "\'";
- int file_id = 0; // 调用数据库函数；
+ int file_id = -1;
+ vector<vector<string>> rets;
+ int ret = sqlDb.query(sql, rets);
+ if (ret != 0) {
+ return file_id;
+ }
+ if (!rets.empty() && !rets[0].empty()) {
+ string firstField = rets[0][0];
+ file_id = std::stoi(firstField);
+ cout << "First field of first row: " << firstField << endl;
+ }
+ // 调用数据库函数......
return file_id;
}
@@ -24,7 +35,10 @@
std::string sql = "INSERT INTO `files` (`name`, `current_version`) VALUES ('"
+ fileInfo.filename + "','"
+ fileInfo.current_ver + "')";
- return 0;
+
+ // 调用数据库函数......
+ int ret = sqlDb.insert_del_update(sql);
+ return ret;
}
int SaveSQL::create_InsVersions(SQLVersions versionInfo)
@@ -33,5 +47,7 @@
+ versionInfo.file_id + "','"
+ versionInfo.desc + "')";
- return 0;
+ // 调用数据库函数......
+ int ret = sqlDb.insert_del_update(sql);
+ return ret;
}
diff --git "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/SaveSQL.h" "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/SaveSQL.h"
index 6183854..834f8c4 100644
--- "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/SaveSQL.h"
+++ "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/SaveSQL.h"
@@ -1,6 +1,7 @@
#pragma once
#include <iostream>
#include "struct_data.h"
+#include "MYSQLDB.h"
class SaveSQL
{
public:
@@ -9,6 +10,7 @@
int get_file_ID(std::string filename);
int create_InsFiles(SQLFiles fileInfo);
int create_InsVersions(SQLVersions versionInfo);
-
+private:
+ MYSQLDB sqlDb;
};
diff --git "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/tiankai.vcxproj" "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/tiankai.vcxproj"
index 9a8e237..43895fa 100644
--- "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/tiankai.vcxproj"
+++ "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/tiankai.vcxproj"
@@ -145,6 +145,7 @@
<Text Include="ReadMe.txt" />
</ItemGroup>
<ItemGroup>
+ <ClInclude Include="MYSQLDB.h" />
<ClInclude Include="SaveFile.h" />
<ClInclude Include="SaveSQL.h" />
<ClInclude Include="stdafx.h" />
diff --git "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/tiankai.vcxproj.filters" "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/tiankai.vcxproj.filters"
index 3e10e9f..732be99 100644
--- "a/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/tiankai.vcxproj.filters"
+++ "b/Server/\344\273\230\346\236\227\346\266\233/code/vscode/tiankai/tiankai/tiankai.vcxproj.filters"
@@ -30,6 +30,12 @@
<ClInclude Include="SaveFile.h">
<Filter>澶存枃浠�</Filter>
</ClInclude>
+ <ClInclude Include="SaveSQL.h">
+ <Filter>澶存枃浠�</Filter>
+ </ClInclude>
+ <ClInclude Include="MYSQLDB.h">
+ <Filter>澶存枃浠�</Filter>
+ </ClInclude>
</ItemGroup>
<ItemGroup>
<ClCompile Include="stdafx.cpp">
@@ -41,5 +47,8 @@
<ClCompile Include="SaveFile.cpp">
<Filter>婧愭枃浠�</Filter>
</ClCompile>
+ <ClCompile Include="SaveSQL.cpp">
+ <Filter>婧愭枃浠�</Filter>
+ </ClCompile>
</ItemGroup>
</Project>
\ No newline at end of file
--
Gitblit v1.8.0