开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 压缩解压 > 查看源码
DBROWSER.CPP
资源名称：huff_stream.zip　[点击查看]
上传用户：zdlsnail
上传日期：2007-01-06
资源大小：16k
文件大小：9k
源码类别：

压缩解压

开发平台：

Visual C++

DBROWSER.CPP：源码内容
  1. #define MAXCONNECT 10
  2. #define MAXBUFFER 100000 
  3. #define MAXCONNECTID 200
  4. #define MAXUSER 1000
  5. #include <string.h>        
  6. #include <stdio.h>
  7. #include <stdlib.h>
  8. #include <windows.h>    
  9. //#include <malloc.h>
  10. #include <ole2ver.h>
  11. #include <ole2.h>
  12. #include <httpext.h>
  13. #include <sqlext.h>
  15. //#include <odbcinst.h>
  16. #include "chcode.h"
  17. #include "sqlprog.h"
  18. #include "myole.h"
  19. DWORD dwBytesWritten;
  20.   
  21. //------------------------------------------
  22. short dog() {
  23. short i; 
  24. i=0;
  25.    _asm {
  26.          mov dx,037ah
  27.           mov ax,00ffh
  28.           out dx,ax
  29.           dec dx
  30.           dec dx
  31.           mov ax,0010h
  32.           out dx,ax
  33.           inc dx
  34.           in ax,dx 
  35.           test al,010h
  36.           jnz g150
  37.           dec dx
  38.           mov ax,0030h
  39.           out dx,ax
  40.           inc dx
  41.           in ax,dx
  42.           test al,010h
  43.           jnz g150
  44.           dec dx
  45.           mov ax,0070h
  46.           out dx,ax
  47.           inc dx
  48.           in ax,dx 
  49.           test al,010h
  50.           jz g150
  51.           inc dx
  52.           mov ax,0
  53.           out dx,ax
  54.           mov ax,1
  55.           mov i,ax   
  56.           jmp g160
  57.    g150:  
  58.           mov dx,027ah
  59.           mov ax,00ffh
  60.           out dx,ax
  61.           dec dx
  62.           dec dx
  63.           mov ax,0010h
  64.           out dx,ax
  65.           inc dx
  66.           in ax,dx 
  67.           test al,010h
  68.           jnz g155
  69.           dec dx
  70.           mov ax,0030h
  71.           out dx,ax
  72.           inc dx
  73.           in ax,dx
  74.           test al,010h
  75.           jnz g155
  76.           dec dx
  77.           mov ax,0070h
  78.           out dx,ax
  79.           inc dx
  80.           in ax,dx 
  81.           test al,010h
  82.           jz g155
  83.           inc dx
  84.           mov ax,0
  85.           out dx,ax
  86.           mov ax,1
  87.           mov i,ax   
  88.           jmp g160
  89.    g155:  mov ax,0
  90.           mov i,ax   
  91.    g160:  mov ax,1
  92.          }
  93.       return i;};
  94. //------------------------------
  95. void WriteHtml(EXTENSION_CONTROL_BLOCK *pECB,LPSTR lpsz)
  96.   {
  97. dwBytesWritten=lstrlen(lpsz);
  98. pECB->WriteClient(pECB->ConnID,(PVOID)lpsz,&dwBytesWritten,0);}
  99. //------------------------------
  100. BOOL WINAPI DllMain(HINSTANCE hinstDLL,DWORD dwreason,LPVOID lpv)
  101. {
  102.   return(TRUE);}
  103. //------------------------------
  104. BOOL WINAPI GetExtensionVersion(HSE_VERSION_INFO *version)
  105. {
  106.   short i;
  107.   RETCODE retcode;
  108.   version->dwExtensionVersion=MAKELONG(HSE_VERSION_MINOR,
  109. HSE_VERSION_MAJOR);
  110.   version->lpszExtensionDesc[0]='';
  111.   retcode=SQLAllocEnv(&henv);
  112.   if(retcode!=SQL_SUCCESS) return(FALSE);
  113.   for(i=0;i<MAXCONNECT;i++) {
  114.     connectStru[i].ID=0;
  115.     connectStru[i].usermark=0;
  116.     connectStru[i].hdbc=SQL_NULL_HDBC;}
  117.   return(TRUE);}
  118. //------------------------------
  119. DWORD WINAPI HttpExtensionProc(EXTENSION_CONTROL_BLOCK *pECB)
  120. {
  121. }
  123. abcd(unsigned char *requeststring)
  124.   {
  125.   short i,j,k,wwmark;
  126.   int connectID,funMark;
  127.   //unsigned char requeststring[20000];
  128.   EXTENSION_CONTROL_BLOCK *pECB;
  129.   unsigned char *ptr,*returnstring,*tmpstr;
  130.   long dwBytesRead;
  131.   UCHAR FAR userName[30],passWord[30],dwLib[30],dwName[30],
  132. tmpdw[30],dateString[16];
  133.   BOOL errorUpdate;
  134.   /*WriteHtml(pECB,
  135.     "HTTP/1.0, 200 OKrnContent-type: text/htmlrnrn");
  136.   if(stricmp(pECB->lpszMethod,"GET")==0)  
  137.    strcpy(requeststring,pECB->lpszQueryString);
  138.   else {
  139.     dwBytesRead=20000;
  140.     pECB->ReadClient(pECB->ConnID,(PVOID)requeststring,&dwBytesRead);}
  141.   k=10000;
  142.   while(TRUE) {
  143. i=0;
  144.     while(i<MAXCONNECT) {
  145.       if(connectStru[i].usermark==0) {
  146.     k=i;break;}
  147.       i++;}
  148.     if(k==10000) Sleep(1000);
  149. else returnstring=malloc(MAXBUFFER);
  150.     if(returnstring==NULL) {
  151.        WriteHtml(pECB,"ERROR002");return(HSE_STATUS_SUCCESS);}
  152. else break;}
  153. */
  154.   tmpstr=&requeststring[0];
  155.   connectID=0;
  156.   if(strlen(tmpstr)==0) {WriteHtml(pECB,"ERROR001");goto fail1;}
  157.   ptr=strchr(tmpstr,'=');
  158.   if(ptr==NULL) {WriteHtml(pECB,"ERROR001");goto fail1;}
  159.   *ptr='';ptr++;funMark=0;
  160.   if(stricmp(tmpstr,"sqlselect")==0) funMark=1;
  161.   if(stricmp(tmpstr,"sqlupdate")==0) funMark=2;
  162.   if(stricmp(tmpstr,"readwindow")==0) funMark=3;
  163.   if(stricmp(tmpstr,"readall")==0) funMark=4;
  164.   if(funMark==0) {WriteHtml(pECB,"ERROR001");goto fail1;}
  165.   tmpstr=ptr;
  166.   if((funMark==1)||(funMark==2)) {
  167.     for(j=k;i<MAXCONNECT;i++) {
  168.       if((connectStru[j].ID==connectID)&&
  169.   (connectStru[j].usermark==0)) {
  170.       k=j;break;}}
  171.     ptr=strchr(tmpstr,'t');
  172. if(ptr==NULL) {WriteHtml(pECB,"ERROR001");goto fail1;}
  173.     *ptr='';strcpy(userName,tmpstr);
  174. tmpstr=ptr+1;
  175.     ptr=strchr(tmpstr,'t');
  176.     if(ptr==NULL) {WriteHtml(pECB,"ERROR001");goto fail1;}
  177.     *ptr='';strcpy(passWord,tmpstr);
  178. tmpstr=ptr+1;ptr=strchr(tmpstr,'t');
  179. if(ptr==NULL) {WriteHtml(pECB,"ERROR001");goto fail1;}
  180.     *ptr='';connectID=atoi(tmpstr);
  181. tmpstr=ptr+1;ptr=strchr(tmpstr,'t');
  182.     if(ptr==NULL) {WriteHtml(pECB,"ERROR001");goto fail1;}
  183. *ptr='';strcpy(dwLib,tmpstr);
  184. tmpstr=ptr+1;ptr=strchr(tmpstr,'t');
  185. if(ptr==NULL) {WriteHtml(pECB,"ERROR001");goto fail1;}
  186.     *ptr='';strcpy(dwName,tmpstr);
  187. tmpstr=ptr+1;strcpy(connectStru[k].dwLib,dwLib);
  188.     strcpy(connectStru[k].dwName,dwName);
  189.     strcpy(connectStru[k].UID,userName);
  190.     strcpy(connectStru[k].PASSWORD,passWord);}
  191.   connectStru[k].returnstring=returnstring;
  192.   connectStru[k].pECB=pECB;
  193.   connectStru[k].usermark=1;
  194.   switch(funMark) {
  195.     case 1:
  196.       if(connectID!=connectStru[k].ID) {
  197.     if(makeConnect(k,connectID)==FALSE) {
  198.   strcpy(tmpstr,connectStru[k].DSN);
  199.   strcat(tmpstr,connectStru[k].UID);
  200.   strcat(tmpstr,connectStru[k].PASSWORD);
  201.   WriteHtml(pECB,tmpstr);
  202.   WriteHtml(pECB,"ERROR003");goto end1;}
  203.     else {
  204.   sqlSelectFun(k,tmpstr);
  205.   break;}}
  206.   else {sqlSelectFun(k,tmpstr);break;}
  207.     case 2:
  208.   ptr=strchr(tmpstr,'t');
  209.       if(ptr==NULL) {WriteHtml(pECB,"ERROR001");goto end1;}
  210.   *ptr='';
  211.   if(stricmp(tmpstr,"YES")==0) errorUpdate=TRUE;
  212.   else errorUpdate=FALSE;
  213.       connectStru[k].errorUpdate=errorUpdate;
  214.       tmpstr=ptr+1;
  215.       if(connectID!=connectStru[k].ID) {
  216.     if(makeConnect(k,connectID)==FALSE) {
  217.   WriteHtml(pECB,"ERROR003");goto end1;}
  218.     else {
  219.   sqlUpdateFun(k,tmpstr);break;}}
  220.   else {
  221. sqlUpdateFun(k,tmpstr);break;}
  222.     case 3:
  223.       ptr=strchr(tmpstr,'t');
  224.       if(ptr==NULL) {WriteHtml(pECB,"ERROR001");goto fail1;}
  225.       *ptr='';strcpy(userName,tmpstr);
  226.   tmpstr=ptr+1;
  227.       ptr=strchr(tmpstr,'t');
  228.       if(ptr==NULL) {WriteHtml(pECB,"ERROR001");goto fail1;}
  229.       *ptr='';strcpy(passWord,tmpstr);
  230.   tmpstr=ptr+1;ptr=strchr(tmpstr,'t');
  231.   if(ptr==NULL) {WriteHtml(pECB,"ERROR001");goto fail1;}
  232.       *ptr='';strcpy(dwName,tmpstr);
  233.       tmpstr=ptr+1;ptr=strchr(tmpstr,'t');
  234.   if(ptr==NULL) {WriteHtml(pECB,"ERROR001");goto fail1;}
  235.   *ptr='';strcpy(dateString,tmpstr);
  236.   if(UserPass(tmpdw,dwLib,userName,passWord)==FALSE) {
  237.         WriteHtml(pECB,"ERROR005");goto fail1;}
  238.   if(strlen(dwName)==0) {wwmark=0;strcpy(dwName,tmpdw);}
  239.   else wwmark=1;
  240.   readWinInfo(dwLib,dwName,dateString,wwmark,k);
  241.   break;
  242.     case 4:break;}
  243.   end1:
  244. connectStru[k].usermark=0;
  245.     free(connectStru[k].returnstring);
  246.     return(HSE_STATUS_SUCCESS);
  247.   fail1:
  248. free(returnstring);
  249. return(HSE_STATUS_SUCCESS);}
  250. //------------------------------------------
  251. main()
  252.   {
  253.      long i,ID;
  254.  long len;
  255.  size_t len1;
  256.  FILE *fp;
  257.  abcd("readwindow=dbatsqlt19970809121314t19970203121324t");
  258.      return(1);}
  259.  /*
  260.  i=MAX_CODE;
  261.  ID=TABLE_BANKS;
  262.  strcpy(connectStru[0].DSN,"foxtest");
  263.  strcpy(connectStru[0].dataDir,"C:\DBROWSER\");
  264.  Http(
  265.  "sqlselect=dbatsqlt1treport.pblttestttselectt*tfromtgpinfo");
  266.   return(1);
  267.  Http(
  268.  "sqlupdate=dbatsqlt1treport.pblttesttYEStinserttintotgpinfo(ccode,gpname)tvalues(1234,'abcd');inserttintotgpinfo(ccode,gpname)tvalues(123534,'a4bcd');");
  269.   return(1);
  270.  for(i=0;i<MAXCONNECT;i++) {
  271.    connectStru[i].ID=0;
  272.    connectStru[i].usermark=0;
  273.    connectStru[i].henv=SQL_NULL_HENV;
  274.    connectStru[i].hdbc=SQL_NULL_HDBC;
  275.  }
  276.  strcpy(connectStru[1].DSN,"fox");
  277.      strcpy(connectStru[1].UID,"DBA");
  278.      strcpy(connectStru[1].PASSWORD,"SQL");
  279.  strcpy(connectStru[1].dataDir,"C:\DBROWSER\");
  280.  connectStru[1].returnstring=malloc(1000000);
  281.  if(connectStru[1].returnstring!=NULL) {
  282.  ID=1;
  283.  len=lstrlen(connectStru[1].returnstring);
  284. // len=compress_code(connectStru[1].returnstring,len);
  285. // len=uncode_expand(connectStru[1].returnstring,len);
  286.  fp=fopen("c:\dbrowser\test.txt","w");
  287.  len1=fwrite(connectStru[1].returnstring,1l,len,fp);
  288.  fclose(fp);
  289.  free(connectStru[1].returnstring);
  290.  len=len;}
  291.      return 1; }
  292. */