mzyengopenc.c

将SQL数据库的内容按照记录存放到文件中

#include <stdio.h>
#include <string.h>
#include <malloc.h>
#include <stdlib.h>
#include <io.h>

main()
{
  FILE *fp1,*fp2;
  unsigned char *ch;
 
  char *filename; 
  
  int cht,i=1,fenhao=0; 
  
  filename=(char *)malloc(sizeof(char)*15);
  
  ch=(char *)malloc(sizeof(char)*10);
  if((fp1=fopen("g:\Edata.txt","r"))==NULL)	   
  printf("error");   
  strcpy(filename,"");
  strcpy(filename,"g:\eng");
  cht=fgetc(fp1);
  while(!feof(fp1))
  {
  	 
         
        itoa(i,ch,10);
  		strcat(filename,"\\");
		strcat(filename,ch);
  		strcat(filename,".txt");
		if((fp2=fopen(filename,"w"))==NULL)	  		
        printf("error2");
        i++; 
	  

       while(cht!='\n')
	   {
             
	      if(cht==34)
		  {    
			fenhao++;
			cht=fgetc(fp1);
          	if(cht==',')
            cht=fgetc(fp1);
		  }
		  else
		  {
			  fputc(cht,fp2);
		      cht=fgetc(fp1);	
		  }
		  if(fenhao%2==0)
              fputc('\n',fp2);
	    }
	     
     fclose(fp2);

	  
  }   
   free(ch);
   free(filename);
   fclose(fp1);
   
}