Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎÊ´ð£º

MYSQLÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......

ÔõôÔÚeclipseÏÂÏòmysql²åÈë±äÁ¿°¡ - Java / JavaÏà¹Ø

String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡­¡­µ½µ×¸Ãզд°¡

Íò·Ö¸Ðл£¡

String SQL=&q ......

mysql²éѯÎÊÌâ

bas_car ±í ÓÐÁÐcarname £¬Òª½øÐÐÊý¾Ýͳ¼Æ£¬ 
select count(a.carname),a.carname from bas_car a,bas_car b where a.carid>=b.carid and a.carname=b.carname
group by a.carname  
ÈçÉϲéѯ½á ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ