Category Archives: PROGRAMMING

Parsing SQL CREATE query using JSQLParser

In the previous articles, we saw how to parse and Insertquery and how to parse different forms of Select query using JSQL Parser in Java. This article describes how to do the same for a Create statement. There are multiple use-cases for parsing a Create Statement. Suppose if you want to validate the table schema… Read More »

Parsing SQL SELECT query using JSQLParser

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 the basic condition and multiple select queries. Imagine a scenario… Read More »

Parsing SQL INSERT query using JSQLParser in Java

It will be fun if we can parse the SQL query to get the objects used, columns selected, getting database names, etc from the query. The use-case depends are what you are going to do after parsing and extracting the objects from the query. You may want to modify the table name and simply load… 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 »

AES Encryption using Python packages

AES stands for Advanced Encryption Standard. AES is the first and only publicly accessible cipher approved by the National Security Agency(NSA). There is multiple AES package available in python. In this post, we will see the implementation with two different packages in python Method1 – “crypto” package Method2 – “cryptography” package Using the “Crypto” AES package In this… Read More »