使用C API获取SQLite语句的受影响行数

#include<sqlite3.h>
#include<stdio.h>

int main(int argc, char* argv[]) {
   sqlite3 *db;
   char *zErrMsg = 0;
   int rc;

   rc = sqlite3_open("test.db", &db);

   if (rc) {
      fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
      return(0);
   } else {
      fprintf(stderr, "Opened database successfully\n");
   }

   const char* sql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " 
      "VALUES (1, 'Paul', 32, 'California', 20000.00 );"
      "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " 
      "VALUES (2, 'Allen', 25, 'Texas', 15000.00 );"
      "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)"
      "VALUES (3, 'Teddy', 23, 'Norway', 20000.00 );";

   rc = sqlite3_exec(db, sql, 0, 0, &zErrMsg);
   
   if (rc != SQLITE_OK) {
      fprintf(stderr, "SQL error: %s\n", zErrMsg);
      sqlite3_free(zErrMsg);
   } else {
      fprintf(stdout, "Records created successfully\n");
   }

   int nRows = sqlite3_changes(db);
   printf("Number of rows affected: %d\n", nRows);

   sqlite3_close(db);
   return 0;
}