锋线上的冲杀——论Linux数据库大比拚

void list_books(void) 
{ 
EXEC SQL BEGIN DECLARE SECTION; 
int article_no; 
char author_first_names[30]; 
char author_last_names[30]; 
char title[30]; 
char isbn[14]; 
int wholesale_price; 
int retail_price; 
int copies_available; 
EXEC SQL END DECLARE SECTION; 
EXEC SQL DECLARE book_cursor CURSOR FOR 
SELECT ARTICLE_NO, AUTHOR_FIRST_NAMES, AUTHOR_LAST_NAMES, 
TITLE, ISBN, WHOLESALE_PRICE, RETAIL_PRICE, 
COPIES_AVAILABLE FROM BOOK; 
EXEC SQL OPEN book_cursor; 
while (1) 
{ 
EXEC SQL FETCH NEXT FROM book_cursor 
INTO :article_no, :author_first_names, :author_last_names, 
:title, :isbn, :wholesale_price, :retail_price, 
:copies_available; 
if (sqlca.sqlcode == 100) /* 100 == NOT FOUND */ 
break; /* bail out */ 
printf("\nArticle no. %d\n", article_no); 
printf("%s, %s:\n", author_last_names, author_first_names); 
printf(" %s (%s)\n", title, isbn); 
printf("Bought at %d; selling at %d; %d copies available\n\n", 
wholesale_price, retail_price, copies_available); 
}; 
EXEC SQL CLOSE book_cursor; 
}