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

¹ØÓÚMYSQLÖÐͼƬÌáÈ¡ÎÊÌ⣨ͼƬÀàÐÍΪlongblob£©

Êý¾Ý¿â½á¹¹£º
±íÃû£ºmmm
id        varchar£¨50£©
filename  longblob

ÒÔ¶þ½øÖÆ´æÈëͼƬµÄ´úÂëÈçÏ£º

            conn.Open();


            string imgPath = @"D:\\aa.jpg";//ͼƬÎļþËùÔÚ·¾¶ 
            FileStream file = new FileStream(imgPath, FileMode.Open, FileAccess.Read);
            Byte[] imgByte = new Byte[file.Length];//°ÑͼƬת³É ByteÐÍ ¶þ½øÖÆÁ÷ 
            file.Read(imgByte, 0, imgByte.Length);//°Ñ¶þ½øÖÆÁ÷¶ÁÈ뻺³åÇø
           
         
            string sqlstr = "insert into mmm(id,filename) values('200','"+imgByte+"') ";
            MySQLCommand cmd = new MySQLCommand(sqlstr ,conn );
                      int value0 = cmd.ExecuteNonQuery();
            if (value0 >= 0)
            {
                MessageBox.Show("³É¹¦");
            }
       


Ïà¹ØÎÊ´ð£º

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: ......

mysqlÊý¾ÝÕÒ»ØÄÑÌ⣬¸ß·Ö£¬¼±£¡£¡£¡

ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......

mysqlÖÐÎÄÂÒÂë - C/C++ / C++ ÓïÑÔ

mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ