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
Ïà¹ØÎĵµ£º
Ò»£º×¼±¸ www.savarese.org download
1. rocksaw-1.0.0-src.tar.gz
2. vserv-tcpip-0.9.2-src.tar.gz
¶þ£º±àÒëÔ´ÎļþµÃµ½jar°ü ʹÓÃAnt
1. build vserv-tcpip-0.9.2-src
ÔÚvserv-tcpip-0.9.2Ŀ¼ÏÂÃæ½¨Ò»¸ötestsĿ¼£¬È»ºóÔÚcmd´°¿ÚϽøÈë ......
¸Õ¸ÕѧϰÁ˼̳Ð,¼Ç¼ÏÂÎÒ¾õµÃ¼Ì³ÐÖÐÎÒÃÇÓ¦¸Ã×¢ÒâµÄÎÊÌâ. ʲô¼Ì³ÐÊÇʹÓÃextendsÀ´ÊµÏÖµÄ,ÕâÖÖÎÊÌâ¼Ç¼ÏÂÀ´ÊDz»ÊÇÓе㽵µÍ¸çµÄIQÄØ?¹þ¹þ,ËùÒÔÕâЩ»ù´¡Óï·¨¾Í²»¼Ç¼¿©.ÏÂÃæ¿ªÊ¼°É:
1.ÔÚѧϰjavaÖÐ,ÎÒÃÇÓ¦¸ÃÒªÖªµÀËùÓÐÀàµÄ³¬Àà¶¼ÊÇobjectÀà,ÕâÑù˵µÄÒâ˼¾ÍÊÇ˵,ËùÓеÄÀà¶¼°üº¬ÁË ......
1. Ò»¸öjavaÔ´ÎļþÖ»ÓÐÒ»¸öpublicÀàÇÒÀàÃûÓëÎļþÃûÒ»Ö¡£×¢£ºÒ»¸ö¿ÉÔËÐеÄjavaÓ¦ÓóÌÐòÓ¦ÓÐÒ»¸ömain·½·¨£¬ÇÒ¸ñʽ¹Ì¶¨£¬µ«²»Ò»¶¨ÔÚpublicÀàÖС£
2. packageÓï¾äÖ»ÄÜÓÐÒ»¸öÇÒ·ÅÔÚ³ÌÐòµÄµÚÒ»ÐС£
3. ÕûÊýÔÚÄÚ´æÖÐʽ°´ÕÕÆä²¹ÂëÀ´´æ´¢µÄ£¬ÕýÊýµÄ²¹Âë=ÔÂ룬¸ºÊýµÄ²¹Âë=ÔÂëÈ¡·´¼Ó1 £¬charÎÞ·ûºÅ루0~65535£©
4. Ç¿ÖÆ ......
¶ÔÓÚJava×ÀÃæÓ¦ÓÃÀ´Ëµ£¬±È½Ï·³ËöµÄ¾ÍÊǰ²×°²¿ÊðÎÊÌ⣬È磺¿Í»§¶ËÊÇ·ñ°²×°ÓÐjre¡¢jre°æ±¾¡¢jreÔÚÄÄÀïÏÂÔØ¡¢ÈçºÎÓÃjreÆô¶¯JavaÓ¦Óõȵȡ£²»ÒªËµ¸Õ½Ó´¥µçÄÔµÄÈË£¬¾ÍËãÊDZȽÏÊìϤµçÄÔ£¬Èç¹ûûÓнӴ¥¹ýJava£¬Ãæ¶ÔÒ»¸öJavaÓ¦Óã¬ÈçºÎÔÚWindowsÏÂÆô¶¯Ëü£¬¹À¼Æ¶¼»áÕÛÌÚ°ëÌì¡£ËùÒÔÕâ¸öÊǵ¼ÖÂJava×ÀÃæÓ¦Óñ»Ò»Ð©ÈËËùÌÖÑáµÄ×î´óÔÒò£¬J ......
¸Ã´úÂëʵÏÖÁËÔÚϵͳÓÒϽǵÄÈÎÎñÀ¸ÖÐÏÔʾ³ÌÐòµÄͼ±ê£¬²¢ÇÒ×îС»¯³ÌÐòºóµ¥»÷ͼ±ê¿ÉÒÔÏÔʾ³öÀ´Õâ¸ö³ÌÐò´°¿Ú
import java.awt.Color;
¡¡¡¡import java.awt.Image;
¡¡¡¡import java.awt.MenuItem;
¡¡¡¡import java.awt.PopupMenu;
¡¡¡¡import java.awt.Toolkit;
¡¡¡¡
¡¡¡¡
¡¡¡¡import javax.swing.JFrame;
¡¡¡ ......