.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×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
´ó¼ÒºÃ:
ÎÒÊǸãCµÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
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 ......