MySQL Java ¿ª·¢Ì××°
MySQL Java ¿ª·¢Ì××°(·þÎñÆ÷,¹ÜÀí¹¤¾ß,JDBCÇý¶¯,ʾÀý´úÂë)
С¸üÐÂ: ΪÁ˼õÇḺµ£, Óà MySQL-Front 2.5 À´¹ÜÀí, Õâ¸öÈí¼þÎÞÖÐÎÄÎÊÌâ. Èç¹ûÒÔºó¿ªÔ´°æ±¾HeidiSQLµÄ½â¾öÁËÖÐÎÄÎÊÌâ, ¾ÍÓÿªÔ´µÄ.
ÏÂÔØ: http://tomcatmonitor.googlecode.com/files/portable_mysql5.exe 4.02MB (×Ô½âѹ°ü)
²Î¿¼Îĵµ: MySQL 5 ÂÌÉ«°æ(BAT°æ±¾)
2007-10-01
°æÈ¨ËùÓÐ 2007 Áõ³¤¾¼(BeanSoft@126.com)
Blog: http://www.blogjava.net/beansoft/
±¾Èí¼þÌ××°²ÉÓõÄÐÒé: GPL, ²Î¿¼ gpl.txt
Java ³õѧÕß×îÍ·ÌÛµÄ, ιýÓÚ°²×°Êý¾Ý¿â, ѰÕÒÊý¾Ý¿â¹ÜÀí¹¤¾ß, ѰÕÒ JDBC Çý¶¯, È»ºó±àд´úÂëÀ´²âÊÔ, È»ºóÓöµ½ÁËÂÒÂëÎÊÌâ, Í·´óµÄÒªÃü, ²»ÖªµÀÈçºÎ½â¾ö.
ÔÚ´Ë, ÎÒËѼ¯Á˼¸¸ö¿ªÔ´Èí¼þ, ×éºÏµ½Ò»Æð, À´·½±ã´ó¼ÒµÄÊý¾Ý¿â¿ª·¢. Êý¾Ý¿âÎÒÑ¡Ôñ MySQL 5.0.41 ÂÌÉ«°æ(±¾Õ¾¿ª·¢), ¹ÜÀí¹¤¾ßÎÒÑ¡Ôñ MySQL-Front 2.5 Ãâ·ÑÈí¼þ(Õâ¸ö°æ±¾¿ÉÒÔÕùÈ¡ÏÔʾÖÐÎÄ), È»ºóÑ¡ÔñÁË MySQL JDBC Çý¶¯, ²¢±àдÁ˲âÊÔ´úÂë, ÕâЩ´úÂë½â¾öÁËÖÐÎÄÎÊÌâ, ×îºóʹÓÃÃâ·ÑµÄ PStart 2.11 ÖÆ×÷ÁËÆô¶¯¹¤¾ß.
Ó÷¨: ÏÂÔØºó½âѹËõµ½Ó²Å̵ÄÈÎÒâλÖÃ, È»ºóË«»÷ PStart.exe ¿ªÊ¼, ÏÈÆô¶¯ MySQL ·þÎñÆ÷, È»ºó¼´¿É±àÒëÔËÐÐ JDBC ²âÊÔ´úÂë.
×¢ÒâÊÂÏî: Õâ¸ö°æ±¾µÄ MySQL ÂÌÉ«°æÄ¬ÈϲÉÓõÄ×Ö·û¼¯ÊÇ GBK, Èç¹ûÄãÐ޸ijÉÁ˱ðµÄ×Ö·û¼¯, MySQLFront ½«ÏÔʾΪÂÒÂë.
¸ÐлÒÔÏÂÈí¼þ:
MySQL http://www.mysql.com/ GPL ÐÒé
MySQL Front 2.5 http://www.mysqlfront.de/ FreeWare
MySQL ÂÌÉ«°æ http://www.blogjava.net/beansoft/ GPL ÐÒé
MySQL ConnectorJ(¼´ JDBC Çý¶¯) http://dev.mysql.com/downloads/connector/j/ GPL ÐÒé
MySQL JDBC ʾÀý´úÂë http://www.blogjava.net/beansoft/ GPL ÐÒé
PStart http://www.pegtop.net/start/ FreeWare
½ØÍ¼:
Ö÷½çÃæ, Ë«»÷ mysql_start Æô¶¯ MySQL ·þÎñÆ÷
ÄÚÖÿªÔ´ MySQL ¹ÜÀí¹¤¾ß, Ë«»÷Ö÷½çÃæµÄ "MySQL-Front" Æô¶¯
Ë«»÷Ö÷½çÃæ "ÔËÐÐJDBC" ½øÐвåÈëºÍ¶ÁÈ¡Êý¾Ý²âÊÔ, ¿ªÏä¼´ÓÃ, ÎÞÐèÅäÖÃ.
Ïà¹ØÎĵµ£º
ÈçºÎÔÚUltraEditÖÐʹjavaÎļþÓï·¨¸ßÁÁÏÔʾ£¿
1. UltraEdit¹Ù·½ÍøÕ¾ÏÂÔØËùÐèÎļþ¸ñʽµÄÓï·¨·½, http://www.ultraedit.com/downloads/extras.html£¬Ñ¡ÔñjavaÏÂÔØ¡£
2. Ñ¡Ôñ“¸ß¼¶”->“ÅäÖÔ
3. Ñ¡Ôñ“±à¼Æ÷ÏÔʾ”->“Óï·¨¼ÓÁÁ”£¬µã»÷“ ......
ÔÚJava
ÐéÄâ»úÖУ¬±»¼ÓÔØÀàÐ͵ÄÐÅÏ¢¶¼±£´æÔÚ·½·¨ÇøÖС£ÕâЩÐÅÏ¢ÔÚÄÚ´æÖеÄ×éÖ¯ÐÎʽÓÉÐéÄâ»úµÄʵÏÖÕß¶¨Ò壬±ÈÈ磬ÐéÄâ»ú¹¤×÷ÔÚÒ»¸ö“little- endian”
µÄ´¦ÀíÆ÷ÉÏ£¬Ëû¾Í¿ÉÒÔ½«ÐÅÏ¢±£´æÎª“little-endian”
¸ñʽµÄ£¬ËäÈ»ÔÚJava
ÀàÎļþÖÐËûÃÇÊÇÒÔ“big-endian”
¸ñʽ±£ ´æµÄ¡£Éè ......
/**
* ÏÂÔØÎļþ
* @param filePath --ÎļþÍêÕû·¾¶
* @param response --HttpServletResponse¶ÔÏó
*/
public static void downloadFile(
String filePath,
javax.servlet.http.HttpServletResponse response) {
String fileName = ""; //ÎļþÃû£¬Êä³öµ½Óû§µÄÏÂÔØ¶Ô»°¿ò
//´ÓÎļþÍêÕû·¾¶ÖÐÌáÈ¡ÎļþÃû£¬²¢½øÐбà ......
Ê×ÏÈÐèÒªÖªµÀµÄÊÇ£¬MP3ÎļþµÄÎļþÐÅÏ¢¶¼·ÅÔÚÎļþ×îºóµÄ128¸ö×Ö½ÚÀïÃæ£¬Õâ128¸ö×Ö½Ú·Ö±ð´æ´¢µÄÐÅÏ¢ÈçÏ£º
char Header[3]; /* ±êǩͷ±ØÐëÊÇ"TAG"·ñÔòÈÏΪûÓбêÇ© */
char Title[30]; /* ±êÌâ */
char Artist[30]; /* ×÷Õß&n ......