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_
Ïà¹ØÎÊ´ð£º
ÇëÎʸ÷λ¸ßÊÖÈçºÎÓÃC/C++»ñµÃϵͳδ°²×°²¹¶¡
ºÃÏñºÜרҵµÄ¶«Î÷¡£¡£¡£
²é×¢²á±í
ÿ¸ö²¹¶¡Èç¹û°²×°Á˶¼»áÔÚ×¢²á±íÀïÃæµÇ¼Ç
ÇëÎÊÄܲ»ÄܸüÇåÎúЩ£¬ÎÒÏëÓÃc\c++²é³öÀ´£¬²»ºÃÒâ˼£¬ÎÒÊÇÐÂÊÖ¡£»¹ÍûÖ¸½Ì¡£Ð»
·ÖÖµ ......
ÓÃc/c++¶¨Î»É¾³ýÒ»ÐеÄÎÊÌâ¡£
ÎÊÌâ±³¾°£º
ËùÐèÊý¾ÝÏ൱´ó¡£aÓëbÎļþ¾ùΪһ×éÎļþ£¨a1£¬a2¡£¬b1£¬b2¡£©£¬aÎļþÓÐ×î´óÊý¾ÝÐÐÊý£¨Èç5000£©£¬ÒÔÐеÄÐÎʽ£¬´ÓaÎļþÖжÁÈ¡Êý¾Ý£¬½«aÖв»ÄÜ´¦ÀíµÄÊý¾Ý·ÅÔÚbÎ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ ......
ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿
¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......