?? backdb.java
字號:
package swing;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import swing.Datetime;
import com.zh.conpool.Condata;
import java.sql.Connection;
//import javax.servlet.http.HttpServlet;
public class backdb extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
//Initialize global variables
public void init() throws ServletException {
}
//Process the HTTP Post request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
Datetime dat=new Datetime();
Condata con=new Condata();
Connection conn=null;
try{
con.getConnection();
}catch(Exception e){
System.out.println(e.getStackTrace());
}
String times=dat.toDate();
String path=request.getRealPath("backdb/")+"\\"+times+".sql'";
String sql1="backup database db_manp to disk='";
String sql=sql1+path;
out.println("<html>");
out.println("<head><title>backdb</title></head>");
out.println("<body bgcolor=\"#ffffff\">");
int rs=0;
try{
rs=con.executeUpdate(sql);
out.println("<p>備份成功！</p>");
}catch(Exception ee){
System.out.println(ee.getStackTrace());
out.println("<p>備份失敗！！</p>");
}
if(rs>0){
}else{
}
out.println("</body></html>");
}
//Clean up resources
public void destroy() {
}
}?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -