MySQLÊý¾Ý¿âÓÃʲôÁ¬½Ó³ØºÃ£¿
ÏëÕÒÒ»¸öʵÏÖÁ˶þ½øÖƲÙ×÷µÄÁ¬½Ó³Ø£¬dbcpºÍc3p0¶¼Ã»ÓУ¬ÎÒҲд¹ýÒ»¸ö£¬µ«ÊǸоõÐÔÄÜÉÏÒ»¶¨Ã»ÓдóʦÃǵĺ㬻¹ÓÐʲôÁ¬½Ó³Ø£¿£¿£¿×¢Ò⣺ҪʵÏÖ¶þ½øÖƲÙ×÷µÄ£¬Ò²¾ÍÊÇÀàËÆÕâ¸ö·½·¨PreparedStatement .setBinaryStream()µÄ£¡£¡£¡£¡£¡£¡£¡
°ïÄã¶¥~~~~~~~~~~~~
ͬ
Á¬½Ó³ØÖ»ÊÇÓÃÓÚ´æ·ÅÊý¾Ý¿âÁ¬½ÓµÄ×ÊÔ´³Ø£¬¶Ô¿ª·¢ÕßÀ´ËµÊÇÍêȫ͸Ã÷µÄ¡£¶ÔÓÚ JDBC ²Ù×÷À´ËµÊ¹ÓÃÁ¬½Ó³ØÓ벻ʹÓÃÁ¬½Ó³Ø¶ÔÓÚ´úÂëÀ´ËµÃ»ÓÐÈκÎÇø±ð£¬Ö»ÊÇ»ñµÃÁ¬½ÓµÄ·½Ê½²»Ò»Ñù¡£
Èç¹û JDBC µÄ½Ó¿ÚÖÐûÓÐÌṩµÄ·½·¨£¬ÄÇÒ²²»¿ÉÄÜ×Ô¼ºÈ¥ÊµÏÖÒ»Ìס£
Á¬½Ó³ØÖ»ÊǸºÔð¹ÜÀíÁ¬½Ó¶ÔÏóµÄ£¬¸úÄã¶þ½øÖƲÙ×÷²»²Ùûʲô¹ØÏµ°É£¡
Á¬½Ó³ØµÄºÃ»µÖ÷ÒªÊÇ¿´ÆäÎȶ¨ÐÔÈçºÎ¡£DBCPÓëCP30ËÆºõ¶¼²»ÔõôÑù¡£ÓÐÒ»¸ö½ÐʲôproxoolµÄ²»´í¡£
¡£¡£¡£¡£¡£
PreparedStatementºÍConnection¶¼ÊÇjava.sql°üÖеĽӿڣ¬¶¼ÐèҪʵÏÖ¡£
ͨ¹ýdbcp»òÕßc3p0»ñµÃµÄConnection·µ»ØµÄPreparedStatementûÓÐʵÏÖsetBinaryStream()·½·¨£¡
Ç¿ÁÒ½¨Òé´ó¼Òȥʵ¼Ê²âÊÔһϣ¨ÒòΪÿ¸öÈ˳ÙÔç¶¼»áÓöµ½ÕâÑùµÄÎÊÌ⣩¡£
»á±¨ÈçÏÂÒì³£µÄ£º
java.lang.AbstractMethodError: org.apache.commons.dbcp.DelegatingPreparedStatement.setBinaryStream(ILjava/io/InputStream;J)V
Ã÷ÏÔÊdzéÏó·½·¨Ã»ÓÐʵÏÖ£¡£¡£¡£¡£¡£¡£¡£¡
Õâ¸öµ¹²»Çå³þ£¬ÄÇÄã×Ô¼ºÐ´Ò»¸öËãÁË¡£
Á¬½Ó³Ø£¬¸Õ¸Õ²Å¸ã¶®£¬ºÍÏ̳߳ØÒ»¸öµÀÀí¡£
¹§Ï²Â¥Éϸ÷룬¾¹ý²âÊÔproxoolʵÏÖÁËPreparedStatement½Ó¿ÚµÄsetBinaryStream()·½·¨£¡£¡£¡
Ï£ÍûÒÔºóÓöµ½Õâ¸öÎÊÌâ´ó¼Ò¶¼ÇáËɸ㶨£¡£¡
Java code
Code highlighting produced by Actipro Code
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......