mysql capiºÍodbc
odbc·ÃÎÊmysqlЧÂÊÊDz»ÊÇÏ൱µÍ°¡¡£
×öÁ˸ö²âÊÔ£¬±í¼Ç¼40000ÐÐ
select a from test
ÓÃodbc²éѯ£¬±éÀú×ܹ²ºÄʱ500ms
ÓÃcapi²éѯ£¬±éÀú×ܹ²ºÄʱ70ms
¶øÇÒÔÚsqlserver ÉÏÓÃado²âÊÔÁËͬÑùµÄ±íºÍ²éѯ£¬ºÄʱ400ms¡£
ÄѵÀÿ¸öÊý¾Ý¿â¶¼Ö»ÄÜÓÃ×Ô´øµÄapi½Ó¿ÚÂð£¬adoºÍodbcЧÂʶ¼Õâô²î£¿£¿£¿£¿
ÄãÕÆÎÕËùÓÐit¼¼ÄܺÍÄ㾫ͨlampÄǸö¹«Ë¾°®Òª
ºÇºÇ£¬Â¥ÉϵIJ»½â¡£¡£¡£
°´µÀÀíadoµ½oledbµ½apiÓ¦¸ÃÖ»ÊǶàÁË2²ã·â×°¶øÒÑ£¬£¬Ôõô²éÕâô¶à¡£¡£ÊDz»ÊÇrecordsetµÄÐÔÄÜÌØ±ðµÍ£¿
API ÊÇÖ±½ÓÓÉMYSQL¹«Ë¾ÌṩµÄ£¬¿ÉÒÔ˵Á¬Ê²Ã´Çý¶¯¶¼Ã»ÓУ¬ÊÇÖ±½Ó²Ù×÷¡£µ±È»»áЧÂʸߺܶࡣ
¶øODBC·â×°ºó£¬¼ÓÁ˺ܶ࿪·Åʽ±ê×¼»¯µÄ¶«Î÷ÔÚÆäÖУ¬°üº¬¶ÔÊý¾ÝÀàÐ͵Äת»»£¬¼æÈݵȵȡ£
ËùÒÔ»á²îºÜ¶àÒ²²»Ææ¹Ö¡£
odbc²»ÓÃÓÚado
¶øoledbÊÇodbcµÄǰÉí°É
capiÁ´½ÓÊÇmysqlÌṩµÄÖ±½ÓÓÃcÓïÑÔ½øÐÐÁ´½Ó
ÒªÖªµÀmysqlÊÇcдµÄ°É£¬Ð§Âʵ±È»¸ß
ÕâÊǸöÈËÈÏΪ¶®µÄ²»ÊǺܶà
¸ãÃ÷°×ÁË¡£Ð»Ð»Â¥Éϼ¸Î»¡£
ÎÒÓõÄÊÇado£¬myqlûÓкõÄoledb£¬ËùÓÐÖ»ÄÜadoµ÷ÓÃodbc·ÃÎÊmysql¡£
sqlserver ÓõÄÊÇ adoµ÷ÓÃoledb·ÃÎÊsqlserver¡£
Ò»°ãoledb¶¼ÊǶÔcapiµÄÒ»²ã·â×°¡£ÄÇôÓÃadoµ÷Óã¬×î¶àÖ»¶àÁË2²ã·â×°£¬Âý10±¶²»¿ÉÀí½â¡£
´ó¸ÅÖªµÀÔÒòÁË£¬ÊÇÊý¾Ý¼¯µÄÎÊÌâ¡£·µ»ØµÄ4wÐÐÊý¾Ý£¬²»¹Üodbc£¬ado¶¼ÊÇÃæÏò¶ÔÏóµÄ£¬¹¹½¨ÁË4w¸örow¶ÔÏó¡£capi¶¼ÊǾä±ú²Ù×÷¶þ½øÖÆ¡£ËùÒÔ¿ì¡£¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï.
ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî
SQL code:
update ±í set introtxt=left(`fulltext`,300);
¶¥£¬Ñ§Ï°
SQL code: ......
ÎÒÏëÒª¸üÐÂij¸ö±íÅÅÐòºó¿¿Ç°µÄÊý¾Ý£¬ÓÚÊÇдÁËÒ»¸öÓï·¨£º
update dcproduct set pOrder=pOrder+2 order by pOrder desc,id desc limit 6£»Õâ¸öÊÇ¿ÉÒÔÔËÐе쬽á¹ûÊǸüÐÂÁËǰÁùÌõ¼Ç¼¡£
ºóÀ´·¢ÏÖ©Á˸öÌõ¼þÒªÁ¬± ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......