ÔËÓÃjava, jCom À´ дexcelÎļþ£¨IDispatch£©·½·¨¶þ
package sample1;
import java.io.File;
import jp.ne.so_net.ga2.no_ji.jcom.IDispatch;
import jp.ne.so_net.ga2.no_ji.jcom.JComException;
import jp.ne.so_net.ga2.no_ji.jcom.ReleaseManager;
/**
* ʹÓÃjComʵÏÖдexcelÎļþµÄÁíÒ»ÖÖ·½Ê½£¨IDispatch£©
* @author steve_wang_victor
*
*/
public class Tt {
private static ReleaseManager rm = null;
private static IDispatch xlsApp = null;
private static IDispatch excel = null;
private static IDispatch workbook = null;// ¹¤×÷±¡
private static IDispatch sheets = null;// ËùÓй¤×÷±í£¨ÊÇÒ»¸öÊý×éÐÎʽ£©
private static IDispatch sheet = null;// µ¥¸ö¹¤×÷±í
private static IDispatch currentSheet = null;// µ±Ç°»î¶¯µÄ¹¤×÷±í
/**
* @param args
*/
public static void main(String[] args) {
rm = new ReleaseManager();// ²éÕÒJCOMÄܹ»²Ù×÷µÄ×é¼þ
try {
xlsApp = new IDispatch(rm, "Excel.Application");
Ïà¹ØÎĵµ£º
xmlÎļþÄÚÈÝ£º
<?xml version="1.0" encoding="UTF-8"?>
<channels>
<channel switchTime="20080101000101" k="1.07" n="6" s="55" channelId="0404" channelName="xxxx.xxxx.xxx.cn"/>
<channel switchTime="20080301010101" k="1.07" n="6" s="55" channelId="0405" channelName="xxx ......
javaÊý¾Ý¿âÁ¬½Ó³Ø
javaÊý¾Ý¿âÁ¬½Ó³Ø
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Enumeration;
import java.util.Vector;
......
/**
* Title: ConnectPool.java
* Description: Á¬½Ó³Ø¹ÜÀíÆ÷
* Copyright: Copyright (c) 2002/12/25
* Company:
* Author :
* Version 2.0
*/
import java.io.*;
import java.sql.*;
import java.util.*;
import java.util.Date;
/**
* ¹ÜÀíÀàDBConnectionManagerÖ§³Ö¶ÔÒ»¸ö»ò¶à¸öÓÉÊôÐÔÎļ ......
×òÌ쿪ʼ¾ÍÒµ°àµÄ¿Î³Ì¾Í¿ªÊ¼ÁË£¬Ç°¼¸ÌìÕÅТÏéÀÏʦ¸øÎÒÃǽ²ÁËjavaµÄһЩ»ù´¡µÄ¶«Î÷£¬ÕÅÀÏʦµÄ¿Î֪ʶÁ¿´ó£¬ÉîÈëdz³ö£¬ÁîÈË»ñÒæ·Ëdz£¬½ÓÏÂÀ´¾ÍÓÃÎÒÀí½âµÄ¶«Î÷ÔÚÕâÀïºÍ´ó¼ÒÒ»Æð̽ÌÖһϡ£
sun¹«Ë¾ÔÚjava1.5°æ±¾Ôö¼ÓÁ˲»ÉÙÐÂÌØÐÔ£¬ÀýÈ磺»ù±¾Êý¾ÝÀàÐ͵Ä×Ô¶¯×°ÏäÓë²ðÏä¡¢¿É±ä²ÎÊý¡¢ÔöÇ¿forÑ»·¡¢Ã¶¾Ù¡¢ ......
JavaÓïÑÔµÄÊäÈëÊä³ö¹¦ÄÜÊÇÊ®·ÖÇ¿´ó¶øÁé»îµÄ£¬ÃÀÖв»×ãµÄÊÇ¿´ÉÏÈ¥ÊäÈëÊä³öµÄ´úÂë²¢²»ÊǺܼò½à£¬ÒòΪÄãÍùÍùÐèÒª°ü×°Ðí¶à²»Í¬µÄ¶ÔÏó¡£ÔÚJavaÀà¿âÖУ¬IO²¿·ÖµÄÄÚÈÝÊǺÜÅÓ´óµÄ£¬ÒòΪËüÉæ¼°µÄÁìÓòºÜ¹ã·º:±ê×¼ÊäÈëÊä³ö£¬ÎļþµÄ²Ù×÷£¬ÍøÂçÉϵÄÊý¾ÝÁ÷£¬×Ö·û´®Á÷£¬¶ÔÏóÁ÷£¬zipÎļþÁ÷....±¾ÎĵÄÄ¿µÄÊÇΪ´ó¼Ò×öÒ»¸ö¼òÒªµÄ½éÉÜ¡£
......