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

ÍøÕ¾ºǫ́ÉÏ´«Í¼Æ¬Â·¾¢µ½mysqlÊý¾Ý¿âÖгöÏÖÎÊÌ⣡

Java code:

Connection con = connectionFactory.getconnection();
String sql1="insert into $hanzdb.photolist (content,imageurl) values ('fileForm.getContend','upload/¡¯+fname)";
PreparedStatement ps = con.prepareStatement(sql1);
ps.setString(1, fileForm.getContent());
ps.setString(2, fileForm.getImageurl());
//ResultSet rs = ps.executeQuery();
ps.executeUpdate();
out.flush();
out.close();
file.destroy();


ͨ¹ýÁ÷ÉÏ´«Í¼Æ¬Â·¾¶µ½MySQLÊý¾Ý¿â£¬imageurl×Ö¶ÎÏÂÀàÈÝΪupload/xxxx.jpg(xxx.jpg ¾ÍÊÇfname)
ÍøÉϲéÁË×ÊÁÏ£¬Ò»Ö±Ã»½â¾ö²åÈë²»³É¹¦£¡
ÆäÖÐphotolist±í½á¹¹ÈçÏÂ
id imageid tile    uploadtime        content      imageurl          address
1  1      ÁªÏë  2009-06-12 00:00:00  ¼¯ÌåºÏÓ°    upload/xxxx.jpg  ±±¾©
ͼƬÄܳɹ¦ÉÏ´«µ½ÏîÄ¿µÄuploadĿ¼Ï£¬¾ÍÊDzåÈë·¾¶³öÏÖÎÊÌ⣬ÍùÓо­ÑéÕßÄܸøÓëÌáʾ£¬Ð»Ð»£¡
sqlÓï¾ä¸Ä³ÉÕâÑùÊÔÊÔ£º
String sql1="insert into $hanzdb.photolist (content,imageurl) values ('fileForm.getContend','upload/"+fname+"')";


µ÷ÊÔÖп´Ï sql1 µÄÄÚÈݵ½µ×ÊÇʲô£¿

ллÉÏÃæ2ΪÀÏÈ˵Ľ¨Ò飬ÎÒµ÷ÊÔ¿´¿´£¡

Óï·¨´íÎó°É£¿
°Ñ


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......

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

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

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

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

ASP +Mysql proc

ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ­»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ