ych

通過exp導出與imp導入進行數(shù)據(jù)的備份轉移：
exp命令：
1其中一是將Test（與某一數(shù)據(jù)庫對應的oracle服務名）數(shù)據(jù)庫進行整體導出
2將屬于用戶ly的所有表導出
3將表grid1，與grid2導出
d：test.dmp是導出的文件地址

imp命令：
ignore=y表示如果被導入的數(shù)據(jù)庫中某個表已經存在就忽略不導入那個表
3表示只導入grid1這個表

在導入導出前要先測試下對應的數(shù)據(jù)庫是否是通的：tnsping test來測試，同樣test是服務名
所有命令可在cmd下執(zhí)行

http://blog.csdn.net/techyang/archive/2005/08/09/448677.aspx(luanfengxia/arc/2006/05/20/746951.aspx)

 public ActionForward add(ActionMapping mapping, ActionForm form,
   HttpServletRequest request, HttpServletResponse response) throws Exception {
        String encoding = request.getCharacterEncoding();
        if ((encoding != null) && (encoding.equalsIgnoreCase("utf-8")))
        {
            response.setContentType("text/html; charset=gb2312");//如果沒有指定編碼，編碼格式為gb2312
        }
        NodeForm theForm = (NodeForm) form;
        String nodename=theForm.getNodename();
        String note=theForm.getNote();
        FormFile file = theForm.getTheFile1();//取得上傳的文件
        FormFile file2=theForm.getTheFile2();
        FormFile file3=theForm.getTheFile3();
        Session session=null;
        String forward="";
        try
        {
            /*
             * 取當前系統(tǒng)路徑
             */
            String filePath = this.getServlet().getServletContext()
            .getRealPath("/");
            System.out.println("---------------------------------------"+filePath);
            if(file.getFileSize()!=0){
            ByteArrayInputStream stream = (ByteArrayInputStream) file.getInputStream();//把文件讀入
          
            //ByteArrayOutputStream baos = new ByteArrayOutputStream();
          
            /*
             * 建立一個上傳文件的輸出流
             */
            OutputStream bos = new FileOutputStream(filePath +
                    "UploadFiles\\"+file.getFileName());
            request.setAttribute("fileName",filePath + "/"
                    + file.getFileName());
            int bytesRead = 0;
            byte[] buffer = new byte[8192];
            while ((bytesRead = stream.read(buffer, 0, 8192)) != -1)
            {
                bos.write(buffer, 0, bytesRead);//將文件寫入服務器
            }          
            bos.close();
            stream.close();
            }if(file2.getFileSize()!=0){
            ByteArrayInputStream stream2 = (ByteArrayInputStream) file2.getInputStream();
            OutputStream bos2 =  new FileOutputStream(filePath +
                    "UploadFiles\\"+file2.getFileName());//建立一個上傳文件的輸出流
            int bytesRead2 = 0;
            byte[] buffer2 = new byte[8192];
            while ((bytesRead2 = stream2.read(buffer2, 0, 8192)) != -1)
            {
                bos2.write(buffer2, 0, bytesRead2);//將文件寫入服務器
            }          
            bos2.close();
            stream2.close();
            }if(file3.getFileSize()!=0){
            ByteArrayInputStream stream3 = (ByteArrayInputStream) file3.getInputStream();//把文件讀入
        OutputStream bos3 =  new FileOutputStream(filePath +
                "UploadFiles\\"+file3.getFileName());//建立一個上傳文件的輸出流
        int bytesRead3 = 0;
        byte[] buffer3 = new byte[8192];

        while ((bytesRead3 = stream3.read(buffer3, 0, 8192)) != -1)
        {
            bos3.write(buffer3, 0, bytesRead3);//將文件寫入服務器
        }          
        bos3.close();
        stream3.close();
        }
  Configuration config = new Configuration().configure();
  SessionFactory factory = config.buildSessionFactory();
     session = factory.openSession();
        Transaction transaction = session.beginTransaction();
        Node node=new Node();
        node.setNodeName(nodename);
        node.setXsdName(file.getFileName());
        node.setXslName(file2.getFileName());
        node.setXhtmlName(file3.getFileName());
        node.setNote(note);
        session.save(node);
  session.flush();
  session.clear();
  forward="display";
        transaction.commit();
        }
        catch (Exception e)
        {
         forward="error";
            System.err.print(e);
            e.printStackTrace();
        }
   
  finally{
   session.close();
   }
        return mapping.findForward(forward);
 }