C程序在SQLite数据库中创建表并插入数据 (C programs to create table & insert data in SQLite database)
Here, will create a "SCHOOL.db" database, create a table "STUDENT" and insert data using c program.
在这里,将创建一个“ SCHOOL.db”数据库,创建一个表“ STUDENT”并使用c程序插入数据。
#include <sqlite3.h>
#include <stdio.h>
int main(void)
{
sqlite3 * dbPtr;
char *errMsg = 0;
int rec = sqlite3_open("SCHOOL.db", & dbPtr);
if (rec != SQLITE_OK)
{
printf("Database cannot Opened: %s\n", sqlite3_errmsg(dbPtr));
sqlite3_close(dbPtr);
return 1;
}
char *sql = "DROP TABLE IF EXISTS STUDENT;"
"CREATE TABLE STUDENT(rollNum INT, Name TEXT, Section varchar );"
"INSERT INTO STUDENTS VALUES(1, 'Arvind', 'A');"
"INSERT INTO STUDENT VALUES(2, 'Amit', 'C');"
"INSERT INTO STUDENT VALUES(3, 'Shivang', 'A');"
"INSERT INTO STUDENT VALUES(4, 'RAGHU', 'A');"
"INSERT INTO STUDENT VALUES(5, 'SACHIN', 'C');"
"INSERT INTO STUDENT VALUES(6, 'HITEN', 'B');";
rec = sqlite3_exec