J2EE下的oracle数据库备份方法-阿里云开发者社区

1./**

* @Description : 实现数据库的备份

* @since ： JDK1.5

* @date （开发日期）： 2009 - 06 - 10

* @ 注意事项 ：数据库备份文件放在服务器上 , 路径在 Constant 里设置，如希望正确使用，需要导入相关 jar 包

public class BackUpDataBaseAction extends Action {

static Logger logger = Logger.getLogger(BackUpDataBaseAction. class);

public ActionForward execute(ActionMapping actionMapping,

ActionForm actionForm, HttpServletRequest httpServletRequest,

HttpServletResponse httpServletResponse) {

Calendar cDay = Calendar.getInstance();

SimpleDateFormat myf = new SimpleDateFormat( "yyyyMMddHHmmss" );

String day = myf.format(cDay.getTime());

// 获得 Constant 中定义的数据库备份文件存放路径，格式如：

// public static final String DataBaseBackUpPath = "D:\\sOADB\\";

String outputFile = Constant.DataBaseBackUpPath;

// 如果服务器端硬盘上不存在 outputFile 目录，则创建这个目录

File mydir = new File(outputFile);

if (!(mydir.exists())) {

mydir.mkdir();

}

// 备份文件名

String fileName = "soa" + day + ".dmp" ;

// 将备份好的数据库文件放在服务器端的 outputFile 目录下

// 得到数据库的连接信息

// 得到物理路径 , 取得 applicationContext.xml 中数据库定义，

// 如 url,usrname,password ， O/R 映射文件等内容

ServletContext m_application = this .getServlet().getServletContext();

String path = m_application.getRealPath( "/" );

String filename = path + "WEB-INF\\applicationContext.xml" ;

WriteXMLWithDom wxf = new WriteXMLWithDom();

String[] str = wxf.GetOralAddrWithDom(filename);

if (str[0].equalsIgnoreCase( "" )) {

return actionMapping.findForward( "failure" );

}

// str[1] 用户名 ,[2] 用户密码 ,

// 服务器地址 ,[0]

String command = "exp " +str[1]+ "/" +str[2]+ "@" +str[0].substring(str[0].lastIndexOf( ':' )+1)+ " file=" + outputFile+ fileName;

Runtime rt = Runtime.getRuntime();

// Process process=null;

try {

// process=rt.exec(command);

rt.exec(command);

// process.waitFor();

// 假等待一下 , 目的是让其能在文件列表中列出 , 可以 process.destroy() 得到

Thread.sleep(5000);

} catch (Exception e) {

// 捕捉异常

String errorSORT = Constant.errorBeifen;

httpServletRequest.setAttribute( "ERRORSORT" , errorSORT);

String error = " 数据库备份操作失败，请稍候再试！ " ;

httpServletRequest.setAttribute( "PUBLICINFERROR" , error);

return actionMapping.findForward( "warning" );

}

// p.destroy();

logger .warn(StringUtil.getLogString(((UserInfo) httpServletRequest

.getSession().getAttribute(Constant.USER)).getUserAccount(),

" 执行了数据库备份操作 " ));

return actionMapping.findForward( "success" );

}

2.获取application中关于数据库定义的信息，包括用户名，密码，url，.hbm.xml文件等。

package com.gao.sys;

import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStreamWriter;

import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.ParserConfigurationException;
import javax.xml.transform.OutputKeys;
import javax.xml.transform.Result;
import javax.xml.transform.Source;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerConfigurationException;
import javax.xml.transform.TransformerException;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;

import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
import org.w3c.dom.Text;
import org.xml.sax.SAXException;

public class WriteXMLWithDom {
public WriteXMLWithDom() {
}

public int CallWriteXMLWithDom(String fname, String tablename) {
int returnValue = 0;
try {

   File file = new File(fname);
   BufferedInputStream bufferedInputStream = new BufferedInputStream(
     new FileInputStream(file));
   DocumentBuilderFactory factory = DocumentBuilderFactory
     .newInstance();
   DocumentBuilder parser = factory.newDocumentBuilder();

InputStream instr = new FileInputStream(fname);

   Document doc = parser.parse(instr);
   // 根节点
   NodeList nodeList = doc.getElementsByTagName("beans");
   for (int b = 0; b < nodeList.getLength(); b++) {
    Node book = nodeList.item(b);
    for (Node bean = book.getFirstChild(); bean != null; bean = bean
      .getNextSibling()) {
     // bean节点
     if (bean.getNodeName().equals("bean")) {

      for (int i = 0; i < bean.getChildNodes().getLength(); i++) {
       // property节点
       Node pro = bean.getChildNodes().item(i);

       if (pro.getAttributes() != null
         && pro.getAttributes().getNamedItem("name") != null) {
        if (pro.getAttributes().getNamedItem("name")
          .getNodeValue().equals(
            "mappingResources")) {
         // list节点
         Node listn = pro.getFirstChild()
           .getNextSibling();

         Element elistn = (Element) listn;
         Element newvalue = doc
           .createElement("value");
         Text newtest = doc
           .createTextNode("com/gao/data/bean/"
             + tablename + ".hbm.xml");
         newvalue.appendChild(newtest);
         elistn.appendChild(newvalue);

        }
       }
      }
     }
    }
   }

   // }
   FileOutputStream outStream = new FileOutputStream(fname);
   OutputStreamWriter outWriter = new OutputStreamWriter(outStream,
     "UTF-8");

   try {
    // Prepare the DOM document for writing
    Source source = new DOMSource(doc);

// Prepare the output file
Result result = new StreamResult(outWriter);

    // Write the DOM document to the file
    Transformer xformer = TransformerFactory.newInstance()
      .newTransformer();
    xformer.setOutputProperty(OutputKeys.ENCODING, "UTF-8");
    // xformer.setOutputProperty(OutputKeys.DOCTYPE_SYSTEM,"dtd/spring-beans.dtd");
    // xformer.setOutputProperty(OutputKeys.DOCTYPE_PUBLIC,"-//SPRING//DTD
    // BEAN//EN");
    xformer.transform(source, result);

   } catch (TransformerConfigurationException e) {
    e.printStackTrace();
   } catch (TransformerException e) {
    e.printStackTrace();
   }

   try {
    outWriter.close();
    outStream.close();
    returnValue = 1;
   } catch (IOException e) {
    // TODO 自动生成 catch 块
    e.printStackTrace();
   } finally {
    return returnValue;
   }
  } catch (ParserConfigurationException e) {
   e.printStackTrace();
  } catch (FileNotFoundException e) {
   e.printStackTrace();
  } catch (SAXException e) {
   e.printStackTrace();
  } catch (IOException e) {
   e.printStackTrace();
  } finally {
   return returnValue;
  }
}

public int DeleteNodeFromXMLWithDom(String fname, String tablename) {
int returnValue = 0;
try {

InputStream instr = new FileInputStream(fname);

      for (int i = 0; i < bean.getChildNodes().getLength(); i++) {
       // property节点
       Node pro = bean.getChildNodes().item(i);

Element elistn = (Element) listn;

         Node valuen = elistn.getFirstChild();

         int k = valuen.getChildNodes().getLength();
         for(int j=0;j<elistn.getChildNodes().getLength()-1;j++){
          valuen=valuen.getNextSibling();
          if(valuen.getTextContent().contains(
            tablename)){
           listn.removeChild(valuen);
           break;
          }


         }

        }
       }
      }
     }
    }
   }

   // }
   FileOutputStream outStream = new FileOutputStream(fname);
   OutputStreamWriter outWriter = new OutputStreamWriter(outStream,
     "UTF-8");

   try {
    // Prepare the DOM document for writing
    Source source = new DOMSource(doc);

// Prepare the output file
Result result = new StreamResult(outWriter);

   } catch (TransformerConfigurationException e) {
    e.printStackTrace();
   } catch (TransformerException e) {
    e.printStackTrace();
   }

public String[] GetOralAddrWithDom(String fname) {
String[] str = { "", "", "" };
try {

InputStream instr = new FileInputStream(fname);

      for (int i = 0; i < bean.getChildNodes().getLength(); i++) {
       // property节点
       Node pro = bean.getChildNodes().item(i);

       if (pro.getAttributes() != null
         && pro.getAttributes().getNamedItem("name") != null) {
        if (pro.getAttributes().getNamedItem("name")
          .getNodeValue().equals("url")) {
         str[0] = pro.getAttributes().getNamedItem(
           "value").getNodeValue();

        }
        if (pro.getAttributes().getNamedItem("name")
          .getNodeValue().equals("username")) {
         str[1] = pro.getAttributes().getNamedItem(
           "value").getNodeValue();
        }
        if (pro.getAttributes().getNamedItem("name")
          .getNodeValue().equals("password")) {
         str[2] = pro.getAttributes().getNamedItem(
           "value").getNodeValue();
        }
       }
      }
     }
    }
   }

  } catch (ParserConfigurationException e) {
   e.printStackTrace();
  } catch (FileNotFoundException e) {
   e.printStackTrace();
  } catch (SAXException e) {
   e.printStackTrace();
  } catch (IOException e) {
   e.printStackTrace();
  } finally {
   return str;
  }
}
}

大家可以比较阅读的文章;

http://www.xici.net/b785710/d67687082.htm

http://hi.baidu.com/gwc1148/blog/item/0c67f5bfa502550e19d81fac.html

http://baike.baidu.com/view/1302941.htm

本文转自 gaochaojs 51CTO博客，原文链接：http://blog.51cto.com/jncumter/166362，如需转载请自行联系原作者

J2EE下的oracle数据库备份方法

热门文章

最新文章

相关课程

相关电子书

相关实验场景

推荐镜像