linux c查询数据库信息,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);

}