Java SQL comprehension

java

Are there Java classes for manipulating SQL statements?

For example, break this statement

SELECT col1, col2 FROM table WHERE a = 1 AND b = 2 ORDER BY 1;

into some kind of map.

['select' => {'col1', 'col2'}, 'from' => {'table'}, 'where' => ..]

Then, you would be able to say add to the where clause or add tables to select from. Is this possible?

Best Answer

This may help: zql