vc 6.0 mysql 实例_VC++6.0 SQLite 数据库操作例子。

[C++] 纯文本查看 复制代码bool fTest;

CDbSQLite sqlite;

//ﾁｬｽﾓｴｪSQLiteﾊｾﾝｿ・

fTest = sqlite.Open(_T("theTestSqlite.db"));

if (!fTest)

{

AfxMessageBox(_T("ｴｻｿｪtheTestSqlite.db"));

return;

}

CString szQuery;

szQuery = _T("INSERT INTO user VALUES ('xiaoWang','123','2013-09-16 15-56-48')");

fTest = sqlite.DirectStatement(szQuery);

szQuery = _T("INSERT INTO user VALUES ('xdoWang','123','2013-09-16 15-56-48')");

fTest = sqlite.DirectStatement(szQuery);

szQuery = _T("INSERT INTO user VALUES ('admin','123','2013-09-16 15-56-48')");

fTest = sqlite.DirectStatement(szQuery);

if (!fTest)

AfxMessageBox(_T("ｲｻﾄﾜｴｴｽｨｱ咊sersInfo"));

// CString szQuery;

// szQuery = _T("INSERT INTO usersInfo VALUES ('xiaoWang','123')");

// fTest = sqlite.DirectStatement(szQuery);

}