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.<\/p>\n\n\n\n
In this post, we will see how the JSQLParser library is used to parse a simple SELECT SQL statement and fetch the columns from that select statement.<\/p>\n\n\n\n
For using the parser, first, we need to add the dependency of the JSQLParser<\/a> library to our project.<\/p>\n\n\n\n In this example, let us take a simple select query that has columns selected from a single table under a database. Let’s try to parse this SQL and explore the objects inside the same.<\/p>\n\n\n\n The above SQL is a simple one with a few columns selected from the CUSTOMERINFO table which is in the CUSTOMERDB database. Let us explore how to parse this.<\/p>\n\n\n\n After adding this dependency, you will be able to use the classes from the JSQLParser library.<\/p>\n\n\n\n Let us extract all the columns from the select query and print. The following JSQLParser example will show how to parse a simple select query in Java.<\/p>\n\n\n\n Let us try to parse another SQL statement with a where condition. Along with extracting the columns from the select statement, we can extract the where condition also.<\/p>\n\n\n\n From the above code, you can see that we are first extracting the Select object from the SQL, and in that, we are able to extract the where condition.<\/p>\n\n\n\n In this example, let us try to parse a select statement that has multiple join statements. We will parse the join statements and extract the info like the number of joins used, what are the expressions used in each of the ON conditions of the statement.<\/p>\n\n\n\n As mentioned, there are two join conditions in the above SQL statement. The first for loop will process each join statement. The second for loop will go through each ON expression of that join condition.<\/p>\n\n\n\n Also check “Parsing INSERT sql using jsqlparser<\/a>“,”Parsing CREATE sql using jsqlparser<\/a>“<\/p>\n","protected":false},"excerpt":{"rendered":" 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\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[6,14],"tags":[195,190,237,193,192,194],"_links":{"self":[{"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/posts\/1143"}],"collection":[{"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/comments?post=1143"}],"version-history":[{"count":12,"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/posts\/1143\/revisions"}],"predecessor-version":[{"id":1187,"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/posts\/1143\/revisions\/1187"}],"wp:attachment":[{"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/media?parent=1143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/categories?post=1143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/tags?post=1143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<dependency>\n <groupId>com.github.jsqlparser<\/groupId>\n <artifactId>jsqlparser<\/artifactId>\n <version>4.2<\/version>\n<\/dependency><\/pre>\n\n\n\n
Parsing simple SELECT SQL with columns<\/h2>\n\n\n\n
SELECT\nID, NAME, CITY, ADDRESS, COUNTRY, GENDER, CREATED_DT\nFROM CUSTOMERDB.CUSTOMERINFO <\/pre>\n\n\n\n
String selectSQL = \"SELECT\\n\" +\n \"ID, NAME, CITY, ADDRESS, COUNTRY, GENDER, CREATED_DT\\n\" +\n \"FROM CUSTOMERDB.CUSTOMERINFO \";\n\nStatement select = (Statement) CCJSqlParserUtil.parse(selectSQL);\nList<SelectItem> selectlist = ((PlainSelect) ((Select) select).getSelectBody()).getSelectItems();\n\nSystem.out.println(\"List of columns in select query\");\nSystem.out.println(\"--------------------------------\");\nList<SelectItem> selectCols = ((PlainSelect) ((Select) select).getSelectBody()).getSelectItems();\n\nfor (SelectItem selectItem : selectCols)\n System.out.println(selectItem.toString());<\/pre>\n\n\n\n
Parsing simple SELECT SQL with Where clause<\/h2>\n\n\n\n
String selectSQL = \"SELECT\\n\" +\n \"ID, NAME, CITY, ADDRESS, COUNTRY, GENDER, CREATED_DT\\n\" +\n \"FROM CUSTOMERDB.CUSTOMERINFO WHERE CITY='CHENNAI'\";\n\nStatement select = (Statement) CCJSqlParserUtil.parse(selectSQL);\nString whereCondition = ((PlainSelect) ((Select) select).getSelectBody()).getWhere().toString();\nSystem.out.println(\"Where condition: \" + whereCondition);<\/pre>\n\n\n\n
Parsing SELECT SQL with Join conditions<\/h2>\n\n\n\n
String selectSQL = \"SELECT CI.ID, CI.NAME, C.COUNTRY, S.SALESDATE \\n\" +\n \"FROM CUSTOMERDB.CUSTOMERINFO CI\\n\" +\n \"LEFT JOIN CUSTOMERDB.COUNTRY C ON CI.COUNTRYCODE = C.COUNTRYCODE \" +\n \"LEFT JOIN CUSTOMERDB.SALES S ON CI.COUNTRYCODE = S.COUNTRYCODE;\";\n\nStatement select = (Statement) CCJSqlParserUtil.parse(selectSQL);\nList<Join> joins = ((PlainSelect) ((Select) select).getSelectBody()).getJoins();\nSystem.out.println(\"Number of joins: \" + joins.size());\nfor(Join join : joins)\n{\n System.out.println(\"Join condition: \" + join.toString());\n System.out.println(\"ON elements of join\");\n\n for (Expression exp: join.getOnExpressions())\n System.out.println(exp.toString());\n}<\/pre>\n\n\n\n