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");²åÈë×Ö·û´®£¬Êý¾Ý¿âÊÇ¿ÉÒÔ²åÈëµÄ¡£¡£¡£ÎÊÌâÔÚÄÄÄØ
Êý¾Ý¿âÖÐ
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:
<?php
$str="select * from product wh ......