2,208
社区成员
发帖
与我相关
我的任务
分享
sqlite3* pDb = NULL;
//const char* pFilename = "airdrome.s3db";
char* pFilename = "airdrome.s3db";
int rc = sqlite3_open(pFilename, &pDb);
if (SQLITE_OK != rc || NULL == pDb)
{
AfxMessageBox(_T("初始化数据库失败!"));
sqlite3_close(pDb);
return ;
}
string strSql = "insert into userinfo (jobnum, username, userstat, adddate, modifydate, \
deldate, passwd) values ('admin', 'admin', 1, '20110609', '', '', '000000')";
char *errMsg;
rc = sqlite3_exec(pDb, strSql.c_str(), 0, 0, &errMsg);
if (SQLITE_OK != rc)
{
AfxMessageBox(_T("插入数据失败!"));
printf("mxx test %s", errMsg);
sqlite3_close(pDb);
return ;
}
sqlite3* pDb = NULL;
//const char* pFilename = "airdrome.s3db";
char* pFilename = "airdrome.s3db";
int rc = sqlite3_open(pFilename, &pDb);
if (SQLITE_OK != rc || NULL == pDb)
{
AfxMessageBox(_T("初始化数据库失败!"));
sqlite3_close(pDb);
return ;
}
string strSql = "insert into userinfo (jobnum, username, userstat, adddate, modifydate, \
deldate, passwd) values ('admin', 'admin', 1, '20110609', '', '', '000000')";
char *errMsg;
rc = sqlite3_exec(pDb, strSql.c_str(), 0, 0, &errMsg);
if (SQLITE_OK != rc)
{
AfxMessageBox(_T("插入数据失败!"));
printf("mxx test %s", errMsg);
sqlite3_close(pDb);
return ;
}