新人问个简单的问题：如何在代码中使用SQL语句？？

Question

如题，谢谢

Answer 1

http://www.338888.com/VCShare/ShowPost.asp?id=1015
http://www.338888.com/VCShare/ShowPost.asp?id=1016
http://www.338888.com/VCShare/ShowPost.asp?id=1017

Answer 2

_variant_t Holder, strQuery;
    strQuery = "select * from customer ";
   theApp.ADOExecute(theApp.m_pADOSet, strQuery);

Answer 3

CDatabase database;
database.Open(NULL,false,false,"ODBC;机器名;用户名;密码");
CRecordset recset( &database );  
recset.Open(CRecordset::dynaset,SQL语句,CRecordset::readOnly);

Answer 4

先连接数据库
HRESULT hr;
try
{
hr=m_pConnection.CreateInstance("ADODB.Connection");
if(SUCCEEDED(hr))
{
// hr=m_pConnection->Open("driver={SQL Server};Server=zhltlxg;DATABASE=hl_jc;UID=sa;PWD=810702","","",adModeUnknown);
CString sss,sql;
sss="10.231.234.169";
sql.Format("driver={SQL Server};Server=%s;DATABASE=hl_jc;UID=sa;PWD=810702",sss);
hr=m_pConnection->Open((LPCTSTR)sql,"","",adModeUnknown);
// hr = m_pConnection->Open("driver={SQL Server};Server=127.0.0.1;DATABASE=hl_jc;UID=sa;PWD=810702","","",adModeUnknown); 
}
}
catch(_com_error e)
{
CString errormessage;
errormessage.Format("连接数据库失败！\r\n错误信息:%s",e.ErrorMessage());
AfxMessageBox(errormessage);
}这一段执行插入操作CString sql;
sql.Format("insert into jc_ddb(jc_bh,jc_time,jc_1,jc_2,jc_3,jc_4,jc_5,jc_6,jc_7,jc_8,jc_9,jc_10,jc_11,jc_12,jc_13,jc_14,jc_15,jc_16,jc_17,jc_18,jc_19,jc_20,jc_21,jc_22,jc_23,jc_0) values (\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\')",biaohao,riqi,liang1,liang2,liang3,liang4,liang5,liang6,liang7,liang8,liang9,liang10,liang11,liang12,liang13,liang14,liang15,liang16,liang17,liang18,liang19,liang20,liang21,liang22,liang23,liang24);
    m_pConnection->Execute(LPCTSTR(sql),&RecordsAffected,adCmdText);你可以作为例子呀。