数据库连接

来源：互联网发布：falcon python 编辑：程序博客网时间：2024/06/10 08:04

/*testDB.h*/

#include <stdio.h>
#include <string.h>
#include <sybfront.h>
#include <sybdb.h>
#include <stdlib.h>

main()
{
DBPROCESS *dbproc;
LOGINREC *login;
RETCODE   result_code;
char *userid="";
char *userpwd="";

dbinit();
login = dblogin();
DBSETLUSER(login, "telstar");//用户名与密码
DBSETLPWD(login, "tel2000");
dbproc = dbopen(login,"TELSTAR");
if (dbproc==(DBPROCESS*)NULL)
{
  printf("Cannot connect to server!/n");
  exit(FAIL);
}
printf("Connect success!/n");
dbuse(dbproc,"staticdb");//数据库
dbcmd(dbproc, "select * from test");
dbsqlexec(dbproc);
while ((result_code = dbresults(dbproc)) != NO_MORE_RESULTS)
{
  if(result_code == SUCCEED)
  {
   dbbind(dbproc,1,NTBSTRINGBIND,(DBINT)10,(BYTE *)userid);//第一列
   dbbind(dbproc,2,NTBSTRINGBIND,(DBINT)10,(BYTE *)userpwd);//第二列
   while (dbnextrow(dbproc)!= NO_MORE_ROWS)
   {
    printf("%s:%s/n",userid,userpwd);
   }
  }

}
}

/*echo $SYBASE 查看SYBASE目录*/

/*cc testDB.c -I/usr/users/sybase12/OCS-12_0/include -L/usr/users/sybase12/OCS-12_0/lib -lsybdb */