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
Ïà¹ØÎĵµ£º
×î½üÏîÄ¿½ø¶È±È½Ï»ºÂý£¬³õ²½Ñо¿ÁËÒ»ÏÂOracleµÄ´æ´¢¹ý³Ì£¬½«´úÂëÌù³öÀ´¡£
Ê×ÏÈÏÈÌù³öÀ´OracleµÄ·ÖÒ³·ÖÒ³´æ´¢¹ý³Ì´úÂë°É¡£
1.ÕâÊǰüµÄ´úÂë
create or replace package DB_Oper is
-- Author : LIUBING
-- Created : 2009-10-28 15:01:30
-- Purpose : ²âÊÔOracleµ ......
1. import java.util.*;
2.(A) public class Test
{ public static void main(String[] args)
{
//Éú³É [0-n) ¸ö²»Öظ´µÄËæ»úÊý st ÓÃÀ´±£´æ ......
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 ......
3.Sun HotSpot
¡¡¡¡1.4.1 JVM¶Ñ´óСµÄµ÷Õû
¡¡¡¡Sun HotSpot 1.4.1ʹÓ÷ִúÊÕ¼¯Æ÷£¬Ëü°Ñ¶Ñ·ÖΪÈý¸öÖ÷ÒªµÄÓò£ºÐÂÓò¡¢¾ÉÓòÒÔ¼°ÓÀ¾ÃÓò¡£JvmÉú³ÉµÄËùÓÐжÔÏó·ÅÔÚÐÂÓòÖС£Ò»µ©¶ÔÏó¾ÀúÁËÒ»¶¨ÊýÁ¿µÄÀ¬»øÊÕ¼¯Ñ»·ºó£¬±ã»ñµÃʹÓÃÆÚ²¢½øÈë¾ÉÓò¡£ÔÚÓÀ¾ÃÓòÖÐjvmÔò´æ´¢classºÍmethod¶ÔÏó¡£¾ÍÅäÖöøÑÔ£¬ÓÀ¾ÃÓòÊÇÒ»¸ö¶ÀÁ¢Óò²¢ÇÒ²» ......