Firebird C API 간단 사용기

C API를 이용한 Firebird embedded 를 간단하게 사용하는 예이다. 질의문의 결과난 파라메터를 이용한 방법은 XSQLDA(eXtended SQL Descriptor Area)를 이해한 후에 정리를 해야 할 것 같다.

ClearResult(); AppendResult( _T("Try to attach database!!") ); isc_db_handle db = 0L; /* database handle */ isc_tr_handle trans = NULL; /* transaction handle */ isc_stmt_handle stmt = NULL; /* statement handle */ char szDBName[ MAX_PATH ] = "E:\\TEST.FDB"; ISC_STATUS_ARRAY status; ISC_LONG sqlcode; // Database Parameter Block (DPB) 준비 std::string strDPB; strDPB.append( 1, isc_dpb_version1 ); // DPB 버전 strDPB.append( 1, isc_dpb_user_name ); // User Account strDPB.append( 1, (char)strlen("sysdba") ); strDPB.append( "sysdba" ); strDPB.append( 1, isc_dpb_password ); // Password strDPB.append( 1, (char)strlen("masterkey") ); strDPB.append( "masterkey" ); // Database connect if ( isc_attach_database( status, 0, szDBName, &db, (short)strDPB.length(), strDPB.c_str() ) ) { AppendResult( _T("Fail to attach database!!") ); return; } // Start Transaction isc_start_transaction( status, &trans, 1, &db, 0, NULL ); // Execute query char szQuery[1024]; // Create Table sprintf_s( szQuery, 1024, "CREATE TABLE employee (" " name VARCHAR(20) " ", birth INTEGER" ", enter TIMESTAMP" ")"); isc_dsql_execute_immediate( status, &db, &trans, strlen(szQuery), szQuery, 1, NULL ); isc_commit_transaction( status, &trans ); if ( status[0] == 1 && status[ 1 ] > 0 ) { // Error occurred sqlcode = isc_sqlcode( status ); char szMsg[512]; isc_sql_interprete( (short)sqlcode, szMsg, 512 ); CString strMsg; strMsg.Format( _T("Fail to Create Table : %d - %s"), sqlcode, CString( szMsg ) ); AppendResult( strMsg ); } else { AppendResult( _T("Table Creaded.") ); } // Insert Data isc_start_transaction( status, &trans, 1, &db, 0, NULL ); AppendResult( _T("Insertion!!") ); for ( int i = 0; i < 5; ++i ) { sprintf_s( szQuery, 1024, "INSERT INTO employee ( name, birth, enter ) VALUES ( 'name%d', %d, CURRENT_TIMESTAMP )" , i, 20 + i ); isc_dsql_execute_immediate( status, &db, &trans, strlen(szQuery), szQuery, 1, NULL ); if ( status[0] == 1 && status[ 1 ] > 0 ) { // Error occurred sqlcode = isc_sqlcode( status ); char szMsg[512]; isc_sql_interprete( (short)sqlcode, szMsg, 512 ); CString strMsg; strMsg.Format( _T("Fail to Insert : %d - %s"), sqlcode, CString( szMsg ) ); AppendResult( strMsg ); } else { AppendResult( _T("1 Row Inserted.") ); } } // Update Data // Statement allocation isc_dsql_allocate_statement( status, &db, &stmt ); AppendResult( _T("Update!!") ); sprintf_s( szQuery, 1024, "UPDATE employee SET birth = birth + 2 WHERE birth > 22"); isc_dsql_prepare( status, &trans, &stmt, 0, szQuery, 0, NULL ); isc_dsql_execute( status, &trans, &stmt, 0, NULL ); isc_commit_transaction( status, &trans ); if ( status[ 0 ] == 1 && status[ 1 ] > 0 ) { // Error occurred sqlcode = isc_sqlcode( status ); char szMsg[512]; isc_sql_interprete( (short)sqlcode, szMsg, 512 ); CString strMsg; strMsg.Format( _T("Fail to Update : %d - %s"), sqlcode, CString( szMsg ) ); AppendResult( strMsg ); } else { AppendResult( _T("Table Updated") ); } isc_dsql_free_statement( status, &stmt, DSQL_close ); // Delete Table AppendResult( _T("Drop Table!!") ); sprintf_s( szQuery, 1024, "DROP TABLE employee"); isc_dsql_execute_immediate( status, &db, &trans, strlen(szQuery), szQuery, 1, NULL ); // Commit Transaction isc_commit_transaction( status, &trans ); // Database disconnect isc_detach_database( status, &db ); AppendResult( _T("Database detached!!") ); AppendResult( _T("Finished!!") );