java´úÂëÖ´ÐÐmysqlµÄÊý¾Ý±¸·ÝºÍÅúÁ¿Êý¾Ý²åÈ룡
mysqlÊý¾Ý¿â±¾ÉíÓÐÊý¾Ý±¸·ÝºÍÅúÁ¿Êý¾Ý²åÈëµÄÃüÁjava´úÂë¿ÉÖ´ÐÐÕâЩÃüÁî¡£
°²×°mysqlºó£¬ÐèÒªÉèÖû·¾³±äÁ¿£ºÎҵĵçÄÔÓÒ»÷--ÊôÐÔ--¸ß¼¶--»·¾³±äÁ¿£¬Ôö¼ÓMYSQL_HOME=“mysql°²×°Â·¾¶”£¬È»ºópath=%MYSQL_HOME%\bin
´úÂëÈçÏ£º
import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
public class OperateDb {
private String user;
private String password;
private String filePath;
private String dbip;
//±¸·ÝÊý¾Ý
public void backup() {
try {
Runtime rt = Runtime.getRuntime();
//ÐγÉcmdÃüÁî
String cmd = "mysqldump -u"+user+" -p"+password+" -h"+dbip+" --set-charset=utf8 -t --no-create-info recommend movieinfo";
// µ÷Óà mysql µÄ cmd,ÉèÖõ¼³ö±àÂëΪutf8¡£ÕâÀï±ØÐëÊÇutf8
Process child = rt.exec(cmd);
// °Ñ½ø³ÌÖ´ÐÐÖеĿØÖÆÌ¨Êä³öÐÅϢдÈë.sqlÎļþ£¬¼´Éú³ÉÁ˱¸·ÝÎļþ¡£×¢£ºÈç¹û²»¶Ô¿ØÖÆÌ¨ÐÅÏ¢½øÐжÁ³ö£¬Ôò»áµ¼Ö½ø³Ì¶ÂÈûÎÞ·¨ÔËÐÐ
// ¿ØÖÆÌ¨µÄÊä³öÐÅÏ¢×÷ΪÊäÈëÁ÷
InputStream in = child.getInputStream();
// ÉèÖÃÊä³öÁ÷±àÂëΪutf8¡£ÕâÀï±ØÐëÊÇutf8£¬·ñÔò´ÓÁ÷ÖжÁÈëµÄÊÇÂÒÂë
InputStreamReader xx = new InputStreamReader(in, "utf8");
String inStr;
StringBuffer sb = new StringBuffer("");
String outStr;
// ×éºÏ¿ØÖÆÌ¨Êä³öÐÅÏ¢×Ö·û´®
BufferedReader br = new BufferedReader(xx);
while ((inStr = br.readLine()) != null) {
sb.append(inStr + "\r\n");
}
outStr = sb.toString();
// ÒªÓÃÀ´×öµ¼ÈëÓõÄsqlÄ¿±êÎļþ£º
FileOutputStream fout = new FileOutputStream(filePath);
OutputStreamWriter writer = new OutputStreamWriter(fout, "utf8");
writer.write(outStr);
//ÕâÀïÈç¹ûÓûº³å·½Ê½Ð´ÈëÎļþµÄ»°£¬»áµ¼ÖÂÖÐÎÄÂÒÂ룬ÓÃflush()·½·¨Ôò¿ÉÒÔ±ÜÃâ
writer.flush();
//¹Ø±ÕÊäÈëÊä³öÁ÷
in.close();
xx.close();
br.close();
writer.close();
fout.close();
System.out.println("Êý¾Ý³É¹¦±¸·Ýµ½"+filePath);
} catch (Exception e) {
e.printS
Ïà¹ØÎĵµ£º
ÀàµÄ³õʼ»¯ºÍ¶ÔÏó³õʼ»¯ÊÇ JVM ¹ÜÀíµÄÀàÐÍÉúÃüÖÜÆÚÖзdz£ÖØÒªµÄÁ½¸ö»·½Ú£¬Google ÁËÒ»±éÍøÂ磬ÓйØÀà×°ÔØ»úÖÆµÄÎÄÕµ¹ÊDz»ÉÙ£¬È»¶øÀà³õʼ»¯ºÍ¶ÔÏó³õʼ»¯µÄÎÄÕ²¢²»¶à£¬ÌرðÊÇ´Ó×Ö½ÚÂëºÍ JVM ²ã´ÎÀ´·ÖÎöµÄÎÄÕ¸üÊÇÏÊÓÐËù¼û¡£
±¾ÎÄÖ÷Òª¶ÔÀàºÍ¶ÔÏó³õʼ»¯È«¹ý³Ì½øÐзÖÎö£¬Í¨¹ýÒ»¸öʵ¼ÊÎÊÌâÒýÈ룬½«Ô´´úÂëת»»³É JVM ×Ö½ÚÂëºó£¬ ......
¡¡¡¡¶ÔÓÚ Java ÓïÑÔ¿ª·¢ÈËÔ±À´Ëµ£¬ÐÅÏ¢¹ýÁ¿ÊÇÒ»¸öÕæÕýµÄÎÊÌ⡣ÿ¸öÐÂÈëÐеijÌÐòÔ±¶¼ÒªÃæÁÙÒ»¸öÁîÈËηËõµÄÌôÕ½£ºÒª½øÈëµÄÐÐÒµÊÇÒ»¸ö¾ßÓк£Á¿ÖªÊ¶µÄÐÐÒµ¡£ÒªÁ˽âµÄ¶«Î÷¼òֱ̫¶àÁË¡£¶ÔÓÚÓоÑéµÄÀÏÊÖÀ´Ëµ£¬Çé¿öÖ»ÓÐЩ΢ºÃת¡£ÖªÊ¶Á¿×ÜÔÚÔö´ó£¬½ö½ö¸úÉϽø¶È¾ÍÊÇÒ»¸öÌôÕ½¡£Èç¹ûÓÐÒ»·ÝרҵÈËÊ¿±Ø±¸µÄÊé¼®ºÍÍøÕ¾Áбí¸ÃÓжàºÃ!±¾Îľ ......
ÔÚÓ¦ÓÃÖУ¬ÎÒÃdz£³£ÐèÒªThread»º³å³ØÀ´×öһЩÊÂÒÔÌá¸ß³ÌÐòµÄЧÂʺͲ¢·¢ÐÔ¡£±¾ÎÄÑÝʾÁËÈçºÎÀûÓÃQueueÕâÖÖÊý¾Ý½á¹¹ÊµÏÖÒ»¸ö¼òµ¥µÄThread»º³å³Ø¡£
Ò»¸öThread»º³å³Ø¿ÉÒÔÉè¼Æ³ÉÒÔÏÂÕâÑù£º»º³å³ØÓɼ¸¸ö¹¤×÷ThreadºÍÒ»¸öQueue×é³É£¬Client¸ºÔð°ÑÈÎÎñ·Åµ½QueueÀïÃæ£¨put·½·¨£©£¬¶ø¹¤×÷Thread¾ÍÒÀ´ÎÈ¡³öÕâЩÈÎÎñ²¢Ö´ÐÐËüÃÇ£¨get· ......
ÖйúJavaÅàѵ£¬ÓÈÆäÊDZ±¾©µÄJavaËùν¸ß¶ËÅàѵ£¬ÖÁÉÙÒѾ»ðÁË5ÄêÒÔÉÏÁË£¬×î½üÓÐһЩÏë·¨ºÍ´ó¼Ò·ÖÏíһϡ£
ÏÖÔڱȽÏÓÐÃûµÄJavaÅàѵÓÐ ´ïÄÚ£¬¶«·½±ê×¼£¬ÉÐѧÌ㬴«ÖDz©¿Í£¬Èü¶û¿´ï£¬»¹ÓÐÀ¶µãµÈµÈ°ÉÆäËûÃûÆø²»Ôõô´óÁË£¬¶ÔÁË»¹Óб±´óÇàÄñ ¡£
×îÔçÖªµÀµÄÊDZ±´óÇàÄñ£¬ÉÏ´óѧ¾ÍÖªµÀÕâ¸öÁË ......
¸Ã´úÂëʵÏÖÁËÔÚϵͳÓÒϽǵÄÈÎÎñÀ¸ÖÐÏÔʾ³ÌÐòµÄͼ±ê£¬²¢ÇÒ×îС»¯³ÌÐòºóµ¥»÷ͼ±ê¿ÉÒÔÏÔʾ³öÀ´Õâ¸ö³ÌÐò´°¿Ú
import java.awt.Color;
¡¡¡¡import java.awt.Image;
¡¡¡¡import java.awt.MenuItem;
¡¡¡¡import java.awt.PopupMenu;
¡¡¡¡import java.awt.Toolkit;
¡¡¡¡
¡¡¡¡
¡¡¡¡import javax.swing.JFrame;
¡¡¡ ......