-
大小: 291KB文件類型: .rar金幣: 1下載: 0 次發(fā)布日期: 2021-01-10
- 語言: 數(shù)據(jù)庫
- 標(biāo)簽: sqlite??
資源簡介
sqlite嵌入式數(shù)據(jù)庫使用示例源碼(VC)-sqlite_demo,免費(fèi)下載
代碼片段和文件信息
//?sqlitedemo.cpp?:?Defines?the?entry?point?for?the?console?application.
//
#include?“stdafx.h“
#include?“../sqlite3_lib/sqlite3.h“
#pragma?comment(lib?“../sqlite3_lib/sqlite3.lib“)
static?int?_sql_callback(void?*?notused?int?argc?char?**?argv?char?**?szColName)
{
????int?i;
????for?(?i=0;?i?????{
????????printf(?“%s?=?%s\n“?szColName[i]?argv[i]?==?0???“NUL“?:?argv[i]?);
????}
????return?0;
}
int?main(int?argc?char?*?argv[])
{
const?char?*?sSQL1?=?“create?table?users(userid?varchar(20)?PRIMARY?KEY?age?int?birthday?datetime);“;
const?char?*?sSQL2?=?“insert?into?users?values(‘wang‘20‘1989-5-4‘);“;
????const?char?*?sSQL3?=?“select?*?from?users;“;
????sqlite3?*?db?=?0;
????char?*?pErrMsg?=?0;
????int?ret?=?0;
????
//?連接數(shù)據(jù)庫
????re
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1232??2009-03-06?15:08??sqlitedemo\ReadMe.txt
?????文件?????499246??2009-02-17?16:54??sqlitedemo\sqlite3.dll
?????文件???????1430??2009-03-06?16:49??sqlitedemo\sqlitedemo.cpp
?????文件???????4584??2009-03-06?15:08??sqlitedemo\sqlitedemo.dsp
?????文件????????545??2009-03-06?15:08??sqlitedemo\sqlitedemo.dsw
?????文件??????41984??2009-03-06?16:50??sqlitedemo\sqlitedemo.ncb
?????文件??????48640??2009-03-06?16:50??sqlitedemo\sqlitedemo.opt
?????文件???????1819??2009-03-06?16:49??sqlitedemo\sqlitedemo.plg
?????文件????????297??2009-03-06?15:08??sqlitedemo\StdAfx.cpp
?????文件????????769??2009-03-06?15:08??sqlitedemo\StdAfx.h
?????文件???????3072??2009-03-06?16:14??sqlitedemo\test.db
?????文件????????174??2009-03-06?16:28??代碼說明.txt
?????文件???????3710??2009-02-17?16:54??sqlite3_lib\sqlite3.def
?????文件?????323624??2009-02-17?16:53??sqlite3_lib\sqlite3.h
?????文件??????42252??2009-03-06?15:02??sqlite3_lib\sqlite3.lib
?????目錄??????????0??2009-03-06?16:51??sqlitedemo
?????目錄??????????0??2009-03-06?15:11??sqlite3_lib
-----------?---------??----------?-----??----
???????????????973378????????????????????17
評論
共有 條評論