ÔËÓÃ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");
Ïà¹ØÎĵµ£º
ÈçºÎ×ÔѧjavaѸËÙ³ÉΪjava¸ßÊÖ
ÒªÏëѧºÃJava£¬Ê×ÏÈÒªÖªµÀJavaµÄ´óÖ·ÖÀà¡£ÎÒÃÇÖªµÀ£¬×Ô´ÓSunÍÆ³öJavaÒÔÀ´£¬¾ÍÁ¦Í¼Ê¹Ö®ÎÞËù²»°ü£¬ËùÒÔJava·¢Õ¹µ½ÏÖÔÚ£¬°´Ó¦ÓÃÀ´·ÖÖ÷Òª·ÖΪÈý´ó¿é£ºJ2SE,J2MEºÍJ2EE,ÕâÒ²¾ÍÊÇSunONE(Open NetEnvironment)Ìåϵ¡£J2SE¾ÍÊÇJava2µÄ±ê× ......
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;
......
JavaÖз½·¨ÃüÃûÒ»°ãÊÇ£º¶¯´Ê/¶¯´ÊÐÔ´Ê×飬Ê××ÖĸСд£¬Öм䵥´ÊµÄÊ××Öĸ´óд£¬ÆäËü×ÖĸСд¡£
¾¡Á¿Ó¦Óüòµ¥µÄ¡¢³£Óõĵ¥´Ê£¬Ê¾Àý:
get/set first/last
add/remove& ......
RXTXÊÇÒ»¸ö¿ªÔ´°ü£¬Ö÷ÒªÊÇÔÚCOMM¿ªÔ´°üÖÐ×öÀ©ÕÅ£¬ÒÔǰµÄCOMM°üÖ»ÄÜÔÚWINDOWSÏÂÃæ¶Ô´®¿Ú»ò²¢¿Ú×ö²Ù×÷£¬À©³äºóµÄRXTX¿ÉÒÔÔÚLINUXºÍMAC϶Դ®¿ÚºÍ²¢¿Ú×ö²Ù×÷¡£ ÏÖÔÚ¿çÆ½Ì¨£º
ÔÚRXTXÍøÕ¾ÏÂÔØJAR°üºÍ¶¯Ì¬¿â
http://users.frii.com/jarvi/rxtx/download.html
ÏÂÔØºóÅäÖû·¾³
Windows
¿½±´RXTXcomm.jar Îļþ ......
1. Èç¹ûÒѾ֪µÀij¸öµØµãµÄÊ±Çø£¬Ä꣬Ô£¬ÈÕ£¬Ê±£¬·Ö£¬Ã룬ϣÍûµÃµ½×ª»»ºóµÄ±¾ÏµÍ³Ê±¼ä£¬¿ÉÒÔ²ÉÓÃÈçÏµķ½·¨£º
·½·¨£º¼ÙÉèÊ±ÇøÊÇGMT+08:00,£¬ÄêÊÇ2009Ä꣬ÔÂÊÇ11Ô£¬ÈÕÊÇ7ÈÕ£¬Ê±ÊÇ10ʱ£¬·ÖÊÇ50·Ö£¬ÃëÊÇ30¡£
public class Time {
public static void main(String[] args) {
TimeZone tz = Tim ......