3.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 hstmt1,hstmt2;
  RETCODE retcode1,retcode2;

//=========分配句柄===========
  
  SQLAllocEnv(&henv);
  retcode1=SQLAllocConnect(henv,&hdbc);  
  SQLConnect(hdbc,(unsigned char *)"DeviceMan",SQL_NTS,(unsigned char *)"gml",SQL_NTS,(unsigned char *)"1",SQL_NTS);
  SQLAllocStmt(hdbc,&hstmt1);
  SQLAllocStmt(hdbc,&hstmt2);

//=======SQL语句的执行=========

  retcode2=SQLExecDirect(hstmt2,(unsigned char *)"create table teacher(tname char(10),tno char(20),tsex char(2),tdept char(20),tage int,PRIMARY KEY(tno))",SQL_NTS);  //建立新表“teacher”
  retcode1=SQLExecDirect(hstmt1,(unsigned char *)"Select  sno,sname  From student",SQL_NTS) ;//查询学生表中所有学生的学号和姓名
    
//==========结果显示============
  
  if(retcode2>=SQL_SUCCESS) {printf("1.建teacher表\n  结果：建表成功  \n\n");}  
  if(retcode1==SQL_SUCCESS)  
	{
	    printf("2.查询表student中所有学生的学号和姓名\n");
		printf("  学号    姓名\n") ;
		while(SQLFetch(hstmt1)==0)
     	{
		    SQLGetData(hstmt1,1,SQL_C_CHAR,&sno,10,&sno1);
	        SQLGetData(hstmt1,2,SQL_C_CHAR,&sname,10,&sname1);
		printf(" %s  %s\n",sno,sname);
	  }
		printf("  搜索结束.......\n");
  }
 

//==========释放句柄============

    SQLFreeStmt(hstmt1,SQL_DROP);
	SQLFreeStmt(hstmt2,SQL_DROP);
	SQLDisconnect(hdbc);
    SQLFreeConnect(hdbc);
    SQLFreeEnv(henv);
}