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
Ïà¹ØÎĵµ£º
ÔÚÓ¦ÓÃÖУ¬ÎÒÃdz£³£ÐèÒªThread»º³å³ØÀ´×öһЩÊÂÒÔÌá¸ß³ÌÐòµÄЧÂʺͲ¢·¢ÐÔ¡£±¾ÎÄÑÝʾÁËÈçºÎÀûÓÃQueueÕâÖÖÊý¾Ý½á¹¹ÊµÏÖÒ»¸ö¼òµ¥µÄThread»º³å³Ø¡£
Ò»¸öThread»º³å³Ø¿ÉÒÔÉè¼Æ³ÉÒÔÏÂÕâÑù£º»º³å³ØÓɼ¸¸ö¹¤×÷ThreadºÍÒ»¸öQueue×é³É£¬Client¸ºÔð°ÑÈÎÎñ·Åµ½QueueÀïÃæ£¨put·½·¨£©£¬¶ø¹¤×÷Thread¾ÍÒÀ´ÎÈ¡³öÕâЩÈÎÎñ²¢Ö´ÐÐËüÃÇ£¨get· ......
Äã¾õµÃ×Ô¼ºÊÇÒ»¸öJavaר¼ÒÂð£¿ÊÇ·ñ¿Ï¶¨×Ô¼ºÒÑ¾È«ÃæÕÆÎÕÁËJavaµÄÒì³£´¦Àí»úÖÆ£¿ÔÚÏÂÃæÕâ¶Î´úÂëÖУ¬ÄãÄܹ»Ñ¸ËÙÕÒ³öÒì³£´¦ÀíµÄÁù¸öÎÊÌâÂð£¿
OutputStreamWriter out = ...;
java.sql.Connection conn = ...;
try { // ¢É
Statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery("select uid, nam ......
Á÷ ¾ÍÊÇÒ»¸ù¹Ü×Ó¡£Á÷×ÜÊdzɶԳöÏÖ¡£
·ÖΪÊäÈëÁ÷¡¢Êä³öÁ÷¡£Ëĸö×î½ü±¾µÄ³éÏóÀàÊÇ£ºinputstream,outputstream.ReaderÓëwriter.ǰÕßÊÇ×Ö½ÚÁ÷£¬ºóÕßÊÇ×Ö·ûÁ÷¡£
·ÖΪ ×Ö½ÚÁ÷(8bit)¡¢×Ö·ûÁ÷(16bit)¡£
·ÖΪ½ÚµãÁ÷£¨Ö±½Ó°Ñ¹Ü×ӷŵ½Ä¿±êÉÏ£©£¬´¦ÀíÁ÷£¨°Ñ¹Ü×Ó°ü×°´¦Àí£¬Èç
bufferedwriterÓëbufferedreader
£©
new FileOutputStr ......
//´úÂë¾¹ý±àÒ룬ÔËÐУ¬Ö¤Ã÷¿ÉÒÔÔËÐÐ
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.io.*;
import java.net.*;
import javax.swing.filechooser.FileFilter;
public class Ftp extends JLabel
{
private JButton openButton;
privat ......
À´Ô´£ºhttp://cj1240.zhmy.com/archives/2008/148832.html
JAVA ÖеÄIOÁ÷
Ò»¡¢Á÷µÄ¸ÅÄî
Á÷(stream)µÄ¸ÅÄîÔ´ÓÚUNIXÖйܵÀ(pipe)µÄ¸ÅÄî¡£ÔÚUNIXÖУ¬¹ÜµÀÊÇÒ»Ìõ²»¼ä¶ÏµÄ×Ö½ÚÁ÷£¬ÓÃÀ´ÊµÏÖ³ÌÐò»ò½ø³Ì¼äµÄͨÐÅ£¬»ò¶ÁдÍâΧÉ豸¡¢ÍⲿÎļþµÈ¡£
&nb ......