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" ½øÐвåÈëºÍ¶ÁÈ¡Êý¾Ý²âÊÔ, ¿ªÏä¼´ÓÃ, ÎÞÐèÅäÖÃ.
Ïà¹ØÎĵµ£º
1.Ê÷¼¯TreeSet
TreeSetÀàÔÚjava.util°üÖÐ
Ê÷¼¯ÖеĽáµãÊÇ°´×ÅÆä´æ·ÅµÄÊý¾ÝµÄ×ÖµäÐòÒ»²ãÒ»²ãµØÒÀ´ÎÅÅÁÐ ÔÚͬһ²ãÖеĽáµã´Ó×óµ½ÓÒ°´×ÖµäÐòµÝÔöÅÅÁÐ
A.¹¹Ôì·½·¨£ºTreeSet()
B.³£Ó÷½·¨
& ......
ÏÂÔØ dom4j-1.6.1.jar¡£
1: package org.zzp.common.xml.dom4j;
2:
3: import java.io.FileWriter;
4: import java.io.IOException;
5: import org.dom4j.Document;
6: import org.dom4j.DocumentHelper;
7: import org.dom4j.Element;
8: import org.dom4j.io.OutputFormat;
9: impor ......
/**
* ÏÂÔØÎļþ
* @param filePath --ÎļþÍêÕû·¾¶
* @param response --HttpServletResponse¶ÔÏó
*/
public static void downloadFile(
String filePath,
javax.servlet.http.HttpServletResponse response) {
String fileName = ""; //ÎļþÃû£¬Êä³öµ½Óû§µÄÏÂÔضԻ°¿ò
//´ÓÎļþÍêÕû·¾¶ÖÐÌáÈ¡ÎļþÃû£¬²¢½øÐбà ......
µ±Java³ÌÐò´´½¨Ò»¸öÀàµÄʵÀý»òÕßÊý×éʱ£¬¶¼ÔÚ¶ÑÖÐΪеĶÔÏó·ÖÅäÄÚ´æ¡£ÐéÄâ»úÖÐÖ»ÓÐÒ»¸ö¶Ñ£¬ËùÓеÄÏ̶߳¼¹²ÏíËü¡£
1¡¢À¬»øÊÕ¼¯£¨Garbage Collection£©
À¬»øÊÕ¼¯ÊÇÊÍ·ÅûÓб»ÒýÓõĶÔÏóµÄÖ÷Òª·½·¨¡£ËüÒ²¿ÉÄÜ»áΪÁ˼õÉٶѵÄËéƬ£¬¶øÒƶ¯¶ÔÏó¡£ ......
ÔÚµ±½ñÕâ¸öʱ´ú,ÒªÏëÄܹ»ºÜºÃµÄÉú´æ,¾ÍµÃÓÐ×ã¹»µÃʵÁ¦,ÓÐÄܹ»¿¿µÄסµÄ¼¼Êõ,ÔÚ´óѧѧÁËÁ½Äê°ëµÄÈí¼þ¹¤³Ìרҵ,ÓÐÁ˺ܶàµÄÌå»á,ѧÁ˺ܶàûÓÐÓõĶ«Î÷,ÓÐһЩËäÈ»ÊǺÜÓÐÓÃ,µ±ÊÇÓÖ²»ÊÇÒ»Á½ÄêÄÚÄÜÓõÄÉϵÄ֪ʶ,ËùÒÔÎҾ͵Ã×Ôѧ,ѧʲôÄØ?ѧÓÐʹÓõö«Î÷,Äܹ»ÎªÈÕºóµÄ¹¤×÷ÓõÄÉϵÄ֪ʶ,Õâô³¤Ê±¼äµÄÌå»áºó,ÎÒ·¢Ï ......