ÍøÕ¾ºǫ́ÉÏ´«Í¼Æ¬Â·¾¢µ½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ΪÀÏÈ˵Ľ¨Ò飬ÎÒµ÷ÊÔ¿´¿´£¡
Óï·¨´íÎó°É£¿
°Ñ
Ïà¹ØÎÊ´ð£º
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......