Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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("³É¹¦");
            }
       


Ïà¹ØÎÊ´ð£º

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

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

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

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

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

<?php
$str="select * from product wh ......

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

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

Íò·Ö¸Ðл£¡

String SQL=&q ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ