179 lines
5.6 KiB
C++
179 lines
5.6 KiB
C++
#import "C:\Program Files\Common Files\System\ado\msado15.dll"\
|
||
no_namespace rename("EOF","EndOfFile")
|
||
#include <vector>
|
||
#include <string>
|
||
#include <iostream>
|
||
#include <windows.h>
|
||
#include <iomanip>
|
||
#include <stdio.h>
|
||
|
||
using namespace std;
|
||
|
||
|
||
string g_db_hostName = "192.168.200.97"; /*全局变量 服务器ip或名称*/
|
||
string g_db_dBName = "purple"; /*全局变量 服务器ODBC数据源*/
|
||
string g_db_userName = "BJSH"; /*全局变量 服务器用户名*/
|
||
string g_db_password = "bjshadmin"; /*全局变量 服务器密码*/
|
||
|
||
/*调试数据*/
|
||
//string g_db_hostName = "localhost"; /*全局变量 服务器ip或名称*/
|
||
//string g_db_dBName = "yanshuaishuai"; /*全局变量 服务器ODBC数据源*/
|
||
//string g_db_userName = "yannsy"; /*全局变量 服务器用户名*/
|
||
//string g_db_password = "123456"; /*全局变量 服务器密码*/
|
||
|
||
string g_db_qurry_start = "200906"; /*全局变量 数据库查询_开始日期*/
|
||
string g_db_qurry_end = "201610"; /*全局变量 数据库查询_结束日期*/
|
||
string g_db_qurry_zone = "0"; /*全局变量 数据库查询_特定区域*/
|
||
string g_db_qurry_stu_num = "0"; /*全局变量 数据库查询_特定考号*/
|
||
bool g_db_qurry_all = true; /*全局变量 数据库查询_查询全部标记*/
|
||
|
||
_ConnectionPtr p_conn; /*全局变量 连接对象*/
|
||
_RecordsetPtr p_recordset; /*全局变量 记录集对象*/
|
||
_CommandPtr p_cmd; /*全局变量 操作集对象*/
|
||
string str_conn; /*全局变量 连接字符串设置*/
|
||
|
||
|
||
/**
|
||
程序功能： 根据string类的stu【存储学号】，搜索出所有此人的考试信息,并分别存储在不同的变量中
|
||
|
||
@变量 stuNum 学号
|
||
@变量 date<vector> 考试时间
|
||
@变量 subject<vector> 考试科目
|
||
@变量 stuNum<vector> 考号
|
||
@返回值 成功1 失败0
|
||
*/
|
||
int DbImg(string stuNum, vector<string>& dateVec, vector<string>& subjectVec, vector<string>& stuNum2)//搜寻图片
|
||
{
|
||
/*字符转换，方便使用*/
|
||
string userName(g_db_userName.c_str());
|
||
string password(g_db_password.c_str());
|
||
string hostName(g_db_hostName.c_str());
|
||
string dBName(g_db_dBName.c_str());
|
||
|
||
//构造查询语句 下句注释是sql语句，需要构造成这种类型
|
||
/*select KS_ZKZ, KSSJ, TJ_KC_DM from ZK.T_BYSQ_KS_KC WHERE KSSJ between '200907' and '201510' and KS_ZKZ = 010207203867*/
|
||
/*string sql = "select KS_ZKZ2, KSSJ, TJ_KC_DM from ZK.T_BYSQ_KS_KC WHERE KSSJ between '200907' and '201504' AND KS_ZKZ = ";*/
|
||
string sql = "select KS_ZKZ2, KSSJ, TJ_KC_DM from ZK.T_BYSQ_KS_KC WHERE KSSJ between ";
|
||
sql += g_db_qurry_start;
|
||
sql += " and ";
|
||
sql += g_db_qurry_end;
|
||
sql += "AND KS_ZKZ =";
|
||
sql += stuNum.c_str();
|
||
|
||
_bstr_t _vstr_sql(sql.c_str());/* 转换string为_variant_t */
|
||
::CoInitialize(NULL);//初始化com组件
|
||
|
||
/*创建、打开连接*/
|
||
try{
|
||
p_conn.CreateInstance("ADODB.Connection");//创建连接
|
||
p_recordset.CreateInstance("ADODB.Recordset");//创建结果集,也就是实例化
|
||
p_cmd.CreateInstance("ADODB.Command");
|
||
|
||
p_conn->CursorLocation = adUseClient; //存储过程同时返回记录集和返回值
|
||
p_conn->Open(_bstr_t(str_conn.c_str()), _bstr_t(userName.c_str()), _bstr_t(password.c_str()), adConnectUnspecified);
|
||
p_cmd.CreateInstance("ADODB.Command");
|
||
p_cmd->ActiveConnection = p_conn;
|
||
|
||
HRESULT hr = p_recordset->Open(_bstr_t(_vstr_sql),//执行sq语句，查询一个学生的所有考试信息
|
||
p_conn.GetInterfacePtr(),
|
||
adOpenStatic,
|
||
adLockOptimistic,
|
||
adCmdText);
|
||
|
||
//将结果集输出到三个vector变量中
|
||
if (p_recordset->RecordCount < 1)//结果集为空
|
||
{
|
||
return 1;//没有信息，直接跳过这个人
|
||
}
|
||
do{ //将结果集输出到三个vector变量中
|
||
dateVec.push_back((string)(_bstr_t)(p_recordset->Fields->GetItem(_variant_t("KSSJ"))->GetValue()));
|
||
subjectVec.push_back((string)(_bstr_t)(p_recordset->Fields->GetItem(_variant_t("TJ_KC_DM"))->GetValue()));
|
||
stuNum2.push_back((string)(_bstr_t)(p_recordset->Fields->GetItem(_variant_t("KS_ZKZ2"))->GetValue()));
|
||
p_recordset->MoveNext();
|
||
} while (!p_recordset->EndOfFile);
|
||
}
|
||
catch (_com_error e){ return 0; }
|
||
|
||
/*关闭查询*/
|
||
try { ::CoUninitialize(); }
|
||
catch (_com_error e){ /*cout << "qurry:" << e.ErrorInfo() << endl;*/ }
|
||
|
||
return 1;
|
||
}
|
||
|
||
|
||
|
||
/**
|
||
程序功能： 更新学生数据库信息,根据学生的鉴定结果，将结果输出到数据库中
|
||
|
||
@变量 stuNum：学号
|
||
@变量 subject：考试科目
|
||
@变量 flagCheat：作弊标记
|
||
@返回值 成功1失败0
|
||
*/
|
||
int DbUpdate(string stuNum, vector<string> dateVec,
|
||
vector<string> subjectVec, vector<string> stuNum2,
|
||
vector<string> flagVec)
|
||
{
|
||
/*字符转换，方便使用*/
|
||
string userName(g_db_userName.c_str());
|
||
string password(g_db_password.c_str());
|
||
string hostName(g_db_hostName.c_str());
|
||
string dBName(g_db_dBName.c_str());
|
||
|
||
/*更新字串设置*/
|
||
int count = subjectVec.size();
|
||
vector<string > sqlKC; //课程表：作弊第一字段
|
||
int ci = 0; //循环
|
||
|
||
string flagSQL = "0";//标记 机器审核结果表
|
||
for (ci = 0; ci < count; ++ci)
|
||
{
|
||
if (flagVec[ci] == "1")
|
||
flagSQL = "1";
|
||
|
||
/*作弊的*/
|
||
string sqlKC1 = "UPDATE ZK.T_BYSQ_KS_KC SET BJSH_JG_JQ =";//天津_课程_代码
|
||
sqlKC1 += flagVec[ci].c_str();
|
||
sqlKC1 += " WHERE KS_ZKZ2=";
|
||
sqlKC1 += stuNum2[ci].c_str();
|
||
sqlKC1 += " AND TJ_KC_DM=";
|
||
sqlKC1 += subjectVec[ci].c_str();
|
||
sqlKC1 += " AND KSSJ=";
|
||
sqlKC1 += dateVec[ci].c_str();
|
||
sqlKC1 += " AND KS_ZKZ=";
|
||
sqlKC1 += stuNum.c_str();
|
||
|
||
sqlKC.push_back(sqlKC1);
|
||
}
|
||
|
||
::CoInitialize(NULL);//初始化com组件
|
||
|
||
/*更新数据库表*/
|
||
try{
|
||
p_conn.CreateInstance("ADODB.Connection");//创建连接
|
||
p_recordset.CreateInstance("ADODB.Recordset");//创建结果集,也就是实例化
|
||
p_cmd.CreateInstance("ADODB.Command");
|
||
|
||
p_conn->CursorLocation = adUseClient; //存储过程同时返回记录集和返回值
|
||
p_conn->Open(_bstr_t(str_conn.c_str()), _bstr_t(userName.c_str()), _bstr_t(password.c_str()), adConnectUnspecified);
|
||
p_cmd->ActiveConnection = p_conn;
|
||
|
||
for (ci = 0; ci < count; ++ci)
|
||
{
|
||
p_recordset->Open(_bstr_t(sqlKC[ci].c_str()),//更新第二条
|
||
p_conn.GetInterfacePtr(),
|
||
adOpenStatic,
|
||
adLockOptimistic,
|
||
adCmdText);
|
||
}
|
||
}
|
||
catch (_com_error e){ return 0; }
|
||
|
||
/*关闭查询*/
|
||
try {
|
||
::CoUninitialize();
|
||
}
|
||
catch (_com_error e){ }
|
||
return 1;
|
||
} |