1.cpp

数据库接口程序

#include<windows.h>
#include<sql.h>
#include<sqlext.h>
#include<string.h>
#include<stdio.h>
SQLINTEGER sno[10],sno1,sname[10],sname1;
void main()
{
  //=================================================
  HENV henv;
  HDBC hdbc;
  HSTMT hstmt;
  RETCODE retcode1;
 

  //===================================================
  SQLAllocEnv(&henv);
  retcode1=SQLAllocConnect(henv,&hdbc);  
  SQLConnect(hdbc,(unsigned char *)"student",SQL_NTS,(unsigned char *)"SYSTEM",SQL_NTS,(unsigned char *)"1",SQL_NTS);
  SQLAllocStmt(hdbc,&hstmt);
  //===================================================
  retcode1=SQLExecDirect(hstmt,(unsigned char *)"Select  sno,sname  From student",SQL_NTS) ;
    if(retcode1==SQL_SUCCESS)  
	{
		printf(" 学号    姓名\n") ;
		while(SQLFetch(hstmt)==0)
     	{
		    SQLGetData(hstmt,1,SQL_C_CHAR,&sno,10,&sno1);
	        SQLGetData(hstmt,2,SQL_C_CHAR,&sname,10,&sname1);
		printf("%s  %s\n",sno,sname);
	  }
		printf("  搜索结束.......\n");
  }
  //====================================================
   	SQLFreeStmt(hstmt,SQL_DROP);
	SQLDisconnect(hdbc);
    SQLFreeConnect(hdbc);
    SQLFreeEnv(henv);
}