sqlite学习笔记9:C语言中使用sqlite之插入数据
2024-08-30 18:07:58
前面创建了一张表,如今给他插入一些数据。插入数据跟创建表差点儿相同,不过SQL语言不一样而已,完整代码例如以下:
#include <stdio.h>
#include <stdlib.h>
#include "sqlite/sqlite3.h" #define DB_NANE "sqlite/test.db" sqlite3 *db = NULL;
char* sql = NULL;
char *zErrMsg = NULL;
int ret = 0; typedef enum{
false,
true
} bool; /*
typedef int (*sqlite3_callback)(
void*, Data provided in the 4th argument of sqlite3_exec()
int, The number of columns in row
char**, An array of strings representing fields in the row
char** An array of strings representing column names
);
*/
static int callback(void *NotUsed, int argc, char **argv, char **azColName)
{
int i = 0;
for(i=0; i < argc; i++){
printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
}
printf("\n"); return 0;
} bool connectDB()
{
ret = sqlite3_open(DB_NANE, &db); if( ret != SQLITE_OK){
fprintf(stderr, "Error open database: %s\n", sqlite3_errmsg(db));
sqlite3_free(zErrMsg); return false;
} fprintf(stdout, "Successfully opened database\n");
return true;
} bool createTable()
{
/* Create SQL statement */
sql = "CREATE TABLE COMPANY(" \
"ID INT PRIMARY KEY NOT NULL," \
"NAME TEXT NOT NULL," \
"AGE INT NOT NULL," \
"ADDRESS CHAR(50)," \
"SALARY REAL );"; /* Execute SQL statement */
ret = sqlite3_exec(db, sql, callback, 0, &zErrMsg);
if( ret != SQLITE_OK ){
fprintf(stderr, "Error SQL: %s\n", zErrMsg);
sqlite3_free(zErrMsg); return false;
} fprintf(stdout, "Successfully table created\n"); return true;
}
/*加入了此函数*/
bool insertRecords()
{
/* 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 */
ret = sqlite3_exec(db, sql, callback, 0, &zErrMsg);
if( ret != SQLITE_OK ){
fprintf(stderr, "SQL error: %s\n", zErrMsg);
sqlite3_free(zErrMsg);
return false;
} fprintf(stdout, "successfully records created\n"); return true;
}
bool closeDB()
{
int ret = 0;
ret = sqlite3_close(db);
if ( ret == SQLITE_BUSY ){
return false;
} return true;
} int main(int argc, char* argv[])
{
connectDB();
/*createTable();*/
insertRecords();
closeDB(); return 0;
}
最新文章
- Atitit.cto 与技术总监的区别
- 《DSP using MATLAB》示例Example4.6
- razor GPU
- cdoj 24 8球胜负(eight) 水题
- Linux下php安装phpredis
- SSO(转)
- [Redux] React Todo List Example (Filtering Todos)
- Eclipse中的Debug
- Keras的安装与配置
- 跟我一起读postgresql源码(七)——Executor(查询执行模块之——数据定义语句的执行)
- P2068 统计和(树状数组模板)
- SqlServer中的临时表
- 关于我在17号“一个查询任意年份中任意月份的天数”程序编写中的代码&;第二种方法!
- MySQL学习笔记-数据库内存
- Servlet中forward和redirect的区别
- 网络中TCP、IP、MAC、UDP的头部格式信息
- Spark记录-Scala数据类型
- KMP 理解
- javaweb(三十三)——使用JDBC对数据库进行CRUD
- 51NOD 1038:X^A Mod P——题解