Category Archives: PROGRAMMING

Java parse SQL Select query using JSQLParser

JSQLParser is one of the most powerful open source parsers for parsing SQL statements using Java classes. The parser is capable of parsing DDL and DML statements and exposing the details of the query. In this post, we will see how the JSQLParser library is used to parse a simple SELECT SQL statement and fetch… Read More »

Parsing SQL CREATE query using JSQLParser

Parsing SQL statements using programming languages are not common. In this article, we will cover how to parse the standard CREATE SQL statement using a Java-based open source JSQLParser There are multiple use-cases for parsing a Create Statement. Suppose if you want to validate the table schema between the source and target system and make… Read More »

Parsing SQL SELECT query using JSQLParser

Update: A new version of this article is available here In the other article, we saw how to parse an insert query and modify the objects in the query with the help of the JSQL Parser. In this article, we will see how to use the JSQL Parser for parsing a simple select query with… Read More »

AES Encryption and Decryption in Java

While there are many encryption and decryption algorithms available, AES is one of the robust and reliable modes of encrypting the data. The implementation can be done in many languages as there are libraries and packages available for multiple languages. Creating the AES encryption/decryption library We do not need any special library to be downloaded… Read More »