📄 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() {
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -