phpÀïÃæÈçºÎ²åÈë»òÕ߸üÐÂaccessÊý¾Ý¿â
ΪʲôÏÂÃæµÄsqlÓï¾äÊDzéѯÊý¾Ý¿âµÄʱºò¾Í²»³ö´í£¬Èç¹ûÊÇ ²åÈë»òÕ߸üÐÂÊý¾ÝµÄʱºò¾ÍÌáʾ £ºOperation is not allowed when the object is closed£¬µ±Ê¹ÓÃupdate»òÕßinsertµÄʱºò£¬ÏÂÃæ´úÂëÓ¦¸ÃÈçºÎ¸ü¸Ä£¿
<?php
$conn = @new COM("ADODB.Connection") or die ("ADO Connection faild.");
$connstr = ".................";
$conn->Open($connstr);
$rs=@new COM("ADODB.RecordSet");
$rs->Open("select * from pingpai",$conn);
...
...
...
?>
»¹ÊÇʹÓõÚÈý·½µÄÀà¿â°É..adodb Äãȥϸö¿´¿´.
½¨ÒéʹÓÃADODBÀà
TottyAndBatyµÄÍ·Ïñ²»´í¡£
¸ù±¾Ã»½â¾öÎÊÌâ°¡£¡£¡
Ïà¹ØÎÊ´ð£º
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿
¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖÃ
¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......