Merlin's Blog
Just record something
Toggle navigation
Merlin's Blog
Home
Scratch基础教程
About Me
Archives
Tags
用sqlite3_prepare_v2使用INSERT
sqlite3
sqlite3_prepare_v2
2017-01-18 13:17:50
129
0
0
merlin
sqlite3
sqlite3_prepare_v2
``` if(m_textCtrl1->GetValue().IsEmpty()){ wxMessageBox(_("请输入章节名称后再添加"),_("友情提示")); return; } char sql[256]={}; std::string cp = m_textCtrl1->GetValue().ToStdString(); sprintf(sql,"INSERT INTO chapters (chapter) VALUES('%s');",cp.c_str()); sqlite3 *db; sqlite3_stmt* stmt = NULL; const char* zTail; int r = sqlite3_open("exam.db", &db); if (sqlite3_prepare_v2(db, sql, -1, &stmt, &zTail) == SQLITE_OK){ if(sqlite3_step(stmt)== SQLITE_DONE) wxMessageBox(_("章节添加成功!"), _("友情提示")); else wxMessageBox(_("章节添加失败!"), _("友情提示")); }else wxMessageBox(_("章节添加失败!"), _("友情提示")); sqlite3_finalize(stmt); sqlite3_close(db); ``` 使用sqlite3_prepare_v2的时候，真正执行sql的语句是sqlite3_step，没有返回值的操作，成功后返回的是SQLITE_DONE
Pre:
sqlite3中文乱码问题
Next:
Linux开机启动mongodb和leanote
0
likes
129
Weibo
Wechat
Tencent Weibo
QQ Zone
RenRen
Table of content
merlin
