c语言操作数据库

        #include <stdio.h>
	#include <stdlib.h>
	#include "sqlite3.h"
	
	char path[100] = "C:\\Users\\yincheng01\\Desktop\\1.db";
	
	void main()
	{
		sqlite3 *db = NULL;//数据库指针
		int ret = sqlite3_open(path, &db);//打开数据库
		if (ret!= SQLITE_OK)
		{
			printf("文件打开失败 ");
		}
		else
		{
			printf("文件打开成功 ");
	
			//char *sql = "insert into mytable(id, value) values(2, 'Jenny');";
			//char *sql = "insert into mytable(id, value) values(2, 'Jenny');";
	
			char *sql = "create table mytableX11(id integer primary key, value text);";
			char *sql1 = "insert into mytableX11(id, value) values(12, 'J1enny');";
			char *sql2 = "insert into mytableX11(id, value) values(22, 'J2enny');";
			//char *sql3 = "delete * from  mytableX1;";//清空
			char *sql3 = "delete  from  mytableX11 where id =12;";
		    ret = sqlite3_exec(db, sql, 0, 0, NULL);
			ret = sqlite3_exec(db, sql1, 0, 0, NULL);
			ret = sqlite3_exec(db, sql2, 0, 0, NULL);
			ret = sqlite3_exec(db, sql3, 0, 0, NULL);
			if (ret != SQLITE_OK)
			{
				printf("sql执行失败 ");
	
			}
	
			sqlite3_close(db);//关闭数据库
		}
		system("pause");
	}