{"id":180,"date":"2010-04-21T09:25:57","date_gmt":"2010-04-21T14:25:57","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=180"},"modified":"2011-09-26T21:41:12","modified_gmt":"2011-09-27T02:41:12","slug":"general-sql-parser-java-v0-3-release","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2010\/04\/general-sql-parser-java-v0-3-release\/","title":{"rendered":"General SQL Parser Java v0.3 release"},"content":{"rendered":"

In this release, General SQL Parser can fetch all tables and columns in select\/delete\/insert\/update and create table statement.<\/p>\n

Use this SQL Parser Java version, It’s very easy to find out the tables have Create, Read, Update, Delete and Insert operations against them<\/p>\n

Take this SQL script for example:<\/p>\n

select last_name,job_id,salary from employees
\nwhere job_id=(select job_id
\nfrom employees
\nwhere employee_id=141)
\nand salary >
\n(select salary
\nfrom employees
\nwhere employee_id=141);<\/em><\/p>\n

insert into emp e1 (e1.lastname,job) values(scott,10);<\/em><\/p>\n

delete from department
\nwhere department_name = ‘Finance’;<\/em><\/p>\n

update employees
\nset job_id = (select job_id
\nfrom employees
\nwhere employee_id = 205),
\nsalary = (select salary from employees
\nwhere employee_id = 205)<\/em>
\nwhere employee_id = 114;<\/p>\n

When you use demo getcrud.java shipped together with this Java SQL Parser, you will get this output:<\/p>\n

employees<\/strong> 5(select)\u00a0\u00a0 0(create table)\u00a0\u00a0 0(delete)\u00a0\u00a0 0(insert)\u00a0\u00a0 1(update)
\nemp <\/strong>0(select)\u00a0\u00a0 0(create table)\u00a0\u00a0\u00a0 0(delete)\u00a0\u00a0 1(insert)\u00a0\u00a0 0(update)
\ndepartment<\/strong> 0(select)\u00a0\u00a0 0(create table)\u00a0\u00a0\u00a0 1(delete)\u00a0\u00a0 0(insert)\u00a0\u00a0 0(update)<\/em><\/p>\n

Do you interested in this? You can download Java SQL Parser from here<\/a>.<\/p>\n

In next release, this SQL Parser will be able to fetch all table and columns from SQL Server stored procedure(procedure\/function\/trigger), Oracle stored procedure(procedure\/function\/trigger) and package.<\/p>\n

Feel free to contact me at support@dpriver.com if you have any questions or suggestions about this SQL Parser.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this release, General SQL Parser can fetch all tables and columns in select\/delete\/insert\/update and create table statement. Use this SQL Parser Java version, It’s very easy to find out the tables have Create, Read, Update, Delete and Insert operations against them Take this SQL script for example: select last_name,job_id,salary from employees where job_id=(select job_id from employees where employee_id=141) and salary > (select salary from employees where employee_id=141); insert into emp e1 (e1.lastname,job) values(scott,10); delete from department where department_name = ‘Finance’; update employees set job_id = (select job_id from employees where employee_id = 205), salary = (select salary from employees\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[14,15],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nGeneral SQL Parser Java v0.3 release<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n