sqlite3 解决并发读写冲突的问题

#include "stdafx.h"
#include "sqlite3.h"
#include <iostream>
#include <process.h>

//sqllite 相关变量
sqlite3 *sql_db;
char *sql_ErrMsg;
int sql_rc;
sqlite3_stmt *sql_statement;

//写入重试客克服锁库的问题
void sql_insert_proc(char insert_state[400])
{
    while (1)
    {
        if (SQLITE_OK != sqlite3_exec(sql_db, insert_state, 0, 0, &sql_ErrMsg))
        {
            if (strstr(sql_ErrMsg, "database is locked"))
            {
                printf("try again!
");
                continue;
            }
            else
            {
                printf("other error! 
");
                break;
            }
        }
        else
        {
            printf("ok insert !
");
            break;
        }
    }
}


int _tmain(int argc, _TCHAR* argv[])
{
    sql_rc = sqlite3_open("C:\SQLite\test.db", &sql_db);
    if (sql_rc){
        fprintf(stderr, "Can't open database: %s
", sqlite3_errmsg(sql_db));
        sqlite3_close(sql_db);
        return(1);
    }
    printf("hello world!
");
    getchar();
    int i;

    
    for (i = 0; i < 10000; i++)
    {
        int step_result = SQLITE_BUSY;
        char select_statement[400] = "";
        char selectname[25] = "";

        //读取重试克服锁库的问题
        //SQLITE_ERROR、SQLITE_BUSY、SQLITE_MISUSE、SQLITE_ROW、SQLITE_DONE
        while (step_result == SQLITE_BUSY)
        {
            memset(select_statement, 0, 400);
            memset(selectname, 0, 25);

            sprintf_s(select_statement, "select name from test order by id desc limit 1");

            sql_rc = sqlite3_prepare(sql_db, select_statement, -1, &sql_statement, NULL);

            if (sql_rc != SQLITE_OK)
            {
                fprintf(stderr, "prepare error return code = %d
", sql_rc);
            }

            step_result = sqlite3_step(sql_statement);

            while (step_result == SQLITE_ROW)
            {
                strcpy_s(selectname, (char *)sqlite3_column_text(sql_statement, 0));
                step_result = sqlite3_step(sql_statement);
            }

            sqlite3_finalize(sql_statement);
        }
        
        printf("index = %d : %s
", i, selectname);
    }
    
    /*
    for (i = 0; i < 10000; i++)
    {
        char insert_statement[400] = "";
        sprintf_s(insert_statement, "insert into test (name) values('proc1 hello %d')", i);
        printf("%s
", insert_statement);
        sql_insert_proc(insert_statement);
    }
    */
    

    sqlite3_close(sql_db);
    return 0;
}