backdb.java

来自「改代码是采用JSP实现的在线办公自动化管理系统」· Java 代码 · 共 58 行

JAVA
58
字号
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() {
  }
}

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?