¿ª»ú¼ì²âmysqlÊý¾Ý¿âÁ¬½ÓÎÊÌâ
Public Function CreateConnection(ByVal pProvider As String, pDataSource As String) As ADODB.Connection
Dim oCn As ADODB.Connection
Set oCn = New ADODB.Connection
oCn.CursorLocation = adUseClient
oCn.Open NMySqlCon
Set CreateConnection = oCn
Call Command_Click
End Function
NMySqlCon£º"Driver=MySQL ODBC 5.1 Driver;SERVER=localhost;UID=root;PWD=***;DATABASE=*******;PORT=3306"
¿ª»úÆô¶¯ÔËÐе½£ºoCn.Open NMySqlCon ÏÔʾÁ¬½Ó²»Éϱ¾µØÊý¾Ý¿â¡£
Public Function Command_Click() Dim sKeyName As String, sKeyValue As String, sKeyValueIcon As String
Dim Ret As Integer, lphKey As Long
sKeyName = "Software\Microsoft\Windows\CurrentVersion\Run"
sKeyValue = "C:\PcposX8\Suntouch.exe"
Ret = RegCreateKey&(HKEY_LOCAL_MACHINE, sKeyName, lphKey)
Ret = RegSetValue&(lphKey&, "", REG_SZ, sKeyValue, 0&)
End Function
ÕâÊǼÓÈë×¢²á±íµÄ³ÌÐòµÄ´úÂë¡£
ÈçºÎÔÚ¿ª»úµÄʱºòoCn.Open NMySqlCon ²»³É¹¦ºó£¬ÔÙ¼ÌÐøÁ¬½ÓmysqlÊý¾Ý¿â£¬¶ø²»ÈÃËüµ¯³ö´íÎó¿ò¿ò¡£
ÄÇÍòÒ»¿Í»§MYSQL³öÏÖ¹ÊÕϵϰ£¬ÄDz»ÊÇÒ»Ö±Á¬²»ÉÏÂð£¿
Ö»ÄÜ˵Ã÷ÄãµÄÐèÇó¸ù±¾Ã»Óп¼ÂÇÕâÀàÒì
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
È»ºóɾ³ýÊý¾Ý¿âÖеÄÈô¸ÉÖØ¸´¼Ç¼ºóID±äµÄ²»Á¬Ðø£¬ÈçºÎ±äµÃÁ¬Ðø£¿£¿
ÔËÐÐ
ALTER TABLE tablename DROP id;
ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY ......