Look here for more information and examples: https://github.com/JSQLParser/JSqlParser/wiki.
JSqlParser is licensed under the LGPL V2.1.
Version 0.9.3-SNAPSHOT where条件添加括号明确判断优先级。
Version 0.9.2 released.
Version 0.9.1 released.
Version 0.9 released.
More news can be found here: https://github.com/JSQLParser/JSqlParser/wiki/News.
JSqlParser is a SQL statement parser. It translates SQLs in a traversable hierarchy of Java classes. JSqlParser is not limited to one database but provides support for a lot of specials of Oracle, SqlServer, MySQL, PostgreSQL ... To name some, it has support for Oracles join syntax using (+), PostgreSQLs cast syntax using ::, relational operators like != and so on.
To help JSqlParsers development you are encouraged to provide
- feedback
- bugreports
- pull requests for new features
- improvement requests
Also I would like to know about needed examples or documentation stuff.
- first support for numeric bind
SELECT a FROM b WHERE c = :1- support for keywords as column names in create table statements
- Release Notes
- Modifications before GitHubs release tagging are listed in the Older Releases page.
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.
JSQLParser is deployed at sonatypes open source maven repository. Starting from now I will deploy there. The first snapshot version there will be 0.8.5-SNAPSHOT. To use it this is the repository configuration:
<repositories>
<repository>
<id>jsqlparser-snapshots</id>
<snapshots>
<enabled>true</enabled>
</snapshots>
<url>https://oss.sonatype.org/content/groups/public/</url>
</repository>
</repositories>This repositories releases will be synched to maven central. Snapshots remain at sonatype.
And this is the dependency declaration in your pom:
<dependency>
<groupId>com.github.jsqlparser</groupId>
<artifactId>jsqlparser</artifactId>
<version>0.9</version>
</dependency>