spline3 插入

来源：互联网发布：企业网络拓扑结构图编辑：程序博客网时间：2024/06/15 01:18
INSERT 操作

#include <stdio.h>#include <stdlib.h>#include <sqlite3.h>static int callback(void *NotUsed, int argc, char **argv, char **azColName){   int i;   for(i=0; i&lt;argc; i++){      printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");   }   printf("\n");   return 0;}int main(int argc, char* argv[]){   sqlite3 *db;   char *zErrMsg = 0;   int rc;   char *sql;   /* Open database */   rc = sqlite3_open("test.db", &db);   if( rc ){      fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));      exit(0);   }else{      fprintf(stderr, "Opened database successfully\n");   }   /* Create SQL statement */   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 );" \         "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)" \         "VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 );";   /* Execute SQL statement */   rc = sqlite3_exec(db, sql, callback, 0, &zErrMsg);   if( rc != SQLITE_OK ){      fprintf(stderr, "SQL error: %s\n", zErrMsg);      sqlite3_free(zErrMsg);   }else{      fprintf(stdout, "Records created successfully\n");   }   sqlite3_close(db);   return 0;}
0 0