Execlµ¼Èënotes JAVA´úÀí
import lotus.domino.*;
import java.io.*;
import java.util.Vector;
import jxl.*;
/*******************************************************************************
* @saveSQMessageToOracle
* @×÷ÕߣºÐ컪Ïé
* @2009Äê10ÔÂ28ÈÕ
* @˵Ã÷£ºExeclÎļþµÄµ¼Èë
******************************************************************************/
public class inputExecl_new extends AgentBase {
public void NotesMain() {
System.out.println("´úÀí¿ªÊ¼");
EmbeddedObject ebd = null;
String srcFile = "";
InputStream is = null;
Workbook wb = null;
Sheet st = null;
try {
Session session = getSession();
AgentContext agentContext = session.getAgentContext();
Document currentDoc = agentContext.getDocumentContext();
Database currentDB = agentContext.getCurrentDatabase();
Database wjkhDB = session.getDatabase(currentDB.getServer(),
"whcg/linkey_weijkh.nsf");
String path = currentDoc.getItemValueString("Path");
View wjkhView = wjkhDB.getView("showtousNo");
Vector vtr = session.evaluate("@AttachmentNames", currentDoc);
srcFile = new String("" + vtr.get(0).toString());
ebd = currentDoc.getAttachment(srcFile);
ebd.extractFile(srcFile);
is = new FileInputStream(srcFile);
wb = Workbook.getWorkbook(is);
if (ebd == null) {
wb.close();
wb = null;
return;
}
if (ebd.getType() != EmbeddedObject.EMBED_ATTACHMENT) {
wb.close();
wb = null;
return;
}
st = wb.getShe
Ïà¹ØÎĵµ£º
×î½üÔËÐгÌÐò£¬ÀÏÊÇÓöµ½ÄÚ´æÒç³öµÄÎÊÌ⣬Out of Memory(ϵͳÄÚ´æ²»×ã)µÄÒì³£¡£×Ðϸ²é×ÊÁÏ£¬ºÃºÃѧϰÁËÒ»ÏÂÐéÄâ»úµÄ¼¸Ö»£¬²ÅÖªµÀ£¬ÕâÊÇÒòΪJavaÐéÄâ»úĬÈÏ·ÖÅäµÄÄÚ´æÖ»ÓÐ64M£¬Èç¹ûÓ¦ÓõıȽϴ󣬳¬³öÁË64M£¬JavaÐéÄâ»ú¾Í»áÅ׳öOutOfMemoryError£¬²¢Í£Ö¹ÔËÐС£ËùÒÔ£¬ ......
×î½üÏîÄ¿½ø¶È±È½Ï»ºÂý£¬³õ²½Ñо¿ÁËÒ»ÏÂOracleµÄ´æ´¢¹ý³Ì£¬½«´úÂëÌù³öÀ´¡£
Ê×ÏÈÏÈÌù³öÀ´OracleµÄ·ÖÒ³·ÖÒ³´æ´¢¹ý³Ì´úÂë°É¡£
1.ÕâÊǰüµÄ´úÂë
create or replace package DB_Oper is
-- Author : LIUBING
-- Created : 2009-10-28 15:01:30
-- Purpose : ²âÊÔOracleµ ......
·´ÉäÊÇJavaÓïÑÔÖкÜÖØÒªµÄÒ»¸ö×é³É²¿·Ö£¬ËùÒԾʹ˻°ÌâÌÖÂÛµÄ×ÊÔ´¿ÉνÊýÖ®²»¾¡£¬ÈÕ³£¿ª·¢Ò²»á¾³£Ê¹Óõ½¹ØÓÚ·´ÉäµÄReflection
API¡£Java5.0
Tiger³öÏÖÒԺ󣬸ü¶Ô·´ÉäAPIÓÐÁËеÄÀ©Õ¹£¬¾¡¹ÜÌÖÂ۵ϰÌâºÜ¶à£¬²»¹ýÎÒ»¹ÊǾõµÃ²»¹»È«Ã棬ÓÈÆäÊǶԷºÐÍÕâÒ»¿é£¬ËùÒÔ¾ÍÎÒËùÖª£¬ÔÙ»¨Á¦Æø×ܽáÒ»·¬
Ê×ÏÈ·´ÉäµÄÈë¿ÚÊÇ´ÓClass¿ ......
jdkÌṩÁËZipÏà¹ØµÄÀà·½±ãµÄʵÏÖѹËõºÍ½âѹËõ¡£Ê¹Ó÷½·¨ºÜ¼òµ¥¡£Ï±߷ֱðÊÇѹËõºÍ½âѹËõµÄ¼òµ¥ÊÂÀý
1¡¢Ñ¹ËõµÄ
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.util.zip.ZipE ......