写入数据至历史库

#include <QCoreApplication>
#include <QTextCodec>
#include <QMapIterator>
#include <QDebug>
#include <cmath>
#include <QVector>
#include "math.h"


#include "DBAccess.h"
#include "CSqlResultAlign.h"


//int ExecuteCommandWithoutCommit(char *cmd_string,vector<TErrorMsg> &err_vec);




bool insertValueIntoHisDB(QString sql_str)
{
    qDebug() << "sql is ->"<<sql_str;


    CDbAccess g_db_access;
    vector<TErrorMsg> g_err_vec;
    CSqlResultAlign g_sqlresult;


    char username[32] = "SYSDBA";
    char passwd[32] = "SYSDBA";
    char dbname[32] = "mdb";


    int ret_code =g_db_access.Login(username,passwd,dbname,LOGIN_DEFAULT_MODE,g_err_vec);


    if(ret_code == DB_FAIL)
    {
        qDebug()<<"***************** Login fail*******************";
        return false;
    }
    qDebug() << "******** Login SUCCESS ************";


    char sql_str_c[1024]={0};
    strcpy(sql_str_c,sql_str.toLocal8Bit());


    UserSpecTypeMap user_type_map;
    char *result_link = new char;
    char *data_link = new char;
    signed short *result_indicator = new signed short;


    TResultHead *result_head_ptr = new TResultHead;
    TFieldInfo *field_info_ptr = new TFieldInfo;
    qDebug() << "******** Login SUCCESS ************";
    qDebug() << "******** OK SUCCESS 1************";


    ret_code =g_db_access.ExecuteCommandWithCommit(sql_str_c,g_err_vec);
    //ret_code =g_db_access.GetQueryResult(sql_str_c,GET_ALL_RESULT,user_type_map,result_link,result_indicator,g_err_vec);
    qDebug() << "******** OK SUCCESS 2************";
    if(ret_code == DB_FAIL)
    {
        delete result_link;
      result_link =NULL;
        qDebug()<<"GetQueryResult error";
       return false;
  }


    return true;
}






int main(int argc, char *argv[])
{


    QCoreApplication a(argc,argv);


    QString sql_str;
    //sql_str ="select top 10 cur_002 from hisdb.hisdb.YC_RS_1441";
    sql_str ="update hisdb.hisdb.YC_RS_1441 set STA_003=9";
    //float a[1024]={0};
    //int dataNum=1;


        insertValueIntoHisDB(sql_str);




    return a.exec();
}