4,011
社区成员
发帖
与我相关
我的任务
分享
const char * sSQL = "select * from users;";
sqlite3 * db = 0;
char * pErrMsg = 0;
int ret = 0;
// 连接数据库
ret = sqlite3_open("./test.db", &db);
if ( ret != SQLITE_OK )
{
return(1);
}
// 查询数据表
sqlite3_exec( db, sSQL, _sql_callback, 0, &pErrMsg);
// 关闭数据库
sqlite3_close(db);
db = 0;
return 0;
$sql = "select count(*) from tb_guestbook";
$result = mysql_query($sql,$link);
if($row = mysql_fetch_array($result)){
$recordtotal = $row[0];
}
if(dlg.DoModal() == IDOK)
{
CString sSQL;
CSqlite *con = NULL;
con = new CSqlite;
con->Open("../Data.db3");
sSQL.Format(_T("UPDATE tb_DanyuanFengxian SET name='%s',unittype=%d,counts=%d,zhuangbeitype=%d,moshi=%d,wuzhi=%d,yuanqiang=%d WHERE id=%d;"),
dlg.m_Name,
dlg.m_UnitType,
dlg.m_Amount,
dlg.m_Shebei,
dlg.m_Moshi,
dlg.m_Wuzhi,
dlg.m_Yuanqiang,
Id);
const char * sql = sSQL.GetBuffer(0);
con->Execute(sql);
con->Close();
}