SQLite3使用
SQLite3使用 www.sqlite.org下载shell把exe放置C:WINDOWSsystem32下 创建数据库user sqlite3 user 创建表tbl create table tbl(name char(10),age smallint,score float); 查询表 .table 插入数据 insert into tbl values('yanggang',24,98); insert into tbl values('sunboy',20,78.5); 查询数据 select * from tbl; 修改显示模式 .mode column sqlite3 表里插入系统时间(时间戳) CREATE TABLE time([ID] INTEGER PRIMARY KEY,[IDCardNo] VARCHAR (50),[CreatedTime] TimeStamp NOT NULL DEFAULT (datetime('now','localtime')));
sqlite3 *db = 0; sqlite3_stmt * stmt; sqlite3_open("./test.db",&db); char* zErrMsg = 0; sqlite3_prepare(db,"select * from admin;",-1,&stmt,0); int rc = sqlite3_step(stmt); while( rc == SQLITE_ROW ) { CString type = sqlite3_column_text(stmt,51); font-family:宋体; font-size:14px; line-height:28px"> CString adminpassword = sqlite3_column_text(stmt,1); MessageBox(type); MessageBox(adminpassword); rc=sqlite3_step(stmt); } sqlite3_finalize(stmt); sqlite3_close(db) sqlite3取数据库数据 sqlite3 * db = NULL; char *sql = sqlite3_mprintf("select * from ALLID"); //获得表内所有记录 sqlite3存入中文数据navicat premium显示 (1)写入: char str [256] = "实验"; (2)读出到mfc CString setname = sqlite3_column_text(stmt,2); char *str =(LPSTR)(LPCTSTR)setname; // char str [256] = "实验"; int len = ::MultiByteToWideChar(CP_UTF8,str,0); vector<wchar_t> unicode(len); MultiByteToWideChar(CP_UTF8,&unicode[0],len); setname=CString(&unicode[0]); (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |