/*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 */