Ò»¸öÁ¬½ÓmysqlºÍmssqlµÄ×¢²á¹¦ÄÜ£¡100·Ö
Ìṩһ¸öÍêÕûµÄ¼òµ¥Ê¾Àý
µã»÷×¢²áµÄʱºò£¬°ÑÐÅϢͬʱע²áµ½mysqlµÄA±íºÍmssqlµÄA±í лл
×¢²á¹¦ÄÜ?? ÊÇʲôÒâ˼
ÄãºÃ ÎÒÊǵÚÒ»´Î½Ó´¥PHP£¬¿ÉÒÔÏêϸµãÂð
ÆäʵÎÒÊÇÏëÔÚDiscuzÀïµÄ×¢²áÌí¼ÓÒ»¸öµ½MSSQLµÄ±í
$db->query("Insert Into ceshi(CeshiName)Values('AAAA')");
Õâ¸öÊÇÎÒ²âÊÔÁËÏÂÔÚMYSQLÀïOK
ÏÖÔÚÎÒÏëÔõôʵÏÖÔÚMSSQL£¬mysql_queryÕâ¸öÊÇʲô£¿ÎÒÐèÒªÁ¬½ÓÊý¾Ý¿âÊÇÔõôÑùµÄ ³õѧÕßÇë½ÌºÇºÇ
¼ÈÈ»ÊÇÐÂÊÖ£¬½¨ÒéÏÈ¿´¿´PHPÊÖ²áÔÙȥʵÏÖijЩ¹¦ÄÜ¡£
ллÄãµÄ½¨Ò飬ÓÉÓÚ¸Õ½Ó´¥PHP£¬Óï·¨²»ÊìϤ£¬²»¹ý×¢²áµÄ»°Ò²¾ÍÊÇÒ»ÌõSQL
ÎÒÏÖÔÚ¾ÍÊÇÏë×î¼òµ¥µÄ×¢²áµ½MSSQLÀïµÄÒ»¸öСʾÀý
PHP code:
<?php
$con=mssql_connect("localhost","sa","123","ceshi");
echo $con;
if($con)
echo "<br/>Á¬½Ó³É¹¦";
else
echo "Á¬½Óʧ°Ü";
?>
±ÈÈçÕâ¸öÊý¾Ý¿âÁ¬½ÓÉÏÁË ÎÒÔõôÌí¼ÓÒ»ÌõÊý¾Ý£¿
PHP code
Code highlig
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕⶼװÁ赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......