sql/sqlite/sqlite3 向表中插入数据

来源：互联网发布：太阳黑子数据网站编辑：程序博客网时间：2024/05/17 09:34
#include <iostream>#include <string>#include <tchar.h>#include "sqlite3\\sqlite3.h"#pragma comment (lib, "sqlite3\\sqlite3.lib")static const char* data = "Callback function called";static int Callback(void *data, int argc, char **argv, char **pszColName){printf("%s: \n", (const char*)data);for(int i=0; i<argc; i++){printf("%s = %s\n", pszColName[i], argv[i] ? argv[i] : "NULL");}printf("\n");return 0;}int main(int argc, char* argv[]){sqlite3 *pDataBase = NULL;char *pErrMsg = 0;int   iResult = 0;char *pszSql = NULL;/* Open database */iResult = sqlite3_open("test.db", &pDataBase);if( iResult != SQLITE_OK ){printf( "Can't open database: %s\n", sqlite3_errmsg(pDataBase));exit(0);}else{printf( "Opened database successfully\n");}/* Create SQL statement */pszSql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) "  \"VALUES (1, 'Zhao', 32, 'BeiJing', 10000.00 ); " \"INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) "  \"VALUES (2, 'Qian', 25, 'ShangHai', 20000.00 ); "     \"INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)" \"VALUES (3, 'Sun', 23, 'GuangZhou', 20000.00 );" \"INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)" \"VALUES (4, 'Li', 25, 'WuHan', 9000.00 );";/* Execute SQL statement */iResult = sqlite3_exec(pDataBase, pszSql, Callback, 0, &pErrMsg);if( iResult != SQLITE_OK ){printf( "SQL error: %s\n", pErrMsg);sqlite3_free(pErrMsg);}else{printf( "Records created successfully\n");}sqlite3_close(pDataBase);return 0;}
0 0