网络编程-6

 

#include <myhead.h>
int main(int argc, const char *argv[])
{
	//1、定义一个数据库句柄指针
	sqlite3* ppDb = NULL;
	//2、创建或打开数据库
	if(sqlite3_open("./mydb.db",&ppDb)!=SQLITE_OK)
	{
		printf("sqlite3_open error:%s, errorcode=%d\n",\
				sqlite3_errmsg(ppDb),sqlite3_errcode(ppDb));
		return -1;
	}
	printf("数据库打开成功\n");

	//3、创建数据表
	//3、1准备sql造句
	char sql[128]="create table if not exists Stu(id int, name char,score double);";
	char *errmsg = NULL;

	if(sqlite3_exec(ppDb,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
	{
		printf("%s\n",errmsg);
		return -1;
	}
	while(1)
	{
		int ch=0;
		printf("1>添加学生信息\n");
		printf("2>删除学生信息\n");
		printf("3>修改学生信息\n");
		scanf("%d",&ch);
		while(getchar()!=10);
		switch(ch)
		{
		case 1:
			{
				int id;
				char name[10]="";
				double score;
				printf("请输入学号：");
				scanf("%d",&id);
				printf("请输入姓名：");
				scanf("%s",name);
				printf("请输入成绩：");
				scanf("%lf",&score);
				sprintf(sql,"insert into Stu values (%d,'%s',%lf);",id,name,score);
				//	printf("%s\n",sql);
				errmsg = NULL;
				if(sqlite3_exec(ppDb,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
				{
					printf("insert:%s\n",errmsg);
					return -1;
				}
				break;
			}
		case 2:
			{	
				char name[10]="";
				printf("删除学生姓名：");
				scanf("%s",name);
				sprintf(sql,"delete from Stu where name='%s';",name);
				errmsg = NULL;
				if(sqlite3_exec(ppDb,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
				{
					printf("insert:%s\n",errmsg);
					return -1;
				}
				break;
			}
		case 3:
			{
				int  id;
				char str[20]="";
				printf("要修改学生的学号：");
				scanf("%d",&id);
				printf("要修改的内容：");
				scanf("%s",str);
				sprintf(sql,"update Stu set %s where id=%d",str,id);
				errmsg = NULL;
				if(sqlite3_exec(ppDb,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
				{
					printf("insert:%s\n",errmsg);
					return -1;
				}
				break;
			}
		}

	}

	//关闭数据库
	sqlite3_close(ppDb);
	return 0;
}