Linux c 查询Oracle数据库例子
/*
* File: main.c
* Author: oracle
*
* Created on October 11, 2012, 3:14 AM
*/
#include
#include
#include "sqlora.h"
/*
*
*/
int main(int argc, char** argv) {
sqlo_db_handle_t dbh;
int sd;
int sth;
const char *cstr = "xia/pass123@DBInstance";
const char **v;
if (SQLO_SUCCESS != sqlo_init(SQLO_OFF,1,100))
{
printf ("sql_init failed. Exiting\n");
exit(1);
}
if (SQLO_SUCCESS != sqlo_connect(&dbh, cstr)){
printf ("connect failed. Exiting\n");
exit(1);
}else
{
printf ("connect successfully. Exiting\n");
}
char *select_stmt="SELECT * FROM status";
if (0>(sd=sqlo_open(dbh, select_stmt, 0, NULL)))
{
printf("open table failed: %s\n", sqlo_geterror(dbh));
return 0;
}
else
{
printf("open table");
}
printf("\n");
while(0==sqlo_fetch(sd,1)){
v=sqlo_values(sd,NULL,1);
printf("Result is : %s %s %s %s %s %s\n",v[0],v[1],v[2],v[3],v[4],v[5]);
}
sqlo_finish(dbh);
return (EXIT_SUCCESS);
}