数据库 8月16日

sqlite3数据库插入

int do_insert(sqlite3 *db)
{
    int id;
	char name[20] = "";
	float score;
	char sql[128] = "";
	char *errmsg = NULL;
	printf("请输入id>>> ");
	scanf("%d", &id);
	while(getchar() != 10);
	printf("请输入name>>> ");
	scanf("%s", name);
	while(getchar() != 10);
	printf("请输入score>>> ");
	scanf("%f", &score);
	while(getchar() != 10);	
	sprintf(sql, "insert into stu values (%d, \"%s\", %.2f)", id, name, score);	

	if (sqlite3_exec(db, sql, NULL, NULL, &errmsg) != SQLITE_OK)
	{
		fprintf(stderr, "sqlite3_insert: %s %d __%d__\n", \
				errmsg, sqlite3_errcode(db), __LINE__);
		return -1;
	}
	printf("insert to stu success\n");
	
	

	return 0;
}