Chapter 1. Quick Start

Index:

  1. What Is the HXTT Excel?
  2. Follow Me

What Is the HXTT Excel?

HXTT Excel provides a type 4 JDBC driver for Microsoft Excel (MS Excel) version from 5.0, 95, 97, 98, 2000, 2001, 2002, 2003, to 2004. It supports JDBC1.2, JDBC2.0, and JDBC3.0. It supports Personal Java, JDK1.0.X, JDK1.1.X, JDK1.2.X, JDK1.3.X, JDK1.4.X and JDK1.5.X. It supports all transactions level of READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. It supports JBuilder's Database Pilot, Oracle's JVM, JDeveloper 10G, Dreamweaver UltraDev, Dreamweaver ColdFusion, ObJectRelationalBridge, DBVisualizer, iSQL-Viewer, AquaDataStudio, Sunopsis, MySQL Migration Toolkit, Tomcat, vqServer, Hibernate, SQuirreL SQL Client, and DbEdit Database Utilites for Eclipse Platform. It supports XOPEN SQLState, RMI, Jini, JNDI, and serialization. It supports { UNION | INTERSECT | EXCEPT | MINUS } [ ALL ] query , INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, NATURAL JOIN, CROSS JOIN, self join, multiple-row VALUES table, PIVOT table, UNPIVOT table, and subquery which includes single-row subquery, multirow subquery, multiple-column subquery, inline views, and correlated subquery. The current version of the HXTT Excel packages are available here:

Follow Me

First, you need to download JDK 1.3.X, 1.4.X, or 1.5.X from www.javasoft.com if you use Excel JDBC 3.0 package(Excel_JDBC30.jar). You can download JDK1.2.X too if you use Excel JDBC 2.0 package(Excel_JDBC20.jar). You can download JDK1.1.X too if you use Excel JDBC 1.2 package(Excel_JDBC12.jar).

Secondly, please add Excel_JDBC30.jar, Excel_JDBC20.jar or Excel_JDBC12.jar to your Java class path, for instance, "SET CLASSPATH=c:\javalib\Excel_JDBC20.jar;%classpath%". You can also use "java -classpath c:\javalib\Excel_JDBC20.jar yourExcelclass" to run your class. More information about classpath, please read the "Setting the Classpath" topic in file:///yourdriver|/jdk1.2/docs/tooldocs/tools.html . You can use "java -classpath c:\javalib\Excel_JDBC20.jar yourExcelclass" too.

Thirdly, you can use 'Class.forName("com.hxtt.sql.excel.ExcelDriver").newInstance();' or Class.forName("com.hxtt.sql.excel.ExcelDriver");' to load this driver.

Fourth, if you have used other JDBC driver, you only need to know the correct URL format for DriverManager.getConnection(url,"",""); You can find the Excel URL format below. If you were a Java novice, please read also other Java examples code in Excel_JDBC30demo.zip, Excel_JDBC20demo.zip or Excel_JDBC12demo.zip.
Excel URL format:


        Embedded:
                jdbc:excel:[//]/[DatabasePath][?prop1=value1[;prop2=value2]] (You can omit that "//" characters sometimes)
                        For example:
                                "jdbc:excel:/."
                                "jdbc:excel:/c:/data"
                                "jdbc:excel:////usr/data" 
                           for unix or linux:
                                "jdbc:excel:/./data"
                                "jdbc:excel:/./data/mydata.xls"
        Remote Access:
                jdbc:excel://host:port/[DatabasePath]
                        For example: "jdbc:excel://domain.com:3099/c:/data" if one ExcelServer is run on the 3099 port of domain.com
                                     "jdbc:excel://domain.com:3099/c:/data/mydata.xls"

Last, Excel driver is a standard JDBC driver so that you will find most of valuable information at file:///yourdrive|/jdk1.2/docs/api/java/sql/package-frame.html .

Excel supports SQL-92. It supports { UNION | INTERSECT | EXCEPT | MINUS } [ ALL ] query , INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, NATURAL JOIN, CROSS JOIN, self join, and subquery which includes single-row subquery, multirow subquery, multiple-column subquery, inline views, and correlated subquery. The major syntax is listed at here.

Excel driver will use index to speed up the query which contains some indexed expressions. Excel supports utilizing index file for LIKE, BETWEEN, IN, DISTINCT, ORDER, and some OR operations.

 
Copyright © 2006 Hongxin Technology & Trade Ltd. | All Rights Reserved. |