Linux 连接SQL Server库——sqlapi_trial

今天发现一个很好的开源库，下载地址 http://www.sqlapi.com/index.html

 

连接SQl Server 实例：

1、Connecting to database (and error handling)

#include <stdio.h> // for printf#include <SQLAPI.h> // main SQLAPI++ headerint main(int argc, char* argv[]){ SAConnection con; // create connection object try { // connect to database // in this example it is Oracle, // but can also be Sybase, Informix, DB2 // SQLServer, InterBase, SQLBase and ODBC con.Connect( "test", // database name "tester", // user name "tester", // password SA_Oracle_Client); printf("We are connected!/n"); // Disconnect is optional // autodisconnect will ocur in destructor if needed con.Disconnect(); printf("We are disconnected!/n"); } catch(SAException &x) { // SAConnection::Rollback() // can also throw an exception // (if a network error for example), // we will be ready try { // on error rollback changes con.Rollback(); } catch(SAException &) { } // print error message printf("%s/n", (const char*)x.ErrText()); } return 0;}

 

2、Executing a simple SQL command

#include <stdio.h> // for printf#include <SQLAPI.h> // main SQLAPI++ headerint main(int argc, char* argv[]){ SAConnection con; // connection object SACommand cmd; // create command object try { // connect to database (Oracle in our example) con.Connect("test", "tester", "tester", SA_Oracle_Client); // associate a command with connection // connection can also be specified in SACommand constructor cmd.setConnection(&con); // create table cmd.setCommandText( "Create table test_tbl(fid integer, fvarchar20 varchar(20), fblob blob)"); cmd.Execute(); // insert value cmd.setCommandText( "Insert into test_tbl(fid, fvarchar20) values (1, 'Some string (1)')"); cmd.Execute(); // commit changes on success con.Commit(); printf("Table created, row inserted!/n"); } catch(SAException &x) { // SAConnection::Rollback() // can also throw an exception // (if a network error for example), // we will be ready try { // on error rollback changes con.Rollback(); } catch(SAException &) { } // print error message printf("%s/n", (const char*)x.ErrText()); } return 0;}

 

3、Executing a select query (and fetching result set)

#include <stdio.h> // for printf#include <SQLAPI.h> // main SQLAPI++ headerint main(int argc, char* argv[]){ SAConnection con; // connection object SACommand cmd( &con, "Select fid, fvarchar20 from test_tbl"); // command object try { // connect to database (Oracle in our example) con.Connect("test", "tester", "tester", SA_Oracle_Client); // Select from our test table cmd.Execute(); // fetch results row by row and print results while(cmd.FetchNext()) { printf("Row fetched: fid = %ld, fvarchar20 = '%s'/n", cmd.Field("fid").asLong(), (const char*)cmd.Field("fvarchar20").asString()); } // commit changes on success con.Commit(); printf("Rows selected!/n"); } catch(SAException &x) { // SAConnection::Rollback() // can also throw an exception // (if a network error for example), // we will be ready try { // on error rollback changes con.Rollback(); } catch(SAException &) { } // print error message printf("%s/n", (const char*)x.ErrText()); } return 0;}