【Java开源代码栏目提醒】:以下是网学会员为您推荐的Java开源代码-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() {
}
}