Skip to content

tKe/JSqlParser

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

97 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

JSqlParser

This is a fork of the jsqlparser originally developed by ultimoamore.

Original project websites:

Extensions

  • Added support for escaping double quotes (double occurrence of double quotes is parsed as an escaped double quote)
  • Enabled UNICODE support
  • Changed project tests to junit 4
  • Changed project layout to maven project
  • Added regexp (REGEXP) operator
  • Added support for SELECT without FROM (e.g. "SELECT 1+2")
  • Moved parser from using StringBuffer to using StringBuilder
  • Added support for CAST expression
select cast(col as varchar) from table
  • Added support for modulo (a % b)
  • Added support for brackets quotation
  • Added support for NOT expr IS (expr IS NOT was already supported)
  • Added support for Oracles (+) Join Syntax
select * from taba, tabb where taba.a=tabb.a(+)
  • Added alias visitor to add aliases to selections
  • Added connect visitor
  • TableNamesFinder moved from tests to main source
  • Added proper support for sets (union, intersect)
select a from taba union select b from tabb
select a from taba intersect select b from tabb
  • Added support for extract(year from datetime-expr)
  • Start implementation of analytical expressions

BUILDING

As the project is a Maven project, building is rather simple by running:

mvn package

This will produce the jsqlparser-VERSION.jar file in the target/ directory.

About

JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Java 100.0%