vc++6.0ͨ¹ýODBC·ÃÎÊMySQL serverÓöµ½µÄÎÊÌ⣡£¡£¡
ǰ¼¸ÌìÔÚ°³µÄ±¾×ÓÉϰ²×°ÁË
1,MySQL server 5.0
2,MySQL tools for 5.0
3,MySQL Connector\ODBC 3.51
È»ºó½¨Á¢ÁËÃûΪxyxµÄÊý¾Ý¿â£¬ÔÚ¸ÃÊý¾Ý¿âÄÚ½¨ÁËÒ»¸ö±í¸ñdblist,°üº¬ID,NAME,AGEÈýÏîÄÚÈÝ£ººÜ¼òµ¥£¬ÔÝÇÒΪÁËÊìϤһÏÂvcÏ·ÃÎÊÊý¾Ý¿âµÄÒ»°ã¹ý³Ì¡£
£¨1£©½¨Á¢ODBCÊý¾ÝÔ´£¬²âÊÔÁ¬½Ó³É¹¦£¡£¡
£¨2£©½¨Á¢Ò»¸öMFCµÄ¶Ô»°¿òÓ¦ÓóÌÐò¡£
£¨3£©ÔÚ¶Ô»°¿òÄÚÌí¼ÓÒ»¸ölist controlºÍËĸöbutton(²éѯ£¬Ìí¼Ó£¬É¾³ý£¬±à¼)¡£
£¨4£©Îªlist controlÌí¼Ó¿ØÖƱäÁ¿m_list£¬Îª²éѯButtonÌí¼Óµã»÷ÏìÓ¦º¯ÊýOnButtonQuery() Ìí¼ÓÈçÏ´úÂ룺
// TODO: Add your control notification handler code here
m_list.DeleteAllItems();
CDatabase db;
db.Open(NULL,FALSE,FALSE,"ODBC;DSN=MySQL;UID=root;PWD=xyx");
CRecordset rs( &db );
rs.Open( CRecordset::forwardOnly, "SELECT * from dblist");
while(!rs.IsEOF())
{
CString varID;
rs.GetFieldValue("ID", varID);
m_list.InsertItem(0,varID);
CString varNAME;
rs.GetFieldValue("NAME", varNAME);
m_list.SetItemText(0, 1, varNAME);
CString varAGE;
rs.GetFieldValue("age", varAGE);
m_list.SetItemText(0, 2, varAGE);
rs.MoveNext();
}
rs.Close();
db.Close();
}
µ¥²½µ÷ÊÔʱÔÚºìɫһÐÐÌøµ½MFC\src\wincore.cppÖÐ
LRESULT lResult;
TRY
{
#ifndef _AFX_NO_OCC_SUPPORT
// special case for WM_
Ïà¹ØÎÊ´ð£º
QQȺ 29152388
ÓÑÇéUP
°ï¶¥
up
°ïup
up Ö§³Ö£¡
up jf
...ÄѵÀÓзÖ..?
up up up
Ï£ÍûÓеüӷ֣¬¹þ¹þ¡£
Ö§³Ö£¬ÎÒ¼ÓÁË£¬Ï£ÍûÂ¥Ö÷ÄܼÓÎÒ£¬¹²Í¬Ñ§Ï°¹þ
¼ÓÁË¡£
¶¥ÉÏ£¬Ã¿ÌìÊÕ»ñÒ»µã£¬Ö§³Ö ......
ÎÊÌâ:¹¤µØÉÏÐèÒª³¤¶ÈΪA1µÄ¸Ö½îX¸ù,³¤¶ÈΪA2µÄ¸Ö½îY¸ù,³¤¶ÈΪA3µÄ¸Ö½îZ¸ù......ÒÔ´ÎÀàÍÆ.
ÆäÖÐA1,A2,A3,...³¤¶ÈÈÎÒâÖ¸¶¨,X,Y,Z,...ÊýÁ¿Ò²ÈÎÒâÖ¸¶¨.
µ«²Ö¿âÖеĸֽîΪ±ê×¼³¤¶È,Ö»ÓÐ9Ã׺Í15Ã×Á½ÖÖ³¤¶È,ÊýÁ¿² ......
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......