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

mysql²åÈëͼƬÎÊÌâ

²åÈëͼƬʱ»á±¨Á˸öÒì³£ÈçÏ£º
org.springframework.dao.DataAccessResourceFailureException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '8 l??¡°???_?o????¡±? @,????0N\'?ué¡­¡­ 象¯I6????! c??? \"?ZT?????Lc\0c' at line 1 at org.carf.common.jdbc.mysql.MySqlLobHelper.updateLobValue(MySqlLobHelper.java:84) .....

¶øÇÒÎÒÄÇÌõSQLÓï¾äËü±¨³öÀ´¾ÓÈ»ÊÇÂÒÂ룬ÎÒÈ·ÐÅÕâ±ß²»´æÔÚÖÐÎıàÂëÎÊÌ⣬ȷÐÅûÓÐÓï·¨´íÎ󣬲¿·Ö´úÂëÈçÏ£º
sql = "update imagetable set image = £¿where id='1'";
PreparedStatement pstmt = null;
try
  {
      pstmt = con.prepareStatement(sql);
      File f = new File(path);
      FileInputStream in = new FileInputStream(f);
      pstmt.setBinaryStream(1, in, (int) (f.length()));
      pstmt.executeUpdate();£½£½£½£½ÕâÀﱨÁËÒì³£
    }
catch (Exception e)
    {
      e.printStackTrace(System.out);
      throw new DataAccessResourceFailureException(e.getMessage());
    }


¸÷λÓÐûÓÐÓöµ½¹ýÀàËÆµÄÇé¿ö°¡£¬¸éÁ˺þÃÁËһֱû½â¾ö
ÎҰѲåÈëͼƬÄǾ任³Épstmt.setString(i+1, "letex");²åÈë×Ö·û´®£¬Êý¾Ý¿âÊÇ¿ÉÒÔ²åÈëµÄ¡£¡£¡£ÎÊÌâÔÚÄÄÄØ

Êý¾Ý¿âÖÐ


Ïà¹ØÎÊ´ð£º

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

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

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

´Ómysql¶ÁͼƬ·¾¶µ«ÊÇÎÞ·¨ÏÔʾ

´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:

<?php
$str="select * from product wh ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ