1public class AutoBackUpListener implements ServletContextListener{
2
3 private Timer timer;
4
5 public void contextDestroyed(ServletContextEvent arg0) {
6 System.out.println("shut down task.");
7 timer.cancel();
8 }
9
10 public void contextInitialized(ServletContextEvent arg0) {
11 timer = new Timer();
12 System.out.println("begin task.");
13
14 Calendar calendar = Calendar.getInstance();
15 calendar.set(Calendar.HOUR_OF_DAY, 03);
16 calendar.set(Calendar.MINUTE, 30);
17 calendar.set(Calendar.SECOND, 0);
18 Date time = calendar.getTime();
19 timer = new Timer();
20
21 timer.scheduleAtFixedRate(new Beifen(), time, 1000*60*60*24);
22
23 }
24
25 class Beifen extends TimerTask {
26 private String user_name;
27 private String user_psw;
28 private String db_name;
29 private String host_ip;
30 private String user_charset;
31 private String backup_path;
32 private String stmt;
33 public Beifen(){}
34
35 public Beifen(String user_name,String user_psw,String db_name,String host_ip,String user_charset,String backup_path){
36 this.user_name=user_name;
37 this.user_psw=user_psw;
38 this.db_name=db_name;
39
40 if(host_ip==null||host_ip.equals(""))
41 this.host_ip="localhost";
42 else
43 this.host_ip=host_ip;
44
45 if(user_charset==null||user_charset.equals(""))
46 this.user_charset=" ";
47 else
48 this.user_charset=" --default-character-set="+user_charset;
49 this.backup_path=backup_path;
50
51
53 this.stmt="D:\\AppServ\\MySQL\\bin\\mysqldump "+this.db_name+" -h "+this.host_ip+" -u"+this.user_name+" -p"+this.user_psw
54 +this.user_charset+" --result-file="+this.backup_path;
55 }
56
57 public boolean backup_run(){
58 boolean run_result=false;
59 try{
60 Runtime.getRuntime().exec(this.stmt);
61 run_result=true;
62 }catch(Exception e){
63 e.printStackTrace();
64 }finally{
65 return run_result;
66 }
67 }
68
69 @Override
70 public void run() {
71 Beifen backup=new Beifen("root","root","tansuo_mobile",null,"utf8","d:\\tansuo_moblie.sql");
72 boolean result=backup.backup_run();
73 if(result)
74 System.out.println("备份成功");
75 }
76
77 }
78
79
80}
使用jsp 流从服务器下载该sql文件:
Java代码
81
82<%@ page language="java" pageEncoding="utf-8"%>
83<%@ page import="java.io.OutputStream,java.io.File,java.io.FileInputStream"%>
84<%@page import="java.io.PrintWriter"%>
85<html>
86 <head>
87
88 <title>JSP流文件下载</title>
89
90 <meta http-equiv="pragma" content="no-cache">
91 <meta http-equiv="cache-control" content="no-cache">
92 <meta http-equiv="expires" content="0">
93 <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
94 <meta http-equiv="description" content="This is my page">
95
96 </head>
97
98 <body>
99 <%
100 response.reset();
101 OutputStream o =response.getOutputStream();
102 byte b[]=new byte[500];
103 String path = "d:\\tansuo_moblie.sql";
104 String myName = "数据库备份.sql";
105
106
107
108
109
110
111
112
113
114 File fileLoad=new File(path);
115 response.reset();
116 response.setCharacterEncoding("GBK");
117 request.setCharacterEncoding("GBK");
118
119 response.setContentType("application/octet-stream; charset=GBK");
120 response.addHeader("Content-Disposition", "attachment; filename=\"" + new String(myName.getBytes("gb2312"),"iso8859-1") + "\"");
121
122 long fileLength=fileLoad.length();
123 String length=String.valueOf(fileLength);
124 response.setHeader("Content_Length",length);
125 FileInputStream in=new FileInputStream(fileLoad);
126 int n=0;
127 while((n=in.read(b))!=-1){
128 o.write(b,0,n);
129 }
130
131 in.close();
132 o.close();
133
134 %>
135 </body>
136</html>