2.cpp

数据库接口程序

#include<windows.h>
#include<sql.h>
#include<sqlext.h>
#include<string.h>
#include<stdio.h>
 SQLINTEGER sno[10],sname[10],sdept[10],sclass[10];
 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);
  //===================================================
    SQLExecDirect(hstmt,(unsigned char *)"create table s (a char(10) NOT NULL ,q char(20) NOT NULL,s char(2) NOT NULL,d int ,w  char(20),z char(20),PRIMARY KEY(a))",SQL_NTS);
    
  //====================================================
   	SQLFreeStmt(hstmt,SQL_DROP);
	SQLDisconnect(hdbc);
    SQLFreeConnect(hdbc);
    SQLFreeEnv(henv);
}