gsp-sqlparser

downloaded from this site: http://www.sqlparser.com/

1. In order to compile and run this Java demo, make sure JDK must be installed (JDK version >= 1.5) you can always download the latest version of JDK here: http://www.oracle.com/technetwork/java/javase/downloads/index.html

after download this JDK, then install it.

2. download the latest version of General SQL Parser Java version here: http://www.sqlparser.com/download.php

3. unzip the downloaded general sql parser libary file to c:\tmp, you will find demos under c:\tmp\gsp_java_trial\dist\demos

Or you can download more demos here: http://www.dpriver.com/blog/list-of-demos-illustrate-how-to-use-general-sql-parser/

4. set java environment before compile and run demos, replace java home directory with correct value 4.1 open a dos command window, now you at c:\tmp\gsp_java_trial\dist> 4.2 set java_home="C:\Program Files\Java\jdk1.5.0_09"; 4.3 set path=%path%;%java_home%\bin; 4.4 set classpath=%classpath%;%java_home%\jre\lib\rt.jar;./gsp.jar

5. we compile and run checksyntax demo under demos\checksyntax 5.1 javac demos\checksyntax\checksyntax.java 5.2 create a simple sql file test.sql under c:\tmp\gsp_java_trial\dist with following sample sql: select count(*) from tab 5.2 java demos.checksyntax.checksyntax test.sql 5.3 after select a SQL dialect, you will see a message: Check syntax ok!

6. you can compile other demos under c:\tmp\gsp_java_trial\dist\demos