1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
| #ifndef SYNCDATATODB_H
| #define SYNCDATATODB_H
|
| #include <WinSock2.h>
| #include <mysql.h>
| #include <string>
| #include "pmsqueryresult.h"
| #include <vector>
| #include "pmsplusparam.h"
| #include <QDebug>
|
| using namespace std;
|
| class SyncDataToDB{
| private:
| MYSQL mysql;
| MYSQL_RES * res;
| MYSQL_ROW row;
|
| void DBInit() {
| mysql_init(&mysql);
| mysql_real_connect(&mysql, "127.0.0.1", "root", "root", "mydb", 3306, NULL, 0);
| string sql1 = "set names gbk";
| mysql_real_query(&mysql, sql1.c_str(), sql1.size());
| }
|
| void DBClose() {
| mysql_free_result(res);
| mysql_close(&mysql);
| }
| public:
| SyncDataToDB() {
| DBInit();
| }
| ~SyncDataToDB() {
| DBClose();
| }
| // 从数据库查询所有员工的角色权限信息
| vector<PmsQueryResult> queryAllUserAboutUser();
|
| vector<PmsQueryResult> queryPmsByParam(PmsParam param);
|
| int updatePmsByParam(PmsPlusParma param);
|
| void setPmsResult(PmsQueryResult & res,char ** row);
| };
|
| #endif // SYNCDATATODB_H
|
|
