Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

.net+MySqlÏîÄ¿ÈçºÎ·¢²¼µ½·þÎñÆ÷£¨ÔÚÏߵȴý£©

      ÏÖÔÚÎÒÓÐÒ»¸öСweb³ÌÐò£¬ÎÒÏ뽫Ëü·¢²¼µ½·þÎñÆ÷ÉÏ£¬À´ÊìϤºÍÕÆÎÕÈçºÎÔÚ·þÎñÆ÷Éϲ¿Êð.netÏîÄ¿,Çë´ó¼Ò¶à¶à°ï棬лл£¡

¿ª·¢ÓïÑÔ£ºC# 
Êý¾Ý¿â£ºMySql£¨ Server version: 5.0.86£©
Êý¾Ý¿âÇý¶¯£ºMySQL Connector Net 5.2.5


ÏÖÔÚÎÒÒªÔÚ·þÎñÆ÷ÉÏÀ´²¿ÊðËü£¬ÇëÎÊÎÒÒª×öÄÄЩÊ£¿

·þÎñÆ÷µÄ²Ù×÷ϵͳ£¬Ó¦¸ÃÊÇ2000»òÕß2003

ÎÒ¸öÈ˵Ä×ö·¨ÊÇ£º
1.Èç¹ûIIS×°ºÃÁ˾ÍÖ±½Ó×°.NET3.5¿ò¼Ü¡£
2.×°MySqlÊý¾Ý¿â£¬ÉèÖÃÕ˺ÅÃÜÂë¡£
3.ÔÚÏîÄ¿ÖаÑÁ¬½ÓÊý¾Ý¿âµÄ×Ö·û´®ÖеÄÕË»§ÃÜÂë¸Ä³ÉºÍÊý¾Ý¿âµÄÒ»Ö£¬·¢²¼£¬½«Éú³ÉµÄÎļþ¿½±´µ½IISµÄwwwrootÏÂÃæ

ÔÚÎÒ¸öÈË»ú×ÓÉÏ£¬ÎÒÊÇÕâÑù×öµÄ£¬ÇëÎÊÔÚ·þÎñÆ÷ÉÏÒ²ÊÇÒ»ÑùÂð£¬Çë¸÷λ°ï棿


ÖÜÄ©Óä¿ì    ÎÒ¾ÍÊÇÅ  Õâ¸ö»á³öÏÖʲôÎÊÌâ   
ÔÚ·þÎñÆ÷ÉÏ  ²»ÖªµÀ¸ÃÔõô×ö

http://blog.oucsoft.com/post/130.html

Õâ¸ö²»ÄѰ¡,°ÑÎļþcopyµ½·þÎñÆ÷ÉÏ£¬Êý¾Ý¿âµ¼Èë¾Í¿ÉÒÔÁË

"°ÑÎļþcopyµ½·þÎñÆ÷ÉÏ"  ÕâÑù×ö²»ºÃ°É£¿£¿


Ïà¹ØÎÊ´ð£º

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......

cÓïÑÔÈçºÎÁ¬½ÓMYSQL£¿

´ó¼ÒºÃ:
ÎÒÊǸãCµÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

MYSQL ÊÂÎñµÄÎÊÌâ

SQL code:

create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000))
begin
declare exit handler for sqlexception rollback;
start TRANSACTION;
EXECUTE SqlCMD1;
EXE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ